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 information in the OrderLogix application. It can also provide limited receipt functionality, in order for stock to be added in one step.

---

Making The Connection

Where Will I See This Within OLX?

You will see this during Inventory Sync, Shipping Export, and on Inventory Item.

What Reports Can Be Pulled?

1. Inventory Item List Report Definitions (orderlogix.com)
   
2. Warehouse Report Definitions (orderlogix.com)
   
3. Supplier Item Report Definitions (orderlogix.com)
   
4. Inventory Item Location Report Definitions (orderlogix.com)

What Imports/Exports Relate to Inventory SKU Import

1. OLX Inventory Synchronization Import (orderlogix.com)
   
2. OLX Inventory Adjustment Import (orderlogix.com)
3. OLX Inventory SKU Association Import (orderlogix.com)
   
4. OLX Supplier Pricing Import (orderlogix.com)
   
5. OLX Inventory Supplier Import (orderlogix.com)

---

Trouble Shooting

1. Line:1 has followings errors:
   REORDER_LEVEL must be a valid numeric value.INVENTORY_VALUE must be a valid numeric value.Index:(1) - Location (LOCATION) unit of measurement UNIT OF MEASUREMENT does not exists.
   Index:(1) - Location (LOCATION) doesn't exists.
   Index:(1) - Location (LOCATION) has invalid quantity.
   Index:(1) - Location (LOCATION) has invalid unit of measurement count.
   Index:(1) - Location (LOCATION) has invalid search order.
   CATEGORY:CATEGORY doesn't exists.CLIENT:CLIENT doesn't exists.SUPPLIER:SUPPLIER doesn't exists.
1. check to see if you have the Includes Header checked.

Import Configuration

1. Category = Inventory Imports
   
2. Import Type = OLX Inventory SKU Import
   
3. Data Source

1. Upload
   
1. 
   
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
   
1. 
   
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)
   
1. 
   
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)
   
1. 
   
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
   
1. 
   
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. Includes Header - 
   
1. Checked - the file you are importing contains a header row
   
2. Unchecked - you do not have a header row on the file being imported
2. Default Reorder Level - any numerical value to be assigned to all items being imported
3. Default Unit of Measure
   
1. none - no Unit of Measure selected, will set via import
   
2. if you select a Unit of Measure from the drop down the system will set this as the Unit of Measure for all items being imported
4. Default Quantity - any numerical value to be assigned to all items being imported
   
5. Default Category
   
1. none - no Category selected, will set via import
   
2. if you select a Category from the drop down the system will set this as the Category for all items being imported
6. Default Location
   
1. none - no Location selected, will set via import 
2. if you select a Location from the drop down the system will set this as the Location for all items being imported  
7. Default Preferred Supplier
   
1. none - no Preferred Supplier selected, will set via import
   
2. if you select a Preferred Supplier from the drop down the system will set this as the Preferred Supplier for all items being imported
8. Default Client
   
1. none - no Client selected, will set via import
   
2. if you select a Client from the drop down the system will set this as the Client for all items being imported
9. Default Search Order
   
1. 0 is your default Sell From Location
   
2. 1 - 100 will assign to additional warehouse locations you are using. This value needs to be determined when setting up warehouse locations and used consistently across inventory setup.

Decryption Tab

1. None
   
1. no decryption method will be used
2. 
   
   
   
2. Zip 
   
1. the password entered here is the password needed to unzip the file and pull the information into the system
2. 
   
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
3. 

Results Tab

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

To utilize multiple values in a single field use a pipe ( | ) to separate the values

#	Field Name	Req.	Type	Max	Field Description
1	INVENTORY SKU	YES	Alpha	100	Inventory Item name (SKU)
2	CATEGORY	see notes	String	100	Category for the SKU. Required for new SKUs only.  NOTE: If value provided for existing SKU, category will be updated.
3	SUPPLIER	NO	Alpha	100	Preferred supplier name associated with the SKU. NOTE: If value provided for existing SKU, supplier will be updated.
4	DESCRIPTION	see notes	Alpha	100	SKU Description. Required for new SKUs only. NOTE: If value provided for existing SKU, description will be updated.
5	REORDER LEVEL	see notes	Numeric	N/A	Set number of units in inventory to reordered at. Required for new SKUs only. NOTE: If value provided for existing SKU, reorder level will be updated.
6	LOCATION	YES	Alpha	100	Stored location of SKU. NOTE: To utilize multiple values in a single field use a pipe ( | ) to separate the values
7	UNIT OF MEASUREMENT	YES	Alpha	10	The name of any valid unit of measurement in OLX (Unit of Measure list screen). REQUIRED if adding multiple locations NOTE: If value provided for existing SKU, it may be required if there are different SKUs occupying the same warehouse location. Example: “DOZEN” To utilize multiple values in a single field use a pipe ( | ) to separate the values
8	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. REQUIRED if adding multiple locations NOTE: To utilize multiple values in a single field use a pipe ( | ) to separate the values Example: “12”
9	QUANTITY	see notes	Numeric	N/A	This is the amount of the SKU that is being received or seeded for this SKU. REQUIRED if adding multiple locations NOTE: To utilize multiple values in a single field use a pipe ( | ) to separate the values
10	INVENTORY VALUE	NO	Decimal	N/A	This is the dollar value of this SKUs being imported. For new SKUs, this will be the initial value of the inventory that has been seeded. For existing SKUs, this value will be averaged with the current value of the SKU, unless the current value of the SKU is zero, in which case the value will be set as the initial value.
11	SEARCH ORDER	YES	Numeric	N/A	Required when using locations, this determines the order the warehouse locations will be used during exports. NOTE: To utilize multiple values in a single field use a pipe ( | ) to separate the values
12	CLIENT	YES	Alpha	N/A	The client to associate the inventory item to.

Attachments