Coupon Reports

[kbadr]

Hi,

I'm still investigating using ZenCart as a solution for my business. One of the features I'd like to have is coupon codes. It looks like Zen Cart has a really good implementation of coupons, but I can't find anything about the reporting side of things. Does ZenCart track coupon use in a way that is easy to report on? Can I run a report for a certain date range and see exactly how much each coupon code was used?

Thanks.

[Ajeh]

There isn't anything built into Zen Cart, at present, for reporting on the Discount Coupons ...

You would need to create the report based on the coupon_code in the orders table you could build various reports on them ...

[kbadr]

So the coupon code is stored with the actual purchase? If it is, I can get at the data one way or another.

I'm not familiar with zen cart's reporting. Can I write custom sql-type statements for the reports, or would I have write something from scratch?

[Ajeh]

In the orders table is a field:
coupon_code

This contains the Discount Coupon code that was used with the Order ...