How to create product groups based on profit margin for marketing purposes

[Miikaoja]

I want to categorize individual products to 3 different internal profit groups based on the profit margin each product has. This is to better plan the marketing expenses I will use on these products. These 3 level groups would not be seen to customers and would not be the same as the product categories used in the store for customers. 

For example if the store sells all kids of products, like toys, cosmetics, furniture, then I would for example like to put individual products like Barbie dolls in "toys" category into one of three "internal or "secret" categories based their profit margin and some other Barbie doll or whatever other toys to another category also based on profit. Customers would not know which items in "toys" category would belong to any of these profit categories.

How can I do this? Any ideas?

[BetterReports-C]

Hi @Miikaoja 

Claudia here from Better Reports.

Have you been able to find a solution for this? If not, I would recommend our app Better Reports.

If I understand correctly, you want to create three product categories based on their Gross margin (or gross margin rate). We can easily create these categories. For example, category A could be for items with a gross margin rate of 60+%, Category B could be for items with a gross margin rate of 30% to 60%, and the last category could be for items with a gross margin rate of less than 30%.

With this custom field, we could then set up sales and inventory reports, keeping track of the movement in each category to help you plan your marketing strategy. 

In addition to this, Better Reports has more than 60 built-in reports available out of the box that cover many common use cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel or PDF format.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

What do you think?

[Peter_Datma]

Hello,

If you just want to organise them yourself, one easy way I think would be unpublished collections. A product can be placed in as many collection as you want so it would not interfere with your public collection/organisation, customers cant see in what unpublished collection a product is added. Of course there are also more complex ways, custom attributes etc.

Best, 

Peter @ Datma

Product analytics and reporting

Demo: https://demo.datma.io