Price management - Runner
Margin Setup
Go to @Sources-> @Your source - Edit->@Categories change +margin and Press @Donwload template. Template for Settings Margins for selected categories will be downloaded.
It is Excel file - open it in Ms Excel or OpenOffice or LibreOffice editor.Sample file
Now you have to fill this file and upload to @Upload new Settings section.
Find below sample of filled file:
How does Margin work
Active formula for NEW Prices is the next:
New Price = (Wholesale Price * (1 + Margin %) ) + (Margin DELTA)
Source category column (A) - do not change it!
Destination category column (B) - allows you to change original category path.
Margin % percent column (C) - allows you to set your margin for exported products
Margin DELTA column (D) - allows you to add specific number to price after margin % action
Sample 1: calculate manually
Wholesales price is 100$
Margin Percent is 10%
Lets get results:
100$ * (1 + 10%/100) = 110$
or 100$*1,1=110$
where 1,1 is effective multiplier
Sample 2: what "Margin percent" should I set if I want just multiply "Wholesales price" at 1800
effective multiplier is 1800
Lets get results:
1 + %/100 = 1800
1800-1 = 1799
%/100 = 1799
% = 179900
So, "Margin percent" has to be 179900
It is Excel file - open it in Ms Excel or OpenOffice or LibreOffice editor.Sample file
Now you have to fill this file and upload to @Upload new Settings section.
Find below sample of filled file:
How does Margin work
Active formula for NEW Prices is the next:
New Price = (Wholesale Price * (1 + Margin %) ) + (Margin DELTA)
Source category column (A) - do not change it!
Destination category column (B) - allows you to change original category path.
Margin % percent column (C) - allows you to set your margin for exported products
Margin DELTA column (D) - allows you to add specific number to price after margin % action
Sample 1: calculate manually
Wholesales price is 100$
Margin Percent is 10%
Lets get results:
100$ * (1 + 10%/100) = 110$
or 100$*1,1=110$
where 1,1 is effective multiplier
Sample 2: what "Margin percent" should I set if I want just multiply "Wholesales price" at 1800
effective multiplier is 1800
Lets get results:
1 + %/100 = 1800
1800-1 = 1799
%/100 = 1799
% = 179900
So, "Margin percent" has to be 179900
Pretty prices like 4.99 or 0.95. How to do it?
Go to @Source settings and at @Categories change + margin settings section set Round delta value: 0.05 or 0.01.
How to apply margin based on Wholesale price range?
If you need to apply margin based on Wholesale price range you have to define your margin rules in excel config file: fine sample below, please
How to do it
Go to Column (F - Margin rule) and put cell value to X
Insert new Worksheet and set it's name to Margin rule - X
At Margin rule - X worksheet define your rules
Download sample here
https://drive.google.com/open?id=158BwK1xuBwRLCYtVb56q0TFYiiJ-Y6TV
How to do it
Go to Column (F - Margin rule) and put cell value to X
Insert new Worksheet and set it's name to Margin rule - X
At Margin rule - X worksheet define your rules
Download sample here
https://drive.google.com/open?id=158BwK1xuBwRLCYtVb56q0TFYiiJ-Y6TV