OLX Inventory Adjustment Import

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 inventory amount adjustments in the OrderLogix application by providing relative or absolute adjustment amounts.

Making The Connection

Where Will I See This Within OLX?

This import will affect orders with inventory assigned and the shipping export.

What Reports Can Be Pulled?

What Imports/Exports Relate to Inventory Adjustment


Trouble Shooting


Setup

Import Configuration

Navigate to Processing > Import/Export > Imports


  1. Category = Inventory Imports
  2. Import Type = OLX Inventory Adjustment 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. if the file you are importing contains headers check this box
  2. Default Location
    1. This is the exact name of where the item is being stored. Item must already have a history of being stored at this location.
  3. Default Amount
    1. This represents the amount of the adjustment. It must be a whole number, decimals and negative numbers are not allowed.
  4. Default Operator
    1. This character determines how the ADJUSTMENT_AMOUNT will be applied to the inventory at the specified location.
      1. Add - “+” increase by ADJUSTMENT AMOUNT
      2. Subtract - “-“decrease by ADJUSTMENT AMOUNT
      3. Absolute - “=” set to the ADJUSTMENT AMOUNT

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 something similar to what you displayed above or if there are errors it will display information about the error 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


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.



Copyright 2019
Revised 8.08.2024

Attachments

The attached documentation includes the 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 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 ...