Global price change?

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

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

why dosn't work?

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

or this?

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

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

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

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

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

I use admin tools install SQL patches

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.

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

Succefull!

I use wrong id.

Thanks for all help.

Thanks for the update that you have this working now and that the problem was related to using the incorrect id ... :smile:

What about just change price for certain category?
All my waterslide sub-categories decals are same price under Main Category "Waterslide Decals"

is there a simple way to change the price without change one product at time?

Thank you for your time.

Do you use Linked Products?

No, I did not.

there are many sub decal categories under Main "Water slide decals" categories, but I did not link them because they are different designs, but they are all same price.

A global price change using a SELECT statement needs to be able to use something common about the Products ...

Usually, this is easily done with the manufactuers_id or the master_categories_id ...

Products that are in the same Top Level Category have different master_categories_id as the master_categories_id is the immediate categories_id that the Product belongs to ...

So if you have a Top Level or Main Category called Water Decals with categories_id 27 ... then sub-categories below that that hold Products, you need to know those sub-categories categories_id that are the master_categories_id of the Product ...

If you have 7 sub-categories, there will be 7 master_categories_id for these products ...

If you are still unsure about the master_categories_id then you can edit a Product to see what it is ...

Does that make sense to you on what categories_id you need to find for these Products in order to run a SELECT statement to update the prices?

I think so,
My Main (top) Waterslide decal id is 1, and sub-categories (master) id are 33, 47, 3, 4, 5, 34, 6, 37, 39, 40 41, and 38 (I found these ID by go to Admin > catalog > categories/products, and they are on left side with subcategory name)

So I would need to Run SELECT statement to globally change my prices by go to "Install MySQL patches"?

could you show me the SELECT statement that I do to run...
Thank you so much for your time!

That is correct, each categories_id that you see in the master_categories_id would need to have this statement run:

UPDATE products SET products_price = XX.XX WHERE master_categories_id = YY;

NOTE: Backup your database before using this and replace the XX.XX with the Product Price for all Products that are in the master_categories_id where YY is the master_categories_id such as 33, 47, 3, 4, 5, 34, 6, 37, 39, 40, 41, and 38 ...

Thank you so much,

I am going to back up my database first before I run this statement. will let you know how it turn out.

once again Thanks!!!

mprough:

I use quick updates (http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=101) to accomplish this... Nice thing for you is the added ability to change by percentage (like to cover currency fluctuations) for all products or just selected products.

~Melanie

Hi Melanie,
I have just installed this, but nothing seems to have changed. How do you use it?:unsure:

I've had a look around but had no luck with anything I've found so far.

What I'm looking for is to change all products of a set price. Eg. All items worth 45 to change to 46 .

I've tried editing the SQL code but with no luck due to my relatively poor coding knowledge