Stock For Product With Different Attributes (OLD)

If possible I would prefer it if it showed the attributes with the amount in stock in brackets. If a javascript alert could be shown or something before the customer gets to the shopping cart I think that would be better.

I think having to add to your cart and the cart telling you the item is out of stock would be a waste of time and likely to annoy the customer.

We need to show when something is out of stock but also make sure that the option cannot be picked from the dropdown.

What does everyone else think?

Quote:

---

Originally posted by longstockings@Feb 2 2006, 10:11 AM
We need to show when something is out of stock but also make sure that the option cannot be picked from the dropdown.

---

We've gone over this before, it's not that easy. The reason being, attributes are shown seperately on the product info page, and there's no way to know that a combo of attributes is out of stock until we know which combo the user wants (the user must set each attribute first).

This is tricky to do, it either requires a page reload whenever an attribute is picked (to check stock), or some sort of AJAX solution.

I do have an idea to handle this. Instead of showing a form option for each seperate attribute, it would show a dropdown offering all permutions of attribute. This way we could check stock on each permutation and show or not show it depending on its stock.

Something like this: http://ajax.zervaas.com.au/examples/Countr...yRegionCityJax/ would probably work..

Quote:

---

Originally posted by bettysue@Feb 1 2006, 01:59 AM
Nice site Audra! Unique, well organized, and pleasing to the eye! In other words....I'm jealous...lol

b

---

Thanks, I needed that! Still so much to do and so much to learn about how to do it!

Quote:

---

Originally posted by chad@Feb 2 2006, 08:30 PM
Something like this: http://ajax.zervaas.com.au/examples/Countr...yRegionCityJax/ would probably work..

---

I've got to say, this certainly seems like the ideal way to go. Myself, I am a programming ignoramous. Is this "AJAX" that afx114 referred to earlier?

Audra

Quote:

---

Originally posted by longstockings@Feb 2 2006, 10:11 AM
If possible I would prefer it if it showed the attributes with the amount in stock in brackets. If a javascript alert could be shown or something before the customer gets to the shopping cart I think that would be better.

We need to show when something is out of stock but also make sure that the option cannot be picked from the dropdown.

What does everyone else think?

---

It would *really* help if you bothered to read the entire thread and saw that the request has already been made and the reasons for it not happening explained. Asking for it again.. ISN'T going to get it done any faster.

Quote:

---

Originally posted by afx114@Feb 2 2006, 05:32 PM
This is tricky to do, it either requires a page reload whenever an attribute is picked (to check stock), or some sort of AJAX solution.

I do have an idea to handle this. Instead of showing a form option for each seperate attribute, it would show a dropdown offering all permutions of attribute. This way we could check stock on each permutation and show or not show it depending on its stock.

---

The dropdown with the different permutations would work.. except for two things

a) it's a freaking nightmare for the customer in terms of usability (imagine 4 different attributes.. that's a lot of combinations...).
B) it's require modification of the core source files.. the add to cart function would be .. kinda hard to mess with imo.

AJAX on the other hand would work decently well as you could have a seperate ajax.php file which will handle the stock lookup. To degrade gravefully, you could put the existing code now between some noscript tags and have it work.

I've been searching the forums and I can't seem to find the answer ... or at least the one I'm hoping for. I though I'd ask here since you all are attribute experts ;)

Is it possible to display a list of products by the value of an attribute? For example, if I assign a size attribute to a product, is there any way for me to list all products available in size 6?

I just don't think doing this through category linking is a good approach.

Quote:

---

Originally posted by gyrm@Feb 9 2006, 05:49 AM
I've been searching the forums and I can't seem to find the answer ... or at least the one I'm hoping for. I though I'd ask here since you all are attribute experts ;)

Is it possible to display a list of products by the value of an attribute? For example, if I assign a size attribute to a product, is there any way for me to list all products available in size 6?

I just don't think doing this through category linking is a good approach.

---

Nope.. not possible

Here's an addition that will display the actual stock amounts for each attribute next to the attribute name. You can see it in action on this product in my store.

Open includes/modules/pages/product_info/main_template_vars_attributes.php and make the following changes:
Replace

Code:

---

    $sql = "select  pov.products_options_values_id,
            pov.products_options_values_name,
            pa.*
        from  " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov
        where  pa.products_id = '" . (int)$_GET['products_id'] . "'
        and    pa.options_id = '" . (int)$products_options_names->fields['products_options_id'] . "'
        and    pa.options_values_id = pov.products_options_values_id
        and    pov.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
        $order_by;

---

by

Code:

---

    $sql = "select  pov.products_options_values_id,
            pov.products_options_values_name,
            pwas.quantity,
            pa.*
        from  " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " pwas
        where  pa.products_id = '" . (int)$_GET['products_id'] . "'
        and    pa.options_id = '" . (int)$products_options_names->fields['products_options_id'] . "'
        and    pa.options_values_id = pov.products_options_values_id
        and    pwas.stock_attributes = pa.products_attributes_id
        and    pov.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
        $order_by;

---

Next, in that same file replace:

Code:

---

    if ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_FILE or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_TEXT or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_CHECKBOX or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_RADIO or $products_options->RecordCount() == 1 or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY) {
      $products_options_value_id = $products_options->fields['products_options_values_id'];
      if ($products_options_names->fields['products_options_type'] != PRODUCTS_OPTIONS_TYPE_TEXT and $products_options_names->fields['products_options_type'] != PRODUCTS_OPTIONS_TYPE_FILE) {
      $products_options_details = $products_options->fields['products_options_values_name'];
      } else {
      // don't show option value name on TEXT or filename
      $products_options_details = '';
      }
      if ($products_options_names->fields['products_options_images_style'] >= 3) {
      $products_options_details .= $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
      $products_options_details_noname = $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
      } else {
      $products_options_details .= $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
      $products_options_details_noname = $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
      }
    }

---

by

Code:

---

    if ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_FILE or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_TEXT or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_CHECKBOX or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_RADIO or $products_options->RecordCount() == 1 or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY) {
      $products_options_value_id = $products_options->fields['products_options_values_id'];
      if ($products_options_names->fields['products_options_type'] != PRODUCTS_OPTIONS_TYPE_TEXT and $products_options_names->fields['products_options_type'] != PRODUCTS_OPTIONS_TYPE_FILE) {
//      $products_options_details = $products_options->fields['products_options_values_name'];
// gbm - replaced original line above to display attribute stock amount beside attribute
      $products_options_details = $products_options->fields['products_options_values_name'] . ' [' . $products_options->fields['quantity'] . ' '. TEXT_ATTRIBUTES_PIECES . ']';
      } else {
      // don't show option value name on TEXT or filename
      $products_options_details = '';
      }
      if ($products_options_names->fields['products_options_images_style'] >= 3) {
      $products_options_details .= $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
//      $products_options_details_noname = $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
// gbm - replaced original line above to display attribute stock amount beside attribute
      $products_options_details_noname = ' [' . $products_options->fields['quantity'] . ' '. TEXT_ATTRIBUTES_PIECES . '] ' . $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '<br />' . $products_options_display_weight : '');
      } else {
      $products_options_details .= $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
//      $products_options_details_noname = $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
// gbm - replaced original line above to display attribute stock amount beside attribute
      $products_options_details_noname = ' [' . $products_options->fields['quantity'] . ' '. TEXT_ATTRIBUTES_PIECES . '] ' . $products_options_display_price . ($products_options->fields['products_attributes_weight'] != 0 ? '' . $products_options_display_weight : '');
      }
    }

---

Then open includes/languages/english/your_template/product_info.php and add the following line:

Code:

---

define('TEXT_ATTRIBUTES_PIECES','pieces');

---

Repeat for all languages in your store.