'campaignEcommAddOrder' always tracks 'Order Details Missing'

Feb 10, 2014 at 3:42 PM
hey out there,

we've been trying to impliment 'Ecommerce360' on one of our eCommerce sites (it's an inhouse platform rather than an off the shelf).

the code appears to be working correctly but we always get 'Order Details Missing' in mailchimp!

this is an example of the json being sent:
{
    "order_id": "2598",
    "order_date": "2014-02-10T16:16:46.71",
    "campaign_id": "8cf6c84491",
    "plugin_id": null,
    "email_id": "f760c35faf",
    "email": null,
    "total": 12.75,
    "shipping": 2.75,
    "tax": 1.4,
    "store_id": "my store",
    "store_name": "www.mystore.com",
    "items": [
        {
            "line_num": 0,
            "product_id": 0,
            "product_name": "a product name",
            "category_id": 0,
            "category_name": "a product categoty",
            "qty": 20,
            "cost": 1
        }
    ]
}
it all looks legit and the response comes back from mailchimp ok - any idea's what's going wrong?!

cheers,

jake
Feb 11, 2014 at 4:26 PM
ok, i figured it out - the issue is in the 'item' array: the 'product_id' and 'category_id' are two int fields that i was sending as 0 meaning the data was being skipped:
{
    "line_num": 0,
    "product_id": 0,
    "product_name": "a product name",
    "category_id": 0,
    "category_name": "a product categoty",
    "qty": 20,
    "cost": 1
}
the trick is, our ecommerce system doesn't use int id's for it's products or categories! it uses guids.

based on what i'm seeing on the google group https://groups.google.com/forum/#!searchin/mailchimp-api-discuss/product_id$20 this seems to be a common problem for people...

we don't really want to change the database just to accommodate how mailchimp works - has anyone else come up with a good solution to this one?!?!

cheers,

jake