Using CSV to import e-commerce data

This article shows CSV files to import historical data from an e-commerce website.

Customer import

For importing customers required field is ‘registered’ which is unique customer ID. Other fields will be imported as customer attributes that you can use for further segmentation and custom email targeting.

customer CSV example

registered;first_name;last_name;email;birthday;company;sex
john@smith.com;John;Smith;john@smith.com;1987;Exponea;male

* required fields: registered

Events import

For importing historical purchases required fields are ‘registered’ as customer identity and timestamp which will be used as event timestamp. All other fields are imported as event properties.

purchase CSV example

registered;timestamp;transaction_id;total_price;item_quantity
john@smith.com;1474886373;100001;53.90;3

purchase_item CSV example

registered;timestamp;transaction_id;product_id;title;unit_price;quantity;total_price
john@smith.com;1474886373;100001;29;Colorful bracelet;35.30;1;35.30
john@smith.com;1474886373;100001;47;Fancy necklace;9.30;2;18.60

* required fields: registered, timestamp