OLX Item Offer Import Spec

OLX Item Offer Import Spec


Spec

The OLX Item Offer Import is a three-function import that can create both new items and product offers, while attaching (or not attaching) them to scripts in the OrderLogix application. This is accomplished by creating a CSV (a file with information fields, each separated by a single comma) with all required information, leaving the unused fields blank. This document will cover in detail, the specifications needed to create a valid file that OrderLogix can successfully import.

File Format: ASCII text (standard US-English letters, numbers and keyboard characters). 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:

#
Field Name
Req.
Type
Max
Field Description
1
OFFER NAME
For Offer
Alpha
50
The product offer name.
2
OFFER DESCRIPTION
For Offer
Alpha
50
The product offer description.
3
UNIT PRICE
For Offer
Numeric
50
The unit price of the product offer.
4
SHIPPING
For Offer
Numeric
255
The shipping of the product offer.
5
RUSH FEE
For Offer
Numeric
255
The rush fee of the product offer.
6
MULTIPLY SHIP BY QTY
For Offer
Boolean
50
Multiple product offer shipping by the quantity (1) or not (0).
7
COMMISSION PREF
NO
Alpha
50
Commission preference for the product offer.
8
ROYALTY PREF
NO
Alpha
20
Royalty preference for the product offer.
9
ITEM NAME
YES
Alpha
50
The item name
10
NEW ITEM?
YES
Boolean
30
Add new item (1) or update existing (0).
11
CLIENT
For Item
Alpha
30
The client of the item (must be valid in OLX).
12
DESCRIPTION
For Item
Alpha
50
The item description.
13
PRODUCT GROUP
For Item
Alpha
255
The product group (must be valid in OLX).k
14
GUARANTEE
For Item
Alpha
1
The guarantee for the item.
15
EXT SKU
For Item
Alpha
255
The item external SKU.
16
UNIT COST
For Item
Numeric
50
The unit cost of the item.
17
COUNT
For Item
Numeric
50
The unit count of the item.
18
WEIGHT
For Item
Numeric
50
The weight of the item in pounds.
19
SHORT WEB DESCRIPTION
NO
Alpha
10
The short description of the item.
20
LONG WEB DESCRIPTION
NO
Alpha
10
The long description of the item.
21
THUMBNAIL WEB IMAGE
NO
Alpha
255
The path for the thumbnail image.
22
FULL WEB IMAGE
NO
Alpha
255
The path for the image of the item.
23
DISALLOW PAY PROCESS
For Item
Boolean
1
Item is allowed to participate in payment processing (1) or not (0).
24
DISALLOW SHIP PROCESS
For Item

Boolean
1

Item is allowed to participate in shipment processing (1) or not (0).
25
CHARGE ONLY
For Item

Boolean
1

Item is a charge only item (1) or not (0). NOTE: Does not participate in shipment processing.
26
SERVICE ONLY
For Item

Boolean
1

Item is a service only item.  NOTE: Does not participate in payment processing.
27
SCRIPT
For Script
Alpha
50
A pipe delimited list of script names to attach the product offer to.  Example: “Script 1 | Script 2 | Script 3” NOTE: Pipe character found above the Enter key, hold shift. 
28
MAX DISCOUNT
For Script
Numeric
20
Maximum discount percentage for the offers between 0-100.
29
REALTIME AUTH
For Script
Boolean
1
The script product offer participates in real time authorization (1) or not (0).
30
TAKE BACK
For Script
Boolean
1
Take back paid commissions on returns (1) or not (0).
31
PAY PREF
For Script
Alpha
50
Commission payment preference for the script product offer.  Example: All Orders, Approved Sales, or Net Orders.
32
ITEM TYPE
For Script
Alpha
50
Item type for the script product offer. Example: ORD, CTY, RSH, ADD, XSL, USL
33
NEW OFFER
YES
Boolean
50
Add new product offer (1) or update existing (0).
34
Non Refundable
NO
Boolean
1
Item is non refundable (1) or not (0)
35
BackOrder Expiration
NO
Numeric
50
Back order expiration days of item

Inventory

#
Field Name
Req.
Type
Max
Field Description
1
Inventory Item Sku
For Record Type "I"
Alpha
50
Inventory Sku to attach to item. Must be a valid Inventory Item Name in OrderLogix
2
Inventory Item QTY
For Record Type "I"
Numeric
50
Inventory item's quantity
3
Inventory Item Location
For Record Type "I"
Alpha
255
Inventory item's location. Must be a valid Location in OrderLogix
4
Inventory Item Action
For Record Type "I"
Alpha
10
Action to take for inventory item. Allowed action are "Add", "UPDATE", "DELETE"

Custom Value

#
Field Name
Req.
Type
Max
Field Description
1
Custom Value Name
For Record Type "CV"
Alpha
50
The name of custom value for the item
2
Custom Value
For Record Type "CV"
Alpha
255
The custom value for the item
3
Custom Value Action
For Record Type "CV"
Alpha
10
Action to take for custom value. Allowed action are "Add", "UPDATE", "DELETE"

Tax Categories

#
Field Name
Req.
Type
Max
Field Description
1
Tax Provider
For Record Type "TC"
Alpha
50
The name of  tax provider for the item. Must be a valid Tax Provider Name in OrderLogix
2
Category Name
For Record Type "TC"
Alpha
50
The category name for the item. Must be a valid Category Name in OrderLogix
3
Tax Provider Action
For Record Type "TC"
Alpha
10
Action to take for tax categories. Allowed action are "Add", "UPDATE", "DELETE"


Trouble Shooting:

  1. ERROR: Error adding item 'XXX'.

    1. There was an error adding the new item to the database.
  2. ERROR: Error adding offer 'XXX'.

    1. There was an error adding the new offer to the database.
  3. ERROR: 'TaxCategory' The product can only have one category added for the selected provider.

    1. One tax provider can only have one tax category for the give item.

Import

Navigate to Processing > Import/Export > Imports

  1. Category = Other
  2. Import Type = OLX Item/Offer Import
  3. 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

    3. SFTP (SSH)

    4. FTPS (SSL)

    5. Email


Configuration Tab

  1. File Includes Header Row
    1. if the file you are importing contains headers check this box

Decryption Tab







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.


Attachments

The attached documentation includes the OLX Item Offer Import Spec, Template, and Example.
    • Related Articles

    • OLX Telemarketing Import Spec

      The OLX Telemarketing Import Spec is a 121 column order import used to bring outside calls and orders into the OrderLogix application. This is accomplished by creating a CSV (a file with information fields, each separated by a single comma) with all ...
    • OLX Telemarketing Import Spec

      The OLX Telemarketing Import Spec is a 121 column order import used to bring outside calls and orders into the OrderLogix application. This is accomplished by creating a CSV (a file with information fields, each separated by a single comma) with all ...
    • OLX Autoship Sequence Import Spec

      The OLX Autoship Sequence Import automates the functionality found within the application for manually creating Autoship Sequences (Company Data > Product Data > Autoship Sequences in the new Autoship Sequence Manager window). This is accomplished by ...
    • OLX Order Import/Export Spec

      The OLX Order Import/Export is compatible with OrderLogix versions 3.5 & up. It is the original (or legacy) 107 column order import used to bring outside orders into the OrderLogix application. This is accomplished by creating a CSV (a file with ...
    • OLX Order Import/Export V4 Spec

      The OLX Order Import/Export V4 is compatible with OrderLogix version 4.0 & up. It is the newer, more detailed 145 column order import used to bring outside orders into the OrderLogix application. This is accomplished by creating a CSV (a file with ...