Ubercart product quantity count in product view page show as smsung 2/10 sold?

Question

I added a product and say it has count of ten(of that product), If one is bought, then I want to show in the product view page out of 10/1 sold like that.

Is there any contributed modules available, or custom way to do it? I can add the quantity as field in the product content type, but what do I do after that?

Answer 1

Code snippets to display total and sold item from stock:

$output = '';

$array_sku = uc_product_get_models($node->nid, FALSE);          

foreach ($array_sku as $sku) {
    $stock_level = uc_stock_level($sku);

    $stock_counts = db_select('uc_order_products', 'up')
                    ->fields('up', array('nid','qty'))
                    ->condition('up.model', $sku, '=')
                    ->execute()
                    ->fetchAll();

    $quantity_count = 0;

    if(isset($stock_counts))  {   
        foreach($stock_counts as $stock_count ) {
            $quantity_count += $stock_count->qty;
        }   
    }

    $total = $stock_level +  $quantity_count;

    if($total == 0){
        $total = 1;
    }           

    $output .= $total . " / " . $quantity_count . " Sold out";          
  }

 print $output;

Kindly see that above code will be check stock level for each different SKU of the product. If there is attribute of the product and each attribute has different SKU, then it will display the stock for each sKU of the product.

It will work perfect in fresh "Ubercart" installation with "stock" configuration.

You can add this code in node--product.tpl.php file in your theme directory.

Answer 2

This is not an answer, but you can find the stock level using the below code, just put in the node.tpl.php, and print the var $stock_html in a proper place, probably in node-product.tpl.php <?php print $stock_html ?> .

<?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>:&nbsp;&nbsp;'.$stocklevel.'</td></tr>';
    }
  }
  $stock_html .='</table>';
}
?>

or you can try this http://www.ubercart.org/comment/60577

Answer 3

         <?php
                $array_sku = uc_product_get_models($node->nid, FALSE);          
                foreach ($array_sku as $sku) {
                    $stock_level = uc_stock_level($sku);
                    //$stock_count = db_select('uc_order_products', 'up')->fields('up', array('nid'))->condition('up.model', $sku, '=')->execute()->rowCount();

                    $stock_counts = db_select('uc_order_products', 'up')
                                    ->fields('up', array('nid','qty'))
                                    ->condition('up.model', $sku, '=')
                                    ->execute()
                                    ->fetchAll();
                    $quantity_count = 0;
                    if(isset($stock_counts))
                    {   
                        foreach($stock_counts as $stock_count )
                        {
                            $quantity_count += $stock_count->qty;
                        }   
                    }
                    $total = $stock_level +  $quantity_count;
                    if($total == 0){
                        $total = 1;
                    }           
                    $output .= $total . " / " . $quantity_count . " Sold out";          
                }
          ?>    

This will output exact stock level and sold level of the product.