Batch change zen cart url digital ID and batch product add money

 

For example, zen cart a product page ID is www.2cto.com/xxxx-p-20.html

Run the following command to add the following number plus 1000.

Xxxx-p-1020.html/www.2cto.com

In this way, we can solve one of the website similarity. The comparison of the same set of data is required.

Execute commands in the background

UPDATE 'products' SET 'products _ id' = 'products _ id' + 1000;

UPDATE 'products _ description' SET 'products _ id' = 'products _ id' + 1000;

 

UPDATE 'products _ to_categories 'set 'products _ id' = 'products _ id' + 1000;

 

UPDATE 'products _ attributes 'set 'products _ id' = 'products _ id' + 1000;

 

UPDATE 'featured' SET 'products _ id' = 'products _ id' + 1000;

Execute them one by one

If the preceding command fails, change the command.

UPDATE 'products' SET 'products _ id' = 'products _ id' + 1000;

UPDATE 'optional any003 '. 'products _ description' SET 'products _ id' = 'products _ id' + 1000;

UPDATE 'optional any003 '. 'products _ to_categories 'set 'products _ id' = 'products _ id' + 1000;

UPDATE 'optional any003 '. 'products _ attributes' SET 'products _ id' = 'products _ id' + 1000;

UPDATE 'featured' SET 'products _ id' = 'products _ id' + 1000;

Tiffany003 is the database name, corresponding to your own Database Change

Add money to the product

UPDATE 'newall'. 'products' SET 'products _ price' = 'products _ price' + 125;

The following figure shows how much money is added.

Or deduct money

UPDATE 'newall'. 'products' SET 'products _ price' = 'products _ price'-125;

 

Author: Shine's holy heaven-Min Chen 〃