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 fields, Unit of Measure fields, Pricing 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.