Articles in this section

How to Fill Out the Product Mix Template

Summary

Learn how to correctly fill out the Product Mix template in Involves Stage. This article shows how to configure mixes by POS or segmentation, as well as the main rules and import validations.

Expected result: template correctly filled out and ready for import into the system.

📘 We recommend reading the main article: Product Mix Registration


In this article


Before You Start

Before filling out the template, make sure that:

  • The products are registered in the system;
  • The points of sale (POS) exist in the environment;
  • The segmentations have already been configured.

⬆ Back to top


Template Structure

The template consists of the following groups of information:

  • Assortment Name
  • POS Name
  • POS Segmentation
  • Product Portfolio

 

💡 Tip

The template includes a link with practical filling examples.

Click the shortcut available at the top of the spreadsheet to view examples of Mix registration.

 


imagem exemplo.png

 

⬆ Back to top


Mix by POS

Use this configuration when each POS has specific products.

How to Fill

  • Fill the POS Name column with the names of the points of sale.
  • Do not fill the segmentation columns.

 

Multiple POS with the Same Mix

If more than one POS has the same product mix, add them in different rows within the same assortment.

Exemplo de múltiplos PDVs no mesmo sortimento 

⚠️ Attention

You cannot mix POS and Segmentation in the same assortment.

Use separate assortments for each configuration.

⬆ Back to top


Mix by Segmentation

Use segmentation to apply the mix to groups of POS with similar characteristics, such as region or brand.

How to Fill

  • Choose a segmentation criterion (example: South Region);
  • Do not fill the POS Name column;
  • Add the desired segmentation conditions.

⬆ Back to top


Rules and Validations

Import Validations

  • POS or Segmentation not found: if an entered name does not exist in the system, an error will be displayed.
  • Do not mix POS and Segmentation in the same assortment: the system will indicate an error during import.
  • POS or Segmentation must be filled: the mix needs to be linked to a point of sale or segmentation.

The error examples below follow this logic:

Exemplo de mensagem de erro

💡 Tip

Review the names of POS, products, and segmentations before importing.

Any discrepancies may prevent the mix from being registered.

⬆ Back to top


Product Hierarchy

The template filling must respect the hierarchy configured in Involves Stage.

Hierarquia de produtos

💡 Important

If the chosen hierarchy is Product Line, also fill in Brand and Category.

Example of correct filling:

Exemplo de hierarquia preenchida corretamente

⬆ Back to top


Frequently Asked Questions

Can I mix POS and Segmentation in the same file?

No.

Each type of configuration must have a separate assortment.

What happens if a POS does not exist?

The system will display an error during template import.

Can I use more than one segmentation?

Yes.

You can combine different segmentation criteria in the same assortment.

⬆ Back to top


Related Articles

⬆ Back to top


💬 Need help?

If this page did not solve your question, contact support.

Support hours:
Monday to Friday, from 9 a.m. to 6 p.m. (Brasília time).

Was this article helpful?
1 out of 2 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Encontre ajuda por soluções ou produtos