Global price change?

[Ajeh]

I would have to sit down and write all of the code to manage a Category update of all Products to update the Attribute Price for just the one Category ...

This is not just something that can be thrown together in a minute or two ...

[nyunyi]

UPDATE products SET products_price= products_price -5.00 where manufacturers_id = "50";

why dosn't work?

[nyunyi]

UPDATE products SET products_price= products_price +5.00 WHERE (manufacturers_id LIKE "27");

or this?

[Ajeh]

Are you getting any error messages?

If I use:

UPDATE products SET products_price= products_price -5.00 where manufacturers_id = "50";

all of my Prices in the products table in the field products_price will be reduced by 5.00 for manufacturers_id 50 ...

NOTE: after running a change like this you should go to the Tools ... Store Manager ... and run an Update on the Products Price Sorter ...

The only reasons this would not change your the Price of your Products would be:

1 You are lowering the products_price in the products table but in the wrong database

2 Your Products are all Priced by Attribute and this means the prices are not in the products table

[nyunyi]

I didn't get any error message, but didn't changed the price

[Ajeh]

Look at the two files, on the server for:
/includes/configure.php
/admin/includes/configure.php

Are they both using the same database?

Does your database use a prefix on the tables?

Are you apply this change in the Tools ... Install SQL Patches ... or via phpMyAdmin ...

Are you sure that your manufacturers_id is 50 ...

[nyunyi]

Look at the two files, on the server for:
/includes/configure.php
/admin/includes/configure.php

Are they both using the same database?

Does your database use a prefix on the tables?

Are you apply this change in the Tools ... Install SQL Patches ... or via phpMyAdmin ...

Are you sure that your manufacturers_id is 50 ...

sorry I don't know how can I check the two configure use same database.

I use admin tools install SQL patches

[Ajeh]

Using your FTP program, you should be able to download, from the server, the current configuration files from:
/includes/configure.php
/admin/includes/configure.php

and compare them to see that both are configured to use the same database etc.

[nyunyi]

my database included a manufacturers/manufacturers_name/ table
and the brand names here are.

[nyunyi]

Succefull!

I use wrong id.

Thanks for all help.