Order Export missing "coupons" column

smallfarm — Thu, 18 Apr 2024 20:15:41 GMT

The new exporting of orders has been really great. Far easier to organize the exported spreadsheet than the previous iteration. However, it seems to be missing the coupons column which has been critical for us. Instead of having all our ordering information on one spreadsheet, we're now slowed down having to hunt down and verify, with the Square issued receipt via the dashboard, to see/verify if a customer used a coupon.

Why was this removed?

Re: Order Export missing "coupons" column

TheRealChipA — Fri, 19 Apr 2024 12:45:55 GMT

Hey @smallfarm As a fellow Square seller, I can’t address the “why” part of your question. But I think I have a decent workaround that will at least get rid of the “hunt down and verify” part of your problem.

In the new Order export, you can “infer” coupons as follows. Create a new column with the formula:

Order Total (col. G) - Item Price (col AC) - Item Options Price (col AD)

The difference between the item price and the price the customer paid has to be the amount of any coupons applied.

No, it’s not perfect, but it’s workable while you wait for Square engineers to investigate and determine if they want to explicitly add a “Coupons Applied” column to the CSV. I hope that helps.

thread Re: Order Export missing "coupons" column in Online Store

Order Export missing "coupons" column

Re: Order Export missing "coupons" column