Import QOH Data

Contents of this Topic: Show

Overview

This screen is accessed from Inventory>Import Inventory File. It is used to enter QOH data from a text file when the system is initially configured or from Cycle Counts. It is not possible to import product data other than QOH, and it is not possible any data from a database table, only tab or comma delimited text files.

Best practice

It is advisable to make a backup copy of your database before importing large quantities of data, and perform this action during off-hours when the program is not being used.

Procedure

  1. Launch the Monsoon Fulfillment Manager.
  2. Select Inventory from the ribbon.
  3. Select Import Inventory File.
  4. Enter the path to the text file or select the folder icon to navigate to its location. Up to fifty fields of the first 100 records are displayed in the data sheet.

  1. Select Next to move to another screen and select your Import Options.

 

  1. Specify the type of Field Delimiter used in the text file.
  2. Indicate if the First row contains field names (header record).
  3. Specify whether to Replace the QOH value in the database with the value in the file, or to Add to the current QOH in the database.
  4. Select Next to move on to another screen where you identify the field which contains the QOH information and tell the program how to match inventory record in the file with the inventory record in the database.  

  1. The SKU, Client ID, Client Name, and QOH drops-down lists contain the names of all of the fields in the text file.

  2. Select the field which contains the product stock keeping unit in SKU.

  3. In Client ID or Client Name select the field that identifies the Monsoon Order Manager store. If the file does not include client information, select the client from If Client Data is missing from the file, which contains a list of stores associated with the warehouse. Currently, a warehouse can only be associated with a single client.   

  4. In QOH, select the field containing the number of units of a given product.

  5. Select Next to move to another screen and Finish and Import data.

  1. If you are setting up the system for the first time, clear Send Adjustment Events. If you are entering data from a cycle count, Send Adjustment Events should be selected.

  2. Select Test Data and the program checks for some common data errors.

  3. Select Begin Import after any data errors are corrected.

  4. A message box with a summary of the results is displayed.

Additional information

Inventory View

Created: 6/13/14

Revised: 6/25/15

Published: 08/19/15