help creating a repricing tool with defined parameters

[jayfresh]

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 example attachement I need the user to easily identify skus to reprice with 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.

THanks

Jay