xearoth Posted December 2, 2006 Posted December 2, 2006 Any help is appreciate ahead of time. I have a oscommerce shop with products in "Archive" that I keep there in case in teh future i can easily take the description or product and use it elsewhere. Now my other thing is I run a inventory checker every hour to see any products that are <5 to go unavailable from the website as we have inventory fluctuation all the time. So products i have in archive for instance come back instock but I do NOT want to show on the website. They do not show in any of my categories but if you were to use the site search for that product or model they would show up. So my question is without deleting the product, is there anyway to exclude products that are essentially 'good' products from the search as i do not want to them to show up? Thanks!
boxtel Posted December 2, 2006 Posted December 2, 2006 Any help is appreciate ahead of time. I have a oscommerce shop with products in "Archive" that I keep there in case in teh future i can easily take the description or product and use it elsewhere. Now my other thing is I run a inventory checker every hour to see any products that are <5 to go unavailable from the website as we have inventory fluctuation all the time. So products i have in archive for instance come back instock but I do NOT want to show on the website. They do not show in any of my categories but if you were to use the site search for that product or model they would show up. So my question is without deleting the product, is there anyway to exclude products that are essentially 'good' products from the search as i do not want to them to show up? Thanks! you would use the same sql logic which prevents them from showing up in your categories. Treasurer MFC
dittones Posted December 2, 2006 Posted December 2, 2006 Xearoth, Their is a status byte with each product you have in your database set to 0 or 1 for inable and disable...Why not in your search logic look for this byte field and test for 0 or 1 and eliminate the product based upon the field value... I hope this helps dittone.com Roman
xearoth Posted December 3, 2006 Author Posted December 3, 2006 because i have products that come "available" because inventory levels raise >4 but that doesnt mean i want them to show on the website. which they dont unless a person uses the search and they can find the product that way. so does that help explain what i am looking for?
dittones Posted December 3, 2006 Posted December 3, 2006 Xearoth, In the search rtn is where I am indicating to put the code test...if product status is disabled exclude them in the search results I hope that helps Roman
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.