Skip to main content

​
Historic order feed / offline orders

To help kick start PureClarity’s AI learning it is recommended that you upload up to 6 months of historic order data prior to go-live. To do this you can send a CSV file to PureClarity. The simplest way is to upload the feed via the PureClarity Admin. Go to Settings -> Data Feeds, and click “Upload Feed File”. Note that PureClarity will ignore any orders older than 1 year.
If your site handles orders in another channel to the website (such as via telephone), then these orders can be sent on a daily basis to PureClarity so that the customers experience on the website is correct.
These daily order files can be uploaded via the Admin area, or via the SFTP server.
Each unique order Id can only be sent once. Orders reusing an Id will be dropped.

​
CSV Format for order files

The header order of each column is not important – but the field names are.
FieldDescription
OrderIDUsed to map order lines together
AccountIdUnique Identifier for an Account (See below)
UserIdUnique Id of the user (See below)
EmailEmail address of the user (See below)
DateTimeDate/Time the order was made. This needs to be an ISO 8601 formatted date (see below)
ProdCodeProduct Id. This must match the Id of a product in the data feed.
QuantityNumber of items of ProdCode in the order
UnitPricePrice of a single ProdCode. Used to provide a basic order total in the admin for historical orders. NOTE: Values should have no currency symbol or comma separators. This value can either be ex-VAT or VAT depending on the site. Decimal separator must be a . and NOT and ,
LinePricePrice of the orderline (Quantity * UnitPrice). Used to provide a basic order total in the admin for historical orders. NOTE: Values should have no currency symbol or comma separators. This value can either be ex-VAT or VAT depending on the site. Decimal separator must be a . and NOT a ,
Either “Unit Price” or “Line Price” must be specified but not both.
The date/time stamp the order was made needs to be an ISO 8601 formatted date. If there is no timezone information present, then the time is assumed to be in the timezone of your site. This time zone can be altered by your Success Manager. Some examples of valid date/time formats:
FormatDescription
2016-12-25Only the date passed in. Hourly data is not used by PureClarity for offline/historical orders – but they can be included to make importing your data easier.
2016-12-25 09:00:00Order is taken as 9am on 25th December in the timezone of the site
2016-12-25T09:00:00Order is taken as 9am on 25th December in the timezone of the site. (Optional ‘T’ to separate the time)
2016-12-25T09:00:00ZOrder is taken as 9am UTC on 25th December.