snubbr.com

How to implement Verisign SSL on a Particular Page of a Website?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
First question I have is How to implement Verisign SSL on a Particular Page of a Website? Many thanks for any answer. My other question... When a customer buys the last unit of a given item, the store automatically sets that particular product page not to be displayed. When we run out of an item, we receive more inventory fairly quickly. As a result, I would like to continue to display the product even if it has zero inventory. How/where can I change that setting so that products with zero inventory remain displayed by default?.

I know I can go to the admin and manually set a product to be displayed. However, I would like to change the default to display the product with zero inventory and have to manually change it to "not to be displayed" in the admin, if desired..

Thanks...

Comments (7)

I would like to know the answer too. Anyone here know what is the answer to your question. I'll do some investigation and get back to you if I find an useful answer. You should email the people at Verisign as they probably could answer your Verisign question..

Comment #1

Thanks for the reply, Geoffrey..

I have looked in the Admin>Configuration section. While I have found controls such as "Prevent Adding Out of Stock to Cart" and "Mark product out of stock," I have not found what controls the product from automatically not being displayed when inventory reaches zero. ("Mark product out of stock" merely controls what symbol "***" is used to display items in the cart that have less quantity than ordered.).

I also have a number of contributions. However, I'm not certain what they are. I do have a contribution that allows inventory by attribute. So, I also have controls such as "Show Out of Stock Attributes" (which keep an out-of-stock attribute in the dropdown list on the product page but marks it as "Out Of Stock")..

Am I just overlooking where the control is to automatically remove a product from display when inventory reaches zero? Is there some other place I should look?.

Thanks...

Comment #2

You could add a where clause to the sql e.g..

Where stock level > 0.

See w3.schools.com for more info on sql...

Comment #3

Since there doesn't appear to be an admin control setting for displaying products with zero inventory, I was thinking of amending the code. However, I'm not sure which file contains that code. Any ideas?..

Comment #4

I'm amazed that no one has previously posted a solution to this very basic issue: Blocking the display of products with zero inventory..

I'm amazed that this isn't the default state for osCommerce..

I'm amazed there is no switch to turn the display of these products on or off..

But it is what it is so I hope this helps..

I found a query in file.

Products_new.php.

On.

Line 54.

If you add.

P.products_quantity > 0 and.

To.

Where p.products_status = '1'.

Resulting in.

Where p.products_quantity > 0 and p.products_status = '1'.

This will block the display of products with zero inventory in the default page of index.php and the new products page products_new.php..

For other pages such as those which result from the search function, it appears to involve the code that defines.

$listing_sql.

In the file index.php..

I have not yet found the correct code to block products with zero inventory for these pages but, I assume, it will require a similar solution..

If I solve this issue before anyone else does, I'll edit this post with the information..

This post has been edited by.

Ifscal.

: 19 September 2008, 01:10..

Comment #5

Here's the solution:.

In file checkout_process.php, find the following lines and comment them out..

Find:.

If ($stock_left < 1) {.

Tep_db_query("update "TABLE_PRODUCTS" set products_status = '0' where products_id = '"tep_get_prid($order->products[$i]['id'])"'");.

}.

Comment out, as such:.

// if ($stock_left < 1) {.

// tep_db_query("update "TABLE_PRODUCTS" set products_status = '0' where products_id = '"tep_get_prid($order->products[$i]['id'])"'");.

// }..

Comment #6

You can also make a check in your product_info.php to tell customers that the product is on backorder. Just place this in your product_info page wherever you want it..

<?.

If ($product_info['products_quantity'] < 1).

{.

Echo "This product is currently on backorder";.

} else {.

Echo "Quantity Available: "$product_info['products_quantity']" in stock";.

}.

?>..

Comment #7

...and to reset all of your products back to "active" status from the command-line... This will set ALL PRODUCTS ACTIVE so don't do it unless that's what you want!.

Mysql -uroot -p your_osc_databasename -e "update products set products_status = '1' where 1".

Enter your mysql root password at the prompt -..

Comment #8


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.