The multi pricelist manager

The goal of this management feature is to enable, starting from a technical pricelist managed in the catalog (at Layedit level), the creation of N variations/versions by applying different coefficients and currencies. This is particularly useful, for example, for managing points-based price lists, where prices need to be modified via a coefficient and the desired currency must be set.

Note: It is now possible to assign multiple commercial price lists to each user simultaneously, if configured. The user will then be able to select the desired pricelist from those available via a dedicated menu. This makes it easy to handle scenarios such as temporary promotions, price lists for special customers (e.g., Best Buyer), or customized lists for specific commercial needs.

Furthermore, this feature is integrated with the discount library and the upcharge library, which are advanced tools designed to centralize and provide greater flexibility across multiple price adjustments. See the articles The discount library and The upcharge library for more details.

Key benefits

• Flexibility: Allows you to quickly adapt price lists to different markets, customers, or promotional scenarios without duplicating base data.

• Customization: Enables assigning specific price lists by country, store, or single user, facilitating differentiated commercial policies.

• Centralized management: All price lists are linked to a single reference technical list, simplifying price updates and maintenance.

• Scalability: Easily expand the number of price lists without impacting the catalog’s basic structure.

• Multi-currency and multi-coefficient: Supports managing price lists in different currencies and with various price ratios, useful for international contexts or point-based sales strategies.

• Pricelist selection: The user can choose among multiple price lists based on their profile, role, or access context.

Architecture and database

Tables involved

1. CommercialLists: Commercial pricelist management and configuration.

2. DiscountLibrary: Discount library and structure. See the article The discount library for more details.

3. UpchargeLibrary: Price increase library and structure. See the article The upcharge library for more details.

4. AssocCommercialListDiscount: Association between price lists and discounts; manages application priority. See the article The discount library for more details.

CommercialLists Table structure 

Manages all data related to multi pricelists. Each list can have additional information, be linked to a technical price list, have a price conversion ratio, and a currency. It can be assigned to a certain entity (such as a country, market, store, or specific user). 

• Cod: Identifier code of the price list.

• Des: Description (this appears in the list of available price lists). 

• HiddenInfo: Additional information (e.g., internal notes). 

• Catalog: Catalog reference (code).

• TechPriceList: Reference to the base technical price list. 

• PriceListRatio: Price conversion ratio relative to the technical list. 

• Currency: Currency of the price list. 

• EntityType: Type of assigned entity (country, store, user) (2 = Country | 1 = Shop | 0 = User) 

• EntityCriteria: Specific assignment criterion (e.g., Italy, Store X, User Y).

Typical use: Management, creation, and customization of multi price lists for different markets or customers.

Configuration of a commercial pricelist in the interface

The configuration of the Commercial Pricelist is accessible through the Supervisor tool in 3CAD Next: 

• Path: Supervisor → Catalog → Commercial Pricelist 

• From here, you can create, edit, and manage all multi price lists available for the selected environment/catalog.

Note: You must select the reference catalog (via the top menu) to view, filter, and configure the pricelists related to that specific catalog. This is essential in environments with more than one catalog available. 

Click here to view full screen.

Configurable parameters

• Cod: Identifier code of the price list. 

• Des: Description. 

• HiddenInfo: Additional information (e.g., internal notes). 

• Catalog: Name or reference of the catalog. 

• TechPriceList: Reference to the base technical price list. 

• PriceListRatio: Price conversion ratio relative to the technical list. 

• Currency: Currency of the price list. 

• EntityType: Type of assigned entity (country, store, user, etc.). 

• EntityCriteria: Specific assignment criterion (e.g., Italy, Store X, User Y). 

Note on currency assignment: Traditionally, currency was a property of the shop (Country/Language combination). Now, however, currency is a property of the individual price list selected by the user.

Practical configuration examples

• The “CPL_SFA_EUR_2_IT_1” list is assigned to the country “IT”.
• The “CPL_SFA_EUR_1_IT001_1” list is assigned to the shop “IT001”.
• The “CPL_SFA_EUR_0_736944_1” list is assigned to the user “736944”.
   

Pricelist visibility example: If user “736944” accesses shop “IT001” located in Italy, they will be able to choose between 3 different price lists.

End-user perspective

The end user can choose among multiple available price lists, as many as have been assigned according to the criteria described above. Typical examples of available price lists: 

• Standard price list

• Promotional price list

• Dedicated pricelist (Best Buyer)

• …and so on.

This choice offers great commercial flexibility and the ability to tailor the economic proposal according to the sales context or customer type.

Price calculation

To enable the calculation, the new newPriceEngine2025 flag must be set in web.config. 

Note: To set it, you need to submit a request to the R&D department.

Simplified calculation algorithm:

1. Apply base prices:

   • Prices are determined from the ARTLIST, ARTIMAGG, and ARTICOLI tables.
      

2. External Prices:

   • If external prices are present, these replace the catalog prices.
      

3. Choose the commercial price list:

   • Price determination takes place based on the commercial pricelist selected by the user. If multiple commercial price lists have been assigned to the user (e.g., at user, shop, or country level), they can choose the desired list from a dedicated menu within the interface. In this way, the user has full control and flexibility in choosing the list best suited to their context. 
      

4. Apply the technical list factor:

   • The price is updated by applying the coefficient (PriceListRatio) provided by the reference commercial price list. 
      

5. Apply discounts:

   • Discounts found in the DiscountLibrary are applied according to the defined priorities and rules. 

      

6. Apply markups:

   • Markups and other price increases found in the UpchargeLibrary are applied according to the defined priorities and rules.