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

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

A link to the product is here: http://r-c-s.ca/index.php?main_page=product_info&cPath=44&products_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.

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.

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... :frusty:

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..

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..


Try this mod
<http://www.zen-cart.com/index.php?main_page=contrib_search_result&search_in_description=1&keyword=Easy+Populate+CSV>

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... :frusty:

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.

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 = :productsID 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, ':productsID', $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:

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.

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.

So I've been reading a bunch of other threads and it looks like the SBA version I have is not compatible with dynamic drop downs.

So here is a stupid question and benchmark of how little I know... Do I need to uninstall my version 4_13 of SBA? There does not appear to be a removal script in the download... Or can I just install 4_7 over top of what I have?

ssteel:

So I've been reading a bunch of other threads and it looks like the SBA version I have is not compatible with dynamic drop downs.

So here is a stupid question and benchmark of how little I know... Do I need to uninstall my version 4_13 of SBA? There does not appear to be a removal script in the download... Or can I just install 4_7 over top of what I have?

I don't believe removing SBA version 4_13 and replacing it with version 4_7 will correct your problem - and besides 4_7 has a lot of features and updates missing. What I believe you need to do is COMPLETELY REMOVE Dynamic Drop Downs. However if you decide to install 4_7, you will have to remove each individual file of 4_13 to reinstall 4_7.

This may be misplaced, but wanted to interject that I have both SBA and Dynamic Dropdowns working just fine on my site with no customizations to get it working properly.

I believe in order to get it to display the way I wanted I had to use:

Title Value
Product Info Single Attribute Display Plugin sequenced_dropdowns
Product Info Multiple Attribute Display Plugin sequenced_dropdowns

If I'm not totally off base with this remark let me know if I can be of any other assistance in relaying my own settings.

-lindasdd

lindasdd:

This may be misplaced, but wanted to interject that I have both SBA and Dynamic Dropdowns working just fine on my site with no customizations to get it working properly.

I believe in order to get it to display the way I wanted I had to use:

Title Value
Product Info Single Attribute Display Plugin sequenced_dropdowns
Product Info Multiple Attribute Display Plugin sequenced_dropdowns

If I'm not totally off base with this remark let me know if I can be of any other assistance in relaying my own settings.

-lindasdd

Which version of SBA and DD are you using?

lindasdd

do you have a product with two attributes that are linked (i.e. the choice of the first attribute determines the stock availability and which attributes are shown of the second attribute because together they form one product) This is where it dynamic drop downs fails to work for me and most others I believe.

If you have it working in this way would like to know how. - I am trying to get it to show "out of stock" or "in stock" against each choice in the second drop down once the first has been chosen.

Regards

M

MikeyG,
Sorry for the lack of follow up - I've been out of the US.

I do not have a dependent attribute structure similar to what you mentioned. I just have one level.

What actually does happen for you in the second dropdown? Are you saying it still shows as in stock? Or does it disappear? I would think as long as it disappears you should be all set.

SSteel,
All the latest versions.

-lindasdd

P.S. You might have to get someone more versed in the programming for this MOD to do some custom work for you to make it work properly the way you'd like.

Has anyone used this with all business template?

I tried installing and the files have been loaded on server but I don't see anything in admin.
I goto the product with attributes. I click to edit attributes but I don't see a new field in attribute settings for quantity. AM I looking in the wrong place?

I got it loaded but it allows checkout when attributes aren't loaded with stock.
I was hoping when you highlighted an item in the dropdown the add to cart button would change to out of stock. Or just have the out of stock attribute not show at all

I will read through this and hopefully come up with an answer

mysh:

Has anyone used this with all business template?

I tried installing and the files have been loaded on server but I don't see anything in admin.
I goto the product with attributes. I click to edit attributes but I don't see a new field in attribute settings for quantity. AM I looking in the wrong place?

I got this running and setup.

I have encountered a problem. I can change product by hitting edit quantity button, but if I just try to fill in the number on the list screen and hit the save button, the save button does nothing. It doesn't seem to be a link at all

Any known fix for this issue? I found another thread where someone was having same issue but no follow up

reading through this I found someone offer a fix for the save button issue. I corrected the code and now the save button actually registers but it brings up this error msg

1146 Table 'peimei_zc11.products_with_attributes_stock' doesn't exist
in:
[UPDATE products_with_attributes_stock SET quantity = '31' WHERE products_with_attributes_stock.stock_id =416 LIMIT 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.