If you want to import your existing orders for the Loyalty Program and RFM Analysis, you can do so by creating a JSON order feed. Only the orders from the last 3 years will be imported.
Please keep in mind that the order feed will need to support pagination, our default parameter is "page". We recommend a maximum of 50 orders per page.
JSON Structure:
{
"orders": {
"order": [
{
"order_no": "100000049",
"order_status": "Fulfilled",
"refund_value": "0.00",
"created_at": "013-03-15 02:01",
"email_address": "[email protected]",
"phone": "0700000000",
"firstname": "John",
"lastname": "Doe",
"city": "City",
"county": "County",
"country": "RO", //country ISO code
"address": "Customer address",
"discount_value": "0.00",
"discount_code": "",
"shipping": "20",
"tax": "24",
"total_value": "153.50",
"products": [
{
"product_id": "377",
"name": "Product name",
"url": "https://yourwebsite.com/product-url",
"main_image": "https://yourwebsite.com/product-image.jpg",
"category": "Some category",
"brand": "Brand name",
"price": "750.00",
"sale_price": "650.00",
"quantity": 1,
"variation_id": "377",
"variation_sku": "alb007"
}
]
}
]
}
};All the attributes listed in the sample order feed are required.