i want to remove all products

[Guest]

Hi

I need your help, i uploaded 14000 products and i have found a big mistake :'( , is there any "automatic" :D chance to clean all products, all categories and all customers?

 

Thanks for your help

Saso

 

www.kozmetikax.com

[Daemonj]

Copy and paste the following into an SQL window in PHPMyAdmin.

 

truncate address_book;

truncate categories;

truncate categories_description;

truncate customers;

truncate customers_basket;

truncate customers_basket_attributes;

truncate customers_info;

truncate manufacturers;

truncate manufacturers_info;

truncate newsletters;

truncate orders;

truncate orders_products;

truncate orders_products_attributes;

truncate orders_products_download;

truncate orders_status_history;

truncate orders_total;

truncate products;

truncate products_attributes;

truncate products_attributes_download;

truncate products_description;

truncate products_notifications;

truncate products_options;

truncate products_options_values;

truncate products_options_values_to_products_options;

truncate products_to_categories;

truncate reviews;

truncate reviews_description;

truncate sessions;

truncate specials;

truncate whos_online;

 

 

alter table address_book auto_increment = 1;

alter table banners auto_increment = 1;

alter table banners_history auto_increment = 1;

alter table categories auto_increment = 1;

alter table categories_description auto_increment = 1;

alter table customers auto_increment = 1;

alter table customers_basket auto_increment = 1;

alter table customers_basket_attributes auto_increment = 1;

alter table customers_info auto_increment = 1;

alter table manufacturers auto_increment = 1;

alter table manufacturers_info auto_increment = 1;

alter table newsletters auto_increment = 1;

alter table orders auto_increment = 1;

alter table orders_products auto_increment = 1;

alter table orders_products_attributes auto_increment = 1;

alter table orders_products_download auto_increment = 1;

alter table orders_status_history auto_increment = 1;

alter table orders_total auto_increment = 1;

alter table products auto_increment = 1;

alter table products_attributes auto_increment = 1;

alter table products_attributes_download auto_increment = 1;

alter table products_description auto_increment = 1;

alter table products_notifications auto_increment = 1;

alter table products_options auto_increment = 1;

alter table products_options_values auto_increment = 1;

alter table products_options_values_to_products_options auto_increment = 1;

alter table products_to_categories auto_increment = 1;

alter table reviews auto_increment = 1;

alter table reviews_description auto_increment = 1;

alter table sessions auto_increment = 1;

alter table specials auto_increment = 1;

alter table whos_online auto_increment = 1;

[MSP]

um you made a backup of your database before you uploaded 14,000 products correct?

[Guest]

um you made a backup of your database before you uploaded 14,000 products correct?

 

 

 

Ups, no , I didn't :o

[Guest]

Copy and paste the following into an SQL window in PHPMyAdmin.

 

Hi,

 

Can you tell me where is SQL window - PHPMyAdmin located?? How I can find it, where? :blush: I don't have any experiences with this. If I want to keep my costumers I just don't add the line for costumers? I also want to keep 12.000 images, I added.

 

Sorry I'm bothering you with ;) stupid questions

Thanks you helping me

Saso

 

 

Kozmetikax web page -cosmetic

[MSP]

do you have cpanel as provided by your host?

 

If so, MYSQL databases > phpMyAdmin :)