osCommerce Contribution - Low Stock, Order Soon

Compare Products

You have no items to compare.

Affiliate Info

Affiliate Program FAQ
Affiliate Log In

Recent Orders

Hot Keywords: Order Notification, Order Search, Coupon, Flash Board, Compare, Floating Message, Tracking, Moneris, RSS, Visitor Filter

Low Stock, Order Soon

1 of 1494 Next > Last >>

The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website.

To create a sense of urgency and let customers know a product has only one item left in stock.


<?php

$limitedSupply_query = "SELECT products_quantity, products_id
FROM " . TABLE_PRODUCTS . "
WHERE products_id = '" . (int)$_GET['products_id'] . "' ";

$limitedSupply = tep_db_query($limitedSupply_query);

if ($product_info['products_quantity'] < 5) {
echo '<font color="#ff0000"><strong><div align="center"><div id="limited">Low Stock, Order Soon !</div></strong></font>';
}
?>


Paste the code in the file where you would like the alert message to appear, I usually put it just above the Add to Cart button. Upload the edited file to root directory /product_info.php

if you want the low stock alert to show when there are 3 items or less, you would change
if ($limitedSupply->fields['products_quantity'] < 1)
to
if ($limitedSupply->fields['products_quantity'] < 3)

Posted on: 10/24/2009 See contribution details

Request Installation with Paid service