Stock For Product With Different Attributes (OLD)

mrtoner:

If you're using phpMyAdmin, in my experience you need to 1) select the database, 2) click the SQL tab, 3) paste the query into the "Run SQL query/queries on database yyy" field, and 4) click "Go." If I'm reading your post correctly, you did two of those steps out of order. (I'm using phpMyAdmin 2.6.4-pl2.)
Thanks!

I did what you wrote, and it seems i've already created the database, but when i click on the "Products with Attributes Stock" in admin, I don't see the table, only the heading:"Product ID, Product Name, Quantity of all variants, Add Quantity For Product Variant,Sync Quantities". I have products with attributes, but they don't show!
What am i doing wrong?
Thanks
::frust

Taflloyd,
Let me begin by saying that I am an idiot about all of this stuff! I did get this working, however, and know how it feels to be waiting for a response to your query :)

I assume you have uploaded all of the files in the module?

Have you actually gone into MySQL and looked at the table that you created? You can compare the table to the code. When you look at the table it will make sense, what should go where, but yell if you want to double check anything.

Do you have products w/ 2 different attributes per product? I don't know if that matters, but I do know that products w/ no attributes will not show up.

Hope that gives you a place to start,
Audra

Taflloyd:

I did what you wrote, and it seems i've already created the database, but when i click on the "Products with Attributes Stock" in admin, I don't see the table, only the heading:"Product ID, Product Name, Quantity of all variants, Add Quantity For Product Variant,Sync Quantities". I have products with attributes, but they don't show!
What am i doing wrong?
?? The database is your Zen Cart database, not one you create. The query adds an additional table to that database (assuming you selected it). I assume you do not have the new table added to your Zen Cart database.

I love this module!!

I have run into a bit of trouble. I am sure that it is user error, but I can't seem to troubleshoot it. I had 2 products that were set to zero quantity. I added in one of each. When I add the items to my cart I get the out of stock message. I check the Products-With-Attributes-Stock in the admin, and it says there is one each of these items. Hmmm. I have tried emptying my cart and starting over, but same thing. I have zeroed out the amount then reentered it. I have refreshed all pages.

Any thoughts?

Best,
Audra

Taflloyd:

Thanks!

I did what you wrote, and it seems i've already created the database, but when i click on the "Products with Attributes Stock" in admin, I don't see the table, only the heading:"Product ID, Product Name, Quantity of all variants, Add Quantity For Product Variant,Sync Quantities". I have products with attributes, but they don't show!
What am i doing wrong?
Thanks
::frust
Ya gotta add stocks for each one.. so..click on "Add quantity for product Variant" and go from there

mrtoner:

Rather prolific tonight, I am. What functions from functions_lookups.php do I need to put into an override file (which would go in /includes/functions/extra_functions)?
Can't quite do that as I rewrote a core zen function

audradh:

I love this module!!

I have run into a bit of trouble. I am sure that it is user error, but I can't seem to troubleshoot it. I had 2 products that were set to zero quantity. I added in one of each. When I add the items to my cart I get the out of stock message. I check the Products-With-Attributes-Stock in the admin, and it says there is one each of these items. Hmmm. I have tried emptying my cart and starting over, but same thing. I have zeroed out the amount then reentered it. I have refreshed all pages.

Any thoughts?

Best,
Audra
Not quite following...

So you have a single product that has two variants with quantities of zero? Then you update the two variants to have quantities of one?

dafonz:

So you have a single product that has two variants with quantities of zero? Then you update the two variants to have quantities of one?
OK, morning is here and my brain is a bit clearer. I did a little more testing, and at least found out what the trouble is.

I sell clothing, so my standard 2 variants are size and color.

Often I have an item in stock only in one color, but in multiple sizes.

Size is a dropdown w/ multiple variants.

Color shows in the catalog as a radio button (standard default for dropdown if only one variant is given), and the value has been marked as the default in attributes.

In this case, the items are showing as out of stock.

Any thoughts now?

TIA,
Audra

So does this module not prevent someone from ordering something that is out of stock? When one of the items is at 0 stock someone can still select it as it just says X items in stock where X is the total of whatever you have. Then that items inventory goes negative. Is there anyway to correct that?

This can be done in admin area:

Configuration->Stock->Allow Checkout

That works with or without this module.

HTH,
Audra

I don't think you understood what I was asking.
If you have 50 red balls 50 green balls and 50 white balls it's going to say you have 150 of them. Someone orders 50 red balls and now you have 100. The problem with this module is since it shows you still have stock they can order an item that is sold out. So since you have 100 balls left even though there are no red ones they could order 100 of them if they wanted to because it just says you have 100 and not 0 red 50 green 50 white.

That is what happens w/ Zen Cart as is. This module changes it so that it will check the stock based upon the attributes. There is a contribution by Milosh that will do the same based upon only one attribute per product. This module can handle products w/ multiple attributes.

As an aside, it seems to me that if you use this module it makes sense to turn off, in admin, the option of showing how many are in stock because it is misleading to the customer.

HTH,
Audra

Why would one choose to let someone purchase something that is out of stock. In the end it would only serve to frustrate the buyer. If you show the numbers or not it doesn't stop someone from ordering something you don't have.

greenteagod:

If you show the numbers or not it doesn't stop someone from ordering something you don't have.
As I said, that was just an aside.

The meat of the issue here is what I said originally:

Customers can be prevented from checking out w/ out of stock items by choosing that option in the admin area:

Configuration->Stock->Allow Checkout

That prevents customers from checking out when the stock quantity is zero with or without this module.

Without this module it will look only at that total number in stock. In your example #150. The setting would be useless as you stated.

With a module that tracks inventory by attribute you would have entered into your inventory 50 red, 50 green, 50 white. When Zen looks to see what the stock level is for red balls it will see 50, not 150. When there are zero red balls left, if you have configured the settings noted above, the customer will not be able to check out if there is a red ball in their cart.

::frust

Audra

audradh:

I sell clothing, so my standard 2 variants are size and color.

Often I have an item in stock only in one color, but in multiple sizes.

Size is a dropdown w/ multiple variants.

Color shows in the catalog as a radio button (standard default for dropdown if only one variant is given), and the value has been marked as the default in attributes.

In this case, the items are showing as out of stock.

Any thoughts now?

TIA,
Audra
After a little more troubleshooting I have determined that this is not the problem.

Now I am pretty sure that the problem is thus:

The module is working for all but one manufacturer. When products from this manufacturer are order they show up as out of stock despite having quantitiies entered in the product by attribute stock.

The module was iniitlally working, but now is not.

I have subsequently installed this module:

Column Layout Product Listing for Zen Cart v 1.2

Could this be the trouble?

Audra

Another change:

It is not the manufacturer either. I found a product from a different manufacturer that is not working correctly as well. I can't figure out the difference between the few products that are working correctly and the rest!

They seem to span
categories,
manufacturers,
quantity in stock,
with model# and without model#
2 choosable attributes vs one chooseable and one default

Any ideas about what other differences I might be able to look at?

Audra

OK, I have found the responsible variant and fixed the problem, but I don't know why it happenned.

I had a text only/read only attribute attached to a lot of my products. It was the products w/ this option name that were not being accurately accounted in the inventory.

I think it could have been one of two things: either the text only/read only nature of the attribute option was a problem or the fact that this added a 3rd attribute to the product was the trouble.

I don't have time to test it out right now (getting my inventory back up and running took more time than my kids had allotted me as it is!), but I will try and check it out later if nobody else can shed light on it before then.

I don't remeber da'fonz saying that the module could only handle 2 attributes, but I may be mistaken.

HTH someone,
Audra :)

other problems:
If I set the attributes as Multi-select, and want to order 2 pcs of the items for each attributes (i.e. 3 colors, red, green, blue). Then I input 2 in the quantity box and put in the shopping cart.
I suppose that it will show a quantity with total 6pcs in the shopping cart but it only shows 2 pcs and can't distinguish the quantity among the 3 colors.
Besides, it is better to show the quantity besides the attribute on the product_info page.

audradh:

OK, I have found the responsible variant and fixed the problem, but I don't know why it happenned.

I had a text only/read only attribute attached to a lot of my products. It was the products w/ this option name that were not being accurately accounted in the inventory.

I think it could have been one of two things: either the text only/read only nature of the attribute option was a problem or the fact that this added a 3rd attribute to the product was the trouble.

I don't have time to test it out right now (getting my inventory back up and running took more time than my kids had allotted me as it is!), but I will try and check it out later if nobody else can shed light on it before then.

I don't remeber da'fonz saying that the module could only handle 2 attributes, but I may be mistaken.

HTH someone,
Audra :)
I believe it was the text only/read only nature of the attribute. It works just fine with 3 dropdown selects and the code should support an unlimited number of attributes.

xingxing:

Besides, it is better to show the quantity besides the attribute on the product_info page.
That doesn't work...pretend you have this on your page

Size
Big - 40
Light - 20

Color
Green - 30
Blue - 30

So how many of each variant do you have?