Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 02-10-2017 04:41:26

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 834

How to Remove Not For Sale Items from Category Displays

How can we automatically remove products with offertype set to NOTFORSALE from category displays as there is no point having them there if they cannot buy them?

We can still keep the product pages live and have the breadcrumbs (which are great btw) driving people to alternative products.

Last edited by sdn (02-10-2017 04:43:14)


Simon

Offline

 

#2 02-10-2017 09:21:41

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19546
Website

Re: How to Remove Not For Sale Items from Category Displays

Execute this SQL in System / Database / Raw DB Admin:

Code:

UPDATE ecom_prod SET xcat='' WHERE offertype='NOTFORSALE'

That removes it from all category displays by removing the related categories from those offers.  The key is to keep a good category designation in there for the 'catparent' column so that you still get the breadcrumbs you desire.


Nick Hendler

Offline

 

Board footer