Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

How do you delete ALL product info & start fresh?

jsun

By jsun
in General Support

Recommended Posts

jsun

jsun

Posted
Posted

Please tell me how to get rid of all the old product info from my website. java script:emoticon(':huh:', 'smid_12')

smilie

Vger

♥Vger

Posted
Posted

Please don't double post. It's against forum rules and wastes people's time.

 

Vger

knoxweb

knoxweb

Posted
Posted
Please tell me how to get rid of all the old product info from my website. java script:emoticon(':huh:', 'smid_12')

smilie

Here is a code that will clear all your products, categories and manufacturers:

 

Run this sgl code:

 

DELETE FROM `manufacturers` WHERE `manufacturers_id` = 1 LIMIT 1;

DELETE FROM `manufacturers` WHERE `manufacturers_id` = 2 LIMIT 1;

DELETE FROM `manufacturers` WHERE `manufacturers_id` = 3 LIMIT 1;

DELETE FROM `manufacturers` WHERE `manufacturers_id` = 4 LIMIT 1;

DELETE FROM `manufacturers` WHERE `manufacturers_id` = 5 LIMIT 1;

DELETE FROM `manufacturers` WHERE `manufacturers_id` = 6 LIMIT 1;

DELETE FROM `manufacturers` WHERE `manufacturers_id` = 7 LIMIT 1;

DELETE FROM `manufacturers` WHERE `manufacturers_id` = 8 LIMIT 1;

DELETE FROM `manufacturers` WHERE `manufacturers_id` = 9 LIMIT 1;

 

DELETE FROM `products` WHERE `products_id` = 1 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 2 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 3 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 4 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 5 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 6 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 7 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 8 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 9 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 10 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 11 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 12 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 13 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 14 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 15 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 16 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 17 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 18 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 19 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 20 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 21 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 22 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 23 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 24 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 25 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 26 LIMIT 1;

DELETE FROM `products` WHERE `products_id` = 27 LIMIT 1;

 

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 1 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 2 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 3 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 4 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 5 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 6 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 7 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 8 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 9 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 10 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 11 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 26 LIMIT 1;

DELETE FROM `products_attributes` WHERE `products_attributes_id` = 27 LIMIT 1;

 

DELETE FROM `products_options` WHERE `products_options_id` = 1 AND `language_id` = 1 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 2 AND `language_id` = 1 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 3 AND `language_id` = 1 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 4 AND `language_id` = 1 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 1 AND `language_id` = 2 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 2 AND `language_id` = 2 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 3 AND `language_id` = 2 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 4 AND `language_id` = 2 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 1 AND `language_id` = 3 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 2 AND `language_id` = 3 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 3 AND `language_id` = 3 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 4 AND `language_id` = 3 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 5 AND `language_id` = 3 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 5 AND `language_id` = 2 LIMIT 1;

DELETE FROM `products_options` WHERE `products_options_id` = 5 AND `language_id` = 1 LIMIT 1;

 

DELETE FROM `banners` WHERE `banners_id` = 1 LIMIT 1;

 

DELETE FROM `languages` WHERE `languages_id` = 2 LIMIT 1;

DELETE FROM `languages` WHERE `languages_id` = 3 LIMIT 1;

 

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 1 AND `languages_id` = 1 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 1 AND `languages_id` = 2 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 1 AND `languages_id` = 3 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 2 AND `languages_id` = 1 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 2 AND `languages_id` = 2 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 2 AND `languages_id` = 3 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 3 AND `languages_id` = 1 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 3 AND `languages_id` = 2 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 3 AND `languages_id` = 3 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 4 AND `languages_id` = 1 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 4 AND `languages_id` = 2 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 4 AND `languages_id` = 3 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 5 AND `languages_id` = 1 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 5 AND `languages_id` = 2 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 5 AND `languages_id` = 3 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 6 AND `languages_id` = 1 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 6 AND `languages_id` = 2 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 6 AND `languages_id` = 3 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 7 AND `languages_id` = 1 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 7 AND `languages_id` = 2 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 7 AND `languages_id` = 3 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 8 AND `languages_id` = 1 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 8 AND `languages_id` = 2 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 8 AND `languages_id` = 3 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 9 AND `languages_id` = 1 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 9 AND `languages_id` = 2 LIMIT 1;

DELETE FROM `manufacturers_info` WHERE `manufacturers_id` = 9 AND `languages_id` = 3 LIMIT 1;

 

DELETE FROM `currencies` WHERE `currencies_id` = 2 LIMIT 1;

 

DELETE FROM `categories` WHERE `categories_id` = 1 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 2 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 3 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 4 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 5 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 6 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 7 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 8 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 9 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 10 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 11 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 12 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 13 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 14 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 15 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 16 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 17 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 18 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 19 LIMIT 1;

DELETE FROM `categories` WHERE `categories_id` = 20 LIMIT 1;

 

UPDATE `geo_zones` SET `geo_zone_name` = 'Tennessee',

`geo_zone_description` = 'Tennessee tax zone',

`last_modified` = NULL WHERE `geo_zone_id` =1 LIMIT 1 ;

 

UPDATE `tax_rates` SET `tax_rate` = '9.25',

`tax_description` = 'TN Tax 9.25%' WHERE `tax_rates_id` =1 LIMIT 1 ;

 

UPDATE `configuration` SET `configuration_value` = 'true',

`last_modified` = NULL ,

`use_function` = NULL WHERE `configuration_id` =13 LIMIT 1 ;

 

UPDATE `configuration` SET `configuration_value` = '',

`last_modified` = NULL ,

`use_function` = NULL ,

`set_function` = NULL WHERE `configuration_id` =55 LIMIT 1 ;

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...