Customizing ProductCart - Featured Items to include Not For Sale items too

Print Page | Close Window

Featured Items to include Not For Sale items too

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=5866
Printed Date: 27-November-2024 at 10:05am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Featured Items to include Not For Sale items too

Posted By: rosamatsas
Subject: Featured Items to include Not For Sale items too
Date 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

Replies:

Posted By: Greg Dinger
Date 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 "

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |