Historical Order Feed

The historical order feed is for working with past order data. You can use this feed for a one-time import of past transactional data. You can also use this feed to update order data, such as changing estimated delivery dates. New orders are transferred via the JavaScript Order Feed in real time.

Providing the historical order feed

You can provide a historical order feed to Emplif Ratings & Reviews by manually uploading the file, supplying the file's URL or FTP location, or using the TurnTo API for Emplifi Ratings & Reviews.

Manual File Upload

Feeds uploaded through the Ratings & Review Portal have a 250 MB file size limit. Larger feed files should be delivered via FTP or through the API.

Steps:

In Emplifi Ratings & Reviews, click Settings → Feeds → Upload Feed.
From the Feed Type dropdown menu, select TurnTo Batch Orders.
(Optional) Select an encoding.
Select your file, and then click Submit.

Upload File by URL or FTP

Steps:

In Emplifi Ratings & Reviews, click Settings → Manage Site.
In the Transactional Orders Feed Url field, enter the file URL or FTP location.
Scroll to the bottom of the page and click Update to save your changes.

To deliver via the TurnTo API for Emplifi Ratings & Reviews, see Automating Feeds with the TurnTo API for Emplifi Ratings & Reviews.

TurnTo Batch Orders Feed Format

Ensure that your feed file adheres to these formatting requirements:

The feed must be a tab-delimited text file.
The first row of the tab-delimited file must include at least the required headers, in any order.
Each line item in an order is on a separate row.

Supported data fields

Header	Header Required	Value Required	Description
ORDERID	Yes	Yes	The unique identifier for the order from your system. Can be alphanumeric and not to exceed 255 characters.
ORDERDATE	Yes	Yes	The date the order was placed. Valid date formats: `yyyy-MM-dd'T'HH:mm:ssZ` `yyyy-MM-dd` `yyyy-MM-dd HH:mm:ss.000`
EMAIL	Yes	Yes	The customer's email address. Usually used as a unique customer identifier. To include a different unique identifier from your system, use the `USERID` field.
ITEMTITLE	Yes	Yes	The title of the purchased item.
ITEMURL	Yes	Yes	The product page for the purchased item.
FIRSTNAME	Yes	Yes	The customer's first name.
LASTNAME	Yes	Yes	The customer's last name.
SKU	Yes	Yes	The SKU of the item that ties it to the catalog.
ITEMLINEID	Yes	No	The line ID of the item in the context of the order. If an order consists of more than one purchased item, each row will have a different `ITEMLINEID`.
ZIP	Yes	No	The customer's zip code.
PRICE	Yes	No	The item price in `###.##` format.
ITEMIMAGEURL	No	No	The URL of the item image.
NICKNAME	No	No	An alias that the customer may have in your system. If this is included in the feed, it will be used in place of the first and last names.
USERID	No	No	A unique identifer for the customer in your system.
TEASERSHOWN	No	No	At the time the order is placed you can save the value of the TURNTO_TEASER_SHOWN cookie to your datastore associated with the order. Provide that value in this field.
TEASERCLICKED	No	No	At the time the order is placed you can save the value of the TURNTO_TEASER_COOKIE cookie to your datastore associated with the order. Provide that value in this field.
DELIVERYDATE	No	Maybe	The date the order was likely delivered. Valid date formats: `yyyy-MM-dd'T'HH:mm:ssZ` `yyyy-MM-dd` `yyyy-MM-dd HH:mm:ss.000` If your site uses the Trigger initial RSE based on Delivery Date reviews setting and you provide this field, `DELIVERYDATE` is used instead of `ORDERDATE` when sending questions to customers. If your site uses the Trigger initial RSE based on Delivery Date reviews setting, you must send this data point to calculate when to send your review solicitation emails. Without DELIVERYDATE details, review emails will not be sent out.
LOCALE	No	No	The customer's preferred locale. The locale must contain both the language and country code. Example for Canadian French: `fr_CA`

Sample TurnTo Batch Orders Feed Format

For your reference, the following is a sample of the TurnTo Batch Orders Feed:

CODE

ORDERID	ORDERDATE	EMAIL	ITEMTITLE	ITEMURL	ITEMLINEID	ZIP	FIRSTNAME	LASTNAME	SKU	PRICE
1	2020-03-15	jane@mail.com	Product 1	https://www.domain.com/SKU1		90210	Jane	Doe	SKU1
2	2020-03-18	john@mail.com	Product 2	https://www.domain.com/SKU2		90210	John	Doe	SKU2
3	2020-03-20	sam@mail.com	Product 3	https://www.domain.com/SKU3		11111	Sam	Iam	SKU3

Handling orders with items that ship separately

If an order is delivered to a customer in multiple shipments, you can choose to send those order details to Emplifi Ratings & Reviews under either of the following conditions:

When the final item has shipped
Each time another shipment is sent

However, if you choose to send order details each time another shipment is sent, you must also include details for all previously-shipped items in that order. If you only send the new items, your update will overwrite the existing data for that order.

Example: one order, two shipments - wait until final shipment

A customer places a single order for items A and B. The items are shipped three days apart.

If your site uses the Trigger initial RSE based on Delivery Date reviews setting, the delivery date for all items should be set to the most recently shipped item's date.

On February 8th:

You ship item A.

On February 11th:

You ship item B.
You send Emplifi Ratings & Reviews details for this order, including details for item A and details for item B.

Example: incremental updates

A customer places a single order for items C and D. The items are shipped three days apart.

On February 8th:

You ship item C.
You send Emplifi Ratings & Reviews details for this order, specifically about item C.

On February 11th:

You ship item D.
You send Emplifi Ratings & Reviews details for this order, including details for item C and details for item D.

Exporting Historical Orders from Yahoo! Stores

To collect your order data from Yahoo! Stores:

Sign in to your Yahoo! My Services page.
Under Control Panels, click Dashboard.
Click Orders.
Under Order Manager, choose Format: Full Order and Format: Generic CSV
Choose the range of numbers you want to export. Note that Yahoo! will only let you export 3,000 orders at a time.
Download these files:
- Products.csv
- Orders.csv
- Items.csv

You can upload these files in your Emplifi Ratings & Reviews site settings under Upload Feed with feed type: Yahoo Order Export. To deliver via the TurnTo API for Ratings & Reviews, see Automating Feeds with the TurnTo API for Emplifi Ratings & Reviews.