The OLX Inventory Supplier Import allows for batch loading of Inventory Suppliers/Vendors into the OrderLogix application. The vendor contact Information including name and address is loaded for the purposes of creating Purchase Orders in the OrderLogix Application. File Format ASCII text. The file must contain one line per Supplier, with each field enclosed in double quotes and comma separated, ending with a Carriage Return (↵) <CR>. All unused fields will be left blank and remain separated by a single comma. Import Definitions:
#
| Field Name | Req. | Type | Max | Field Description | 1 | SUPPLIER_CODE | YES | Alpha | 510 | Unique Identifier for the Supplier NOTE: This Supplier Code must already exist in OLX prior to importing pricing records. | 2 | SUPPLIER_SKU | YES | Alpha | 255 | Used when purchasing the Product from the Supplier | 3 | INVENTORY_SKU | YES | Alpha | 100 | Inventory Item name (SKU) to associate this Supplier Pricing record with. NOTE: This Inventory SKU must already exist in OLX prior to importing pricing records. | 4 | DESCRIPTION | YES | Alpha | 500 | Supplier Sku Description | 5 | MANUFACTURER | NO | Alpha | 510 | Manufacturer of Product | 6 | MODEL | NO | Alpha | 510 | Model of Product | 7 | LEAD_TIME | YES | Numeric | N/A | Default lead time in days that this product will require for delivery when ordered. Example: “21” | 8 | UNIT_OF_MEASUREMENT | YES | Alpha | 10 | The code of any valid unit of measurement in OLX (Unit of Measure list screen). Example: “DOZEN” | 9 | UNIT_OF_MEASURE_COUNT | YES | Numeric | N/A | Specify the number of individual units contained within the unit of measure. Example: “12” | 10 | UNIT_COST | YES | Decimal | N/A | The Per Unit Cost to purchase this product from the supplier at the specified unit of measure. Example: “12.95” | 11 | FREIGHT_COST | YES | Decimal | N/A | The Per Unit Freight Cost assessed when purchasing this product from the supplier at the specified unit of measure. Example: “4.00” | 12 | WEIGHT | YES | Decimal | N/A | The Per Unit Weight of this product at the specified unit of measure. Example: “2.75” | 13 | IS_PREFERRED_UOM | NO | Boolean | 1 | Indicates if this is the preferred Unit of Measurement when purchasing this product from the supplier. NOTE: If value provided for is 1 and existing Record exists for a different UOM, the Item’s preferred UOM will be updated to this record’s UOM. Default if Empty: “1” | 14 | IS_TAXABLE | NO | Boolean | 1 | Indicates if Sales Tax assessed when purchasing this product from the supplier Default if Empty: “0” | 15 | IS_PREFERRED_SUPPLIER | NO | Boolean | 1 | Indicates if this is the preferred supplier when purchasing this product from the supplier. NOTE: If value provided for this is 1 and an existing Supplier is set as preferred supplier, the preferred supplier will be updated to reflect the Supplier passed in this file. Default if Empty: “1” if this is a new record or if there is no preferred supplier assigned. If left blank for an existing record being updated, the preferred supplier will not be assigned to the value in the file. |
The attached documentation includes the OLX Inventory SKU Association Import Spec, Template, and Example.
|