thread Does the API support the ability to collect what items the customer purchased in a transaction? in Community Corner

Does the API support the ability to collect what items the customer purchased in a transaction?

ryanh123 — Sat, 26 Jan 2019 05:35:15 GMT

I'd like to use the API to capture how many of a particular item an individual customer purchases over time. I was hoping the transaction detail would include the list and quantity of items for each transaction. I can't see to find this however. Is this supported?

Re: Does the API support the ability to collect what items the customer purchased in a transaction?

Helen — Tue, 29 Jan 2019 18:40:08 GMT

Apologies for the delay @ryan123! I escalated this to our API team for you - and yes you can use the Orders API in conjunction with the Transactions API and Customers API to get itemization for your transactions per customer.

The steps you need to to take are as follows (Note - this assumes you have linked a customer_id and order_id to each transaction) :

Use the ListTransactions endpoint and loop through the transactions and pull out all the transactions that have the customer_id attributed to the transaction.
Then retrieve all the order_ids from those transactions.
Next, pass in those order_ids to the BatchRetrieveOrders endpoints to see the itemization breakdown that are associated with that individual customer.

Take a look at the Itemize Tranactions documentation and if you have any other questions please let us know!

Re: Does the API support the ability to collect what items the customer purchased in a transaction?

Dugasmike — Wed, 01 May 2019 22:22:15 GMT

you can but it is not easy. You cannot pull transactions for customers without knowing order Id.

so you cannot say hey get me all orders for this customer.

You should join the slack work space much more helpful