Product information gathering
- Total SKUs - capture the number of created products, simply for comparison purposes
- Total listings - total listings on MPs. We need 2 values when talking about listings - total listed SKUs and total actual listing (to be derived from the account_id + variationGroup)
- Total active listings - same as total listings (2 values). TBD - logic on tracking what is active
- Listings per MP created - again 2 values - we need an aggregated number of prepared listings per MP so we can compare with each other and compare with sales for the account
- Listings per MP active - again 2 values - we need an aggregated number of active listings per MP so we can compare with each other and compare with sales for the account. TBD - logic on tracking what is active
- Average price of live listings - General average price of all active listings per channel & per category
- Number of errors on active listings (revise_item, update_quantity, update_price) per account
- Dead stock (SKUs report with products that have had no sales in the past 3 months) - we need two numbers. SKUs that haven't had any sales and products that haven't had sales on the particular accounts
- Discontinued products (SKUs report with products that have had no stock - 0 - in the past 3 / 6 / 12 months)
- Discount % (Sale Price vs RRP) I imagine this as average per account from live listings on updated products per some specific time (hourly, twice a day, something like that) - from there we can track % discount vs sales per account, comparing with live listings so we can better track effect of discounts
- OPTIONAL - gather products with their categories - idea is to be able to track sales per category so we need to know for which product which is the category so we can track an aggregated value for the category and be able to compare it to other values (like listings per MP, discount % etc)
- in conclusion, take what you can, give nothing back