Start a new topic

Product Sell Price Based Off Supplier Buy Price

Could you please look at adding this to a future release.

Potentially something along the lines of Excel’s formula string: [Item Supplier Price] / [Exchange Rate USD/AUD] + [Freight Modifier] + [Margin] (where all items in []’s are variables / lookups)


1 person likes this idea

For what it's worth...

We accomplish that kind of thing with a quick export/import to/from excel. 

Maybe there would be some way to automate this with a feature like you describe, but pretty easy for us to do the way we're doing it, so this hasn't been a particularly significant pain-point in our workflow.

 I've used system in the past that set price tier rules via a number of different methods. So for example I could use tier rules such as:

Tier 1 (RRP): cost price x 2

Tier 2 (RWP): cost price x 1.5

Tier 1 (retail1): Tier 1 – 15%

Tier 1 (retail2): Tier 1 -20%

Tier 1 (retail3): Tier 1 – 25%

Tier 1 (w/sale1): cost price + 25%

Tier 1 (w/sale2): cost price + 20%

Tier 1 (w/sale3): cost price + 15%

Tier 1 (basecost): cost price + 5%

As long as there is an option at individual product level to apply or not apply the rules.

As mentioned above this can be done at Excel level, but for a dozen or so products it is very time consuming.

Login or Signup to post a comment