Stocks by attributes

[kellan4459]

yes, am using a table prefix zen. Need to get the glasses fixed


Tried the revised SQL, and now the out-of stock items are masked from the selection menu, BUT, all selection menus for items that are not "stock by attributes" have the selection list truncated such that no selections are visible. Go to http://offlinestore.azbizp.com/index...products_id=83 for an example.

cropinstop and kev

I use the left join with mine and it works across all items with attributes whether they have their own stock value or not.

example of mine is at

http://www.zen-cart.com/forum/showpo...&postcount=559

[cropinstop]

Change by krazykev did not fix the problem, change by kellan4459 (post 559) seems to be working. Will do more testing offline to see if there are problems.

Thanks

[krazykev]

Cropinstop,

I guess you have the problem fixed but I would like to understand this better. I am quite new to Zen Cart, so wondered if you could elaborate on your statement

>BUT, all selection menus for items that are not "stock by attributes"

What kind of attributes are you using that do not use "stock by attributes" such that they don't get displayed?

Kev

[kellan4459]

Cropinstop,

I guess you have the problem fixed but I would like to understand this better. I am quite new to Zen Cart, so wondered if you could elaborate on your statement

>BUT, all selection menus for items that are not "stock by attributes"

What kind of attributes are you using that do not use "stock by attributes" such that they don't get displayed?

Kev

Kev
If I understand him correctly he is using his cart similar to the one I'm doing. In mine their are items that I will allow a qty of 20 no matter which attribute they select so I don't want to limit the cart to
qty 10 for attribute 1
qty 10 for attribute 2
I would prefer a qty 20 for the item as a whole so I could have
5 attribute 1
15 attribute 2
or vice versa

on the other hand I have other items where only so many per time slot so I want each attribute to have a limited qty. hope this makes sense.

[krazykev]

Hi Kellan,

you lost me a little. I understand what you are trying to achieve, but no idea how you would! So long as everything works I don't suppose it matters!

[kellan4459]

for example
we offer a cinderella visit offsite or onsite. The item has a qty of 1000 because it is unlimited. I don't care how many onsite or offsite visits so I want to use the product qty and not specify an individual attribute qty.

You can see the example at
http://www.tks-atl.com/index.php?mai...products_id=18



Then we offer things like Easter Bunny Pictures where each time slot has a maximum number available. Each time slot is a separate attribute with a qty set for the attribute rather than just the product. When a qty is set for the individual attribute I added code to show the available qty for the individual attribute.

You can see the example at
http://www.tks-atl.com/index.php?mai...products_id=68

Hopefully that clears it up a little and is what Cropinstop is also trying to accomplish

[cropinstop]

Concur with Kellan's analysis.

I have items in local inventory where I use stock by attributes to track the availability of each color, size, etc;, but also sell dropshipped items, where I set the quantity for the item, independent of color, to a high number to reflect a virtually unlimited availability (assuming of course my wholesaler does not go belly up in this economy)

[s58smith]

You can see the example at
http://www.tks-atl.com/index.php?mai...products_id=68

Hopefully that clears it up a little and is what Cropinstop is also trying to accomplish

I'm trying accomplish the exact same dropdown as displayed in the example above. I believe I modified the sql successfully on attributes.php.

My question is what php was changed to get the quanity to display inside the dropdown next to selection?

Thanks

[cropinstop]

Found a combination of attributes that still have a problem (and probably can't be fixed).

Have a product with two sets of attributes - color and size.
setup stock by attributes as follows:

green, small : qty = 10

green, large : qty=10

red, small : qty =10

red, large : qty = 0

When I order red, large, the item is added to the shopping cart with the note it is out of stock, but the sale can be completed as if stock was available.

"configuration:stock:allow checkout" is set to false.

The problem with being able to order out of stock merchandise existed before this fix, and may be a problem unrelated to Stock by Attributes. Ideally, the red/large combination should not be selectable at all.

[keithlaw]

http://eastgippslandsports.com.au/in...ckout_shipping

I get a blank page. Error tracking gives this error.

[19-Feb-2009 11:10:26] PHP Fatal error: Cannot redeclare class order in /home/eastgipp/public_html/includes/classes/order.php on line 20

I have checked the uploaded files and I can't see what the problem is. Can we get some help please