If the products you are adding are all new, you will need to leave the "_ID" column blank. The ID's will be assigned by SunShop automatically when uploaded. If you're editing existing products, be sure to leave the _ID column as it was so that you do not add a duplicate or overwrite the wrong product.
A few things to note about the columns in your products export file:
_ID: If you are adding a new product, this should be left blank. If editing existing products, this should be populated with the id numbers & you should not change these.
CATIDCAT_ID: This defines the main category that this product will be displayed in. It must be a numeric value and must match the category in question's ID.
META TITLE: This is the meta title that will be used in the HTML for this product.
META DESCRIPTION: This is the meta description KEYWORDS: Keywords that will be used in the HTML for this product.
META KEYWORDS: Keywords DESCRIPTION: This is the meta description that will be used in the HTML for this product.
LIST PRICE: Product list (a.k.a suggested retail) price.
PRICE: Product price that your customers will pay.
SALE PRICE: Sale price. Add a value to this field if the Sale Items plugin has been installed & you wish to include product in the "Sale Items" category. (Price is often times the same as "Price")item has a temporary sale price.
FLAT RATE: Flat product shipping cost. (Product defined shipping must be enabled)
MAX PER BOX: Maximum number of products per box/package.
MIN_QUANTITY: Minimum number of this product that can be order. Set to 0 if there is no minimum.
MULTIPLES: If the product must be purchased in multiple of a certain number, set it here. Set to 0 for no requirement.
CHARGE SHIPPING: Enable/Disable shipping charge for this product ("y" or "n").
ORDERABLE: Allow customers to order this product ("y" or "n").
REWARDS EARNABLE: Will the purchase of this item count towards the customers rewards total, if enabled ("y" or "n").
REWARDS REDEEMABLE: Can rewards be used towards the purchase of this item ("y" or "n").
REQUIRE ADDTOCART: Require that the product be added to the cart before the price can be viewed ("y" or "n").
AVAIL TO: Specific group product will be available to (Group ID).
MANUFACTURER: Product manufacturer (Manufacturer ID).
VENDOR: Product vendor/drop shipper (Vendor ID).
SKU: Product SKU . (Optional).
GTIN: Product Global Trade Item Number (Optional).
MPN: Manufacturer Part Number (Optional).
TAXCLOUD TIC: ID for Taxcloud tax category (Optional).
- To import a CSV file, click on the Import/Export link on the left hand side. It doesn't matter where you access this section from, as long as you set the "Data Source" drop down to the correct type of import. Likewise, when exporting make sure the drop down is set to the correct data source. You need to make sure that you keep the same column structure in your CSV files to avoid database problems or errors during file imports. You also want to be careful when importing any HTML data. You must use the HTML equivalents and not raw HTML characters. Using commas in the CSV file may also cause unwanted results or errors so, you will want to use the HTML equivalent (Example: Use "," instead of ",").