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

[athena]

OK...here is what we found:

Admin > Catalog > Sale Maker - where you put a whole category on sale - The results are that items with different priced attributes calculate correctly for the base items, but if you say add $10 for Large vs Small it will just add the full price to the discounted base.

Admin > Catalog > Specials - Where you put one individual item with attributes on sale, there are no apparent issues.

Work around or suggestion: Change the add on price in the Stock By Attributes for the item to reflect the pecentage off, or just use "Specials" for those items with attributes that add prices.

Hope this helps...we appreciate the heads up, zc_fan - good luck with your sale.

I am using v1.3.9f with Stock by Atributes module. I had problems with this before until I realized that I had to copy the header_php.php as per this support thread.

So now I have applied the 15% sale on the entire catalog and this is whats happening:

I see all the items with reduced price in the catalog admin as well as the shop. But when the products get added to the shopping cart - on some products with attributes it displays the full price and for some other products with attributes it works as expected.

For example the following product works fine:
http://sweetus.com/index.php?main_pa...roducts_id=324

While this one, displays the full price for default attribute and wrongly calculates the 15% discount (it really calculates the 15% discount on the default attribute and applies it to the other attribute) for the other atribute:
http://sweetus.com/index.php?main_pa...roducts_id=251

Thanks again for reading through this

I hope all this made some sense. Please help!!

[tesefoti]

Check Athena's post on page 114 of this thread and copy/paste that code to your file.
I had the same problem, but the code in the post fixed everything.

I used his solution and it seems to work at first, seems to allow checkout, but now I noticed it doesn't take items off on products_with_attributes_stock.php.

Imagine I have:

Item A - 4 units
Size S - 1
Size M - 2
Size L - 1

If a client buys 1 Size L Item A it will show on products_with_attributes_stock.php

Item A - 3 units
Size S - 1
Size M - 2
Size L - 1

I had situations where it ends ups like:

Item A - -1 units
Size S - 1
Size M - 2
Size L - 1

In other words, it updates the total quantity but does not update quantity by attribute.

Anyone has the same problem?

[athena]

When you enter your stock are you using the sync feature to update your over-all stock levels?

I used his solution and it seems to work at first, seems to allow checkout, but now I noticed it doesn't take items off on products_with_attributes_stock.php.

Imagine I have:

Item A - 4 units
Size S - 1
Size M - 2
Size L - 1

If a client buys 1 Size L Item A it will show on products_with_attributes_stock.php

Item A - 3 units
Size S - 1
Size M - 2
Size L - 1

I had situations where it ends ups like:

Item A - -1 units
Size S - 1
Size M - 2
Size L - 1

In other words, it updates the total quantity but does not update quantity by attribute.

Anyone has the same problem?

[tesefoti]

Hi athena thanks for the quick reply.

Yes I update the quantity by attribute on stock_by_attribute.php and click sync. Then I put an order for 1 unit of product A and the total ammount goes down by one unit, but the quantity of product A with that attribute stays the same.

I believe it's something related with the checkout page, that it doesn't update the stock by attribute on the database.

You haven't noticed or had the same problem? Thanks.

(The problem with not allowing to checkout when you have product on stock or to show everything out of stock after you choose an out of stock item was solved with the header.php you posted, but now I get this new problem)

[athena]

I ran a few test and all seems ok and we haven't noticed any problems so far.

Quantity 4
boot size 8 - 2
boot size 6 - 1
boot size 4 - 1

I "bought" a size 8

Quantity 3
boot size 8 -1
boot size 6 - 1
boot size 4 - 1

I deleted the order and checked "Restock product quantity" and it put it back correctly:

Quantity 4
boot size 8 - 2
boot size 6 - 1
boot size 4 - 1

[tesefoti]

Hmm, it's strange I get this error... I will try reinstalling it. How should I do it? Install the newest version

Author: That Software Guy
Version: 1.4.13
Zen Cart™ Version: v1.3.9
Update added on Apr 06 2011

file by file, and then use the header.php you made available?

Thanks!

[tesefoti]

Ok, I solved it. Apparently I overwritten the orders.php with other mod. My bad

[webstar59]

I see alot of users are having problems with this addon. I want to know if its setup right will it work without bugs? Sometimes things don't work because the user did not setup the application right. I would like to use this addon but I want to make sure it won't crash my store. I wish zen-cart allready had this option

[Pablo]

This add on works great if you follow the suggestions in this thread about changing the header_php.php file. Most of the problems I have seen seems to come from the file transfer. You have to be sure that the "ADMIN" and "TEMPLATE" folders have the correct name as your server files. Replace the header_php.php file with the code listed on page 114 of this thread and make sure your files end up exactly where they are supposed to. This is a great add on, but some files have gotten out of sync.

[Shinmai]

I changed all the "Out of Stock" text in my cart by running a case sensitive search being careful to choose the display text incidents of the phrase to "More on Order".

BTW - In case anyone is looking for this file, I fixed many problems, as Chris suggested above, by replacing my includes/modules/pages/shopping_cart/header_php.php with the one below from an earlier version of stock by attributes, namely stock_by_attributes_4-7MULTIADD.

No other modification needed. I'm running 1.3.9h upgrading from 1.3.8a

<?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');
?>

Hi there, I am using 1.3.9h (fresh install) with SBA creinold 5.0 Beta and was wondering if this solution would work for 5.0 Beta version of SBA users...

Currently, I'm having a problem not seeing any warning when I place order higher than the stock available. I set the admin to FALSE on "Allow Checkout" so that I cannot Checkout but without alert displaying, you cannot tell why the shopping cart page is keep staying the same page when I click on Checkout button.
If the product does not have attribute, then warning displays when I place order higher than available stock number.

I read other people are having the same problem but I cannot find the solution posted and this is only thing that is stopping me from going LIVE and am very frustrated

Please let me know if anybody found the solution to this for SBA 5.0 Beta or point me to the right thread.

Thanks