OLX Inventory Synchronization Import

OLX Inventory Synchronization Import

Info
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 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:

  1. SKUs in OLX must be stored only in a single location.
  2. SKUs must be set with a UOM of “Each” and a UOM Count of 1.
  3. Inventory Synch file cannot include item counts for allocated inventory.
  4. 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”)

Making The Connection

Where Will I See This Within OLX?

Inventory sync will be noticed with orders going to back order or being eligible for shipping export.

What Reports Can Be Pulled?

  2. Inventory Item Location Report Definitions
  3. Inventory Item List Report Definitions

Trouble Shooting

  1. h2 as needed


Setup

Import Configuration

Navigate to Processing > Import/Export > Imports


  1. Category = Inventory Imports
  2. Import Type = OLX Inventory Sync Import

Data Source

    1. Upload

      2. This will allow you to upload a file directly from the device you are working from
      3. 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

      2. Server Address - This is the host name of the server where files will be collected from. An IP address can also be used.
      3. 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.
      4. 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.
      5. User Name - This is the user name for the remote server.
      6. Password - This is the password for the remote server.
      7. 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)

      2. Server Address - This is the host name of the server where files will be collected from. An IP address can also be used.
      3. 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.
      4. 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.
      5. User Name - This is the user name for the remote server.
      6. Password - This is the password for the remote server.
      7. 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)

      2. Server Address - This is the host name of the server where files will be collected from. An IP address can also be used.
      3. 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.
      4. 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.
      5. User Name - This is the user name for the remote server.
      6. Password - This is the password for the remote server.
      7. 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
      2. Mail Server - The name of the email server you are using.
      3. Login - This is the user name for the mail server.
      4. Password - This is the password for the mail server.
      5. Server Port - Unless instructed otherwise this should be set to 110
      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)

Configuration Tab


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

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
01
INVENTORY_ITEM_SKU
YES
Alpha
100
Item SKU (Stock Keep Unit)
02
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”
03
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.



Attachments

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

Copyright 2019
Revised 2.05.2025

    • Related Articles

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