What Every Offer Really Brought In

The Report of One Offer

Press REPORT on any offer to open its report, for a range you choose: Last 7, 30 or 90 Days, This Month, or Custom (up to 366 days, in India time). It shows:

• Four figures: Orders, Sales (the orders' totals, with delivery and tax), Discount Given (on goods and delivery waived) and Average Order.
• Average Order With and Without: this offer's orders beside your other orders in the same days, and the difference in rupees.
• Who Used It: new and returning shoppers (by checkout phone number: new means their first order), and cash on delivery against paid online.
• By Day: orders and discount given each day, as bars and a table.
• Top Products: the 5 products where the offer took the most off.
• Cancelled orders that had used it are counted apart (their uses were given back), and a line gives its lifetime: "Since it started: 214 orders, ₹48,200 given."

EXPORT CSV gives the days with orders, sales and discount, in rupees with paise. Every figure counts only the offer's own share of each order, never the order's whole discount, so two offers on one order are never double-counted.

The List's Summary

The Discounts list opens with the last 30 days: Live Offers (and how many are scheduled), Uses, Given, and Sales with Offers, the totals of orders that carried any offer, each order counted once, without cancelled or unpaid orders.

Import and Export

IMPORT / EXPORT on the list keeps a copy of your offers or moves them to another store. EXPORT JSON carries every offer in full (products and collections by their address, sizes, levels, conditions and labels); EXPORT CSV is one row per offer for a spreadsheet. An import is checked first (CHECK FILE says, row by row, what is ready and what needs fixing) and every offer is saved as a draft for you to check before it goes live.

The Discounts List and Its Numbers

The Discounts list has tabs by where each offer stands now (Active, Scheduled, Expired, Used Up, Draft, Archived), counted over your search and filters. Its summary covers the last 30 days against the 30 before: live and scheduled offers, uses, the amount given (goods and delivery waived) and sales with offers, the totals of the orders that carried any offer, each order counted once, never cancelled orders or unpaid online payments.

The report also holds the offer's Card Label card: whether the label shows on product cards and pages now, or why not (a code, a condition, not live, switched off), with its words and a preview.

Mercayo sets how many offers one import file may hold (200 to start with). The report reads only your store's orders: each store's data is kept apart by the database itself, and another store's offer reads as nothing. Use counts, one-time codes and phone lists never leave your store in an export, and an import runs with the rights of the staff member who imports it.