While Shopify offers an excellent product import/export tool, sometimes you need to quickly update your inventory by SKU.
With a click of a button, you can quickly export your entire product inventory to a simple CSV file. This allows you to easily change/update your product inventory (and prices) by SKU number with ease. After you make your changes, you simply save the CSV and re-upload it to Shopify via the app. That’s it! Sit back and relax while Simple Inventory app does the heavy lifting for you.
Once you have installed the application, you can export your entire inventory to a CSV file by clicking on the red "Export Inventory" button. This will download a CSV file that you can then open in Excel (or CSV compatible program of your choice)
You can edit this CSV file with your new inventory and pricing values. After you have finished, save the file and then upload it using the blue "Upload" button on the app dashboard.
That's it! Now just sit back and let Simply Inventory do the work.
Yes! Pricing is part of the product CSV export which you can easily change. More features are coming soon and we are open to hearing your suggestions!
Yes, excel is 100% compatible! In fact, any program capable of reading/writing a CSV file is compatible with this app.
Simple Inventory App only works with CSV files. When you export your inventory, this file will be downloaded.
"CSV" stands for "Comma Seperated Values":
CSV is a common file format that is widely supported by consumer, business, and scientific applications. Among its most common uses is moving tabular data between programs that natively operate on incompatible (often proprietary and/or undocumented) formats. This works because so many programs support some variation of CSV at least as an alternative import/export format.
Excel can open and edit CSV with ease and you can also convert your excel files to CSV using "File -> Save as..." and selecting "CSV" as the file type.
Please see the screenshot to the right of a simple CSV export example.
There are a few factors involved, including internet connection speed and the number of SKU's you plan on updating. Shopify allows us to update roughly (100-200) SKUs (1-2 products) per second. So a product upload spanning 100 SKUs would take approx. 1.6 - 3.3 minutes. Please note that these are approximations and can vary greatly depending on the aforementioned factors.
Once you have uploaded your CSV file, no more action is required on your part! Relax, grab a coffee and let Simple Inventory App do the work!