Jump to content

【已解决】首页推荐太多了,想针对推荐,要批量取消全部推荐,是改哪个字段?


Recommended Posts

首页推荐我想批量取消,也就是后台产品点进去Catalog 那边Home打钩要取消掉,但不知道是哪个字段,所以SQL就不能写了。那位大侠知道的请帮我一下,先谢过

41444_1DVrXl9BMtWL1FAS0GCm_t

Share this post


Link to post
Share on other sites

备份好DB后,登入你的phpmyadmin,执行下面的SQL语句:

DELETE FROM `ps_category_product`
WHERE `id_category` = 1
AND `id_product` IN (这里面,需要填的是产品ID,用英文逗号隔开就可以了。譬如:1,2,3,4)



Good luck!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More