CSV Related Issues

Common Issues Seen

Please note that this article is common between multiple extensions. Any references to “shipping groups” also apply to handling groups and special shipping groups. Not all extensions (for example, Premium Rates) have these attributes, however.

CSV Common Mistakes

You have entered the shipping group values at a store level rather than global level i.e

CSV Format

With Open Office or Libre office, when saving the CSV you should see an option for “Edit Filter Settings” in the “save as” dialog. In the next dialog will be an option for “field delimiter” (a comma) and “text delimiter” (quotes), as shown below:

If using Excel for Mac you will need to select the Windows CSV file format.