To import inventory items via our Retail Imports team, please refer to this article.
The Item Import tool extracts your inventory data from an import file (CSV or Excel file) that you create and then upload to the Item Import tool. To help you create your import file, you can download a template CSV file directly from the Item Import tool's welcome modal or when you start a new import. If you're an Omnichannel merchant (Retail with eCom), the template CSV file contains additional eCom-related columns.
Whether you start your import file from the template CSV or from scratch, it needs to contain a set of columns that the Item Import tool supports (e.g. UPC and Description). For each item you want to import or update, you then need to enter information in its associated columns (e.g. 1234 and T-Shirt). For the import to work, you need to format the column headers and the information in each column in a specific way. If there are any formatting errors in your import file, you'll need to fix them and upload your import file again. To help you know how many errors your file contains and how to fix each of them, the Item Import tool creates a version of your import file with two additional columns that you can download and upload again. For more information, please see 1.1 Formatting item import files and 1.2 Importing matrix items.
Please note the following before importing your items:
Note: If you are updating your existing items, you may want to start by exporting your Retail inventory instead. This way, your CSV file will have each item's System ID, UPC, EAN, Manufacturer SKU or Custom SKU for the Item Import tool to match on.
Note: If you use OpenOffice, make sure to set the file import Separator Options to Comma-separated when opening the CSV file (File > Open > Text Import > Separator Options > Separated by > Comma). The default settings for OpenOffice result in formatting issues in the CSV file.
Note: For more information on how to format the information in each column, see 1.1 Formatting import files and 1.2 Importing matrix items.