Help to automate a repricing tool using if statements

[mrjiggle]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]sku[/TD]
[TD]stk[/TD]
[TD]stk weeks left[/TD]
[TD]total week sales[/TD]
[TD]uk sales[/TD]
[TD]germany sales[/TD]
[TD]spain sales[/TD]
[TD]uk profit[/TD]
[TD]german profit[/TD]
[TD]spain profit[/TD]
[TD]Total uk prof[/TD]
[TD]total german prof[/TD]
[TD]total spain prof[/TD]
[/TR]
[TR]
[TD]pen[/TD]
[TD]10000[/TD]
[TD]10[/TD]
[TD]1000[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]0[/TD]
[TD]£1[/TD]
[TD]£3[/TD]
[TD]£5[/TD]
[TD]£500[/TD]
[TD]£1500[/TD]
[TD]£0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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>

 

[Paul Ked]

Cross-posted here:

http://www.vbaexpress.com/forum/sho...ting-a-repricing-tool-with-defined-parameters

See rule 13 here: http://www.mrexcel.com/forum/board-a...rum-rules.html