1. Home
  2. Inventory and Pricing
  3. Inventory Warehouse Fields

Inventory Warehouse Fields

I am wanting to import Inventory Warehouse information, but do not know the column name to which my data corresponds.

Here is a list of field names from the Inventory Warehouse table into which you are able to import. The Product ID and Warehouse ID are required. NOTE: Some fields not specified below will show up in certain dropdowns–these are fields from the Inventory table and are not actually stored in the Warehouse table. ALSO: the stock levels and cost information in this table are automatically calculated, changing them in the data accomplishes nothing. See also: Inventory fieldsUnit of fieldsPricing fields.

FieldStored Column Name
Product IDstrProductID
WarehousestrWarehouseID
Reorder PointdecReorderPoint
Reorder QuantitydecReorderQty
Warehouse LocationstrWarehouseLocation
Shelf IDstrShelfID
NotesstrNotes
BuyerstrBuyerUserName
Max QuantitydecMaxQty

To import into certain fields, you must first add any new entries into another table in Paradigm. These fields are: strWarehouseID, strWarehouseLocation, strShelfID, and strBuyerUserName.

Related Articles