Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: AlexeyWinesmoke on November 11, 2013, 00:40:47 AM

Title: how to delete related products from mysql
Post by: AlexeyWinesmoke on November 11, 2013, 00:40:47 AM
how to delete related products from mysql. more 5000. Как удалить похожие (сопутствующие) товары при помощи sql запроса. Товаров более 5000 тысяч.
Title: Re: how to delete related products from mysql
Post by: PRO on November 11, 2013, 02:57:42 AM


backup first


My related products

#_virtuemart_product_customfields
virtuemart_custom_id=1

so if you are wanting the delete all the related proucts, you need to delete those rows that have a virtuemart_custom_id=1





Title: Re: how to delete related products from mysql
Post by: Milbo on November 11, 2013, 11:47:46 AM
better is to search for the type R
Title: Re: how to delete related products from mysql
Post by: Maxim Pishnyak on November 11, 2013, 21:39:29 PM
CSVI.
Title: Re: how to delete related products from mysql
Post by: AlexeyWinesmoke on November 11, 2013, 23:50:01 PM
Quote from: Maxim Pishnyak on November 11, 2013, 21:39:29 PM
CSVI.
Что в поле related_products  в csvi написать чтобы они удалились
Title: Re: how to delete related products from mysql
Post by: Maxim Pishnyak on November 11, 2013, 23:55:05 PM
Nothing.
Title: Re: how to delete related products from mysql
Post by: AlexeyWinesmoke on November 12, 2013, 00:07:23 AM
Quote from: Maxim Pishnyak on November 11, 2013, 23:55:05 PM
Nothing.
Так и написать Nothing или поля пустыми оставить?
Title: Re: how to delete related products from mysql
Post by: Maxim Pishnyak on November 12, 2013, 18:09:08 PM
Yes, empty.
Text only | Text with Images