The back office order search currently only searches against the customer name + order number. We have a task to implement a more advanced search but it's not scheduled yet.
I'm not sure we have anything at an API level that would give you these search results so it might need to be a DB query to fetch this. You'll want to query the vendrAppliedDiscountCode table for values with isFulfilled set to true. This will give you the list of discounts that have been redeemed along with the order ID that they were redeemed on.
If you want to raise this on the issue tracker, this could make a nice feature on the discount edit screen. We could have something you could click to see discount / code usage which could open a dialog that lists the orders that have used it?
Yeah, that would be a nice feature. Our customer has asked about this but its not massively urgent right now. If we can get it from sql it will do in the short term.
Search orders for discount codes
Hi
I've tried searching the orders list using a discount code I know has been used, however the expected order(s) isn't returned in the search.
Is there a way to get a list of orders that have had a specific code applied? Or a list of discount codes that have been used?
Thanks.
Hey Sean,
The back office order search currently only searches against the customer name + order number. We have a task to implement a more advanced search but it's not scheduled yet.
I'm not sure we have anything at an API level that would give you these search results so it might need to be a DB query to fetch this. You'll want to query the
vendrAppliedDiscountCodetable for values withisFulfilledset totrue. This will give you the list of discounts that have been redeemed along with the order ID that they were redeemed on.Hope this helps
Matt
Ok thanks for the info Matt.
Cheers.
If you want to raise this on the issue tracker, this could make a nice feature on the discount edit screen. We could have something you could click to see discount / code usage which could open a dialog that lists the orders that have used it?
https://github.com/vendrhub/vendr/issues
Matt
Yeah, that would be a nice feature. Our customer has asked about this but its not massively urgent right now. If we can get it from sql it will do in the short term.
Thanks!
is working on a reply...