Attributes Price Markup

[Nick1973]

Is there a way to add markup to product prices including product attribute prices for v1.5?

I am aware of the Global Price Markup Mod but it doesn't work with v1.5, or at least I couldn't get it to install correctly as it appears that the DB script has a fault during installation.

I need to add 20% markup to all product attribute prices and if it has to be done in the Database that is fine.

[dbltoe]

Don't find Global Price Markup but, have you tried taking a look at Quick Updates?

[Nick1973]

I had a look at that and have installed it but it doesn't appear to put a percentage on attributes prices, only the product prices.##All my products show zero values in quick updates due to them being priced by attributes. So I need another way.

[Ajeh]

To raise the Attribute Price of ALL Attributes you could use:

UPDATE products_attributes SET options_values_price = options_values_price * 1.20;

This will raise all Attribute Prices by 20% ...

NOTE: Backup your database before running this ...

NOTE: You can run this in your Zen Cart Admin in the Tools ... Install SQL Patches ...

[Nick1973]

To raise the Attribute Price of ALL Attributes you could use:

UPDATE products_attributes SET options_values_price = options_values_price * 1.20;

This will raise all Attribute Prices by 20% ...

NOTE: Backup your database before running this ...

NOTE: You can run this in your Zen Cart Admin in the Tools ... Install SQL Patches ...

Perfect, thats exactly what I'm looking for. Out of interest how would I do this per category?

[Ajeh]

That gets a bit more complicate ...

But you could try, to update the Attribute Prices ONLY in master_categories_id 67 to use:

UPDATE products_attributes as pa 
LEFT JOIN products as p ON  pa.products_id = p.products_id
LEFT JOIN products_options_values as pov ON pov.products_options_values_id = pa.options_values_id
SET pa.options_values_price = pa.options_values_price * 1.20
WHERE p.master_categories_id = 67;

NOTE: Backup your database before trying this ...

[Nick1973]

That gets a bit more complicate ...

But you could try, to update the Attribute Prices ONLY in master_categories_id 67 to use:

UPDATE products_attributes as pa 
LEFT JOIN products as p ON  pa.products_id = p.products_id
LEFT JOIN products_options_values as pov ON pov.products_options_values_id = pa.options_values_id
SET pa.options_values_price = pa.options_values_price * 1.20
WHERE p.master_categories_id = 67;

NOTE: Backup your database before trying this ...

Ok thanks Linda will give this a go.

[Nick1973]

Linda what would I do if I wanted to add £1.00 to all attributes and then markup by 20%? or the other way around?

[Ajeh]

Think that through for a minute ...

Do you want to:
1 add $1.00 then raise by 20%

Or ...

Do you want to:
raise by 20% then add a $1.00

[Nick1973]

sorry it would be raise by £1.00 then markup by 20%