Creating a hidden item

[vcache]

Is there any way to create an item that doesn't show up in the product listings?

[Guest]

Yes - you can do this by creating a column in the products table of your database, eg.

 

ALTER TABLE products ADD products_listing_status TINYINT(2) DEFAULT '1' NOT NULL;

 

You can then alter your queries in index.php:

 

where p.products_status = '1' and p.products_listing_status = '1'

 

Just look for: where p.products_status = '1' in the code (there are more than one instance)

 

You can put a radio select in admin/categories.php for marking products or mark them in the database directly - simply adjust products you wish to hide to 0

 

Matti

[vcache]

thanks!

 

Reason I am needing to do this is I plan to run monthly contests and I have the winner pay the shipping (heck, their getting the actual product free...) and want them to be able to pay the shipping through the site to make it easier for them

[laurelsstitchery]

I think this may solve all my problems with trying to give free shipping to my new customers! I've created an item with a cost of -$2.00, but I don't want it to be visible to the general public like it is now. I want to be able to send the new customers a link to the item so they can get free or discounted shipping.

 

I found six instances of where p.products_status = '1' in index.php. Do I change all six to the following?

where p.products_status = '1' and p.products_listing_status = '1'

 

 

 

Yes - you can do this by creating a column in the products table of your database, eg.

 

ALTER TABLE products ADD products_listing_status TINYINT(2) DEFAULT '1' NOT NULL;

 

You can then alter your queries in index.php:

 

where p.products_status = '1' and p.products_listing_status = '1'

 

Just look for: where p.products_status = '1' in the code (there are more than one instance)

 

You can put a radio select in admin/categories.php for marking products or mark them in the database directly - simply adjust products you wish to hide to 0

 

Matti

[laurelsstitchery]

Well, darn. I replaced the code in index.php and created the column in the table and set the one item I want to hide to "0", but it's still visible in the New Products for February box. Any ideas?

 

 

I think this may solve all my problems with trying to give free shipping to my new customers! I've created an item with a cost of -$2.00, but I don't want it to be visible to the general public like it is now. I want to be able to send the new customers a link to the item so they can get free or discounted shipping.

 

I found six instances of where p.products_status = '1' in index.php. Do I change all six to the following?

where p.products_status = '1' and p.products_listing_status = '1'