How to run report on Promotion Code use

Hello



I am using 2.2.4 CS cart and I have several coupon codes in promotions that I would really like to track. I have seen this question asked before but it never gets answered.



So is there a way to track or report on the usage of one coupon code over the others? Would be a HUGE help.



Thank you in advance.

Mark

Not possible more than using PHPMyAdmin and finding all orders with said coupon code used.

Can u export all orders ad .csv and view it in them, then add em all up in excel by adding a filter , assuming the code is an exported field though

This is extremely challenging in cs-cart. There simply isn't enough info kept in an order to determine where the total discounts came from. I wrote an addon that attempted to be a promotion report. For the most part, it worked, but there were holes that no amount of head-scratching could fill. That addon is no longer available and I would never attempt to do it again.

CS-Cart is great for some things but terrible when it comes to coupons and promotions. Promotions are integral events for online stores and I really hope they get it right soon!

Hello,



I have worked on a similar task recently.



It is possible to view the modification at [url=“http://ysergeev.u.simtechdev.com/224pro/admin.php?dispatch=coupon_code_tracking.view”]http://ysergeev.u.simtechdev.com/224pro/admin.php?dispatch=coupon_code_tracking.view[/url]



login/password = admin/admin



To track coupon codes for orders you should open the "Administration” tab and click on the ”Coupon code tracking” link. This page displays the table of correspondence between coupon codes and orders to which they were applied by customers:

https://lh5.googleus…lJsfC0hlZukWBUd





The modification allows to track both automatically generated and manually added coupon codes. On the add-on settings page there is a link. This link runs the script which checks all orders and promotions and fills the coupon code statistics with all existing coupon codes of the store.



Please let me know if you would like it to be modified or adapted to other CS-Cart version or edition.



Feel free to contact me via email sales@cs-cart.com, Subject “Att Sergey Minukevich - Coupon code tracking”

Is this feature going to be included in the next cs-cart version 3.1.x?

We are glad to inform you that we have released a new version of the “Coupon code tracking” add-on.



Now it works with CS-Cart version 4.x.



Please let me know if you are interested in it.



Feel free to contact me via email sales@cs-cart.com, Subject “Coupon code tracking add-on”

[quote name='Pritula Elena' timestamp='1426861329' post='208567']

We are glad to inform you that we have released a new version of the “Coupon code tracking” add-on.



Now it works with CS-Cart version 4.x.



Please let me know if you are interested in it.



Feel free to contact me via email sales@cs-cart.com, Subject “Coupon code tracking add-on”

[/quote]



Where can i see this plugin ? I want to see a demo if its good will buy it.

@fleaffair



You can test it at http://arazumova.simtechdev.net/coupon/424/admin.php?dispatch=coupon_codes.view

Use the following credentials in order to access the admin panel:

E-mail: admin@example.com

Password: coupon424



If you have any questions, feel free to contact us at sales@simtechdev.com. Use the “Coupon code tracking add-on” subject.

[quote name='Pritula Elena' timestamp='1426861329' post='208567']

We are glad to inform you that we have released a new version of the “Coupon code tracking” add-on.



Now it works with CS-Cart version 4.x.



Please let me know if you are interested in it.



[/quote]



Feel free to contact me via email sales@simtechdev.com (not via [color=#282828][font=arial, verdana, tahoma, sans-serif]sales@cs-cart.com[/font][/color]), Subject “Coupon code tracking add-on”

This report just lists the Coupon Code vs Order Number , few other fields which should definitely be part of this report are:

[list=1]

[]Date ( We should be able to use Filter as well on this )

[
]Coupon Code

[]Promotion

[
]Order Number

[]Product Category

[
]Order Value

[*]Customer Name / Email

[/list]



Then only this report will add value since you can do analytics on this report and all these are correlated fields which can be easily pulled out of DB by query.



Let me know if you can add these and update the report.

[quote name='fleaffair' timestamp='1430060428' post='212636'] Let me know if you can add these and update the report. [/quote]



I would like to inform you that we added the following fields in the report:[list]

[]Date

[
]Promotion

[]Total

[
]Customer Name

[*]Customer Email

[/list]

You will be able to sort records in the report by the Date, Coupon code, Order ID.



Please use the following link for test:



Admin panel: http://arazumova.simtechdev.net/coupon_424/admin.php?dispatch=coupon_codes.view



E-mail: admin@example.com

Password: coupon424



If you have any questions, feel free to contact us at sales@simtechdev.com. Use the “Coupon code tracking add-on” subject.

[quote name='simtechdev' timestamp='1430904375' post='213523']

I would like to inform you that we added the following fields in the report:[list]

[]Date

[
]Promotion

[]Total

[
]Customer Name

[]Customer Email

[/list]

You will be able to sort records in the report by the Date, Coupon code, Order ID.



Please use the following link for test:



Admin panel: http://arazumova.sim…upon_codes.view



E-mail: admin@example.com

Password: coupon424



If you have any questions, feel free to contact us at sales@simtechdev.com. Use the “Coupon code tracking add-on” subject.

[/quote]



This report looks fine just one more request which we feel would make this report complete is adding fields for [list=1]

[
]Product Category

[*]Discount Value . ( e.g. If order value = 100$ , discount coupon code gives 15% off then value for this field is = 15 $)

[/list]



Thanks.

As for the Product Category field, we did not add this field into the report intentionally, as there can be several product categories in the order and the report would look uninformative.

Details about the product categories in the order can be easily viewed by the Order ID link.



As for the Discount value field, we will think about this suggestion and maybe if it is in demand, we will add this field to the next version of the “Coupon code tracking add-on” add-on.



Thank you.

Is this add on still available? I cannot see it on your store?

If you are referring to the addon mentioned in #4, no it is not available.

Is this add on still available? I cannot see it on your store?

Do you like to check how many times promotion code was used?

Please have a look our addon "Extended orders search"

Addon adds options to search orders by promotion order promotion code.