Sales Per Brand report, anyone??

 Hi Everyone,


I'm guessing with the fairly limited amount of reporting that LW.net produces that there is no such brand report?!


We have an extended property on each sku with the product brand on it. I would like to be able to see sales data for the brands, in order to get an idea of what brands do well etc etc. What would be even better would be a stock value next to it as well to get a really good breakdown of performance.


Anyone got any ideas, I know if I ask LW tech support I will get the standard "have Linnworks to write the script for you which is a chargeable service".


Thanks


Will

Will, 


Are your brands not your Linnworks categories? 


What we do is multi tier categories that includes the brand. 

Brand > Item Sub Type > second sub type if applicable. 


Then when we export sales reports (which they all have category I think) we can text to column in excel and group by brand / sub type etc


A few years ago we also took this one stage further and added an extended property for stock item parent so we could see the amount of sales on a product level as well as individual SKU level 

See this thread recently where I explain more - https://help.linnworks.com/support/discussions/topics/7000026451


We needed to get a custom query written to be able to pull out all the data we wanted but we have been using that query for about 6 years and it speeded up our reporting by about 30% by not having to combine multiple reports into one 

It was one of the best £120 we ever spent!! 


Daniel 


Login to post a comment