Import order and product data - ExpertSender Help Center

Import order data from file

You can import order data to ExpertSender CDP from other platforms. To make sure all data will upload properly, format them according to the following instructions or use this template: Orders

How to prepare a data file for import?

Prepare your import file as follows:

The import file must be in one of the following formats: CSV, TXT, XLS, XLSX or ZIP.
The max file size for the mentioned formats is 28 MB.
Use UTF-8 as the preferred character encoding.

To format your order data properly, use the following guidelines:

Data	Type	Format	Description
Order date	Required	MM/DD/RRRR gg:mm,e.g., 09/30/2022 10:09	Date when the order was made.
Order ID	Required	A string of characters, may include digits, punctuation marks, cannot include spaces, e.g., 1, 23, 678, 3954	Order identifying number. If order ID already exists in the system or is duplicated within a file, we will not import it.
Order value	Required	Use comma or space for thousands separator, e.g., 5,290 or 5 290.	Total order value.
CRM ID	Required	A string of digits, no spaces: 1, 23, 678, 3954	Customer CRM ID. Fill in this field if the CRM ID is set as default matching mode in Settings > Customers.
Customer email	Required	john.doe@gmail.com	Customer email address. Fill in this field if email is set as default matching mode in Settings > Customers.
Customer phone	Required	Must include a prefix (country code). Leave out additional characters, such as +, (), 0 and 00.	Customer phone number with prefix. Fill in this field if the phone number is set as default matching mode in Settings > Customers.
Product ID	Required	A string of digits, no spaces: 123, 55, 9476	Product custom identifying number.
Product name	Required	A string of characters, can include digits and punctuation marks: Body Care Serum, Black t-shirt	Product name.
Product price	Required	Use comma or space for thousands separator, e.g., 5,290 or 5 290.	Product price at the time of order.
Product quantity	Required	A string of digits, no spaces: 3, 15	Amount of product added to the order.
Website ID	Optional	https://my-store.com/	Unique ID number assigned to a website in Settings > Web Tracking > Websites. Fill in this field, if you handle multiple websites from your account, but only import orders for one.
Status	Optional	Possible statuses: placed, paid, completed, canceled.	In ECDP, you can assign an order one of the following statuses: placed, paid, completed, or canceled. If you do not assign a status to an order, ECDP will assign the default status set in Settings > Orders > Order statuses.
Currency	Optional	An ISO currency code, e.g., : EUR, PLN, USD	Order currency. Order currency should match your account currency. Otherwise, we will convert order currency to match the account currency.
Product URL	Optional	https://my -store.com/men/t-shirts/black-no-logo-tshirt	URL address of a product page.
Product image URL	Optional	https://my -store.com/uploads/ t-shirts/black-no-logo-men-tshirt.jpg	URL address of the main image for a product.
Product category	Optional	Accessories, t-shirts, backpacks.	Product category available in your online store.
Product return quantity	Optional	A string of digits, no spaces: 2, 10	Amount of returned products.

How to import order data?

Order import is a simple three-step process.

Go to main menu and select Customers > Orders.
Click the Import orders button.
Click Select file and choose the file location on your computer. Then click Open to upload the file.
Select the import type based on how you want to handle data for new and existing orders.
- Add new orders and replace existing ones.
- Add new orders without updating the existing ones.
Click Advanced settings to:
- Select the separator used in your file – usually, it is a comma for CSV, and a tab for TXT.
- Specify if your file has headers. Toggle on this option if you file includes column names.
- Choose character encoding applied in your file.
A sample of your imported data will be displayed below. If the result is not as expected, you may need to map the columns.
If the data is displayed correctly, click Save to start the import process. The duration depends on the file’s size.

Once the import is complete, you will receive a notification in the main menu’s Notifications section.

What is column mapping?

Column mapping ensures that data from your file is displayed correctly after import. Since the order of columns may differ, you must assign the columns from your file to those in the ExpertSender CDP platform.

During the mapping process, each column’s data will be presented in separate rows. This is why we refer to the columns as rows in the description below.

To map the columns:

Click a dropdown list on the left side of each row.
Select an attribute that corresponds with the data type in each row. For example, choose the E-mail attribute for email addresses or the Name attribute for customers’ names. Repeat this step for all the rows.
The dropdown list includes both system attributes and custom attributes. We recommend adding custom attributes before starting data imports. Learn how to add custom attributes.
Once you finish mapping, click Save.

Column mapping is optional but recommended. It ensures that information is properly displayed in the ExpertSender CDP platform’s grid tables.

Adding product data to ExpertSender CDP

Adding product information to the platform is different from a standard file import.

First, you need to configure the web tracking channel for your online store. Web tracking allows for collecting product information directly from your website, including price and availability changes.

In the platform, you can add a product feed:

Automatically – the web tracking code automatically adds all products viewed online by the visitors.
Manually – you format all products in a product feed file and upload it to the platform.

For more details on adding product data to the platform, refer to the article: Creating a product feed.