Bulk price Increase

[Faulkds]

Can anybody give advise on how to apply a 5% bulk price increase on my prices and to round the figures off so that they are e.g 6.95

[pinbrook]

I've just done this, very briefly

I exported a froogle file, applied 5% increase to the price field, then manually rounded the figures, converted the column back to values rather than the formula,

then did a find and replace on the section text column to replace > with | so the re-import would work for section names

[Stunty]

Hi Faulkds

This is how I went about a bulk price increase - It's easy enough, using exel.

1. save your catalog as a .csv file: (file - export)
2. create a column down the left-hand side: (this should now be column A)
3. in row '1' of column 'A' type in 'a00000001' and in row '2' type ''a00000002'
4. now select rows 1 & 2 and using the small cross in the bottom right-hand corner of the selection, drag the selection down to the bottom of the whole of the document.
5. select the whole document and from the top menu select, 'data' - 'sort' - 'column G'
6. all the price entries should now be stacked in consecutive rows. copy all of them into a blank document and select the first entry in column A, row 1 and hit the '=' key - select the box next to it, (A2) and then type '+105%'
7. once you have the calculation made, select it and double click the cross in the bottom right-hand corner: (this should automatically fill in the rest of the column)
8. select the new column and copy the changes back into the original document.
9. select the whole document again, and from the menu select, 'data' - 'sort' - 'column A'
10. delete column A and save your csv document and import it back into Actinic.

there's probably a way of rounding the prices using the same technique by way of an 'integer' function, but I've never explored that possibility thus far..

hope this help.

[Faulkds]

Thanks for the advise, not sure i can do it though

[Jan]

You can use our profit and pricing tool to do this, as well as allowing you to set cost prices and calculate profits, it has a nifty little price import / export function. You can use it to export your prices into a csv file, which you can then open in excel and use a formula to increase the prices by the 5% you want, then you can use the program to import the prices in again.

You can fine more details and a 30 day trial at this URL :

http://www.actinicplugins.co.uk/acat...ng_Tool_b.html

Regards,

[Faulkds]

That sounds good, im ont version 6 at the moment and have bought the 7 upgrade, will your software work with that. Is this pluggin also on the cd which came with the upgrade

[Jan]

Yes, this program does work for V6 and should be on the CD you have recieved.

You can install a free trial for V6and for V7. Remember that Actinic prices in pennies, and also make sure you take a snapshot before running the tool just in case you make a mistake (it backs up your original prices actually just in case).

Regards,

[Faulkds]

Hi again ;-)

I dont relly want to have to go through every price as we have over 13000 entries. Any advise?

[pinbrook]

Posts 2 and 3 give the solution. In order to do this job automatically you need to do it in Excel or Access, if you can't do it yourself you will need to find someone to help you, otherwise it will be a manual job.

[Mike Hughes]

You'll need to use one of the excel formulas. Either round or roundup depending on what you want to do. For example, if the 5% increase takes it to 5.97 what price do you want to charge? 5.95 or 6.00? i.e. round to the nearest 5p, round up to the nearest 5p or round down to the nearest 5p?

Mike

[Faulkds]

I would like to round to the nearest 95p. e.g £8.34 becomes £8.95
However, my excel isnt that brilliant and icant ind anybody who are able to do it. Ive managed to add the 5% without a problem

[Mike Hughes]

=ROUND(Ax/5,0)*5

Where Ax is the location of the number to be rounded.

Mike

Edit; Sorry didn't see the 95p bit. Give me a minute.

[Mike Hughes]

This will round to the nearest 95p.

=ROUND(Ax+5,-2)-5

Again, Ax is the location of the number to be rounded.

Mike

PS. £8.34 to the nearest 95p is £7.95 not £8.95

[Faulkds]

Hi Mike,

So it is....

The only problem that ive got now is the pricing figures in Excel are not decimal figures e.g 754 equates to 7.54

:-(

[Mike Hughes]

The formula I've given will round 834 to 795. I've done it this way as Actinic uses prices in pennies. Did you want something different?

Mike