The Product Ranking Report analyzes the activity of a product across all other products within your products database. Product rankings are a way to categorize all your products as to their relative effect to sales, profit, costs, and hits based on the breakpoints defined below.
Breakpoints
A: 21 to 100% of category ranking or Top 80 percent of value.
B: 6 to 15% of category ranking or the next 15 percent of value.
C: 1 to 5% of category ranking or the last 5 percent of value.
X: 0% of category ranking contributing no value at all.
Using these breakpoints, products contributing to the top 80 percent of value get a ranking of A. The products comprising the next 15 percent are marked as B. The products that make up the next 5 percent are marked a C. You cannot go over 100 percent so any product over that amount has no rank and is marked as X.
You can use the Product Ranking results in a variety or areas within your business for example:
•Pricing: You can use the rankings to fine tune pricing for products which are under performing.
•Purchasing: The more you sell the more important it is that you never run out of high ranking products.
•Cycle Counting: When performing cycle counts, you can limit the counts to products with certain product ranks.
•Warehousing: Higher selling products have higher rankings which would indicated the product requires a more convenient and accessible storage location for more efficient and faster picking and packing.
•Product Management & Analysis: The product rankings provide an opportunity to evaluate low performing products to determine viability and continued stocking and sales.
Best Practice:
It is best to run this report for all products at once with no applied filters so you can view the relative performance of each product against the rest of the products within your products database.
You can filter by supplier, category, brand, etc.; however, the results would only display the product performance within the filtered data only and not consider products which do not meet the filter criteria. For example filtering by supplier would group all products by supplier and would be able to view rankings within each supplier.
Click here to view the video for the Amazon Product Ranking report.
Column Headings & Field Mappings
Section
|
Column
|
Table
|
Data Field
|
Type
|
Description
|
Product Info
|
Product SKU
|
Prods
|
ProdSKU
|
Data
|
Product SKU
|
ASIN
|
Prods
|
ASIN
|
Data
|
Amazon Standard Identification Number (ASIN)
|
FN SKU
|
Prods
|
ProdFNSku
|
Data
|
Amazon Fulfillment Network SKU
|
Barcode
|
Prods
|
Barcode
|
Data
|
Product Barcode
|
UPC
|
Prods
|
UPC
|
Data
|
Universal Product Code (UPC)
|
EAN
|
Prods
|
EAN
|
Data
|
International Article Number (EAN)
|
Product Name
|
Prods
|
ProdName
|
Data
|
Product name or listing title
|
Brand
|
Prods
|
BrandID
|
Data
|
Brand/Product Line assignment
|
Category
|
Prods
|
CatID
|
Data
|
Category assignment
|
Sales Info
|
Last Ord
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Last Amazon order ID
|
Last Date
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Last purchase date
|
Nbr Ords
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Number or orders containing the SKU
|
Days Since
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Number of days since last purchase
|
Price
|
Prods
|
PricePerUnit
|
Data
|
Price per unit
|
Units Sold
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Total number of units sold
|
Sales
|
OrdersDetail
|
PricePerUnit * Units Sold
|
Calculated
|
Total sales for the product
|
Cogs
|
OrdersDetail
|
CostPerUnit * Units Sold
|
Calculated
|
Total Cost of goods sold (Cogs) for the product
|
GM
|
|
Proprietary Algorithm
|
Calculated
|
Total Gross Margin (GM)
|
GM %
|
|
Proprietary Algorithm
|
Calculated
|
Total Gross Margin Percent (GM %)
|
Ranking
|
SR
|
|
Proprietary Algorithm
|
Calculated
|
Sales Rank: How the product ranks by sales
|
PR
|
|
Proprietary Algorithm
|
Calculated
|
Profit Rank: How the product ranks by profit
|
CR
|
|
Proprietary Algorithm
|
Calculated
|
Cost Rank: How the product ranks by cost
|
HR
|
|
Proprietary Algorithm
|
Calculated
|
Hits Rank: How the product ranks by number of orders
|
Quantities & Values
|
Qty OH
|
Prods
|
QtyOH
|
Data
|
Quantity on Hand (QtyOH)
|
Qty OO
|
Prods
|
QtyOO
|
Data
|
Quantity on Order (QtyOO)
|
Qty FBA
|
Prods
|
QtyFBA
|
Data
|
Quantity at FBA (QtyOH)
|
Qty IT
|
Prods
|
QtyIT
|
Data
|
Quantity in Transit to FBA (QtyIT)
|
Qty TOT
|
Prods
|
QtyTOT
|
Data
|
Quantity Total available for Sales (QtyTOT)
|
Qty Resv
|
Prods
|
QtyFBAR
|
Data
|
Quantity Reserved at FBA
|
Cost
|
Prods
|
CostPerUnit
|
Data
|
Cost per unit
|
Value
|
Prods
|
CostPerUnit * (QtyTOT + QtyIT + QtyFBAR)
|
Calculated
|
Inventory value for the product
|
Supplier
|
Name
|
Supps
|
SuppName
|
Data
|
Supplier Name
|
SKU
|
Prods
|
SuppSKU
|
Data
|
Supplier SKU
|
Reord Point
|
Prods
|
Proprietary Algorithm
|
Calculated
|
Recommended Reorder Point to prevent out of stocks
|
Reord Qty
|
Prods
|
Proprietary Algorithm
|
Calculated
|
Recommended Reorder Qty to maintain supply
|
Last Rcvd
|
PurchOrdSKUs
|
Proprietary Algorithm
|
Calculated
|
Last Received Quantity
|
Last Date
|
PurchOrdSKUs
|
Proprietary Algorithm
|
Calculated
|
Last Received Date
|
|