Verifying item import files

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 FormatCells.
    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.