Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie

The costs of my products often changes , and depending on the values of those cost, I'd like to apply a specific minimum margin. For example, if a product has a cost of 5€ or less (standard price valuation) , I'd like to sell it with a minimum margin of 75%i. If the cost prices goes from 5 to 10€, I'd like the minimum margin to be set on 50%. Finally, when the cost of a product goes beyond 10€ , the minimum margin should be 25%. The only thing I change manually is the cost price on the product template, and the pricelist should be updated according to the new cost of the product.

Awatar
Odrzuć
Autor Najlepsza odpowiedź

Explanation of the flow/features: 

First, at the creation of a product, it should be added to a pricelist in order to apply the minimum margin on it. It's possible with an automated action, the screenshot below shows how to configure it: 

This will create a specific line (pricelist item) in the pricelist "Public Pricelist (EUR)" for this product so you don't have to update your pricelist each time you create a new product.

The pricelist items are configured like that :

  • Apply on : products
  • Compute Price : Formula
  • Based on : Cost
  • Price discount : - the margin you want


One it's done, you will need to display the product cost in the pricelist item (form view). To do that, you just have to add a related field that points towards the product>cost .  I called it PrCost. Make sure this field is stored, it will be necessary for the next steps.

It's now time to create the automated actions that will update the "price discount" field in the pricelist items. Here are 3 screenshots of the automated actions created (minimum margin for cost below X€, between X and Y€ and above Y€, in the order )


Once it's done, the price discounts are automatically updated when you modify the cost on the product template.

To resume : 

  • Creating a product will automatically create a dedicated pricelist item for it, and based on what you put in the product cost when you create it , it will automatically have a minimum margin applied.
  • Each time you modify the cost of a product, the existing pricelist item for this product will be updated.
Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
2
sty 22
3896
2
maj 25
6469
1
mar 23
3133
0
lip 21
444
2
sty 25
3629