How do you add new products using the Product Import extension?

  • Answered
I successfully installed the product importer, and was able to get an export that included my 5 test products.

I added a single product to the spreadsheet, as well as its options. I tried several methods, including copying the exact data from the row above, as well as uploading with/without assigned product_id (and other opencart-generated data).

No matter what I upload, I get the "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!" error. I uploaded the original, unaltered copy of the export sheet, and it imported successfully. I have verified the Excel version (xlsx) also.

At this point, I am led to believe that new products can't be added; you can only modify what's been exported. Is this correct, or am I doing something wrong?
Hello Naught, I'm sorry to hear that you're having problems with the import. Typically, if you're adding things to the spreadsheet, then it is possible that properties of the table elements may have changed. The best thing that you might want to try is to use a CSV format instead of the Excel format. The data type in each column of your table should match when you are trying to import it back into the database, or you would continue to see the error. For reference purposes, our articles include the information for re-installing the Bulk Export/Import extension in Opencart and also using the export/import extension. If you have already reviewed these articles, then please provide us a copy of the table that you're trying to import. Without seeing the actual table that you are trying to add, it is difficult for us to determine the actual cause. If you want to send the sample data for us to review, you can email it to [email protected] - please make sure to put SUPPORT CENTER in the title so that I can find it and then use it for testing here. Regards, Arnel C.