To import inventory items via our Retail Imports team, please refer to this article.
If your import file is a CSV and you're planning to use Excel to format it, you need to open and save your file as an XLSX to avoid formatting issues that may break the inventory data and cause importing errors.
Open your CSV file in Excel
- Open Excel.
- Click File > Import.
- On the Import modal, select CSV file and click Import.
- Select your CSV file and click Get Data.
- Select Delimited and click Next.
- Under Delimeters, select Tab and Comma.
If you're using the European version of Excel, please select Tab and Other and enter a semicolon (;) in the Other field instead.
- Click Next.
- Select each of the columns listed below one at a time and click Text under Column data format. To confirm the Text data format was applied, Text will appear above the column headers. This step prevents the series of numbers in the columns from being converted to scientific format (e.g. 21+E):
- UPC
- EAN
- Custom SKU
- Manufacturer SKU
- System ID (if updating existing items)
- Any other columns that contain a series of numbers
- Click Finish.
- Click OK.
Now that you've successfully opened your CSV file in Excel, save it as an XLSX right away.
Save your CSV file as XLSX in Excel
- Click File > Save As.
- Give your file a meaningful file name, including the date, for your records.
- From the File Format, select Excel Workbook (.xlsx).
- Click Save.
You should now be able to update your XLSX file and proceed with importing.