Why do some of my product options combinations fail to import in CS-Cart? Print

We have found that if a Product Option Variant contains a comma or colon, this can break the import.

First, to see if any of your option variants contain commas or colons:

1. Login to CS-Cart admin area.
2. Go to Administration --> Export Data --> Products
3. Click on Product combinations tab.
4. In the exported fields, make sure that you have "Combination" and "Product ID" selected as one of the fields.
5. Click Save Layout.
6. Select comma as CSV delimiter and click Export.
7. Click Export and save the file to a location on your computer.
8. Open the file in EXCEL or another spreadsheet program.
9. Hide all columns except for "Combination".
10. Search that column for instances of a "," (comma) or colon ":" character.
11. If any instances are found, note the Product IDs.

Next, fix the product option variants for any of the products:

1. Go to Products --> Products.
2. Click on the product name for any product.
3. In the address bar of your browser, replace the "product_id=###" value of the URL with the productid of the product that you are editing. (ie: product_id=33203)
   Then click enter.
4. In Editing product screen, click on the "Options" tab.
5. Click on the option associated with the  "Combination" that contained the comma.
6. In the "Editing option" window, click on the Variants tab.
7. Edit the "Name" column for the record(s) corresponding with those containing the comma or colon for the "Combination". Replace any commas or colons with semi-colons instead, or remove the commas/colons entirely. Click Save.
8. Repeat this for all products.

Note: You can optionally fix the option variant name values usign the Product export/import feature in CS-Cart. However, due to the potential for a much larger set of data required to export and import for this, this may prove to be problematic.