Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do you delete ALL product info & start fresh?


jsun

Recommended Posts

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 ;

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...