Add Discount Code to Shopify Orders Report / Table

[mfarage]

We’re currently exporting Shopify data via an API to an Azure database. I’d like to be able to view which Discount Code was applied to an order, since the current calculative method (discount/total line item price) makes it difficult to quickly look at performance & LTV by code.

We’re currently exporting the shopify_orders table and shopify_discount table, but I can’t find anything in Shopify Orders to map over to Shopify Discounts.

Any advice?

[Report-Pundit]

Hello @mfarage ,

Consider using a Reporting tool to simplify your data tasks.

For the requirement you mentioned, a solution is at hand. Utilize our pre-made and customizable reports to consolidate the data essential for your analysis.

Here’s a sample:

Best Regards,
Report Pundit