Price Margin

    There are 4 methods to add a margin to the product price. The margin is added to the price list price or to the parsed from the donor site price.

    1. Using the currency rate

    If, for example, today's rate is 27.30, then by setting the rate to 27.31 we will add 1% to all product prices. That will be updated or added when processing the price list:

    To reduce the price by 1% we need to set an exchange rate of 27.29

    2. Margin per category

    You can set a margin for each category. This is done on the "Category and margin" tab, for example, like this:

    In this example, the price of products from the category of "Alt-car" increases by 5%, and those of the category of "SLR" by 2%.

    Here is the algorithm:

    • the plugin reads the product data from the price list
    • finds the product in the store by SKU
    • defines the product category
    • if the category is "Alt-car", increase the price from the price list by 5% and update the product price
    • if the category is "SLR", increase the price from the price list by 2% and update the product price

    In update mode, there is no need to fill in the number of the column containing the category:

    The plugin can apply the margin using the already set product category.

    Margin per manufacturer (update mode only)

    If you fill in the column number containing manufacturers in the "Category" field and set the margins for these manufacturers in the "Category and margin" tab, the update will apply the margin for these manufacturers:

    "Category and margin" settings:

    Margin formula

    The margin may depend on the product price value. If the product price falls within a certain price range, then the corresponding margin is calculated. For example:

    (0-100)10,(100-200)+9.5%,(200-500)-8,(500-1000)+30,(1000-2000)+2%-1,(2000-100000000)+2%

    (without spaces)

    Explanation:

    In the price range (0-100) - the price is increased by 10%
    In the price range (100-200) - the price is increased by 9,5%
    In the price range (200-500) - the price is reduced by 8
    In the price range (500-1000) - the price is increased by 30
    In the price range (1000-2000) - the price is increased by 2% and reduced by 1
    In the price range (2000-100000000)  - all other prices are increased by 2%

    "Category and margin" settings:

    3. Margin by a formula for the entire price list

    If you fill in the margin formula in this field (in the "General buttons"):

    and set "Set margin as defined in the Category and Margin tab" to "No", each product price will be recalculated by the formula regardless of the category to which belongs.

    4. Margin from the price list column

    You can use a column in the price list, enter margins in it without the % sign, and fill in the column number in this field:

    Usergio Copyright © 2022