Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / How to make SOLD OUT items disappear?

How to make SOLD OUT items disappear?

Locked

Views: 2,130

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
1 Feb 2007, 2:37 AM
#1
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

How to make SOLD OUT items disappear?

I'm seeing items that I test sold appear as SOLD OUT, but I want them to not show at all...most of our items are limited qtys or one-of-a-kinds.
How can I make them not show up on the site for the customer to see?

Thanks!

1 Feb 2007, 2:41 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: How to make SOLD OUT items disappear?

You have a choice of having Sold out products disappear from the Catalog or marked as Sold Out so the customer sees you have activity on your site and that they are encouraged to buy now rather than wait ... :cool:

You can change the settings in the Configuration ... Stock ... to either switch to Sold Out or have the Status set to off so that they remove from the Catalog ...

Note: configuring the Stock is usually a combination of 1 or more settings so read that section carefully ...

1 Feb 2007, 2:45 AM
#3
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: How to make SOLD OUT items disappear?

hmmmm... I see your point there, but I know how a comic buyer can be ticked off to SEE the comic they want and then see the "sold out" sign.
How do the Sold Outs work? Do they remain Sold Outs forever until the product is deleted from the catalog? Or ???
then again, I'm working off of eBay sales, so they will see my feedback to see that we do sell, and most will know me as a seller, so now I'm more confused then ever!:wacko:

LOL!
Thanks tho, really!!

1 Feb 2007, 2:52 AM
#4
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: How to make SOLD OUT items disappear?

We've decided to go with it being removed from the catalog, BUT its not disappearing.

Can someone please outline the steps to do this?
I have it set :

**Products status in Catalog when out of stock should be set to
Show Products when out of stock

0= set product status to OFF**

Not sure what else to change to make it stop showing.

1 Feb 2007, 3:19 AM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: How to make SOLD OUT items disappear?

The setting is used when the Product is purchased and then goes to <= 0

For products already set to products_quantity 0 you would need to manually change the products_status in the database ...

In the Tools ... Insert SQL Patches ... you could use this handy dandy little update command to reset the products_status on the existing Products that have products_quantity 0 ...

UPDATE products SET products_status=0 where products_quantity=0;

NOTE: it is a good idea to always backup your database before making changes like this ...

1 Feb 2007, 4:11 AM
#6
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: How to make SOLD OUT items disappear?

You are the greatest!!
What can I say.... after I researched just HOW to backup my database cause I was too embarrased to ask :blush: .... I installed the backup download, did that. Then plugged in what you show and it works like a charm :D !

Thank you ever so much!!!

1 Feb 2007, 4:12 AM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: How to make SOLD OUT items disappear?

You are most welcome ... glad that this worked for you ... :smile:

Remember us fondly when you are rich and famous!! :cool: