Slow Down In Sales

[leehack]

No one knocking on the door asking for their money.

Squatters rights?

[RuralWeb]

The biggest drop in sales I am seeing at the moment is corporate gifts - usually by this time we have had all the details from many major clients but they have all dried up. Some have gone bust others are cutting down and many are just not bothering this year.

Currently sales are up by 70% BUT come Dec when the corporate gifts are usually factored in then things will look very different.

[guitarman]

Changing VAT Inclusive Prices - HELP !!

How that the 2.5% reduction has been confirmed, the problem now is how to change all of our Actinic product prices.

I don't fancy doing that manually - so can anyone suggest a way to go about it with minimum pain ?

Thanks,

Andrew.

[leehack]

vat incl. or vat excl. in actinic?

[Darren B]

Upgrade to V9, that would be the easiest way

[guitarman]

VAT Inclusive Pricing Change

We are using V9 and all of our prices are entered as VAT inclusive.

[leehack]

For those who can get their including vat prices into excel, the formula you want will be:

=ROUND(SUM(A1/1.175)*1.15,0)

A1 is the cell reference in which the price currently sits.

REMEMBER: The figures in blue need to match the vat rates you charge for those of you with differing rates.
MAKE SURE you change them correctly:

1.175 = 17.5%
1.15 = 15%
1.10 = 10%
1.08 = 8%
etc.

If your prices are net of vat, then all you need to do is change the vat rate in actinic.

If you have 2 PC's, then setup one and test it all, so you can just go live on Monday with no panic.

[TraceyHand]

that's worth putting as a new thread, Lee so it's easily found if searched for

[chris ashdown]

Mole end has its profit and pricing tool that allows automatic + & - percentage changes to prices

Might be able to use for those using including vat prices

[leehack]

I've added a new thread with a couple of other things to think about - http://community.actinic.com/showthread.php?t=40026.

[leehack]

Mole end has its profit and pricing tool that allows automatic + & - percentage changes to prices

Might be able to use for those using including vat prices

I very much doubt this Chris, it's not a straightforward % change you need to do.

[Darren B]

We are using V9 and all of our prices are entered as VAT inclusive.

In that case,
1) Use actinic to export the catalog.
2) Open this in excel
3) Remove everything apart from the product reference and the price. Including all the section information so you have two columns.
4) Use Lees formula to generate the new prices.
5) copy these values and paste special over the old prices, when using paste special select to paste values only.
6) Then delete the formula column
7) Then format the new price column to no decimal places
8) save this file.
9) Then do a flat file import into actinic.
10) Make sure you save the erros into a text file so you can change any that do not work

There might be other ways to do this, but it would be the easiest way for me

[guitarman]

Change to VAT rate

Thanks for that - I understand the prinicple but how do you export the catalog information in a FLAT file format - Actinic seems only to export hierarchical files and I find that very difficult to use !!

... or is there a trick I'm missing here ?

Thanks, Andrew.

[leehack]

No trick missed at all, that's what Taddy is talking you through.

[Darren B]

Yep

export hierarchical, rip all the crap out of it to leave two columns with nothing more that product reference and price, no other info required.