To import inventory items via our Retail Imports team, please refer to this article.

After you prepare your import file, scan the document for any erroneous data:

• Edit special characters, such as ☺↨♪♫♀♂¶▓ so that they display the correct data.
• Correct rows that extend into other columns.
• Erase cells with N/A so that they have a blank field.
• Change cells with scientific numbers, such as 4.001E+11 (usually UPC or EAN values) so that they are regular integers instead, such as 40010000000. If you use Excel:
  1. Select the column with the scientific numbers.
  2. Click Format > Cells.
  3. Change the Category to Number, set Decimal places to 0, and then click OK.

Tips for Excel users

To erase multiple N/A entries:

1. Select the data you want to change, whether that's a row, column or the entire document.
2. Press Ctrl+F or Find.
3. Select the Replace tab.
4. For the text you want to replace, type N/A.
5. For Replace with, leave the field blank.

To correct multiple lines in cells or rows:

1. Highlight all of the data in the import file.
2. Press Ctrl+F or Find.
3. Click the Replace tab.
4. In the Find box, while pressing Alt, on the numeric pad type 0010. Don't type anything in the Replace box.
5. Click Replace all.