Attributes Price Markup

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.

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

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.

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 ...

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 ...


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

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 ...

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 ...

Ok thanks Linda will give this a go.

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?

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

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

If the goal is for Attribute Price to change:

10.00 to 13.20
100.00 to 121.20
5.00 to 7.20
99.00 to 120.00

then use the SQL of:

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.00) * 1.20)
WHERE p.master_categories_id = 67;

NOTE: Be sure to backup your database before trying this ...

Ajeh:

If the goal is for Attribute Price to change:

then use the SQL of:

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.00) * 1.20)
WHERE p.master_categories_id = 67;

> 
> NOTE: Be sure to backup your database before trying this ...

Ok thanks again Linda, thats exactly what I need.

Nick1973:

Ok thanks again Linda, thats exactly what I need.

Actually Linda while I need that solution I also need it globally so would I do something like

UPDATE products_attributes SET options_values_price = options_values_price +1.00 * 1.20;

if I wanted to update every products attributes by £1.00 and then add 20% globally?

I would use:

UPDATE products_attributes SET options_values_price = ((options_values_price +1.00) * 1.20);

NOTE: Again, be sure to backup and test this to ensure that all is right in the world when done ...

Thanks again Linda, I think thats everything I need now on this part.

Happy New Year by the way :smile:

You are most welcome ... glad that you have this all sorted out ... :cool:

Have a great New Year!