SageForum for UK versions of Sage 50- Help and support.

Hi All

Is it possible to import products and prices into a price list in any other method than a fixed price?

I have been using "decrease sales price by value" for most of the items in a price list, but cannot see a way to update this other than going in to each product individually.


What is the best/recommended way to deal with price lists?
I have our standard sales prices, and then a Trade price list. Trade prices are not just a % discount on the item, hence why I am using discount by value. We are experiencing a lot of supplier price changes recently, so sales prices (and therefore trade prices) are changing a lot. Would you recommend using fixed prices and reimporting each time we have a price update?

Thanks!

Which method is best for you is very hard to tell.

The issue with fixed prices is that they are fixed and you if need to change them on lots of price lists then they become a real pain as you have to do them one at a time.

Using %ge is easier as the prices change with the standard price but even then that might not be enough.

Whilst Sage only offers fixed prices, there are other third party products that can import all the different price list options.

The tool we use for integrations can import multiple pricelists with multiple products using any of the price list options (it costs £185 per year).

I have made a variety of tools for importing pricelists over the years using it (generally a spreadsheet saved as csv and then imported).