Define the circumstances/conditions for applying the multiple price (using the query builder)

Why do it:

This procedure allows you to specify the rules (based on user, cart, or other criteria) that must be met for a specific multiple price to be applied or displayed.

Procedure:

1. Access the settings of the "Prezzi multipli" plugin.

2. If you don't have a price template yet, click the Add template button.

3. In the new configuration block, fill in the basic data:

  • Under the label Who is this price intended for?, enter the descriptive name of the price (for example, "Prezzo clienti Gold").
  • Under Price type, choose whether the price should Show as discount or Replace price.

4. Locate the field labeled Under what circumstance do you want this price to be applied?.

5. Click inside the text box associated with this field. The Query Builder interface will open automatically.

6. Use the Query Builder to build the desired conditions:

  • Select filters (e.g., "Gruppo Cliente", "Paese di spedizione", etc.).
  • Define logical rules (e.g., "Gruppo Cliente is equal to 'Gold'").

7. Once all conditions are defined, confirm your selections in the Query Builder. The condition syntax will be saved automatically in the text box.

8. Save the plugin settings. The multiple price will now only be applied when the defined conditions are true.