Stock by Attribute v4.0 addon for v1.3.5-1.3.9

[Pablo]

A link to your site please - and which product is showing that is out of stock?

[ssteel]

A link to the product is here: http://r-c-s.ca/index.php?main_page=...roducts_id=105

In the drop down the 200/57 item should not be there as it is out of stock, all the others are there and should be.

[Pablo]

OK - If you add this item to your cart it will show as being out of stock, but you don't want the customer to have to go through all that to find out it's not in stock. Check the list for this product in your admin "Products with Attributes Stock" and be sure the product is listed and that it has zero quantity next to it. If it is not listed then "Products with Attributes Stock" cannot control it regardless of it's stock level.

[ssteel]

I have done that and even added new variants after the header modification and still I have items in the list that should not be there...

[Savvonet]

Hi!

I need a little help reguarding stock by attributes..

I use this query to retrieve all the details of products from my database:

$query_prodotti = "
SELECT concat( '" . $productURLstart . "',pt.type_handler,'" . $productURLend . "' ,p.products_id) AS product_url,
p.products_id,
p.products_quantity,
p.products_model,
p.products_type,
p.products_image,
p.products_price,
p.products_date_available,
p.products_weight,
p.products_tax_class_id,
pd.products_name,
pd.products_description,
cd.categories_name,
cd.categories_id,
m.manufacturers_name,
s.specials_new_products_price,
s.expires_date,
FROM
          " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id=p.products_id and pd.language_id=".$lingua."
LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " pc on pc.products_id=p.products_id
LEFT JOIN " . TABLE_CATEGORIES . " c on c.categories_id=pc.categories_id
LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd on cd.categories_id=pc.categories_id 
LEFT JOIN " . TABLE_MANUFACTURERS . " m on m.manufacturers_id=p.manufacturers_id
LEFT JOIN " . TABLE_SPECIALS . " s on ( s.products_id = p.products_id AND ( (s.expires_date > CURRENT_DATE) OR (s.expires_date = 0) ) )
LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt on p.products_type = pt.type_id

WHERE p.products_status=1 and c.categories_id=34 and c.categories_status=1 and cd.language_id=".$lingua;

I'm stuck on retrieving data from stock by attributes, I need, for every product, to retrieve attributes and obviously the stock for attributes.

Exemple:

Red T-Shirt, Summer Clothes, XXL, 4
Red T-Shirt, Summer Clothes, M, 2


Where "Red T-Shirt" is the product, "Summer Clothes" is the category (and no problem for that), "XXL" and "M" are attributes and "4" and "2" are the respective stock.


Is there an angel with the part of the query I miss?


Thanks..

[Pablo]

Hi!

I need a little help reguarding stock by attributes..

I use this query to retrieve all the details of products from my database:

$query_prodotti = "
SELECT concat( '" . $productURLstart . "',pt.type_handler,'" . $productURLend . "' ,p.products_id) AS product_url,
p.products_id,
p.products_quantity,
p.products_model,
p.products_type,
p.products_image,
p.products_price,
p.products_date_available,
p.products_weight,
p.products_tax_class_id,
pd.products_name,
pd.products_description,
cd.categories_name,
cd.categories_id,
m.manufacturers_name,
s.specials_new_products_price,
s.expires_date,
FROM
          " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id=p.products_id and pd.language_id=".$lingua."
LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " pc on pc.products_id=p.products_id
LEFT JOIN " . TABLE_CATEGORIES . " c on c.categories_id=pc.categories_id
LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd on cd.categories_id=pc.categories_id 
LEFT JOIN " . TABLE_MANUFACTURERS . " m on m.manufacturers_id=p.manufacturers_id
LEFT JOIN " . TABLE_SPECIALS . " s on ( s.products_id = p.products_id AND ( (s.expires_date > CURRENT_DATE) OR (s.expires_date = 0) ) )
LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt on p.products_type = pt.type_id

WHERE p.products_status=1 and c.categories_id=34 and c.categories_status=1 and cd.language_id=".$lingua;

I'm stuck on retrieving data from stock by attributes, I need, for every product, to retrieve attributes and obviously the stock for attributes.

Exemple:

Red T-Shirt, Summer Clothes, XXL, 4
Red T-Shirt, Summer Clothes, M, 2


Where "Red T-Shirt" is the product, "Summer Clothes" is the category (and no problem for that), "XXL" and "M" are attributes and "4" and "2" are the respective stock.


Is there an angel with the part of the query I miss?


Thanks..

Try this mod
http://www.zen-cart.com/index.php?ma...y+Populate+CSV

[Pablo]

I have done that and even added new variants after the header modification and still I have items in the list that should not be there...

I noticed that if you put the out of stock item in the cart, it does not show how many you have in stock - which should be zero - however the attribute should not be showing at all.
Please copy the code from your header_php.php file and post it so I can compare. This is only file that controls this action.
Also please provide a a screen shot of your admin/configuration/stock page.

[ssteel]

I copied this from Athena's post... header_php.php is as follows:
<?php
/**
* shopping_cart header_php.php
*
* @package page
* @copyright Copyright 2003-2007 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: header_php.php 0000 2007-12-02 00:00:00Z kuroi $
*/

// This should be first line of the script:
$zco_notifier->notify('NOTIFY_HEADER_START_SHOPPING_CART');

require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);

// Validate Cart for checkout
$_SESSION['valid_to_checkout'] = true;
$_SESSION['cart_errors'] = '';
$_SESSION['cart']->get_products(true);

if (!$_SESSION['valid_to_checkout']) {
$messageStack->add('shopping_cart', ERROR_CART_UPDATE . $_SESSION['cart_errors'] , 'caution');
}

// build shipping with Tare included
$shipping_weight = $_SESSION['cart']->show_weight();
/*
$shipping_weight = 0;
require(DIR_WS_CLASSES . 'order.php');
$order = new order;
require_once('includes/classes/http_client.php'); // shipping in basket
$total_weight = $_SESSION['cart']->show_weight();
$total_count = $_SESSION['cart']->count_contents();
require(DIR_WS_CLASSES . 'shipping.php');
$shipping_modules = new shipping;
$quotes = $shipping_modules->quote();
*/
$totalsDisplay = '';
switch (true) {
case (SHOW_TOTALS_IN_CART == '1'):
$totalsDisplay = TEXT_TOTAL_ITEMS . $_SESSION['cart']->count_contents() . TEXT_TOTAL_WEIGHT . $shipping_weight . TEXT_PRODUCT_WEIGHT_UNIT . TEXT_TOTAL_AMOUNT . $currencies->format($_SESSION['cart']->show_total());
break;
case (SHOW_TOTALS_IN_CART == '2'):
$totalsDisplay = TEXT_TOTAL_ITEMS . $_SESSION['cart']->count_contents() . ($shipping_weight > 0 ? TEXT_TOTAL_WEIGHT . $shipping_weight . TEXT_PRODUCT_WEIGHT_UNIT : '') . TEXT_TOTAL_AMOUNT . $currencies->format($_SESSION['cart']->show_total());
break;
case (SHOW_TOTALS_IN_CART == '3'):
$totalsDisplay = TEXT_TOTAL_ITEMS . $_SESSION['cart']->count_contents() . TEXT_TOTAL_AMOUNT . $currencies->format($_SESSION['cart']->show_total());
break;
}

// testing/debugging
// require(DIR_WS_MODULES . 'debug_blocks/shopping_cart_contents.php');

$flagHasCartContents = ($_SESSION['cart']->count_contents() > 0);
$cartShowTotal = $currencies->format($_SESSION['cart']->show_total());

$flagAnyOutOfStock = false;
$products = $_SESSION['cart']->get_products();
for ($i=0, $n=sizeof($products); $i<$n; $i++) {
if (($i/2) == floor($i/2)) {
$rowClass="rowEven";
} else {
$rowClass="rowOdd";
}
switch (true) {
case (SHOW_SHOPPING_CART_DELETE == 1):
$buttonDelete = true;
$checkBoxDelete = false;
break;
case (SHOW_SHOPPING_CART_DELETE == 2):
$buttonDelete = false;
$checkBoxDelete = true;
break;
default:
$buttonDelete = true;
$checkBoxDelete = true;
break;
$cur_row++;
} // end switch
$attributeHiddenField = "";
$attrArray = false;
$productsName = $products[$i]['name'];

if (STOCK_CHECK == 'true') {
$flagStockCheck = zen_check_stock($products[$i]['id'], $products[$i]['quantity']);
if ($flagStockCheck == true) {
$flagAnyOutOfStock = true;
}
$stockAvailable = zen_get_products_stock($products[$i]['id']);
}

// Push all attributes information in an array
if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {
if (PRODUCTS_OPTIONS_SORT_ORDER=='0') {
$options_order_by= ' ORDER BY LPAD(popt.products_options_sort_order,11,"0")';
} else {
$options_order_by= ' ORDER BY popt.products_options_name';
}
foreach ($products[$i]['attributes'] as $option => $value) {
$attributes = "SELECT popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix
FROM " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa
WHERE pa.products_id = roductsID
AND pa.options_id = :optionsID
AND pa.options_id = popt.products_options_id
AND pa.options_values_id = :optionsValuesID
AND pa.options_values_id = poval.products_options_values_id
AND popt.language_id = :languageID
AND poval.language_id = :languageID " . $options_order_by;

$attributes = $db->bindVars($attributes, 'roductsID', $products[$i]['id'], 'integer');
$attributes = $db->bindVars($attributes, ':optionsID', $option, 'integer');
$attributes = $db->bindVars($attributes, ':optionsValuesID', $value, 'integer');
$attributes = $db->bindVars($attributes, ':languageID', $_SESSION['languages_id'], 'integer');
$attributes_values = $db->Execute($attributes);
//clr 030714 determine if attribute is a text attribute and assign to $attr_value temporarily
if ($value == PRODUCTS_OPTIONS_VALUES_TEXT_ID) {
$attributeHiddenField .= zen_draw_hidden_field('id[' . $products[$i]['id'] . '][' . TEXT_PREFIX . $option . ']', $products[$i]['attributes_values'][$option]);
$attr_value = $products[$i]['attributes_values'][$option];
} else {
$attributeHiddenField .= zen_draw_hidden_field('id[' . $products[$i]['id'] . '][' . $option . ']', $value);
$attr_value = $attributes_values->fields['products_options_values_name'];
}

$attrArray[$option]['products_options_name'] = $attributes_values->fields['products_options_name'];
$attrArray[$option]['options_values_id'] = $value;
$attrArray[$option]['products_options_values_name'] = zen_output_string_protected($attr_value) ;
$attrArray[$option]['options_values_price'] = $attributes_values->fields['options_values_price'];
$attrArray[$option]['price_prefix'] = $attributes_values->fields['price_prefix'];
}

if ( STOCK_CHECK == 'true' ) {

// Added to allow individual stock of different attributes
unset($attributes);
if(is_array($products[$i]['attributes'])){
$attributes = $products[$i]['attributes'];
} else {
$attributes = '';
}

// End change

$stock_check = zen_check_stock($products[$i]['id'], $products[$i]['quantity'],$attributes);

if (zen_not_null($stock_check))
{
$flagAnyOutOfStock = true;
$flagStockCheck = $stock_check;
$stockAvailable = zen_get_products_stock($products[$i]['id'], $attributes);
}
}
} //end foreach [attributes]
$linkProductsImage = zen_href_link(zen_get_info_page($products[$i]['id']), 'products_id=' . $products[$i]['id']);
$linkProductsName = zen_href_link(zen_get_info_page($products[$i]['id']), 'products_id=' . $products[$i]['id']);
$productsImage = (IMAGE_SHOPPING_CART_STATUS == 1 ? zen_image(DIR_WS_IMAGES . $products[$i]['image'], $products[$i]['name'], IMAGE_SHOPPING_CART_WIDTH, IMAGE_SHOPPING_CART_HEIGHT) : '');
$show_products_quantity_max = zen_get_products_quantity_order_max($products[$i]['id']);
$showFixedQuantity = (($show_products_quantity_max == 1 or zen_get_products_qty_box_status($products[$i]['id']) == 0) ? true : false);
// $showFixedQuantityAmount = $products[$i]['quantity'] . zen_draw_hidden_field('products_id[]', $products[$i]['id']) . zen_draw_hidden_field('cart_quantity[]', 1);
// $showFixedQuantityAmount = $products[$i]['quantity'] . zen_draw_hidden_field('cart_quantity[]', 1);
$showFixedQuantityAmount = $products[$i]['quantity'] . zen_draw_hidden_field('cart_quantity[]', $products[$i]['quantity']);
$showMinUnits = zen_get_products_quantity_min_units_display($products[$i]['id']);
$quantityField = zen_draw_input_field('cart_quantity[]', $products[$i]['quantity'], 'size="4"');
$buttonUpdate = ((SHOW_SHOPPING_CART_UPDATE == 1 or SHOW_SHOPPING_CART_UPDATE == 3) ? zen_image_submit(ICON_IMAGE_UPDATE, ICON_UPDATE_ALT) : '') . zen_draw_hidden_field('products_id[]', $products[$i]['id']);
$productsPrice = $currencies->display_price($products[$i]['final_price'], zen_get_tax_rate($products[$i]['tax_class_id']), $products[$i]['quantity']) . ($products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->display_price($products[$i]['onetime_charges'], zen_get_tax_rate($products[$i]['tax_class_id']), 1) : '');
$productsPriceEach = $currencies->display_price($products[$i]['final_price'], zen_get_tax_rate($products[$i]['tax_class_id']), 1) . ($products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->display_price($products[$i]['onetime_charges'], zen_get_tax_rate($products[$i]['tax_class_id']), 1) : '');
$productArray[$i] = array('attributeHiddenField'=>$attributeHiddenField,
'flagStockCheck'=>$flagStockCheck,
'flagShowFixedQuantity'=>$showFixedQuantity,
'linkProductsImage'=>$linkProductsImage,
'linkProductsName'=>$linkProductsName,
'stockAvailable'=>$stockAvailable,
'productsImage'=>$productsImage,
'productsName'=>$productsName,
'showFixedQuantity'=>$showFixedQuantity,
'showFixedQuantityAmount'=>$showFixedQuantityAmount,
'showMinUnits'=>$showMinUnits,
'quantityField'=>$quantityField,
'buttonUpdate'=>$buttonUpdate,
'productsPrice'=>$productsPrice,
'productsPriceEach'=>$productsPriceEach,
'rowClass'=>$rowClass,
'buttonDelete'=>$buttonDelete,
'checkBoxDelete'=>$checkBoxDelete,
'id'=>$products[$i]['id'],
'attributes'=>$attrArray);
} // end FOR loop


// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_SHOPPING_CART');
?>

The screen shot of the admin/configuration/stock:

[Pablo]

Checked your files and everything seems OK. You may want to change "Show available stock level in cart when less than order" to TRUE. It's your option, but if the customer places 5 in the cart and you only have 3 in stock - It will show so they don't have to guess how many they can buy.

Check your file products_with_attributes_stock.php on line 482.
If it reads echo '<div id="pwa-table"';
It IS MISSING >

It should read echo '<div id="pwa-table">';

This probably won't fix the other problem, but it sure fixes a lot of the "SYNC" and "SORT" problems.

[Pablo]

Ran some tests and found your problem! You need to UNINSTALL "Dynamic Drop Downs". This mod does not work with "Attributes with Stock" and is what is causing zero stock level products to still show up. Be sure to remove the update you placed on your database also.