Stocks by attributes

[the44chris]

Thanks for the reply limelites.

As of now, I just have the site running on my localhost. It is just a stock install of zencart though, with easypopulate and stock by attributes installed.

The pre-installed zencart item I was trying to get it to work with was the "Hewlett Packard - by attributes SALE" product with the color and memory attributes. So for example with that product I would like something similar to the following html:

<table>
<tr> <th>Color</th> <th>Memory</th> <th>Units in Stock</th></tr>

<tr> <td>Blue</td> <td>4mb</td> <td>15</td></tr>
</table>

...and etc. for the rest of the possible attribute combinations.


Just to list the availability, no radio buttons or anything for selection of items in the list.

Thanks again
-Chris

[limelites]

Chris, I'm not sure why you want this, it seems the built in ability to use a drop down menu which lists all the available attributes in the drop down list would be easier for the customer to use and would certainly save space.

The simplest way to list the attributes would of course be to enter them in the description of the item using an HTML table.

That's the way I do it on my own site, I enter a table in the description for each product and if it's available in other sizes and/or colours then I just mention it in the ad.

How you would get php scripts to generate a list of available attributes and insert them in the description is going to be tricky. Each item would have differently sized lists, different headings too, so where would you put the list exactly?

As for 'Quantity in stock', this display can be turned on or off from the admin area at Admin> Catalog> Product Types> General Products> Edit Layout> Show Quantity in Stock Display Quantity in Stock on Product Info to 1..... For this to work though, you need to make sure when you're listing each product that you set Product Qty Maximum: to 0 (unlimited).

[robrem]

I recently installed Zen Cart and have made some changes to customize it to my needs, including installing the Cherry Zen add on. I've created a test product and a real product with attributes. I just tried to install stock by attributes but when I go to the catalog tab "Products with attributes: does not show up. Obviously I've messed up something in the installation - any ideas on how to troubleshoot this?

[robrem]

Hey, You can ignore the previous post. I went back through and compared my uploads and found a file placed in the wrong folder. I tried again and the tab showed up but could not find the page, another round of comparing and I found another file that just didn't upload for some reason. After looking through this thread I'm curious if I will have some of the O/S display problems others have had or if the newest version (4.6) fixed it.

[the44chris]

Thanks again for the reply limelites,

My main problem with the current setup is that you cannot display the quantity in stock of a particular attribute, rather, it adds up stock from all of the attributes and displays that total, which is almost useless in my opinion.

I thought of creating a table that displays the stock of each individual attribute combination so that a company can login and immediately see if we have available stock of that particular combination without the need of entering it into the cart to see if it's in stock.

The chart could also be used by the company selling the product to a customer to recommend a smaller size or different color if the desired size and color is out of stock with all of the information in front of them.

I think displaying something like this would be easier than figuring out how to update that Qty display you are referring to to show specific stock of a combination of attributes. I was hoping to just create a "select * from... echo...while blah blah" command right after the unordered list that appears on the product page.

Thanks

[DivaVocals]

I am using the "Stock by Attributes v4.7 (MULTIADD)". My client is using the product variant feature to track inventory as she has products with multiple combinations of attributes to track stock for.
For example:
size=S color=Pink -- Qty in stock = 3
size=M color=Pink -- Qty in stock = 5

This mod is is working JUST FINE for her.. However, it would be nice to refine the customer's experience just a little.

I've read through this whole thread and the other "Stock by Attributes" thread as well, and I have ONE question. I have seen several posted solutions to NOT display attributes when there is no available stock for that ONE attribute, and I have seen a few solutions to display the quantities of available stock for individual attribute.

What I do NOT see (and need to confirm that it does not in fact exist) is a way to apply this sort of logic to product variants. I would like for example to not allow the customer to add a particular product variant to the cart at all if it is not in stock.

Currently I have the following settings under Configuration > Stock:

Check stock level = true
Subtract stock = true
Allow Checkout = false
Mark product out of stock = ***
Stock Re-order level = 5
Show available stock level in cart when less than order = true
Products status in Catalog when out of stock should be set to = 0
Show Sold Out Image in place of Add to Cart = 1

Now this works OKAY to notify customers that the product variant they requested is out of stock or let's them know how many are in stock if they selected more than what's available. However, the customer doesn't know this until after they add the product variant to their cart.

It would be nice to notify the customer before they add the product to their cart. Did I miss this?? Has someone already posted a solution that allows me to prevent a variant from being added to the cart or better yet lets the customer know before they click "Add to Cart" that the variant they want is not in stock.

[DivaVocals]

Just another thought.. Is there a way to display on the product details page what the administrator sees in "Stock by Attributes" admin. In other words, is there a way to display the available variants shown in the admin section?? (in a grid or tabular format would be ideal) Then one could choose whether or not to display ALL variants or only the ones in stock currently.

For example: Here's what I see for one particular product.
Length: 16"
Size: 3.5" x 4"
Texture: Kinky Straight
Quantity Available = 0

Length: 18"
Size: 3.5" x 4"
Texture: Kinky Straight
Quantity Available = 0

Length: 16"
Size: 3.5" x 4"
Texture: Fresh Relaxed
Quantity Available = 0

Length: 18"
Size: 3.5" x 4"
Texture: Fresh Relaxed
Quantity Available = 0

Length: 16"
Size: 3.5" x 4"
Texture: Fresh Relaxed X^2
Quantity Available = 0

Length: 18"
Size: 3.5" x 4"
Texture: Fresh Relaxed X^2
Quantity Available = 0

Length: 16"
Size: 3.5" x 4"
Texture: Straight
Quantity Available = 0

[DivaVocals]

My main problem with the current setup is that you cannot display the quantity in stock of a particular attribute, rather, it adds up stock from all of the attributes and displays that total, which is almost useless in my opinion.

I thought of creating a table that displays the stock of each individual attribute combination so that a company can login and immediately see if we have available stock of that particular combination without the need of entering it into the cart to see if it's in stock.

I shoulda read your post a little more carefully.. It looks like you and I are asking for the same thing..

Chris, I'm not sure why you want this, it seems the built in ability to use a drop down menu which lists all the available attributes in the drop down list would be easier for the customer to use and would certainly save space.

That's easy.. When you are tracking your stock by a combination of attributes, the drop down lists displaying the quantity of each attribute won't work as the stock is being tracked by a combination of attributes. (see the example I posted above)

The simplest way to list the attributes would of course be to enter them in the description of the item using an HTML table.

Of course we could create a table for each product, but this is a NIGHTMARE to manage. It is difficult even when you have a few products (let alone the store owners with HUNDREDS or even THOUSANDS of products to manage) all with multiple possible attribute combinations.

How you would get php scripts to generate a list of available attributes and insert them in the description is going to be tricky. Each item would have differently sized lists, different headings too, so where would you put the list exactly?

While I don't know PHP, I don't think that either Chris or I are looking to do anything terribly fancy here.. We can already view what's available for each product variant in the admin, would it really present a technical challenge (for someone who knows how to do this of course..) to include that information on the product details page??

[the44chris]

Diva,

Exactly what I was thinking. An html table in the description would in fact be a nightmare to manage, such is the appeal of a dynamically generated php one.

I think that I could even figure this out with my VERY limited knowledge of php, it would just take me a very long time and I would pretty much be starting only with my knowledge of html.

-Chris

[DivaVocals]

Exactly what I was thinking. An html table in the description would in fact be a nightmare to manage, such is the appeal of a dynamically generated php one.

Absolutely.. While this is not the BEST solution, I do think it's the simplest way to get to what we are seeking.

IMO doing anything else (while desirable) is tantamount to a serious re-write of this add-on. With Zen Cart v2.0 having much more advanced inventory management features, a re-write of this mod would seem to be a bit of a time waster. So for me I'll go for the low hanging fruit.. (especially since it would solve my issue) Exposing the available inventory for products which are tracked by a combo of more than one attribute on the product detail page will solve my problem just fine.. A little CSS magic, and we can make this solution quite nice..

I think that I could even figure this out with my VERY limited knowledge of php, it would just take me a very long time and I would pretty much be starting only with my knowledge of html.

-Chris

I wish I was as confident as you! I know WHAT needs to be done.. I'm just not sure know HOW to do it.. But I'm willing to mess around and see if I get lucky.. If I can't guess at a solution, then I am willing to seek "professional" (AKA paid) assistance..