Values that are blank,""
or null
will DELETE the field value.
For example, if you upload a file with a gender
column and customer record without that column filled will erase what is presently on the customer record.
Values must be UTF-8
encoded
Values must be comma delimited
Records must end with a newline (\n
)
Any value may be optionally quoted via double quote ("
) characters
Any field containing a double quote must be quoted. The escape character for an embedded quote is a second quote character. (For example: "Customers think this product is ""Amazing!"""
)
Each record must contain exactly the same number of fields as the header does
No carriage return (\r
) or newline (\n
) may exist within a record
Date / Time fields must be formatted as follows:
Date Format | Examples |
Unix Timestamp / Epoch |
|
​ISO 8601​ |
|
%Y-%m-%d %H:%M:%S%:z |
|
%Y-%m-%d %H:%M:%S |
|
'%m/%d/%y %H:%M |
|
%m/%d/%y %H:%M:%S |
|
%m/%d/%Y %H:%M:%S |
|
%m/%d/%Y %H:%M |
|
If time and time zone are not provided the time is assumed be 12am UTC.
Any record that contains an invalid field will be ignored. If more than 1% of the data is invalid, the entire file will be rejected. The Activity Log will show the status of the uploads, any errors generated, and a success entry if the data is loaded successfully.
Object | File Name Prefix |
Products |
|
Customers |
|
Orders |
|
Events |
|
Lists |
|
Go to Account Settings -> Integrations​
Select Upload CSV -> Browse
Select the file that follows the file name and format conventions outlined below
The files below are only basic examples.
Refer to the Zaius schema section to learn about all available default fields and creating custom fields & objects.
Get more information about the contents of a customer file here.
Get more information about the contents of a product file here.
Get more information about the contents of an orders import here.
Shared Fields
action
value should be one of purchase | refund | return | cancel
order_id (REQUIRED)
ts (REQUIRED)
identifier (REQUIRED - any identifier is accepted)
Order Summary Fields
total
discount
subtotal
tax
shipping
coupon_code
first_name
last_name
bill_address
ship_address
Order Line Item fields (and the associated events) cannot be updated in the future, only summary fields (for refunds, returns, cancellations).
Order Line Item Fields (one row per line item)
item_product_id
item_sku
item_price
item_quantity
item_discount
item_subtotal
Prefix all custom event fields with item_
to indicate the field exists on the Event object, otherwise it will be assumed you attempting to update the Orders object.
Get more information about the content of events imports here.
Get more information about the content of lists imports here.
Uploading a List file without an "action" column assumes a subscription for each email
Upload to Multiple Lists
Get more information about the content custom object imports here.
Replace customobject
with the name of the custom object
All custom object updates must include the primary key (or keys in the case of composite keys) in the file (e.g. id
)