Stock For Product With Different Attributes (OLD)

Oh! I don't think of the combination of the attributes.
Then a table lists all the combination will be better. But the table may be quite large.

audradh:

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.
I have to agree with greenteagod's point, though he didn't state it as I believe he meant: with this module, a customer is allowed to add items to the cart when the store is out of stock in that product/attribute combination. Without this module, ZC can be configured to disallow adding of a product when that product is out of stock.

As a customer, I want to be told a product is unavailable before I go to buy it. Don't waste my time by allowing me to add something to my cart that isn't available. Think like a user, make the store user-friendly. (More on user-friendly here.)

mrtoner:

I have to agree with greenteagod's point, though he didn't state it as I believe he meant: with this module, a customer is allowed to add items to the cart when the store is out of stock in that product/attribute combination. Without this module, ZC can be configured to disallow adding of a product when that product is out of stock.

As a customer, I want to be told a product is unavailable before I go to buy it. Don't waste my time by allowing me to add something to my cart that isn't available. Think like a user, make the store user-friendly. (More on user-friendly here.)
Again, that's not possible without extensive modifications of the core scripts.

You have to add it to your cart first before knowing it is out of stock.

Example: Size and color.

Let's say you have a matrix like this

Blue big - 0
Blue Small - 5
Green big - 5
Green small - 0

Now... there are two dropdowns. Customer selects Big. How would the system know to disable Green? The only way for that to happen would be either a page refresh (and a db query) or some use of AJAX. That's a pretty big addition.

dafonz:

Again, that's not possible without extensive modifications of the core scripts.
...
The only way for that to happen would be either a page refresh (and a db query) or some use of AJAX. That's a pretty big addition.
Agreed and agreed. Landing on the mooon was tough, too. Don't get me wrong: I like your contribution. I just would like to have it all. B)

Perhaps you and milosh (who seems to have solved the issue for individual product/attribute combinations) can work together to get something working for multiple combinations.

Is there a way to call the stock information of the attributes to be displayed on the page? Wether or not you can actually disallow a customer to add it to the cart, there should be a way to access the information about the stock per attribute, no?

mrtoner:

As a customer, I want to be told a product is unavailable before I go to buy it. Don't waste my time by allowing me to add something to my cart that isn't available. Think like a user, make the store user-friendly.
Probably the best thing you can do then to make it user frienclly is to have your cart configured so that when an item is added it immediately takes you to the cart. The customer will then have the added key stroke of having to delete the item, but the knowledge is immediate. When the customer hits "Continue" from this page it takes them back to the page they were on, OK 2 extra key strokes. My cart was already set up this way, which is probably why I couldn't get my brain around what was being asked :)

Best,
Audra

Has anyone installed this in a 1.2.5 store or is it only for 1.2.6?

Thanks,
Ryan

**Let's say you have a matrix like this

Blue big - 0
Blue Small - 5
Green big - 5
Green small - 0

Now... there are two dropdowns. Customer selects Big. How would the system know to disable Green? The only way for that to happen would be either a page refresh (and a db query) or some use of AJAX. That's a pretty big addition.**
I wld like to make a suggestion, is it possible do the followings:

1. display 1 attribute first (eg. Size attribute)
2. user select a particular size (eg. Big)
3. auto refresh page (and a db query), display the 2nd attribute (Color in this case), which in this instance, the 2nd attribute display only "Green" since "Blue" is out of stock for size "Big".

Just sharing my thought, not sure how challenging programmatically that is.

Great mod. dafonz.

Has anyone used this mod in conjunction w/ the Quick Updates mod?

Audra

stupid question. really stupid.

where on earth do i create this table? in a text file? where do i put it? :blink:

missyenta:

stupid question. really stupid.

where on earth do i create this table? in a text file? where do i put it? :blink:
It is a table you need to insert into your database?

Has this mod been updated with the code addition on the first page and any changes mentioned up to now?

I am also curious if this will work with Quick updates/Easy Mod before I install it and break something (old habits die hard...lol)

b

I'm trying to do step #1 in the readme:

Installation

First things first, you will need to make a table. Assuming you have zen_ as a prefix for your tables, the following mysql code will work. Otherwise, modify zen_products_with_attributes_stock accordingly.

You do know of course that what you have put together here is what they call the "Holy Grail" of e-commerce? Aka Inventory by attribute multi-tiered. It has been sought after by clothing stores and others for nearly a decade. Which in Internet years is a Millenium.

However I have to put my $0.02 into this one. Especially since it is the Holy Grail for me as well.

First it needs to be modified to use the overrides system. Looks like that can be done with some simple structure changes and I may have that done soon.

Secondly the zen cart attributes/options system does lack and is EXTREMELY confusing. Sorry folks but comparing it to other carts it really is. While this extension is taking place I would suggest adding a attributes wizard to this contribution so that attributes and their options can be created from a single screen or maybe two. This wizard could then post creating the attributes and options and forward the customer to the variants page for editing of the variants if they wish.

Consider that the "Arc of the Covenant" and my $0.02.

Cheers,

BigWil

missyenta -

All that means is if when you installed Zencart, is you installed it with the function of adding the prefix "zen" to your database then you can install the sql as is.

If you installed it without the prefix (like I do), then you need to change:

zen_products_with_attributes_stock to products_with_attributes_stock

b

bettysue:

I am also curious if this will work with Quick updates/Easy Mod before I install it and break something (old habits die hard...lol)

b
I'm also hoping someone out there may be using this in conjunction with Quick Updates.

Anyone?

Best,
Audra :)

hmmm... if I added this mod to my doorknobs site how long would it take to enter all the possible product combinations?

Take one product for example: a simple doorknob set can have:
1 of 4 functions
1 of 2 backsets
1 of 2 door handings
1 of 15 outside finishes
1 of 15 inside finishes
1 of 36 outside knobs/levers
1 of 36 inside knobs/levers
1 of 12 rosettes on outside
1 of 12 rosettes on inside
too many choices to figure out on my fingers, but the trusty old calculator says that's a total of 671,846,400 possible combinations. Damn good thing they're made to order: I wouldn't want to have even one of each possible combination in stock...

whoops - i left part out. this is the code to make the table (follows the text I pasted in the last message):

CREATE TABLE zen_products_with_attributes_stock (
stock_id INT NOT NULL AUTO_INCREMENT ,
products_id INT NOT NULL ,
stock_attributes VARCHAR( 255 ) NOT NULL ,
quantity INT NOT NULL ,
PRIMARY KEY ( stock_id )
)

I know that this table needs to be created, just don't know how or where to do so ;)

thanks for your help so far, i really appreciate it!!

Go to Tools > SQL Patches and drop this into the big field there:

CREATE TABLE products_with_attributes_stock (
stock_id INT NOT NULL AUTO_INCREMENT ,
products_id INT NOT NULL ,
stock_attributes VARCHAR( 255 ) NOT NULL ,
quantity INT NOT NULL ,
PRIMARY KEY ( stock_id )
);

That should fix you right up. The key is to not use the zen_ in the SQL Patches tool as it will always add the table prefix required per its config file.

Also you were missing the ; at the end.

BigWil

whee, added the prefix that i somehow, for some reason have been using and it works like a charm. this should go into the readme, for folks who are as un-enlightened as myself :)

thanks a bunch bigwil!!