The OLX Inventory Adjustment Import allows for batch inventory amount adjustments in the OrderLogix application by providing relative or absolute adjustment amounts. File Format: ASCII text. The file must contain one line per addition, 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. File Naming: <Organization Identifier><YYYYMMDD>.csv Import Definitions:
#
| Field Name | Req. | Type | Max | Field Description | 1 | INVENTORY ITEM SKU | YES | Alpha | 100 | Item SKU (Stock Keep Unit) | 2 | LOCATION | YES | Alpha | 100 | This is the exact name of where the item is being stored. Item must already have a history of being stored at this location. Example: “Default-1-1-1-1” | 3 | ADJUSTMENT AMOUNT | YES | Numeric | N/A | This represents the amount of the adjustment. It must be a whole number, decimals and negative numbers are not allowed. | 4 | ADJUSTMENT OPERATOR | YES | Alpha | 1 | This character determines how the ADJUSTMENT_AMOUNT will be applied to the inventory at the specified location. Require Format: “+”, “-“ or “=” “+” increase by ADJUSTMENT AMOUNT “-“ decrease by ADJUSTMENT AMOUNT “=” set to the ADJUSTMENT AMOUNT | 5 | UNIT OF MEASUREMENT | see notes | Alpha | 100 | The name of any valid unit of measurement in OLX (Unit of Measure list screen). Conditionally Required. The import will attempt to determine the unit of measurement based on INVENTORY ITEM SKU and LOCATION. If multiple package variations of the same SKU are being stored in the same LOCATION, this may be required. Example: “DOZEN” | 6 | UNIT OF MEASURE COUNT | see notes | Numeric | N/A | Conditionally Required. If column UNIT OF MEASUREMENT has been supplied, this will specify the number of individual units contained within the unit of measure. Example: “12” |
The attached documentation includes the OLX Inventory Adjustment Import Spec, Template, and Example. |