sku | stk | stk weeks left | total week sales | uk sales | germany sales | spain sales | uk profit | german profit | spain profit | Total uk prof | total german prof | total spain prof |
pen | 10000 | 10 | 1000 | 500 | 500 | 0 | £1 | £3 | £5 | £500 | £1500 | £0 |
<tbody>
</tbody>
Hey Experts!
I'm trying to create a repricing tool which will provide prompts for repricing based on defined parameters.
We currently have over 2000 skus listing on various marketplaces at different profit levels.
Using the above example I need the user to easily identify skus to reprice, in this scenario you can see spain is making no sales because the profit level is too high at £5 which will prompt a price reduction. Germany is making the most profit with sales level to the UK, if stk weeks left was below 2, I would prompt a price increase for UK.
Potential scenarios
Stk weeks left is below X and country X profit is below X then increase selling price
Stk weeks left is above X and country profit is above X then lower selling price
If country X achieves X sales and country X profit is below X then increase selling price
If country X is below X sales and Country X profit is above X andstk weeks left is above X then lower selling price
So basically the aim is to maximise profit in all countries when stock weeks is low/or reaches certain defined sales i.e 30 a month and to lower prices when stock weeks is high.
Hope this makes sense! appreciate any help or alternative solutions.
THanks
Jay
<fieldset class="postcontent" style="margin: 5px 0px; padding: 0px; border-width: 0px; border-style: initial; border-color: initial; word-wrap: break-word;"></fieldset>I'm trying to create a repricing tool which will provide prompts for repricing based on defined parameters.
We currently have over 2000 skus listing on various marketplaces at different profit levels.
Using the above example I need the user to easily identify skus to reprice, in this scenario you can see spain is making no sales because the profit level is too high at £5 which will prompt a price reduction. Germany is making the most profit with sales level to the UK, if stk weeks left was below 2, I would prompt a price increase for UK.
Potential scenarios
Stk weeks left is below X and country X profit is below X then increase selling price
Stk weeks left is above X and country profit is above X then lower selling price
If country X achieves X sales and country X profit is below X then increase selling price
If country X is below X sales and Country X profit is above X andstk weeks left is above X then lower selling price
So basically the aim is to maximise profit in all countries when stock weeks is low/or reaches certain defined sales i.e 30 a month and to lower prices when stock weeks is high.
Hope this makes sense! appreciate any help or alternative solutions.
THanks
Jay