Pricelists: Manage advance price rules

This article will guide you through steps to create advanced pricelists in the Viindoo system.

Set up Pricelists feature

Navigate to Sales > Configuration > Settings. Go to the Pricing section:

  • Enable the Pricelists feature;

  • After that, choose the Advanced price rules (discounts, formulas) to configure prices based on the advanced formula;

  • Press Save to finish.

Set up pricelists feature on Viindoo

Steps to create a pricelist

Navigate to the Sales > Products > Pricelists. Press Create to create a new pricelist.

Create a new pricelist in Viindoo

Configure general information

  • Name: Add a name for your new pricelist.

  • Currency: The currency applied to this pricelist. This field is displayed only when the Multi-currencies feature is enabled. For more information, refer to the How to configure a multi-currencies system article.

  • Company: The company that this pricelist will be applied to (only appears if the multi-companies feature is enabled).

General information on a quotation

Price rules tab

Click on Add a line to add information.

Create pricelist items window

General information

  • Apply on: Select one of the following options to define the scope to apply this price rule:

    • All Products;

    • Product Category: Choose a specific product category;

    • Product: Choose a specific product;

    • Product Variant: Choose a specific product variant (if you are using the Product Variants feature). Read more on Using Product variants in Viindoo;

  • Min. Quantity: The pricelist will be applied if the number of products on the quotation/sales order is greater than or equal to this quantity;

  • Start Date: The first day this price rule is applied;

  • End Date: The last day this price rule is applied.

Note

  • Start Date/End Date: This field can be blank if the price rule is applicable without any time limit.

  • If a time limit is set up with a start date/end date, after this period, other price rules will be applied to the product. For example, the default listed price rule.

Price Computation as Fixed price

Select if you want to apply a fixed price without taking into account the listed price on each product form. With this option, you can choose the specific product or variant, etc. and add the price into the Fixed price field:

Create price rule with fixed price

Price Computation as Percentage (discount)

The price of the product, product category, or all products can be increased or decreased by a certain percentage compared with the listed price on the product form.

  • With this option, you can flexibility to use when you want to create a discount program.

  • Besides that, make sure you configure the price on the product form.

    Example: Configure a 5% discount price rule for all products with 10 as the minimum quantity.

Create a discount pricelist

Price Computation as Formula

Choose this option if you need to configure a complex price rule.

Create price rule with formula as compute price method

The product price is calculated based on:

  • Sales Price: The price on the product form;

  • Cost: The cost of products, can be effective by the Costing Method;

  • Other Pricelist: Choose this option, you also can choose the existed pricelist in the system to calculate.

The formula for the calculating the price will be:

  • New price = Sales Price/Cost/Other pricelist - Price discount (percentage) + The surcharge.

  • In which:

    • New Price: The product price will be displayed on quotations/sale orders.

    • Price Discount: The percentage of the Sales Price/Cost/Other pricelist (the previous corresponding choice) will be added to the New Price. If you want to decrease, use the negative syntax.

    • The Surcharge: You can add or subtract with a fixed value. Add the minus symbol (-) if you want to subtract a fixed value in the price calculation.

    Besides, you can apply:
    • Rounding method: Choose a value that the price can be a multiple of this value. Example: The new price after calculating is 280,950 VND. If you set the Rounding method as 1,000, so the new price will be 281,000 VND.

    Note

    • The rounding method will be applied after the Price discount and before the Surcharge.

    • This rounding method also runs following the half-up rules.

    • If the Rounding method equals 0 means not setting the rounding method.

    • Min. Margin: The amount that the Sales Price/Cost/Other pricelist plus this amount is the lowest price appears in quotations.

    • Max. Margin: The amount that the Sales Price/Cost/Other pricelist plus this amount is the highest price appears in quotations. Example:

      • If the Sales Price in product form is 300,000 VND;

      • Min. Margin is set as 50,000, Max. Margin is set as 100,000;

      • So that, the price will appear on the quotation from 350,000 VND to 400,000 VND.

    Note

    Min. Margin and Max. Margin equals 0 means not setting the min-max price. The price on sales orders will be exactly of calculating.

Press Save & Close to save and finish the price rule configuration. Or press Save & Create to continue configuring prices for other products. Then, click Save the newly created pricelist.

Configuration tab

At this tab, you can set the country group that will be available with this pricelist:

Create pricelist with formula as compute price method

When you set this feature, any contacts created with the chosen country will automatically update this pricelist by default in the contact’s form.

Note

To define a group country, navigate to Contacts > Configuration > Group country, create a new group and add the needed country.

Apply Pricelist on Sales

Apply pricelist by default to a partner

Note

  • Pricelist can be applied to one customer or a group of customers.

Navigate to Sales > Orders > Customers, and select the customer that you want to set up a pricelist for. In Sales & Purchase tab, select the newly created pricelist.

Select a default pricelist for a customer

On sales quotation, when you select this customer, the pre-configured pricelist will be automatically applied.

Pricelist auto applied for a customer

The product price will be computed based on the price rules set up on the pricelist attached to this customer.

Select pricelist on a quotation

If you don’t apply a specific pricelist for the partner, by default, the price on quotation is the public price. If you want to change it follow the pricelist, click Edit, select your desired pricelist then press Update Prices to apply the new pricelist to the quotation. Click Ok to confirm the price update. Now, the product price is updated according to your chosen pricelist.

Update pricelist