What to do when you receive errors during a product import process
StoreAutomator import file error messages
StoreAutomator Importer reads your feed file and it can create new items or update the data in the inventory, thousands of items at a time. It is a great tool but when the feed file is incorrectly prepared it may result in not importing the feed and return some error messages for you to fix.
All feed import files and their result reports are kept in Tools>Import>import History.
You can find the feed file in question from the list, clicking on the 'Result' displays the errors or warnings if any. You can click on the download button to get the file, make necessary connections and upload it to the system again.
Errors coming from SA Import and DX channel conversion essentially the same and they share the same error messages. If you are using SA's drop shipping capabilities, then the data will come from a external supplier/warehouse. In this case the imported reads the file accordingly, and issues some other different errors relevant to your suppliers.
Viewing the Results and error can sometimes be confusing. In this article, we tried to cover some general errors messages and provided solutions, or possible causes for the errors.
Error 90009 Invalid Data File error:
This error happens when the feed file does not have required fields or proper formatting. Below are possible causes for this error. Check your feed file against these conditions and made corrections as necessary.
-
If you are sending an excel file, it might have more than one sheet. Delete all unnecessary sheets and leave only one with the feed data, and resend the feed file.
-
If you are sending a .csv file there might be empty columns on the header. You can check if there are empty headers in the feed by using a text editor program; open the feed file, find the last header, check to see if there were unnecessary commas or tabs in the end of the first line. if there are, all these commas or tabs need to be removed from all lines. The best way is to do this with a spreadsheet program; open the feed file with MS Excel, go to the end of headers line, delete at least 20 columns from the last header. Save and resend the feed file.
-
the first cell of the feed file does not make sense to the importer. The first cell must have the importer purpose clause, productdata.sku, channelproduct.sku, etc...
-
All header names in the feed file must be unique, if you have repeating names in the feed file importer will return this error. You need to check all headers one by one, find the duplicate headers, and change the names to make them all unique. Save the feed file and resend.
-
Parent products missing price, returns this error.
-
.xlsm files are not accepted and creates this type of error.
Error 10006 Skipping item [SKU_number] which was already processed on line [feed_line_number]: This error is for repeating SKUs. Remove repeating SKUs and re-import the feed file.
ERROR 30001 Required field title [OR brand_name OR price] is missing: When importer is running in create mode it requires title, brand_name, price, description. Provide the missing fields and try again.
Error 40002 Title [OR brand_name OR price] is required: When importer is running in update mode it requires title, brand_name, price for some certain update operations. Provide the missing fields and try again.
Error 40002 Incorrect variation options: This happens when a parent and its children's variation types are not same. Example: Parent variation types: Size,Color and you are uploading child with same parent SKU and variation types: SizeName,colorName. Also, this can happen if the parent is created before its children with the different variation types then its children.
Error 40002 Cannot update alternate sku: This error happens when you are trying to update a field that is not updateable for alt skus; which are sku, and quantity.
Error 10004: Attribute name missing. Column [Name] must be included. Importer cannot continue... : This error happens when you are missing an expected header, in the feed file. add the column header and the necessary data, save the feed file and resend.
Error 40004: Unauthorized - "Access denied": If your user level not does allow you to create or update inventory products you can receive this message. Please contact your system administrator to assign you necessary permissions.
External API user Error Messages:
Error 40002: Skipping item [SKU_number] which was already processed on line [feed_line_number]:
Error 40002: Barcodes don't match: When the incoming SKU number is present in local inventory, but incoming SKU's barcode does not match with the one in the inventory, that this error is issued. This error helps preventing incorrect updates to the local inventory.
Error 40002 Title [OR brand_name OR price] is required: When importer is running in update mode it requires title, brand_name, price for some certain update operations. Provide the missing fields and try again.
Error 40002 Your supplier sku [SKU_number] does not match our supplier sku [SKU_number]: If the incoming SKU's, barcode match with inventory SKU's barcode but the SKUs don't match this error code issues.