Created: January 9, 2019
Updated: February 15, 2024
sticky.io allows you to import products in a CSV formatted text file with the following input fields. The Products import file can be uploaded through the Import Queue located within Insights >Import/Export Data.
The import product files includes the base fields for creating a product. Any additional product settings, including email notifications, will need to be done from within the CRM interface. If a required field is not properly formatted or blank, the import process will skip that product and it will not be created.
Field Name | Format | Values | Comments |
Name | String 255 characters | The name of the product | REQUIRED |
Description | Text | A breif description of the product | Optional |
SKU | String 255 characters | Unique product identifier that will be used for inventory and fulfillment | REQUIRED |
category_id | Numeric ID | The category that this product is accociated with | REQUIRED |
price | Numeric | The price of the product | REQUIRED |
cost_of_goods | Numeric | Total of costs used to create the product or service | Optional |
restocking_fee | Numeric | The restocking fee is the amount that will be excluded from a refund if it fits the criteria of a return or customized RMA | Optional |
collections | 1 for YES | Specify whether or not this product is eligible for collections | Optional will equal NO if not passed |
signature_confirmation | 1 for YES | Speify if the product will recquire a signature confirmation | Optional will equal NO if not passed |
delivery_confirmation | 1 for YES | Specify if the product will recquire a delivery confirmation | Optional will equal NO if not passed |
shippable | 1 for YES | Specify if this is a shippable product | Optional will equal NO if not passed |
digital_download | 1 for YES | Specify if this is a digitally delivered product. If YES then a digital_download_url is REQUIRED | Optional will equal NO if not passed |
digital_download_url | String 255 characters | The url where your product can be download by the customer. | Optional- REQUIRED if digital_download is YES |
max_quantity | Numeric 1 to 999,999 | Specify the maximum purchase quantity allowed for a product | REQUIRED |
email_trigger_ids | Numeric | This field is used to attach email triggers to a product | Optional |
declared_value | Numeric | This is the declared value for the product | Optional |
products_weight | Numeric | This is the weight of the product | Optional |
weight_unit_id | Numeric | This is the unit of measurement for the weight of the product | Optional |
vertical_id | Numeric | This is the vertical id of the product | Optional |