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. 


Info
titleReporting: Order Location
This report is reporting on orders that are processed to the completed orders location.



To generate your report you simply;

...

B. Select your optional choices (check box)

  • Shipping Address

...

Image Added

 

...

  •  Checked = last / first name
  •   Not checked = first / last name
     
  • Include Sales Rep Code
  •  Checked = Sales Rep Code included in report
  •   Not checked = Sales Rep Code Omitted
     

C.  Filter Item ID's

  • Enter Item ID's that you wish to restrict the report to.  Enter one per line (enter key starts new line).

...

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:


Item IDAmount
ROGGVIN-SAMPLER24.85
ROGGN-2.1OZ-EA6.95
ROGGNP-2.2OZ-EAU4.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:


Item IDMathPercentage
ROGGVIN-SAMPLER24.85 / 36.7567.62%
ROGGN-2.1OZ-EA6.95 / 36.7518.91%
ROGGNP-2.2OZ-EAU4.95 / 36.7513.47%


Taking those allocation percentages we have the following subtotal discount portions:


Item IDMathPortion of Subtotal Discount
ROGGVIN-SAMPLER7.95 *  67.62%5.37
ROGGN-2.1OZ-EA7.95 * 18.91%1.50
ROGGNP-2.2OZ-EAU7.95 * 13.47%1.07


Subtracting the portion of the subtotal discount from the original item unit prices we get


Item IDMathEffective Unit Price
ROGGVIN-SAMPLER24.85 - 5.3719.48
ROGGN-2.1OZ-EA6.95 - 1.505.45
ROGGNP-2.2OZ-EAU4.95 - 1.073.88