OLX Inventory SKU Association Import

OLX Inventory SKU Association Import

The OLX Inventory SKU Association Import allows inventory items that have already been added to the OrderLogix application to be associated with OLX Products. These associations can both be added or deleted with this import.

Product Inventory Mode

OLX Products have a setting which indicates whether or not they are affected by inventory, and which system is used. When inventory SKUs are associated with products, the products inventory mode will be switched from “not controlled” to “internal inventory.” When the last inventory SKU association is removed from a product, the product inventory mode will be switched to “not controlled.”

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.

Import Definitions:


#

Field Name

Req.

Type

Max

Field Description

1

PRODUCT NAME

YES

Alpha

100

OLX Product Name to bind the inventory SKU. NOTE: Must be an exact match to a valid product name in OLX.

2

INVENTORY SKU

YES

Alpha

100

Inventory Item SKU to associate to the OLX Product.

3

LOCATION

YES

Alpha

100

Stored location of SKU. Inventory must be sold from a particular location.

4

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”

5

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”

6

QUANTITY

YES

Numeric

N/A

The number of Inventory Items in the LOCATION that are sold for each OLX product sold.

7

ACTION

NO

Alpha

10

Optional. Determine what to do with the inventory SKU in relation to the OLX product. If this column is left blank, the default action will be APPEND.

Require Format:

“APPEND”          add to OLX Product

“DELETE”           remove from OLX Product

“OVERWRITE”   overwrite existing OLX Product

The attached documentation includes the OLX Inventory SKU Association Import Spec, Template, and Example.


    • Related Articles

    • OLX Inventory SKU Import

      Module: Import Path: Processing > Import/Export > Import Topic: Inventory Sku Import Version(s): 5.1 & up Editions: All What Is OLX Inventory SKU Import The OLX Inventory SKU Import allows for adding new, and updating existing, inventory SKUs ...

    • OLX Inventory Synchronization Import

      The OLX Inventory Synchronization Import allows for batch inventory amount adjustments in the OrderLogix application by providing amounts available to sell by SKU for every SKU in the warehouse.  These counts will be evaluated and the Inventory ...

    • OLX Inventory Supplier Import

      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 ...

    • OLX Inventory Adjustment Import

      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 ...

    • OLX Supplier Pricing Import

      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 ...