Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

This built in report will give the merchant a clear picture of Item Sales Information within a designated date range. 

...

Click the Generate Report button once you have finished entering the Date Range and any optional settings. If the report date range is short, your report may become available immediately.  If not, you will receive a Report Pickup notice email informing you what to do when it's ready for pickup (see below).  The following is an example of the Coupon Usage Report with very short date range settings.  This particular report is comprised of a worksheet with only one tab as shown below:

Report Pickup

If a report that you've created covers a large date range you can expect some wait time.  You'll be notified if there is a delay and will be told that you can obtain the report in the Report Pickup area.  

...

Click here for more about the Report Pickup.


Understanding Subtotal Discount Coupon Impact

This report will spread subtotal discount coupons proportionally to the unit prices shown in the report.  This will help you understand the net price that you're selling the product for.  Here is an example of the math:

Image Added

So for this example we have the following items with cost:
ROGGVIN-SAMPLER1            24.85
ROGGN-2.1OZ-EA1                 6.95
ROGGNP-2.2OZ-EAU              4.95
The subtotal for the order was 36.75 and there were subtotal discounts of 7.95.  So if we look at the % allocations it would be:
ROGGVIN-SAMPLER1            24.85 / 36.75 =  67.62%
ROGGN-2.1OZ-EA1                6.95 / 36.75 = 18.91%
ROGGNP-2.2OZ-EAU             4.95 / 36.75 = 13.47%
Taking those allocation percentages we have the following subtotal discount portions:
ROGGVIN-SAMPLER1            7.95 *  67.62% = 5.37
ROGGN-2.1OZ-EA1                  7.95 * 18.91% = 1.50
ROGGNP-2.2OZ-EAU            7.95 * 13.47% = 1.07
So if you have a unit price of 4.95 for the item and subtract the 1.07 subtotal discount you get an effective net unit cost of 3.88 for item ROGGNP-2.2OZ-EAU.