Importing Orders

Lime Light CRM allows you to import orders in a CSV formatted text file with the following input fields.  Each data item is required to be in the file, but some fields can be blank.  If a required item is not properly formatted or blank, the import process will skip that order and it will not be processed.  There are 5 custom fields that we will pass through to the output CSV to allow you to keep your data relationships intact.  The upsell product Id field is the last field listed to allow you to add an unknown number of upsells to the orders.  Since each campaign can be setup differently, we allow you an unlimited number of upsells to attach to an order.  Caution must be used though, as each upsell product Id must be already created and valid within Lime Light CRM.  If invalid or unknown campaign, shipping, or product Id’s are used, the import process will skip that order and it will not be processed.

 

Field Name

Format

Values

Comments

shipping_first_name

Alphanumeric
Max 60 Characters

Customer’s first name

Required, cannot be blank

shipping_last_name

Alphanumeric
Max 60 Characters

Customer’s last name

Required, cannot be blank

ship_address1

Alphanumeric
Max 60 Characters

Shipping street address

Required, cannot be blank

ship_address2

Alphanumeric
Max 60 Characters

Shipping street address

Optional

ship_city

Alphanumeric
Max 30 Characters

Shipping City

Required, cannot be blank

ship_state

Alphanumeric
Max 30 Characters

Shipping State

Required, cannot be blank

ship_zip

Alphanumeric
Max 10 Characters

Shipping zip

Required, cannot be blank

ship_country

Alphanumeric
Max 30 Characters

The 2 character ISO 3166-1 alpha-2  country code

Required, cannot be blank

phone

Numeric
Max 20 Characters

Customer’s phone number

Required, cannot be blank. No formatting characters, example:

8135551212

email_address

Alphanumeric
Max 90 Characters

Customer’s email address

Required, cannot be blank

billing_first_name

Alphanumeric
Max 60 Characters

Customer’s first name  Optional

billing_last_name

Alphanumeric
Max 60 Characters

Customer’s last name  Optional

billing_street_address1

Alphanumeric
Max 60 Characters

Billing address

Required, cannot be blank

billing_street_address2

Alphanumeric
Max 60 Characters

Billing address

Optional

billing_city

Alphanumeric
Max 30 Characters

Billing city

Required, cannot be blank

billing_state

Alphanumeric
Max 30 Characters

Billing state

Required, cannot be blank

billing_zip

Alphanumeric
Max 10 Characters

Billing zip

Required, cannot be blank

billing_country

Alphanumeric
Max 2 Characters

The 2 character ISO 3166-1 alpha-2  country code

Required, cannot be blank

payment_type Alphanumeric
Max 20 Characters
Credit card type Required, cannot be blank   Allowed values: “visa”, “master”, “discover” ,  “amex” ,  “checking”,"solo", "maestro", "switch", "offline"

credit_card_number

Alphanumeric
Max 30 Characters

Customer’s credit card number

Required, cannot be blank unless payment type is "offline".

credit_card_expiration

Alphanumeric
Max 4 Characters

Credit card expiration in this format: MMYY

If month is < 10, add leading 0

Required, cannot be blank unless payment type is "offline".
Example:  0609 or 1013

CVV

Alphanumeric
Max 4 Characters

CVV data, length of 3 for visa, master, discover, length of 4 for amex

Required. If not used, leave blank.
Example: 123

checking_account_number Numeric Max 17 Characters If you are creating a checking account order, is the consumers checking account number Required, if "checking" is the payment_type
checking_routing_number Numeric
Max 9 Characters
If you are creating a checking account order, is the consumers routing number on the account Required, if "checking" is the payment_type
checking_SSN Number Max 4 Characters If you are creating a checking account order, this is the last 4  of the consumers SSN # Required, only if "checking" is the payment_type, and the check provider requires it, e.g. Actum Processing

campaign_Id

Numeric
Max 5 Characters

A valid campaign Id for a campaign in Lime Light CRM

Required, cannot be blank.
If this is not a valid campaign Id, it will cause the order to fail and be skipped

shipping_Id

Numeric
Max 5 Characters

A valid shipping Id for a campaign in Lime Light CRM

Required, cannot be blank.

If this is not a valid shipping  Id, it will cause order to fail and be skipped

product_Id

Numeric
Max 5 Characters

A valid product Id for a campaign in Lime Light CRM

Required, cannot be blank.

If this is not a valid product Id, it will cause the order to fail and be skipped

product_quantity

Numeric                            Max 6 characters

Total units purchased

Optional. Defaults to one

product_custom_price Numeric Dynamic product price

 

Optional

 

product_attributes

Alphanumeric, SSV

Product attribute option names

Conditional, required if the product_id has variants, e.g. "Large;Red"

Ip_address

Alphanumeric
Max 255 Characters

The Ip Address of the customer

Required, cannot be blank.

Example: 127.0.0.1

custom_field_1

Alphanumeric
Max 255 Characters

If populated, this will be output in the CSV results file.  We do nothing with this data.

Required. If not used, leave blank.

 This allows users to pass through data as needed.

custom_field_2

Alphanumeric
Max 255 Characters

 

Required. If not used, leave blank.

custom_field_3

Alphanumeric
Max 255 Characters

 

Required. If not used, leave blank.

custom_field_4

Alphanumeric
Max 255 Characters

 

Required. If not used, leave blank.

custom_field_5

Alphanumeric
Max 255 Characters

 

Required. If not used, leave blank.

AFID

Alphanumeric
Max 255 Characters

Affiliate Id field

Required. If not used, leave blank

SID

Alphanumeric
Max 255 Characters

Affiliate Id field

Required. If not used, leave blank

AFFID

Alphanumeric
Max 255 Characters

Affiliate Id field

Required. If not used, leave blank

C1

Alphanumeric
Max 255 Characters

Affiliate Id field

Required. If not used, leave blank

C2

Alphanumeric
Max 255 Characters

Affiliate Id field

Required. If not used, leave blank

C3

Alphanumeric
Max 255 Characters

Affiliate Id field

Required. If not used, leave blank

BID

Alphanumeric
Max 255 Characters

Affiliate Id field

Required. If not used, leave blank

AID

Alphanumeric
Max 255 Characters

Affiliate Id field

Required. If not used, leave blank

OPT

Alphanumeric
Max 255 Characters

Affiliate Id field

Required. If not used, leave blan

 

additional_product_ids

 

CSV

List of additional product upsells related to the campaign

Optional e.g. 1,2,3

additional_product_quantities

CSV

List of additional product quantities in sequential relation to additional_product_ids

Optional. Dependent on additional_product_ids e.g. 10,2,1

additional_product_custom_prices

CSV

List of additional product prices in sequential relation to additional_product_ids

Optional. Dependent on additional_product_ids e.g. 10.00,2.50,5.68

additional_product_attributes

Alphanumeric, CSV/SSV

Comma separated list of products

Semicolon separated list of product options

Conditional, required if the associated additional_product_id has variants, e.g. "Large;Red,Small;Green" would identify two variants for additional_product_ids 1 and 2

 

 

 

ISO country codes can be found here:

http://www.iso.org/iso/country_codes/iso_3166_code_lists/country_names_and_code_elements.htm

Have more questions? Submit a request

0 Comments

Article is closed for comments.