Before importing product data from a spreadsheet into Inform as described in Import product information from a spreadsheet, review the following details to determine which data will be overwritten and which is warehouse specific.
| Field | Overwrite | WH Specific | Notes |
|---|---|---|---|
| Product Number | N | ||
| Description | N | ||
| Product Line | N | Will create new Product Line code if it does not already exist. | |
| UPC | Y | ||
| List Price | Y | Y | Warehouse specific if utilizing "Maintain List by Warehouse" |
| Cost | Y | Y | Warehouse specfic if utilizing "Maintain Cost by Warehouse" |
| Keyword | N | ||
| Weight | Y | Imported upon Product Line code creation (does not update existing product lines). | |
| ProdLine Desc | N | ||
| Manufacturer # | Y | ||
| Box Quantity | Y | ||
| Volume/Cubes | Y | ||
| Price Group | N | Will create new Price Group code if it does not already exist. | |
| Buy Line | N | Will create new Buy Line code if it does not already exist. | |
| Vendor | N | Adds new vendors (does not override existing vendors; does not update primary checkbox). | |
| Future Price | Y | ||
| Vend Partno | Y | ||
| Cost Column 4 | Y | Y | Warehouse specific if utilizing "Maintain Cost by Warehouse" |
| Cost Column 6 | Y | Y | Warehouse specific if utilizing "Maintain Cost by Warehouse" |
| Cost Column 7 | Y | Y | Warehouse specific if utilizing "Maintain Cost by Warehouse" |
| List Price 2 | Y | Y | Warehouse specific if utilizing "Maintain Cost by Warehouse" |
| List Price 3 | Y | Y | Warehouse specific if utilizing "Maintain Cost by Warehouse" |
| List Price 4 | Y | Y | Warehouse specific if utilizing "Maintain Cost by Warehouse" |
| Image File | Y | ||
| Document/Specs pdf | Y | ||
| S.D.S. pdf | Y | ||
| Vendor New Cost | Y | Imports into the Next Cost column on the Product Master > Setup : Vendor tab. | |
| Catalog Section | N | ||
| Catalog Description | N | ||
| Web Category | N | Will create new Web Category code if it does not already exist. | |
| Web Sub Category | N | Will create new Web Sub Category code if it does not already exist. | |
| Web Sub Category 2 | N | Will create new Web Sub Category 2 code if it does not already exist. | |
| Pricing Unit of Measure | N | Will create new Unit of Measure code if it does not already exist. | |
| Minimum Stock Qty | Y | Y | If warehouse is not selected, global warehouse field will be updated. (Note that warehouse Min Qtys override global Min Qtys). Expiration dates will be calculated (if blank) based on Company Master setting Number of expiration days for Product Min/Max Qty. Use import field "Stock Qty Exp Date" to override. |
| Maximum Stock Qty | Y | Y | If warehouse is not selected, global warehouse field will be updated. (Note that warehouse Max Qtys override global Max Qtys). Expiration dates will be calculated (if blank) based on Company Master setting Number of expiration days for Product Min/Max Qty. Use import field "Stock Qty Exp Date" to override. |
| Taxable | N | ||
| Special Status | Y | Use field "Stock?" for Warehouse specific settings. | |
| Web Description | Y | ||
| Vendor UPC | Y | ||
| Carton Quantity | Y | N | |
| Purchase History Link Product Number | Y | ||
| Price Service Number | Y | ||
| SDS Change Date | Y | ||
| Quote Description | Y | ||
| S/O External Comments | Y | ||
| Product Image URL | Y | ||
| Product Spec Sheet URL | Y | ||
| S.D.S.URL | Y | ||
| Lead Days | Y | Y | If warehouse is not selected, Warehouse 01 will be updated. |
| Safety Stock % | Y | Y | If warehouse is not selected, Warehouse 01 will be updated. |
| Product Tax Group | N | Will NOT create new Product Tax Group code if it does not already exist. | |
| Stock? | Y | Y | If warehouse is not selected, Warehouse 01 will be updated. Use field "Special Status" for global status. |
| Min P/O Order Qty | Y | ||
| Stock Qty Exp Date | Y | Y | If warehouse is not selected, Warehouse 01 will be updated. |