Can I update my products with an Excel or CSV file?

You do have the ability to update your existing products with a CSV file. If you aren't familiar with CSV files, it is basically an Excel file in a specific format. CSV stands for "comma separated value", or "comma delimited". No need to worry about that too much, though. Just make sure that whenever you save the file you are working on you do a "save as" and select the CSV format option. You might get some warnings from Excel when you do this. Just click yes or ok to the warnings to allow the file to finish saving, and it should be fine.

We are planning on adding the ability for you to create completely new products with a CSV file in the next phase. At this point you'll need to create any new items manually from the Products section of your admin page. But once you have the products created you can export a CSV file from the Products page, make your changes, and then upload them back into your admin account from the Products page. Make sure you remember to save the changed file in CSV format, or your updates will fail.

There are a few things to keep in mind when you are editing the file with your Product information​:

• Some fields in the file will have the text N/A. This means you can't make any changes to that field. Even if you just delete that text, it will cause your changes to fail when you upload your file. So just leave those fields as they are.
• The Marketplace Status column can only have either true or false as the text. True means that the item is in the Storenvy Marketplace, and false means that it is not.
• The Status column can only have either active, hidden, or coming soon as the text. Active is the normal status for a product that is active in your store. Hidden means it isn't visible to your customers yet, and coming soon means your customers can see it and it will be marked as coming soon.
• Be sure that you don't change or delete any of the product or variant IDs in the file. This will cause your updates to fail.
• If you are using the tags column (you should - it is good for search), then you'll need to separate each tag by a comma. Otherwise you'll have just one really long tag that doesn't make much sense.
• It isn't possible to delete an image from the file. If you delete the image URL and upload the changes, the old image will still be there in your product. You can upload a new image if you want. You'll need a URL that points right to the image to do this. The image will need to have a file extension (like .jpg) as part of the URL for this to work.
• If you make some changes to an exported file and then import it, you'll need to export a new file (and make changes to that new file - the old file will no longer work properly) before you can upload more changes.