Setting Default Prices for Attributes

[Ajeh]

Backups can be done with phpMyAdmin which is available through your Control Panel for your domain ...

Or, you can get the add-on for Backup MySQL and install that ...

Or, you can wait for your friend to help you learn this trick ...

You really want to do regular backups in case you have a bad hair day ... and totally moof up your site ...

[juliartz]

Backups can be done with phpMyAdmin which is available through your Control Panel for your domain ...

Or, you can get the add-on for Backup MySQL and install that ...

Or, you can wait for your friend to help you learn this trick ...

You really want to do regular backups in case you have a bad hair day ... and totally moof up your site ...

Hmmmm, and since I am the "Queen" of "Moofs", you are most certainly correct. I will have her talk me thru a back up lesson. Bad hair days? Don't think I've any "good" hair days lately... kinda getting used to the mop!

[heavenlynights]

Hi Ajeh

Is there a simple command like this for attribute pricing. What I am wanting to do is change the attribute price for specific sizes of a product. Mind you garments are NOT priced by attributes. Instead they are priced as follows

Currently Sizes

Small, Medium, Large, X Large, one size, 32, 34, 36, 38 are all set as a base price

sizes 1x, 2x, 3x, 4x, 1x/2x, 2x/3x, Plus Size, 40, 42, 44 are all priced with a fixed increase.

eg below:

11106 Size Small + 0.0000 + 0 1
AUD$0.00 AUD$0.00
11107 Size Medium + 0.0000 + 0 2
AUD$0.00 AUD$0.00
11108 Size Large + 0.0000 + 0 3
AUD$0.00 AUD$0.00
11109 Size 1X/2X + 9.9500 + 0 51
AUD$9.95 AUD$0.00
11110 Size 3X/4X + 9.9500 + 0 52
AUD$9.95 AUD$0.00

What I want to do is decrease or completely get rid of the larger size prices. I want to do this on a global scale and would rather not do this individually as I have hundreds of products, which this will effect. Would you be able to help us out there.

TIA

[Ajeh]

If you know the options_id and options_values_id in the products_attributes table you could do global replacements on the options_values_price ...

Then, when all is done, you can run the Tools ... Store Manager ... and the:

Update ALL Products Price Sorter
to be able to sort by displayed prices:

NOTE: this is providing ALL Attributes defined as a given pair of options_id and options_values_id are to be the same price ...

[heavenlynights]

Thanks Ajeh

I do realise that I would have to run a command for each product value id #.

For instance if I was to change the price from say 9.95 to say 4.95 for the specific size 1x using the below bolded info, what would then be the command code I would run in the install sql patches from the admin?

product option name = size with an id of 1
product option value = 1x with an id of 66

I hope that this hasn't confused you.

TIA

[heavenlynights]

sorry for bumping but need some help with this!

Thanks

[Ajeh]

WARNING: Backup your database first!

Then ... Backup your database ...

Did I mention Backup your database?

UPDATE products_attributes SET options_values_price = 4.95 WHERE options_id = 1 and options_values_id = 66 and options_values_price = 9.95; 

[heavenlynights]

WARNING: Backup your database first!

Then ... Backup your database ...

Did I mention Backup your database?

UPDATE products_attributes SET options_values_price = 4.95 WHERE options_id = 1 and options_values_id = 66 and options_values_price = 9.95; 

Your so funny but I love it. Thanks ajeh.

PS I always back-up before a possible major screw up

[heavenlynights]

Hi Ajeh back again. Just a quick question!

I realised that I have quite a few diferent option_values_price's so is there a way of changing them all using something like a wildcard command in the line of code you mentioned?

eg: where it says options_values_price = 9.95

can we put something else (generic) in there where it says 9.95 so that it changes whatever the figure might be rather than just that particular one.

I want to change them all to the same value.

UPDATE products_attributes SET options_values_price = 4.95 WHERE options_id = 1 and options_values_id = 66 and options_values_price = 9.95;

TIA