Open topic with navigation

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.

1. Open a sample template or custom template in Excel. Sample templates include:
   • Template: Add inventory, use locator codes
   • Template: Add inventory, do not use locator codes
   • Template: Modify inventory, use locator codes
   • Template: Modify inventory, do not use locator codes
   • Template: Decrease inventory, use locator codes
   • Template: Decrease inventory, do not use locator codes
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.

See also

• Data Exchange Overview
• To import inventory from the File menu
• Using Import and Export Features
• Importing and Exporting

©2016 Monsoon, Inc. All rights reserved.