Increasing all prices automatically

[avanta]

I have an Actinic V4 website http://www.workequip.com/ which requires an increase of all prices by a given percentage. The problem is that all product prices are in the form

Sum of component prices

Is there a way to increase every component price at once - I really hope there is otherwise I'll be doing this for the next three years!



Thanks in advance

[Ben]

Hi Alex

There's no way to update all prices in Actinic simultaneously, I'm afraid. However, you can do this in Excel but it's a bit fiddly. I would do something like:

• Export your catalog to a hierarchical file (File | Export Site)
• Open the file in Excel
• Add a new column on the left (column A) and number it so that it acts as an index
• Order the data to be arranged by (what is then) column B
• The 'component' rows should then be grouped together and the prices will be in column D
• Multiply the prices by the percentage you want
• Reorder the data by column A (the numbered index)
• Delete column A

This will update the component prices and therefore the product prices if they are set to Sum of Components.

Ben

[avanta]

Hi Ben - thanks for you reply.

I've tried to export my site but I can only find options to export
it as a snapshot file and nothing about hierarchical exports.

Although, there is an option for hierarchical imports which allows
.csv files - strange.

Any reason why I can't export?

I have patched this version of Actinic with the most up to date
patch for v4 - but would that affect my ability to export?

Any comments appreciated.

Alex

[cdicken]

Hmmm

The reason you cannot export is that this feature was introduced in v5. I'm afraid there's few of us left now who remember v4

Do you have Microsoft Access on your PC? You can open the 'Product' table in ActinicCatalog.mdb (in your 'Site1' folder) and copy and paste the contents of that into Excel. Then change the prices (remembering to keep the prices in pence).

You can then paste the price column back into Access.

Make sure you take a backup of your database first (copy it somewhere safe) in case it doesn't work.

[avanta]

Chris, thanks a lot for your feedback it is proving useful.

A couple of things though:

The Product table doesn't actually contain information about
individual component prices. I found this info in the table
ProductProperties.

The pricing information is indeed stored here but there is also
a lot of other related stuff. At a glance I can see a query that
may pull back the rows which contain only prices for components
but I'm not confident that it'll not pull anything else back.

Any ideas??

Alex

[cdicken]

In the nType column, in the 'Product Properties' table, the values are as follows...

1 - Searchable item
3 - Custom property
4 - Price schedule
5 - Component
6 - Attribute
7 - Choice
8 - Permutation

[avanta]

Chris,

thaks a lot for your posts I've managed to perform an automatic increase of all prices - thats great.

Regards,

Alex Hill