OLX Inventory SKU Association Import

OLX Inventory SKU Association Import

Info
Module: Imports/Exports
Path: Processing > Imports/Exports > Imports/Exports
Topic: OLX Inventory SKU Association Import
Version(s):  5.1 & up
Editions: Standard, Commerce, Call Center


What Is 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.”


Making The Connection

Where Will I See This Within OLX?

On order detail you'll see an inventory icon on each line item that has inventory associated. This will also affect shipping exports that are looking for inventory related data.

What Reports Can Be Pulled?

What Imports/Exports Relate to OLX Inventory SKU Association Import

  1. OLX Item Offer Import Spec

Trouble Shooting



Setup

Import Configuration

Navigate to Processing > Import/Export > Imports


  1. Category = Inventory Imports
  2. Import Type = OLX Inventory SKU Association Import

Data Source

    1. Upload

      1. This will allow you to upload a file directly from the device you are working from
      2. Select Choose File to initiate a file window popup that will allow you to navigate to the specific file you are trying to upload
    2. FTP

      1. Server Address - This is the host name of the server where files will be collected from. An IP address can also be used.
      2. Server Port - This indicates the specific FTP/SFTP port to use. This is an advanced feature and should be left at (default) unless the FTP operator indicates that it should be something different.
      3. Folder - This indicates the relative folder on the remote server where the files should be gathered from. If this is unknown, the default of “/” should be used.
      4. User Name - This is the user name for the remote server.
      5. Password - This is the password for the remote server.
      6. Pattern - Use the pattern field to specify which files are to be collected. Use the * (asterisk) as a wildcard to indicate any character or group of characters in the file name. For example, if the file to be collected is named “Acme_01-31-2012.PGP”, you could specify the pattern “Acme*.PGP”. This will attempt to collect all files that begin with “Acme” and end with “.PGP”. You may only use one * in the pattern field. The pattern must end in either .PGP or .GPG if the data being transferred is of a sensitive nature (as indicated by the selected imports specification)
    3. SFTP (SSH)

      1. Server Address - This is the host name of the server where files will be collected from. An IP address can also be used.
      2. Server Port - This indicates the specific FTP/SFTP port to use. This is an advanced feature and should be left at (default) unless the FTP operator indicates that it should be something different.
      3. Folder - This indicates the relative folder on the remote server where the files should be gathered from. If this is unknown, the default of “/” should be used.
      4. User Name - This is the user name for the remote server.
      5. Password - This is the password for the remote server.
      6. Pattern - Use the pattern field to specify which files are to be collected. Use the * (asterisk) as a wildcard to indicate any character or group of characters in the file name. For example, if the file to be collected is named “Acme_01-31-2012.PGP”, you could specify the pattern “Acme*.PGP”. This will attempt to collect all files that begin with “Acme” and end with “.PGP”. You may only use one * in the pattern field. The pattern must end in either .PGP or .GPG if the data being transferred is of a sensitive nature (as indicated by the selected imports specification)
    4. FTPS (SSL)

      1. Server Address - This is the host name of the server where files will be collected from. An IP address can also be used.
      2. Server Port - This indicates the specific FTP/SFTP port to use. This is an advanced feature and should be left at (default) unless the FTP operator indicates that it should be something different.
      3. Folder - This indicates the relative folder on the remote server where the files should be gathered from. If this is unknown, the default of “/” should be used.
      4. User Name - This is the user name for the remote server.
      5. Password - This is the password for the remote server.
      6. Pattern - Use the pattern field to specify which files are to be collected. Use the * (asterisk) as a wildcard to indicate any character or group of characters in the file name. For example, if the file to be collected is named “Acme_01-31-2012.PGP”, you could specify the pattern “Acme*.PGP”. This will attempt to collect all files that begin with “Acme” and end with “.PGP”. You may only use one * in the pattern field. The pattern must end in either .PGP or .GPG if the data being transferred is of a sensitive nature (as indicated by the selected imports specification)
    5. Email
      1. Mail Server - The name of the email server you are using.
      2. Login - This is the user name for the mail server.
      3. Password - This is the password for the mail server.
      4. Server Port - Unless instructed otherwise this should be set to 110
      5. Pattern - Use the pattern field to specify which files are to be collected. Use the * (asterisk) as a wildcard to indicate any character or group of characters in the file name. For example, if the file to be collected is named “Acme_01-31-2012.PGP”, you could specify the pattern “Acme*.PGP”. This will attempt to collect all files that begin with “Acme” and end with “.PGP”. You may only use one * in the pattern field. The pattern must end in either .PGP or .GPG if the data being transferred is of a sensitive nature (as indicated by the selected imports specification)

Configuration Tab


  1. Default Warehouse
    1. Selection here will set for each line on import that does not have a value in this column.
    2. Select warehouse from drop down to associate to the inventory record on the product item.
    3. This tells the system where to pull inventory from when this product is sold.
  2. Default Warehouse Location
    1. Selection here will set for each line on import that does not have a value in this column.
    2. Select warehouse location to associate to the inventory record on the product item.
    3. This tells the system where to pull inventory from when this product is sold.
  3. Default Unit of Measurement
    1. Selection here will set for each line on import that does not have a value in this column.
    2. Select unit of measurement to associate to the inventory record on the product item
  4. Default Unit of Measurement Count
    1. Selection here will set for each line on import that does not have a value in this column.
    2. Select unit of measurement count to associate to the inventory record on the product item.
  5. File Includes Header Row
    1. checked - the first row will be ignored for data
    2. unchecked - first row will be reviewed for data

Decryption Tab

  1. None
    1. no decryption method will be used


  2. Zip 
    1. the password entered here is the password needed to unzip the file and pull the information into the system

  3. PGP
    1. PGP Key Option - select the PGP from the drop down
    2. Verify passphrase - this must match the passphrase associated to the selected PGP above


Results Tab


The Results tab will display a summary of information imported or information about any potential error(s) to help you resolve and try again.


Spec

File Format

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

  1. #
    1. position the field is required to be listed in when importing the file
  2. Field Names 
    1. A list of passable import fields, which can be transposed (viewed horizontally, instead of vertically) into the columns of a header row.
  3. Required 
    1. Defines if information must be provided for the field or not.  
  4. Type 
    1. Defines the character type (what keyboard characters are allowed in the field): 
      1. Alpha – letters, numbers and simple symbols (ex. @, -, / or &) 
      2. Numeric – numbers only 
      3. Date – format shown in Field Description (ex. MM/DD/YYYY) 
      4. Boolean – 1 for True or 0 for False
  5. Max
    1. The maximum amount of the Type characters that can be passed for the field. 
  6. Field Description
    1. Notes, examples and formatting


#

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 (Base Item) 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



Attachments

The attached documentation includes the Spec, Template, and Example.


Copyright 2019
Revised 2.13.2025
    • 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 Synchronization Import

      Module: Imports/Exports Path: Processing > Imports/Exports > Imports Topic: OLX Inventory Synchronization Import Version(s): 5.1 & up Editions: Standard, Commerce, Call Center What Is OLX Inventory Synchronization Import The OLX Inventory ...
    • OLX Inventory Adjustment Import

      Module: Imports Path: Processing > Imports/Exports > Imports Topic: OLX Inventory Adjustment Import Version(s): 5.1 & up Editions: Commerce, Call Center What Are OLX Inventory Adjustment Import The OLX Inventory Adjustment Import allows for batch ...
    • 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 ...