June 24, 2013 14:51

sticky.io 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 sticky.io. 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.

Templates for File Import can be downloaded on the Import/Export page in the Platform.

ISO country codes can be found here:

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