Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

How to run report on Promotion Code use Rate Topic   - - - - -

 
  • TGNman
  • Newbie
  • Trial users
  • Join Date: 06-Nov 12
  • 1 posts

Posted 06 November 2012 - 01:50 PM #1

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

 

Posted 06 November 2012 - 05:01 PM #2

Not possible more than using PHPMyAdmin and finding all orders with said coupon code used.
I've moved on from CS-Cart to WooC******** - If you need anything I can be of little help.

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4951 posts

Posted 06 November 2012 - 08:11 PM #3

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

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12091 posts

Posted 07 November 2012 - 06:43 AM #4

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.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 

Posted 05 December 2012 - 12:10 AM #5

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!

 
  • mink
  • Developer
  • Authorized Reseller
  • Join Date: 03-Oct 12
  • 27 posts

Posted 11 December 2012 - 10:20 AM #6

Hello,

I have worked on a similar task recently.

It is possible to view the modification at http://ysergeev.u.si...e_tracking.view

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”
Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER
LICENSES | DEVELOPMENT | ADD-ONS | DESIGNS | UPGRADES

 
  • cscartrocks
  • Member
  • Members
  • Join Date: 24-Jan 11
  • 1844 posts

Posted 11 December 2012 - 12:47 PM #7

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

One Step Checkout Addon - The ultimate checkout experience
Best CS-Cart SEO addon - CS-Cart SEO Ultimate Addon
PM for 365-day support and custom development service


 

Posted 20 March 2015 - 02:22 PM #8

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”

 
  • fleaffair
  • Senior Member
  • Members
  • Join Date: 11-Jun 14
  • 537 posts

Posted 20 April 2015 - 05:43 AM #9

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”


Where can i see this plugin ? I want to see a demo if its good will buy it.
Warm Regards,
Admin | MVE: 4.2.4

 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3628 posts

Posted 20 April 2015 - 08:05 AM #10

@fleaffair

You can test it at http://arazumova.sim...upon_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.

Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 

Posted 22 April 2015 - 01:43 PM #11

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@simtechdev.com (not via sales@cs-cart.com), Subject “Coupon code tracking add-on”

 
  • fleaffair
  • Senior Member
  • Members
  • Join Date: 11-Jun 14
  • 537 posts

Posted 26 April 2015 - 03:00 PM #12

This report just lists the Coupon Code vs Order Number , few other fields which should definitely be part of this report are:
  • Date ( We should be able to use Filter as well on this )
  • Coupon Code
  • Promotion
  • Order Number
  • Product Category
  • Order Value
  • Customer Name / Email

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.
Warm Regards,
Admin | MVE: 4.2.4

 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3628 posts

Posted 06 May 2015 - 09:26 AM #13

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


I would like to inform you that we added the following fields in the report:
  • Date
  • Promotion
  • Total
  • Customer Name
  • Customer Email
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.

Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 
  • fleaffair
  • Senior Member
  • Members
  • Join Date: 11-Jun 14
  • 537 posts

Posted 06 May 2015 - 01:57 PM #14

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

  • Date
  • Promotion
  • Total
  • Customer Name
  • Customer Email
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.


This report looks fine just one more request which we feel would make this report complete is adding fields for
  • Product Category
  • Discount Value . ( e.g. If order value = 100$ , discount coupon code gives 15% off then value for this field is = 15 $)

Thanks.
Warm Regards,
Admin | MVE: 4.2.4

 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3628 posts

Posted 08 May 2015 - 12:57 PM #15

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.

Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 
  • myshop
  • Member
  • Members
  • Join Date: 08-Aug 12
  • 26 posts

Posted 08 October 2020 - 11:20 PM #16

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



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12091 posts

Posted 09 October 2020 - 05:58 PM #17

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


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 

Posted 09 October 2020 - 06:56 PM #18

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.


Only helpful and unique addons https://store.retailfactory.ru