Jump to content
Sign in to follow this  
vasyakrn

[Решено] Как удалить все товари в магазине? [15x-1531]

Recommended Posts

Как удалить все товари в магазине? Дайте модуль, хак хоть SQL код

 

Share this post


Link to post
Share on other sites

а че через админку никак?

  • +1 1

Share this post


Link to post
Share on other sites

в phpmyadmin

		TRUNCATE TABLE {DB_PREFIX}product;
		TRUNCATE TABLE {DB_PREFIX}product_attribute;
		TRUNCATE TABLE {DB_PREFIX}product_description;
		TRUNCATE TABLE {DB_PREFIX}product_discount;
		TRUNCATE TABLE {DB_PREFIX}product_image;
		TRUNCATE TABLE {DB_PREFIX}product_option;
		TRUNCATE TABLE {DB_PREFIX}product_option_value;
		TRUNCATE TABLE {DB_PREFIX}product_related;
		TRUNCATE TABLE {DB_PREFIX}product_related;
		TRUNCATE TABLE {DB_PREFIX}product_reward;
		TRUNCATE TABLE {DB_PREFIX}product_special;
		TRUNCATE TABLE {DB_PREFIX}product_tag;
		TRUNCATE TABLE {DB_PREFIX}product_to_category;
		TRUNCATE TABLE {DB_PREFIX}product_to_download;
		TRUNCATE TABLE {DB_PREFIX}product_to_layout;
		TRUNCATE TABLE {DB_PREFIX}product_to_store;
		TRUNCATE TABLE {DB_PREFIX}review;
		
		DELETE FROM {DB_PREFIX}url_alias WHERE query LIKE 'product_id=%';
вместо {DB_PREFIX} ваш префикс таблиц в БД. Edited by afwollis
  • +1 1

Share this post


Link to post
Share on other sites

Спасибо. Тему можно закривать.

 

Для тех у кого как и у меня нет префиксов

		TRUNCATE TABLE product;
		TRUNCATE TABLE product_attribute;
		TRUNCATE TABLE product_description;
		TRUNCATE TABLE product_discount;
		TRUNCATE TABLE product_image;
		TRUNCATE TABLE product_option;
		TRUNCATE TABLE product_option_value;
		TRUNCATE TABLE product_related;
		TRUNCATE TABLE product_related;
		TRUNCATE TABLE product_reward;
		TRUNCATE TABLE product_special;
	
		TRUNCATE TABLE product_to_category;
		TRUNCATE TABLE product_to_download;
		TRUNCATE TABLE product_to_layout;
		TRUNCATE TABLE product_to_store;
		TRUNCATE TABLE review;
		
		DELETE FROM url_alias WHERE query LIKE 'product_id=%';

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.