Welcome Guest! To enable all features please try to register or login.
Options
Go to last post Go to first unread
Offline Adam Bernstein  
#1 Posted : Wednesday, November 29, 2017 6:23:39 PM(UTC)
Adam Bernstein

Rank: Newbie

Reputation:

Groups: Registered, Registered Users, Subscribers
Joined: 12/28/2016(UTC)
Posts: 9

Thanks: 1 times
Was thanked: 1 time(s) in 1 post(s)
Hello, we are looking to determine how many times each promotion code has been used in a given time period. We are using Hotcakes version 1.10.4 Pro.

At the level of an individual order, I can see promo code information via Order Manager > Order Details > (Codes Used area of the Payment Information section).

How can we view this information across all orders, or across orders from a given time period? I tried using the Order Manager's "Export to Excel" feature, and the resulting spreadsheet includes columns labeled "Order Discount" and "Order Discount Details" however these seem to always show "$0.00" and "<DiscountDetails />", respectively, even when a promotion code has been used resulting in a price discount.

I also attempted a workaround, creating an email template (Admin > Email Templates) that includes the desired information, and using it via the Order Manager's "Print Selected Orders" feature. However, I'm unable to print more than one page of orders at a time that way (i.e., 20 orders).

Is there a recommended way to achieve this?

Thanks in advance for your advice,
Adam
Offline Will Strohl  
#2 Posted : Friday, December 22, 2017 1:44:30 PM(UTC)
Will Strohl

Rank: Administration

Reputation:

Groups: Administrators, HCC-Employee-Store-Manager, HCC-Employee-Support, HCC-Partner, Moderators, Partners, Registered, Registered Users, Subscribers
Joined: 12/22/2016(UTC)
Posts: 342

Thanks: 78 times
Was thanked: 59 time(s) in 57 post(s)
It sounds like you may be able to simply use the Coupon Code report.

https://hotcakescommerce...6-Sales-by-Coupon-Report

Please update this if you need anything else.
Will Strohl, Upendo Ventures
Hotcakes Cloud | Get Support | Code Support
Official Cloud & Support provider for Hotcakes
Offline MooreCreative  
#3 Posted : Monday, February 26, 2018 12:45:37 PM(UTC)
MooreCreative

Rank: Advanced Member

Reputation:

Groups: HCC-Partner, Partners, Registered, Registered Users, Subscribers
Joined: 12/28/2016(UTC)
Posts: 59

Thanks: 10 times
Was thanked: 30 time(s) in 26 post(s)
Otherwise, as an alternative, we will often create a Reports screen for administrators where through XMod Pro, or other direct-to-the-database report modules, we setup a custom SQL query that gets specifically the data that you need. We can then combine in other data from the site such as other tracking information, user login info, etc.

The other benefit to setting up externally like this is that, if the client needs to see that report regularly, we can setup a scheduled process to email the report data to them once a week/month, etc.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2020, Yet Another Forum.NET
This page was generated in 0.198 seconds.

Notification

Icon
Error

Loading
  • Sign-up for the Hotcakes Community Newsletter: