Global Attribute Price Change

[nicksab]

Hello,

Is it possible to change the price of an attribute globally?

I want to change it from 9.99 to 12.99 but i am trying to do it globally as opposed to do each product one by one.

This attribute is the same on all products and has the same value.

Option Name is "Please choose a special gift"
Option Value is "Full size greeting card"

Current price is set to 9.99 and need to be raise to 12.99

I tried the solution on this thread: https://www.zen-cart.com/showthread....ts-at-one-time

It didn't work for me as it seems to raise it by a certain percentage instead of a fixed price.

Anyone knows how i can achieve this?

Thank you in advance for your help.

[simon1066]

I have used this in the past, on older versions of ZC - obviously test it yourself.

In phpmyadmin, or similar, run this SQL command for your options_value_id:

UPDATE products_attributes SET options_values_price='12.99' WHERE options_values_id='???';

You could use the Install SQL Patches in Admin but with recent versions of phpmyadmin you get to preview the results before committing.

[nicksab]

I have used this in the past, on older versions of ZC - obviously test it yourself.

In phpmyadmin, or similar, run this SQL command for your options_value_id:

UPDATE products_attributes SET options_values_price='12.99' WHERE options_values_id='???';

You could use the Install SQL Patches in Admin but with recent versions of phpmyadmin you get to preview the results before committing.

It did the trick without any issue and definitely saving this for future use. Thankyou simon.

[dbltoe]

Just a reminder that, IF you have used a prefix for your tables, you will need to add them to the UPDATE syntax in phpMYAdmin.

If you made a DB prefix of ZEN_ when you created your site, then;

UPDATE products_attributes SET options_values_price='12.99' WHERE options_values_id='???';

would need to be the following for phpMyAdmin.

UPDATE ZEN_products_attributes SET options_values_price='12.99' WHERE options_values_id='???';

Using the Install SQL Patches in your ADMIN will automatically take care of the prefix and simon1066's code will work fine as the system already knows what you selected for the prefix when you installed the site.

[nicksab]

Thanks dbltoe.

I personally do not use prefix but that s something to keep in mind if you use the cpanel / phpmyadmin for SQL patches like me. The ADMIN works great too but i like the "simulation" option as pointed out by Simon1066

[simon1066]

Just a reminder that, IF you have used a prefix for your tables, you will need to add them to the UPDATE syntax in phpMYAdmin.

If you made a DB prefix of ZEN_ when you created your site, then;

UPDATE products_attributes SET options_values_price='12.99' WHERE options_values_id='???';

would need to be the following for phpMyAdmin.

UPDATE ZEN_products_attributes SET options_values_price='12.99' WHERE options_values_id='???';

Using the Install SQL Patches in your ADMIN will automatically take care of the prefix and simon1066's code will work fine as the system already knows what you selected for the prefix when you installed the site.

Yes, thanks for that. I should have added the prefix option for completeness.

[mc12345678]

Thanks dbltoe.

I personally do not use prefix but that s something to keep in mind if you use the cpanel / phpmyadmin for SQL patches like me. The ADMIN works great too but i like the "simulation" option as pointed out by Simon1066

Note that the admin doesn't offer the "simulation" option to prevent ready discovery of database information associated with the data returned when doing so. Put another way, that simulation response data is omitted on purpose and by design.