Page 1 of 1

price increases in products

Posted: 14 Jan 2008, 19:51
by hat984
At the company I work for many of our customers have special prices for the products they buy from us. When we need to put the price up on certain products (say by 5%) we have to go into 'Products' enter the product code, select the special price section and then go through every customer individually, manually changing the price they pay. This can be really time consuming when perhaps up to 50 of our customers buy a product that needs a price increase and each customer is paying a slightly different price.

Is their a way in which a product can be selected and a price increase of say 5% can be applied so that all customers with a special buying price for that product will now be paying an extra 5%? No manual editing.

If there is a way I would love to know.

Posted: 23 Jan 2008, 15:25
by brucedenney
There is no way in Sage.

however, we have an advanced import / export tool that can let you do it in excel.

Price lists are hard to maintain. Good idea to use %ges rather than fixed.

Price increases in Products section

Posted: 23 Jan 2008, 19:09
by hat984
Thank you for your reply.
Does this mean that information, such as prices, in excel can just be uploaded to Sage? And from sage to excel?

We do currently work out our price increases on excel (a list of our customers and what they pay for a specific product) But then we manually type in the new increase price on Sage from what we have worked out on excel. If the information can just be imported from the excel spreadsheet in one go then that would save a lot of time.

Please let me know if I have understood correctly.

If this is so, Is the Import/Export tool built in to Sage line50 as standard or an addition?

Posted: 25 Jan 2008, 09:41
by brucedenney
You are correct

the tool is a 3rd party utility and costs £225

You might also need some help and support setting it up to do what you want.