Just ran the report and it's not pulling accurate numbers. I used last month 9/1/2021 thru 9/30/2021. It's showing a total number of orders for Sept as 424 orders. Our Monthly Report for Sept 2021 shows total orders as 422...so it's just off by 2 but still off.
Bigger questions:
1) A large percentage those 424 or 422 orders actually received free shipping as our website is configured to offer free shipping for orders over $75 so no shipping fee was charged however the report is showing 409 of the 424 where charged US shipping, 14 were international and 1 is free...it's completely inaccurate as the vast majority of the "409" actually paid $0 for shipping. Example orders: 60799, 60797, 60796, 60793, 60792, 60791, 60790, 60788, 60786, 60782, 60779, 60778, 60775, 60774, 60773, 60772, 60771, 60768, 60767, 60764, 60763, 60761, 60760....
2) The Gross ASP column:
a) the ASP price for US is shipping is off a tad, it should be $6.80...how do we fix this?
b) The ASP for international is incorrect...not all of those 14 orders were charged $44.82. Each international order is charged by weight and country zone so they the shipping cost paid by customer varies greatly. Eg orders: 60795, 60769, 60753, 60631, 60598, 60503, 60748, 60605, 60606, 60578, 60579, 60564.
*Also we only shipped 13 international orders in Sept 2021. Order #60841 was cancelled and refunded due to Australia suspension.
c) In the ASP column, what is the "total" $8.03 a total of?
3) The discount column: what are these? why is the "total" $0? If they are in fact discounts are the "gross" and "net" the same $ amount?
Attached is the screenshot for Sept 2021
- shipping stat report .jpg (53.24 KiB) Viewed 5835 times