Print
GUIDELINES FOR PREPARING TO IMPORT INVENTORY
Since adding thousands of inventory items into POSitive Retail Manager (PRM) can be time consuming, PRM provides an easy to use importer to automate the process.
To use the PRM Inventory Importer you need to create a file which contains each inventory item as a separate record (row). We recommend that the file be an MS Excel spreadsheet for ease of editing.
The spreadsheet needs fields (columns) for the following key information.
TITLE (maximum # of characters)
Bin Location (20)
Category (20)
Cost (10) -- this field should be set to 2-4 decimal places and not include $ format.
Department (20)
Description (32) -- this will be printed on the customer invoice - every description should be unique; it is not wise to use the same description for different items.
Price 1 (10) -- selling price - set to 2 decimal places and not include $ format
Price 2 (10)
Price 3 (10)
Price 4 (10)
Price 5 (10)
Price 6 (10)
SKU (20) - product barcode - must be UNIQUE - no duplicates
Vendor Name (30)
Vendor Cost (10)
Vendor SKU (20)
OPTIONAL FIELDS
Some additional information can be imported at the same time.
Alternate SKU (20)
In Stock (9) - current quantities on hand
Long Description (50)
Manufacturer Name (30) - not the same as the vendor
Manufacturer Part # (17) - a common code number
Minimum Stock (10)
Standard Note (110) - a brief description of the item
ADDITIONAL NOTES
Please refer to the PRM Help File for more information.
Please be sure that the contents of the Category and Department columns are consistently the same; any variations in spelling will create a new category or department.
Related Articles
