HomeHome Product Discus... Product Discus...SmithCartSmithCartArchived/Disabled products can still be accessed and purchasedArchived/Disabled products can still be accessed and purchased
Previous
 
Next
New Post
2/28/2012 8:16 AM
 
Chad Hensley
9th Level Poster

Joined: 9/7/2010
Posts: 117

I have pretty good SEO rank for my products, so when someone googles my product detail pages come up.  

That's great unless the product is archived/disabled.  When a google searcher clicks on the link, it takes them to the product regardless of it being disabled, and lets them add it to the cart.

Here is an example.  https://huntersclub.com/Store/Product...

I am OK with it still being searchable, but the Add to Cart should be disabled/not visible and it should have a message, preferably customizable, but at least something that says "This product is not currently available for sale". 

Thanks
 
New Post
2/28/2012 3:59 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Chad,

Which version of the Cart and DNN are you currently running?

I tried taking a look at the link you provided but I get a SQL Exception Error.

Thanks,
 
New Post
2/28/2012 4:06 PM
 
Chad Hensley
9th Level Poster

Joined: 9/7/2010
Posts: 117
Thanks for the heads up. I was doing some massive backups and ran out of space.

I am using 4.5
 
New Post
2/28/2012 7:31 PM
 
Chad Hensley
9th Level Poster

Joined: 9/7/2010
Posts: 117
I might also add archived/disabled products continue to show up in Featured Products.
 
New Post
3/2/2012 12:09 PM
 
Chad Hensley
9th Level Poster

Joined: 9/7/2010
Posts: 117
Any word on this?
 
New Post
3/2/2012 12:55 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452

Hi Chad,

Despending on how you have the featured products module settings configured one of the following 3 stored procs will be executed:

  • Smith_ListFeaturedProducts
  • Smith_ListFeaturedNewReleases
  • Smith_ListFeaturedTopProducts
Open up the stored proc that your store is using and add the following to the where clause:
 
Archived != 1 and HideProduct != 1
 
The full where clause should be as follows:
 
where logicallydeleted <> 1 and Archived != 1 and HideProduct != 1 and featured = 1 and PortalId = @PortalId
 
We have made this change in the latest cart dev build and it will be available in the next release cart v4.94
 
Thanks for reporting the issue!
 
 
At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
3/2/2012 12:56 PM
 
Chad Hensley
9th Level Poster

Joined: 9/7/2010
Posts: 117
Dave,

That's the easy one. What about where the archived product is still available to be put in the cart and purchased?
 
New Post
3/2/2012 1:44 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452
Are you talking about adding products to the cart via the querystring or archived products that have been indexed by google? You could set the inventory on hand to zero for the archived products which would prevent anyone from purchasing a particular product.

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
3/2/2012 1:56 PM
 
Chad Hensley
9th Level Poster

Joined: 9/7/2010
Posts: 117
I am talking about the pages that are indexed by Google.

I tried your suggestion and it did not work. I can still add the product to the cart and check out.
 
New Post
3/2/2012 2:09 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452
Make sure you have "enable inventory mgmt" checked in the buynow settings and when the user is on the cart page and clicks checkout a message will be displayed on the cart page indicating qty on hand for the product in zero and the user will not be able to checkout and purchase.



At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
3/2/2012 2:16 PM
 
Chad Hensley
9th Level Poster

Joined: 9/7/2010
Posts: 117
Thanks Dave. That is a work-around for my particular situation.

I see two improvements that can be made.

1. If a product is archived, don't display the add to cart button and display a message that says the product is not currently for sale. (It would be nice if the message was customized)

2. If the quantity of a product is 0, the add to cart button should be invisible, and an "Out of Stock" message should be displayed. (Again, allow the message to be customized)
 
New Post
3/2/2012 2:39 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452
Chad,
Good suggestions thanks!! Will add to the feature enhancement list. On the second part of your item 2 the cart currently supports the display of an "out of stock" message on the product listing and product details pages. To turn on the out of stock message to be displayed when your inventory reaches zero go to the buynow module settings product list setup section and check the box titled "show out of stock message" and go to your product detail module settings and check the same checkbox.



At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
3/2/2012 2:45 PM
 
Chad Hensley
9th Level Poster

Joined: 9/7/2010
Posts: 117
Thanks I got that to work. It still let's it add to cart though. Anyways, thanks for getting back to me.
 
New Post
3/5/2012 8:36 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Chad,

I have determined that the Add To Cart button will be disabled only when the Product Catalog Column setting is set for "1". When displaying multiple columns of products on the product listing page in conjunction with the "Show Sold Out Message" feature the Add to Cart button is not disabled. If have sent this issue into programming to be addressed and will post back as soon as an update is available. for now the best solution would be Dave's suggestion above.

Thanks,
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartArchived/Disabled products can still be accessed and purchasedArchived/Disabled products can still be accessed and purchased




Questions? Contact us for answers!

Contact Us!