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.
Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)
Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
