Stock by Attribute v4.0 addon for v1.3.5-1.3.9

[raspberryjamcloth]

How do I remove this mod? I want to change to the other stock by attributes mod.

[echotasha]

I installed this attribute and it was working PERFECTLY! And now I don't know what happened . . . Even though I have stock available, my cart won't allow checkout.

My settings are as follows:

[echotasha]

Ok I solved my problem and I wanted to share.

We are using zen cart 1.3.8. My customer had added products to her website and added the attributes and updated her stock levels. The problem happened because one of the attributes was a read only size chart. For some reason (anyone have any ideas?) the cart didn't recognize that the products had any stock available for the products that had the size chart as one of its attributes.

However, simply deleting the read only attribute didn't solve the problem. I had to delete the original variant and REDO each variant for each stock item to make it work finally. FRUSTRATING! But so far very happy with the result that this fab attribute works again.

EchoTasha

[laeta904]

Zen Cart v1.3.8a
Mod v4.7

Error Message when try to checkout from shopping cart:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':f7073744a0abbb14cef2678c8463e53a LIMIT 1' at line 1
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 106:f7073744a0abbb14cef2678c8463e53a LIMIT 1]

This happens when the cart includes any product that has attributes (besides read-only attributes, those do not create this error).

Any idea what might be going wrong?

[kuroi]

How do I remove this mod? I want to change to the other stock by attributes mod.

Replace the six files listed in the readme with copies of the originals from a fresh download of Zen Cart. Delete the other files that come in the Stock by Attributes release pack and ignore the database changes as they will be rendered inert by putting the files back into their original state, though if you wanted to your could drop the
products with attribute stock table using a tool such as phpMyAdmin.

[kuroi]

Zen Cart v1.3.8a
Mod v4.7

Error Message when try to checkout from shopping cart:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':f7073744a0abbb14cef2678c8463e53a LIMIT 1' at line 1
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 106:f7073744a0abbb14cef2678c8463e53a LIMIT 1]

This happens when the cart includes any product that has attributes (besides read-only attributes, those do not create this error).

Any idea what might be going wrong?

Nothing to do with Stock by Attributes I'm afraid. A default installation of Zen Cart does not have products_length, products_width and products_height, and Stock by Attributes doesn't add them. So they are being introduced by some other mod that you have installed, which is then confusing product IDs with the variants used when attributes are attached to them. But which mod this is I don't know.

[laeta904]

Nothing to do with Stock by Attributes I'm afraid. A default installation of Zen Cart does not have products_length, products_width and products_height, and Stock by Attributes doesn't add them. So they are being introduced by some other mod that you have installed, which is then confusing product IDs with the variants used when attributes are attached to them. But which mod this is I don't know.

Hmmm...I don't have much experience, since I just started building my site this month, so I didn't know exactly where to look. But with that explanation of the error, it sounds like it might have something to do with the "Auction Site Attributes" mod. Thanks so much for your help, I will go search on that thread.

[laeta904]

Hmmm...I don't have much experience, since I just started building my site this month, so I didn't know exactly where to look. But with that explanation of the error, it sounds like it might have something to do with the "Auction Site Attributes" mod. Thanks so much for your help, I will go search on that thread.

Finally realized it was an issue with the Fedex module. Recent update at the end of July seems to have fixed the problem.

[kuroi]

Finally realized it was an issue with the Fedex module. Recent update at the end of July seems to have fixed the problem.

That would make sense. A shipping module might have need of the dimensions that were causing the problems. Thanks for posting back with the solution. That may help others who run across the same problem.

[laurenjj]

I have a problem that MAY be able to be fixed in a similar way that the google and paypal issues were able to be fixed, but I have no idea.

I've got a sort of 'wishlist' type thing at my store that sits next to the 'Add to Cart' button, but allows people to, instead of clicking 'Add to Cart' they click 'Add to List'. I also have SbA installed and working fine. My problem is that the javascript that checks for those items to indeed be instock when using the 'Add to Cart' button, isn't there for the 'Add to List' button, so this means that empty options are allowed to pass through and rather than that attribute option showing up like it would if you clicked 'Add to Cart' you get the blank 'TEXT' option or a blank one. And while no one can actually purchase this item, it also means that someone can add items to a list that aren't in stock.... so my question is, is there anyway to use the same javascript function that checks the stock when you click 'Add to Cart' and apply it to the 'Add to List' button?