Featured Items to include Not For Sale items too

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I just can't figure something out.
One the homepage featured section, I need for items marked "Not For Sale" to show up. In our online store, these products can be ordered by phone. I want to customer to see them too. Its a large bulk of our inventory.

I'm thinking i need to adjust the SQL to include items that are flagged as "Not For Sale"  but i can't figure out what i need to remove or add.

Does anyone know how to tweak it?

Thanks in advance

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
rosamatsas Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 10-November-2009 Location: Brooklyn, NY Status: Offline Points: 8	Post Options Post Reply Quote rosamatsas Report Post Thanks(0) Quote Reply Topic: Featured Items to include Not For Sale items too Posted: 02-April-2014 at 3:21pm
	I just can't figure something out. One the homepage featured section, I need for items marked "Not For Sale" to show up. In our online store, these products can be ordered by phone. I want to customer to see them too. Its a large bulk of our inventory. I'm thinking i need to adjust the SQL to include items that are flagged as "Not For Sale" but i can't figure out what i need to remove or add. Does anyone know how to tweak it? Thanks in advance

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 03-April-2014 at 1:59pm
	Rosa - in home.asp you will find this code: '// START v4.1 - Not For Sale override if NotForSaleOverride(session("customerCategory"))=1 then queryNFSO="" else queryNFSO="AND formQuantity = 0 " end if '// END v4.1 I have not tested this but I believe if you simply comment out this line, it will give you what you need. queryNFSO="AND formQuantity = 0 "