Coupon Usage Statistics

Which promo codes bring orders and which only eat the margin

CS-Cart keeps a single usage counter on a promotion: it shows neither orders, nor customers, nor revenue per code, and the same customer can enter a coupon as many times as they like. The add-on logs every use of a coupon and gift certificate, counts orders, customers, order totals and discount per code, and adds the "usages per customer not more than N" condition to promotions.

The problem it solves

Promo codes go out in newsletters, to bloggers and partners, and there is nothing to measure them with: a promotion in the admin panel has one total counter that grows with cancelled orders too. How many orders a code brought, for what amount, how much discount it cost and whether one person enters it ten times - the stock store does not answer.

The add-on records every use of a coupon and certificate when the order is placed, follows order edits and deletions and sums everything up into statistics per code. Orders placed before the installation are collected with one button.

Statistics per code for all time: usages, purchases, customers, order totals, discount, average order, first and last use and the "Total" line.

What you get after installation

• •  The "Marketing → Coupons and promo codes" section with two tabs - "Log" and "Statistics".
• •  Log: one row per use of a code in an order - date, order number with a link, status as the standard label, code, promotion or certificate, customer with e-mail, order total, discount or the amount debited from the certificate, vendor in Multi-Vendor.
• •  Filters: code and period in the side panel; the advanced search adds customer, order number, type, promotion, statuses and the "Only counted statuses" checkbox. Filter sets are saved the same way as in the order list.
• •  Links both ways: the code in the log leads to the statistics, the usage count in the statistics - to the log with that filter, the customer's e-mail - to all their usages.
• •  CSV export of the log and the statistics with the current filters: UTF-8 with BOM, ";" delimiter, amounts as numbers, statuses as words - the file opens in Excel without import settings.
• •  Collecting data from orders with a progress indicator - for order history, imports and upgrading from the previous version of the add-on.

Usage log: status labels, codes, promotions and certificates, customers and guests, order total and discount; rows with several promotions are marked.

Advanced search of the log: customer, order number, type, promotion, statuses and "Only counted statuses".

Statistics you can trust

Numbers per code are honest only when it is clear what is counted and how. The add-on says it right on the screen: under the statistics heading you see which period and which statuses are counted.

• •  Only paid statuses count. By default these are the statuses in which the store decreases stock and increases the promotion counter; the set is changed in the settings. The log still shows usages in orders of any status.
• •  A purchase counts once. A Multi-Vendor order split between several vendors becomes child orders, but in "Purchases" it is one; the "Total" line counts every order once even when several codes were used in it.
• •  No invented discounts. When several promotions fired in one order, the store does not keep the share of each one, and the add-on shows the discount of the whole order marked "shared with other promotions" instead of splitting it at random.
• •  Certificates next to coupons: number, debited amount, customer and order - in the same log and the same statistics.
• •  Codes without usages on request: coupons of the active cart promotions that nobody used in the period are shown in grey.

The "Usage" tab on the promotion page: the "All time" and "Last 30 days" summaries, the counted statuses and the recent usages.

The usage limit per customer

A "first order" coupon or a "VIP discount twice a year" cannot be made in stock CS-Cart: there is no "once per customer" condition in promotions. The add-on adds it to the condition builder - next to the coupon code, order subtotal and the other core conditions.

The "Usages by one customer - less than or equal to 2" condition in the promotion condition builder next to the coupon code.

Storefront: the customer has already used VIP20 twice, the third entry of the coupon in the cart is refused.

Vendors, storefronts and editions

• •  Multi-Vendor. The "Show the log and statistics to vendors" setting opens "Marketing → Coupons and promo codes" in the vendor panel: the vendor sees usages in their own orders only, without the "Vendor" column and the storefront switcher; putting another vendor's number into the address changes nothing. Collecting data from orders stays with the marketplace owner.
• •  Storefronts. The standard storefront switcher in the header limits the log and the statistics to the orders of one storefront; "All" shows the whole store.
• •  CS-Cart Ultimate. The log and the statistics follow the company switcher: a storefront shows its orders, "all storefronts" shows the whole store with the "Storefront" column.
• •  Multi-Vendor parent orders are not written to the log: the usage is counted by the vendors' child orders, and the purchase - once.

The Multi-Vendor vendor panel: the log of the vendor's own orders only, without the "Vendor" column and the storefront switcher.

Statistics in the vendor panel: the same columns as for the marketplace owner, but only for this vendor's orders.

In the admin panel, not next to it

• •  The "Purchases" column in the promotion list: the number of orders in the counted statuses with a link to the log; promotions without a coupon show a dash.
• •  The "Usage" tab on the promotion page: summaries for all time and for 30 days, the counted statuses, the recent usages and the "All usages in the log" button.
• •  Standard panel elements: status labels from the order list, storefront switcher, period, advanced search with saved sets, pagination, the actions dropdown.
• •  Mobile layout: on a phone the log table unfolds into cards with column labels.

The promotion list with the "Purchases" column: numbers with links on coupon promotions, a dash on promotions without a coupon.

The log on a phone: cards with column labels instead of a wide table.

Settings, permissions and installation

• •  Three settings: statuses in which a usage counts; vendor access; a line with the date of the last data collection and a link to the log.
• •  Two privileges in the "Coupons and promo codes" group of the "Marketing" section: viewing the log and statistics and rebuilding the log from orders - granted to administrator groups as usual.
• •  Installation through the Cart-Power add-ons manager: the log table, the privileges and the default statuses are created automatically. The add-on uses scheme 4.0 and does not touch the core.
• •  Upgrading from 4.3.x: the new version keeps its own log; after the installation press "Collect data from orders", the old table is no longer needed.

Add-on settings: the counted statuses, vendor access and the date of the last data collection from orders.

What the add-on does not do

• •  It does not create coupons and does not change how the core applies them: codes, discounts and the other conditions are still set in promotions.
• •  It does not let you edit or delete log rows by hand: the log mirrors the orders and changes only together with them.
• •  It does not split the discount between promotions when there are several in one order: the store does not keep that share, and the add-on shows the order discount with a mark.
• •  It does not replace storefront messages: a coupon refused by the limit gets the standard store message.

What it costs to run

The add-on writes one row to its own table when an order is placed and reads statuses and totals from the orders when displaying; there are no separate tables with order copies. Collecting data from history runs in batches of 500 orders with a progress indicator and does not disturb the storefront. No cron is needed.

The price is $60 per license for one store. The "Cart-Power: Add-ons Manager" add-on is required.

Frequently asked questions