Can I show the stock level on a catalog page. So that users know that a product is sold out or how many are in stock!
Thx
Stock level on catalog page
I'm also interested in customizing the catalog page ... It would be nice if you had an option to show stock levels and a fast add to cart button or link. Less clicks for the users viewing the store.
Good with CSS - Bad with Code. 
To show the "add to cart" button that's possible. I don't know where to set this option at this moment, but I thought you can do it by shop configuration and then catalog.
But there you can't set the option to show the stock level on the catalog page.
Have you guys checked out Inventory API & Simple Stock levels?:
http://www.ubercart.org/contrib/132
it is really sweet. If you can print out the levels of stock on admin, then yes, you will be able to do it front-end.
U just need to add the "stocklevels" from /admin/content/types/product/fields
to show on your product pages.... (haven't tried, but sure it would be easy)..
Would be a nice addition.. Will post if I have success..
I'm currently working on code that provides Views integration for Ubercart Attributes:
http://www.ubercart.org/contrib/3960
The code includes some Stock integration (i.e. you can choose to display only those products that are in stock). Including a stock level field as part of that code wouldn't be difficult. This would provide you the ability to make a view that showed the stock level of a product with a specific set of attribute options. The specific set of options could be chosen by an option select box in the Views edit page, and the default would be to show the stock level for a product with no attributes or attribute options.
Admittedly, this doesn't get the Stock level built into Ubercart's catalog feature, but if you're comfortable using Views, this should do exactly what you want.
I suspect I won't be able to work on this feature until sometime next week, but let me know if this is what you're looking for and I'll make sure to put it on my To-Do list.
Maybe this is usefull to somebody:
It displays a small table with the current stocklevel of all stock-enabled SKU's for a product.
<?php
if ($node->type == 'product') {
$arr_sku = uc_stock_skus($node->nid);
$stock_html .='<table>';
foreach($arr_sku as $sku){
$stocklevel = uc_stock_level($sku);
if ($stocklevel) {
if ($stocklevel < 1) {
$stocklevel = '<span class="nostock">'.$stocklevel.'</span>';
}
$stock_html .='<tr><td>'.$sku.'</td><td>: '.$stocklevel.'</td></tr>';
}
}
$stock_html .='</table>';
}
?>Put it in the node.tpl.php, and print the var $stock_html in a proper place.
Feel free to ask.
Regards,
Kees
How do i make stock level by stores?. How do i make store level inventory for each product?
How do i show which store the product is available?
How do i show which store is nearer to a zip code (different ranges).
Sweet keesje76,
is that using the simple stock levels?
if so, I am gonna add it. means I can then add a nice icon as well.
Cheers for the share mate!
I'm finding this theme snippet to be a real gem as it dramatically cuts down customer questions about particular product attributes being in stock.
Placing the < ? php print $stock_html ? > in < fieldset class=" collapsible collapsed" > < / fieldset > tags, allows the table to be displayed in a collapsed field, which reduces screen clutter.
Two Questions:
1) Is there a way to use the snippet to display a message if there are no attributes in stock? (At the moment if no attributes are in stock, no table is rendered, which is confusing to the end user).
2) Also, this snippet only displays a decrease in stock when an item has been purchased. Is there any way to make it display a decrease when a product has been added to a cart, but hasn't yet been purchased.
^_^
How do i make stock level by stores?. How do i make store level inventory for each product?
How do i show which store the product is available?
How do i show which store is nearer to a zip code (different ranges).
Sorry, I don't know what youre talkin about. Ubercart IS a store. Just one.
Set up Ubercart twice and (you wont believe)you will end up with two stores, each one with it's own stock! Wow!
Good suggestion, thanks for sharing.
Answers:
1) Yes there is, funny, I made a small module for it. Gonna release it since it seem I'm not the only one needing this. Hang on, I'l post here when it's ready.
2) This is the nature of Ubercart stock levels. I personally like it the way it is.
is that using the simple stock levels?
No, it's based on the core stock module. Maybe it works with simple stock too, don't know.
Heyas
Any update on this ?
I sell a mixture of items that are "in stock" or "custom made" or "special ordered"
Being able to show current Stock Level on product page helps provide a "Lead Time" for my customer base
I am not good with coding so anything "point and shoot" is ideal for me
Here's a simple way to display stock level for nodes, and also to remove the "add to cart" button if the stock is zero.
Add the following to the template.php file in your sites/all/themes/YOUR_THEME_NAME directory, changing the function name according to your theme's name:
function YOUR_THEME_NAME_uc_product_add_to_cart( $node ) {
$stocklevel = uc_stock_level($node->model);
if (is_numeric($stocklevel)) {
// Stock tracking is active
if ($stocklevel == 0) {
return( '<div class="out_of_stock">' . t('Sorry, this item is out of stock') . '</div>' );
} else {
return( '<div class="stock_level">' . t('Number available: ') . $stocklevel . '</div>' ) . theme_uc_product_add_to_cart($node);
}
} else {
// Stock tracking is not being used for this product, just show the add to cart button as normal
return theme_uc_product_add_to_cart($node);
}
}Note that there are some obvious limitations to this:
1. It doesn't stop someone adding a quantity to their cart that is greater than the stock available
2. It doesn't update in real time so you may see the "add to cart" button but there may be no stock available by the time you click it
3. Stock is normally updated when an item is purchased, but this code tests at "add to cart" time
4. It is unlikely to work with product attributes. I don't use attributes, so didn't test it, but from what I understand about them, I think this approach is too simplistic.
I modified below code to allow for stock levels on product attributes. Not elegant, but it works
// ######### BEGIN CUSTOM CODING RELATED TO STOCK DISPLAY ###############
function YOURTHEMENAME_uc_product_add_to_cart( $node ) {
// look up all sku's for this product
$skus=uc_attribute_uc_product_models($node);
if(!empty($skus)){ // if there are multiple sku's, then list stock availability of options.
$avail = array();
foreach($skus as $val) {
$sl = uc_stock_level($val);
if (is_numeric($sl)) {
$name=lookup_option_name($val); // get the pretty name of option sku
$avail[] = " " .$name." (".$sl.")";
}
}
if(!empty($avail)) { $avail_string = "<br><div class=\"stock_level\">Number Available: ". implode(",",$avail) ."</div>"; }
return( $avail_string ). theme_uc_product_add_to_cart($node);
}
else { // else, we do the normal thing.
$stocklevel = uc_stock_level($node->model);
if (is_numeric($stocklevel)) {
// Stock tracking is active
if ($stocklevel == 0) {
return( '<div class="out_of_stock">' . t('Sorry, this item is out of stock') . '</div>' );
} else {
return( '<div class="stock_level">' . t('Number available: ') . $stocklevel . '</div>' ) . theme_uc_product_add_to_cart($node);
}
} else {
// Stock tracking is not being used for this product, just show the add to cart button as normal
return theme_uc_product_add_to_cart($node);
}
}
}
function uc_attribute_uc_product_models($node) {
$models = array();
// Get all the SKUs for all the attriibutes.
$adjustments = db_query("SELECT model FROM {uc_product_adjustments} WHERE nid = %d", $node->nid);
while ($adjustment = db_fetch_object($adjustments)) {
if (!in_array($adjustment->model, $models)) {
$models[$adjustment->model] = $adjustment->model;
}
}
return $models;
}
function lookup_option_name($sku){
//uc_attribute_options: name,oid
//uc_product_adjustments: combination (number in "quotes" equals oid above),model
$query = "SELECT combination FROM {uc_product_adjustments} WHERE model = '$sku'";
$result = db_query($query);
while ($row = db_fetch_array($result)) {
$combo = $row[combination];
list($stuff, $oid, $junk) = split('"', $combo);
$query2="SELECT name FROM {uc_attribute_options} WHERE oid = '$oid'";
$result2=db_query($query2);
while($row2=db_fetch_array($result2)){$name=$row2[name];}
return $name;
}
}
Here's a simple way to display stock level for nodes, and also to remove the "add to cart" button if the stock is zero.
Add the following to the template.php file in your sites/all/themes/YOUR_THEME_NAME directory, changing the function name according to your theme's name:
function YOUR_THEME_NAME_uc_product_add_to_cart( $node ) {
$stocklevel = uc_stock_level($node->model);
if (is_numeric($stocklevel)) {
// Stock tracking is active
if ($stocklevel == 0) {
return( '<div class="out_of_stock">' . t('Sorry, this item is out of stock') . '</div>' );
} else {
return( '<div class="stock_level">' . t('Number available: ') . $stocklevel . '</div>' ) . theme_uc_product_add_to_cart($node);
}
} else {
// Stock tracking is not being used for this product, just show the add to cart button as normal
return theme_uc_product_add_to_cart($node);
}
}Note that there are some obvious limitations to this:
1. It doesn't stop someone adding a quantity to their cart that is greater than the stock available
2. It doesn't update in real time so you may see the "add to cart" button but there may be no stock available by the time you click it
3. Stock is normally updated when an item is purchased, but this code tests at "add to cart" time
4. It is unlikely to work with product attributes. I don't use attributes, so didn't test it, but from what I understand about them, I think this approach is too simplistic.
Did anyone had succes displaying the stocklevels of options in the right order (same order as the options itself are ordered)?
I'm struggling with this, I believe it's imposible.
See also: http://www.ubercart.org/issue/6541/uc_stock_skus_does_not_use_option_wei...
Any help greatly appreciated!
More info and ugly fix for anyone interested:
http://www.ubercart.org/issue/6541/uc_stock_skus_does_not_use_option_wei...
It works nice except...
When you enable quantity, you still can add higher quantity than the current stock level, thus getting a negative value of stock. With this code you'll get something like "Number available: -11".
Can this be fixed easily? How?
Thanks for the help.
Joined: 12/07/2007