OLX Inventory Synchronization Import

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 counts in OLX will be updated to reflect this many units as available to sell.

**NOTE: To use the inventory synchronization routine, the following conditions must be met:

  • SKUs in OLX must be stored only in a single location.
  • SKUs must be set with a UOM of “Each” and a UOM Count of 1.
  • Inventory Synch file cannot include item counts for allocated inventory.
  • Inventory Synch file should aggregate all stock for a given SKU (across all warehouse storage locations) into a single record which reflects the total amount of stock available to sell for the given SKU.

Upon import for each SKU, the OLX Inventory count at the storage location will be updated to reflect the sum of (AVAILABLE_TO_SELL + Count of Units Assigned to Order Items with a status = “Item Awaiting Ship Confirmation”)

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

INVENTORY_ITEM_SKU

YES

Alpha

100

Item SKU (Stock Keep Unit)

2

FULFILLMENT_CENTER

YES

Alpha

100

This is the exact name of where the item is being stored in OrderLogix. Item must already have a history of being stored at this location.

Example: “WAREHOUSE01”

3

AVAILABLE_TO_SELL

YES

Numeric

N/A

This represents the amount of the SKU that is available to sell and has not already been allocated to shipping orders. It must be a whole number, decimals and negative numbers are not allowed.



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