You are here: Importing and Exporting > Using Import and Export Features > To create an inventory import file in Excel

To create an inventory import file in Excel

You can create an inventory 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 inventory, you can import it into Monsoon Marketplace from the File menu, or, if you have set up a data exchange, place it in the InventoryImport folder to automatically import.

Note:  Before you create an import file to add new inventory, modify existing inventory, or decrease the quantity for existing inventory, review the required and recommended columns in the associated sections of Importing Inventory 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 that you want to import. (For information about available columns and their associated data types, see Inventory 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 File name, type a name for your file.
    3. In Save as type, select Text (Tab delimited) (*.txt).

    4. Click Save, and then close the file in Excel.
  6. If you use a data exchange, you can place the file directly in the InventoryImport 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 don't select text as your column format, Excel will remove leading zeros and transform numbers such as 0689829833 to 689829833.

See also

 

You are here: Importing and Exporting > Using Import and Export Features > To create an inventory import file in Excel

©2016 Monsoon, Inc. All rights reserved.