Setting margins and minimum purchase quantities on product prices

Shane Kloosterman
Written by Shane Kloosterman
Modified on: Wed, 18 Dec, 2024 at 1:50 PM
  • xlsx
    Margin table starting price - Calculator.xlsx 56.1 KB

Why set margins and minimum purchase quantities?

Setting margins ensures you make a profit on your products, while a minimum purchase prevents customers from ordering too small quantities. This helps you work more efficiently and maximize your profits.


Note!

Before you start setting your margins, it is important to think carefully about what type of margin you want to set with the choices below. Make sure that you calculate the margin based on the correct prices (Purchase or sale). See also: View supplier overview, updates, and pricing types


Choose one of the following items to get started:


Create your own margin table (Beginner)
Create your own margin table and link it to your own selection of products
  1. Go to "Settings" via your CMS (Back-end).
  2. Click "Margin Tables" in the left menu.
  3. Click "Add New Margin Table" at the top.
  4. Fill in a "Name" for the margin table.
  5. Choose a "Margin type" for the table
  6. Click "Save"

Ready for the next step?

Link your margin table to the appropriate items to make it work. Click here to link your margin table.

Set standard margin table for supplier (Beginner)
Add a standard margin per supplier based on tiers
  1. Go to "Settings" via your CMS (Back-end).
  2. Click "Margin Tables" in the left menu.
  3. Select the assortment for which you want to set the margin and click "Edit".
    By default, a margin table is already created per supplier assortment.
  4. Fill in your "minimum purchase" and "factor".
    Optionally, you can add extra rows for tiers.
  5. Click "Save"
Set margin based on a 'starting' price (Advanced)
Set a margin and minimum purchase based on the starting price of a product

Note!

Before you can start with this, you must activate the table view for margins. Click here to activate the table view.


What does "Set margin based on a 'starting' price" mean?

If you do not want customers to only order one cheap item, like a pen priced at €0.12, but want them to be able to buy a more expensive jacket starting from one piece, this function is ideal.  


In short: Suppose you have a product with a price of €1 (starting price) and you want the minimum order value to be €100. Then you enter a minimum purchase of 100 pieces (100 x €1 = €100) at the starting price of €1. For another starting price, you can enter a different minimum purchase quantity and margin factor.


This prevents low-priced items from being bought starting from 1 piece, and you are not left in a difficult situation with products that are much more expensive.


Where do I fill in this table?

  1. Go to "My Suppliers" via your CMS (Back-end).
  2. Search for the desired assortment and click "Edit margins".

Tip!

Download our margin calculator via the attachment to this article. This calculator helps you calculate the appropriate prices for both purchase and sale price types. An example:


How does it work in practice?

The system automatically selects the most suitable margin table based on the 'starting' price of the product variant.


Example: If the starting price is €1.20, then the "Margin Table €1.00" applies based on the screenshot above, because it is the closest to the starting price.

Tip!

You can find the starting price of an item in the CMS. When you look up and edit an item, you can see the 'Loaded prices' per variant. These prices are used to calculate the correct sale prices (Loaded price x margin factor = sale price). Click here to learn how to find an item in the CMS


Settings "Use lowest quantity as minimum purchase" and "Overwrite supplier margin table"

If these settings are turned on, the minimum purchase and margin table of the supplier will be overwritten with your settings. Read more below.


Ready for the next step?

Let the system automatically link the margin table(s) to the appropriate product(s). Click here to link your margin table (Choose for automatic).


Tip!

We always recommend using the "Set margin based on a 'starting' price (Advanced)" option. This option has the most extensive setting options and provides the best outcome. With this, you can easily calculate your minimum order value.


Set minimum purchase quantity

You can set a minimum purchase quantity on your webshop in three ways:


Via the standard margin table
Set a minimum purchase for all items linked to the margin table.
  1. Go to "Settings" via your CMS (Back-end).
  2. Click "Margin Tables" in the left menu.
  3. Select the margin table where you want to set the minimum purchase and click "Edit".
  4. Check "Use start number as minimum order quantity".
    The minimum purchase will be the lowest tier within the margin table.
  5. Click "Save".
Via the category
Set a minimum purchase for all items within a category.
  1. Go to "Webshop" via your CMS (Back-end).
  2. Click "Categories" in the left menu.
  3. Search for the desired category and click "Edit".
  4. Under the "Category Properties" tab, fill in the "Minimum order quantity" field with your desired minimum purchase.
  5. Click "Save and continue".
Via the supplier
Set a minimum purchase for all items from an assortment of a supplier.
  1. Go to "Webshop" via your CMS (Back-end).
     
  2. Click "Suppliers" in the left menu.
  3. Select the supplier for whom you want to set the minimum purchase and click "Edit".
  4. Fill in the "Minimum purchase" field with the desired minimum purchase.
  5. Click "Save".
  • xlsx
    Margin table starting price - Calculator.xlsx 56.1 KB