This dashboard was created to help track and manage key collection product data, including some widgets flagging some missing key data.
It brings together important details like the total number of styles, their margin average, plus the category, manufacturer and country of origin split.
Note, some of the widgets have Large Number Formatting switched on. (rounded to 2 dp)
1. Review styles by RRP, unit cost, and profit margin.
2. "Styles" - Total number of "Styles" across relevant products.
3. "RRP Average" - Average "RRP" for relevant products.
4. "Whsl Margin Average" - Average wholesale margin across relevant products.
5. "Colour" ( >RRP >Product ID) - The split of "Colours" across the relevant products.
6. "Fabric" ( >RRP >Product ID) - The split of "Fabrics" across the relevant products.
7. "Size Category" ( >RRP) - "Size Category" breakdown across relevant products.
8. "Product Category 1" ( >RRP >Product ID) - Total split of relevant products per "Product Category 1" option.
9. "Product Category 2" ( >RRP >Product ID) - Total split of relevant products per "Product Category 2" option.
10. "Product Category 3" ( >RRP >Product ID) - Total split of relevant products per "Product Category 3" option.
11. "Product Category 4" ( >RRP >Product ID) - Total split of relevant products per "Product Category 4" option.
12. "Product Category 5" ( >RRP >Product ID) - Total split of relevant products per "Product Category 5" option.
13. "Manufacturer" ( >RRP >Product ID) - The split of relevant products assigned to each "Manufacturer".
14. "Country of Origin" ( >RRP >Product ID) - The split of relevant products per "Country Of Origin".
15. "Product WSP Empty" - Total number of relevant products with no "WSP".
16. "Product Cost Empty" - Total number of relevant products with a total unit "Cost" of 0.00.
17. "Product RRP Empty" - Total number of relevant products with no "RRP".
18. "RRP Split" - Split of products based on "RRP".
19. "Collection Overview" - Review styles by RRP, Category, Manufacturer and COO.