Verifying the file before import

Verifying the file before import

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

    • Related Articles

    • Setting up the import file

      Setting up the import files 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 Purchases

      You can import purchase orders in bulk into your account. All imported purchase orders will be added to your account in a Parked status, allowing you to confirm the transactions before approving them. Before You Begin Read the following topics to ...

    • Import Sales Quotes

      You must import sales quotes using the Unleashed template.  Before You Begin Read the following topics to understand the correct process details and avoid common errors: Data Import Checklist Troubleshooting Import Errors Points to Note: Quote ...

    • Import Sales Orders

      You must import sales orders using the Unleashed template.  Before You Begin Read the following topics to understand the correct process details and avoid common errors: Data Import Checklist Troubleshooting Import Errors Points to Note: Order ...

    • Import multiple manual journals

      Create the manual journal template file, then import it into Xero: In the Accounting menu, select Reports. Under Accounting, click Journal Report. Click Manual Journals, then click Import. Click Download template file. Enter the journal details ...