To create an order import file in Excel

You can create an order import file in Microsoft Excel using a sample template or a template that you have customized to fit your needs. After you create a tab-delimited text file in Excel to add or modify orders, you can place it in the OrdersImport folder to automatically import.

Note:  Before you create an import file to add a new order or modify an existing order, review the required and recommended columns in the associated sections of Importing Orders Overview.
  1. Open a sample template or custom template in Excel. Sample templates include:
  2. Enter your data into the required columns.
  3. Add any additional columns you want to import. (For information about available columns and their associated data types, see Order Column Definitions).
  4. Click the Microsoft Office Button , then click Save As.
  5. Do the following in the Save As dialog box:
    1. In the Address bar, navigate to the location where you want to save the file.
    2. In the File name box, type a name for your file.

    3. In the Save as type list, select Text (Tab delimited) (*.txt).

    4. Click Save, then close the file in Excel.
  6. If you use a data exchange, you can place the file directly in the OrdersImport folder.
Important:  When you open a text file in Excel, use the Excel Text Import Wizard to preserve leading zeros. A leading zero is any 0 digit that leads a string of numbers such as the ASIN 0689829833. In Step 3 of the Excel Text Import Wizard, click the columns that contain leading zeros then, under Column data format, click Text. If you do not select text as your column format, Excel will remove leading zeros and transform numbers such as 0689829833 to 689829833.

See also