Increase price on all products universally?

There isn't an easy way to do that on subcategories with a select statement ...

There are some add-ons that might help you ...

Ajeh:

There isn't an easy way to do that on subcategories with a select statement ...

There are some add-ons that might help you ...

Ok I just got confused, what is Master Category and Subcategory.

~ Time

master_categories_id is a field in the products table ...

A subcategory is a category that the product is in, but there is no reference to it in the products table ...

You could probably work out a SELECT statement with JOINS to figure out what products are in a given subdirectory based on the products_to_categories table ... but for a single SELECT to update all products in a category and its subcategories would take some coding ...

HEy this did not seem to work for me..

UPDATE products SET products_price = products_price * 1.15;

to increase by 15% infact it did not increase prices at all...

any ideas?

thanks for you help

Scotty

Make sure that both your files:
/includes/configure.php
/admin/includes/configure.php

are using the same database ...

Check if you use prefixes on the database table names ...

I tried that same thing and all my prices changed ... :unsure:

Does anyone have any idea how to get this working for products priced by attribute please?

EDIT: Just had a look at the DB - does anyone think that the following statement would work the same for attribute prices (to increase by 35%) :

UPDATE products_attributes SET options_values_price = options_values_price * 1.35;

Oh.... and if I were to create a new field in products_attributes called, say, OLD_options_values_price, what would the SQL statement be to copy the existing options_values_price values into the new field (before I run the price increase) ?

Re second part of my previous post regarding copying all fields values into another - would this be the correct statement :

UPDATE products_attributes SET OLD_options_values_price = options_values_price;

Backup your database first ...

Add the new field but use lowercase on the field name ...

Then you update the new field as you stated:

UPDATE products_attributes SET old_options_values_price = options_values_price;

Then, update the current options_values_price:

UPDATE products_attributes SET options_values_price = options_values_price * 1.35;

Ajeh:

Backup your database first ...

Add the new field but use lowercase on the field name ...

Then you update the new field as you stated:

Then, update the current options_values_price:

Thanks for the confirmation Ajeh - Added the new fields to both tables. Copied over the current prices in both just in case. Updated the prices and it works a treat for both normal products and products priced by attribute.

Just gonna convert the SQL statements to a php script now so I can do it as and when without using phpMyAdmin.

Thanks for the update that this worked for you ... :smile:

Ajeh, Thanks for teaching this simple price-change strings! Very helpful! :smile:

I have now learned how to make an all over price change:

UPDATE products SET products_price = products_price * 1.35; 

How to make changes by master category id:

UPDATE products SET products_price = products_price * 1.35 WHERE master_categories_id = XX;

And how to change the price of attribute priced items:

UPDATE products_attributes SET options_values_price = options_values_price * 1.35; 

The last one affect all attribute priced items.
Is there a nice way to make this happen to only a attribute group?
Say by group name?

Thanks for all your nice and patient answers in this community! :yes:
/Jan

Can you define what you mean by an attribute group? :unsure:

Sorry.
I think the term is "option group" in the English admin.
I give all attributes a name, and that name is then sorted into "option groups".
(Overview found under the fourth button in admin-products-dropdown.)

I'm thinking, if I an attribute name is specific to what item they lay under. Then It would be possible to update the price for only that "attribute group"?...

Looks like the ID nr. they are given in "option group" sorting is NOT unique, but their name is!..

Or said in another way.
How do I change a single item price, when that is a bunch of attribute priced items without doing this one by one?

I have read something about copying, but I don't understand that one...

Hope this make any sense... :blink:

As a more real life example ...

Are you trying to change the Price on all
Option Name: Color

Or, Are you trying to change the Price on all
Option Name: Color
Option Value Red

In your example that would be
Option Name: Color

That is in my admin-translation called "Variantgroup"... :unsure:

Actually, what I am aiming at, is to change all variables for a single products ID.

Here is the actual example in my shop.

So what you really want to do is change all the Attribute Prices for:
products_id 186
options_id 22

and you want to increase all of the:
options_values_price

by an amount or a percentage?

Correct!

I guess the only option would be percentage, as the price is different for different attributes!?

Or am I wrong here?
Thinking of it, I might have read somewhere of an addon?...
-To be able to correct price to amounts without decimals, and even to an amount of ex. 199 instead of 200 would be awesome!

Change all options_id 22 Option Values to $3.50 for products_id 186 ...

UPDATE products_attributes SET options_values_price = 3.50 WHERE products_id = 186 and options_id = 22;

Change all options_id 22 Option Values to current price plus $1.00 for products_id 186 ...

UPDATE products_attributes SET options_values_price = options_values_price + 1.00 WHERE products_id = 186 and options_id = 22;

Change all options_id 22 Options Values to current price plus 10% for products_id 186 ...

UPDATE products_attributes SET options_values_price = options_values_price * 1.10 WHERE products_id = 186 and options_id = 22;

NOTE: be sure to backup your database before attempting any of these ...

Fantastic Ajeh - Oba-San :hug:

I'll try this out!
Sorry you had to drag it out of me... :P

Not a problem ... let us know how this ends up working for you ... :smile: