#INVENTORY SHEET UPDATE#

#INVENTORY SHEET UPDATE#

It doesn’t create a location or update the values that identify products. The import procedure updates and overwrites inventory quantities only. Noteĭon’t use the product CSV file to import inventory quantities. If you don't want to update quantities for a location, then make sure that the column for the location, including the column heading, is removed from the CSV file. You can also enter Not stocked to indicate that the product is never stocked at the location.īefore you import inventory, make sure that you have created a CSV file in the correct file format. The numbers that you enter in each row can be positive, negative, or 0. Update the quantities in the remaining location columns. If your CSV file contains location columns that you don't want to update the inventory for, then delete the entire columns for those locations, including their headings. Open your exported CSV file in a spreadsheet program. When you're converting your store to use multiple locations, edit only the location columns. The CSV file has several columns to help you identify your product, as described in Inventory CSV file format. Specify the rows that you want to export, and whether you want to export from a single location or all locations if you have more than one.Īfter you've exported the CSV file to get a template, you need to update the inventory quantities in the file.If you have multiple locations, then you can specify whether you want to export the data for all of your locations or just for one specific location.

You can export an inventory CSV file either to create a template that contains your uniquely identified products or product variants for the location or specified locations, or to export the inventory quantities for use in other systems or processes. To see more videos, visit our YouTube channel.

Inventory sheet