CSV Troubleshooting

This guide will help with common errors experienced using the Import & Export tools.

Before Importing the File

  • The total size of of the CSV file cannot exceed 110MB
  • If you use a Mac, you may need to save the CSV as CSV (Windows) file- your Zoey store will not be able to read the file otherwise.

👍

Check your CSV file for empty spaces, typos, wrong capitalization, or special characters in the rows or columns returning an error message.

The system is space and case sensitive!

Categories

  • If your spreadsheet defines categories for your products, those categories must be created within Zoey before uploading your CSV file!

HTML

  • HTML in your CSV will often return an error or simply skip the product! For CSV imports, use plain text.
  • The same is of Smart quotes and apostrophes. If you use smart quotes (the ones that curve in) " rather than the regular or plain text ' (straight up and down) the link will be skipped.
    You can learn more about these here.

Default Settings

  • If you are importing data tied to default Config settings (for example default settings for Backorders), make sure you also update the value in the related column telling to no longer use default Config settings. Otherwise your updated value will not take effect.

Localization

  • If you are importing descriptions for multiple store views you will need two rows per SKU: One for the default description, the other one for the translated description.

Import The File

Use the Import & Export menu on the left sidebar and select Import Products.

Once you are alerted the import was successful, Flush Cache and Re-Index and view your newly updated Product List.

Attributes

  • Before assigning attributes to products via CSV files, you will need to create those attributes and attribute values first.

Import Errors

👍

NOTE: The header doesn't count as first row, which means that the second row in a file is "row 1". If the system returns an error message for "row 55" it actually refers to row 56.

  • SKU does not exist: The SKU either has a typo, not matching the SKU in your Product List or it was already deleted.
  • Invalid SKU Type: The product type cannot be imported (bundle and grouped products).
  • Category doesn't exist: Typo in the file or the category is not yet created
  • Invalid Attribute: Attribute does not exist in Products > Attributes
  • Invalid Value for Attribute: The attribute value has either a typo or does not exist yet.