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

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

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:

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

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?

raspberryjamcloth:

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.

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?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.

kuroi:

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.

laeta904:

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.

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?

Hi,

I'm using the current version of zencart and and thinking about installing this mod - however I have been using zencart for a while now and have a large product catalouge already set up (with many attributes...hence my need for this mod!)

If I installed this would I need to re enter all of my products that have attributes? And if not what would happen to those products that already exist with attributes?

Thanks,
Emma

PS my site is at www . butterfly - babies . co . uk

laurenjj:

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?

I would have thought that there were some advantages to customers being able to add out of stock products to a wishlist as then it would make it easier for them to buy them once back in stock? I suppose the only problem would be if you aren't planning on replenishing stock?

Best wishes, Emma

ButterflyBabies:

I would have thought that there were some advantages to customers being able to add out of stock products to a wishlist as then it would make it easier for them to buy them once back in stock? I suppose the only problem would be if you aren't planning on replenishing stock?

Best wishes, Emma

Hi Emma...
The problem is that right now, if you go click "add to cart", if you haven't chosen ANY options, you get the following alert:
Attachment #6254
and are then forced to make actual options which then adds them to your cart.

Now if you were at that same page but instead of clicking "add to cart" you clicked "Add to Registry", you wouldn't get an alert, and non-options would be added as show here:
Attachment #6253

There is no 'TEXT' option so I'm assuming this is just the default...it SHOULD look like this:
Attachment #6252

Hi Lauren,

I can see what you mean - it is confusing for the customer. I've not started with this module yet so haven't got an answer for you . Good luck!

Emma

hello everyone! Hope this isn't answered somewhere in this topic... to many pages to search through..

I have a client that is having a problem and this is what he sent me in an email... could someone shed some light on this for me and lead me in the right direction?? Much thanks in advance!

Hi John the attribute issue that we are having
except for 1 attribute created in the attribute module all of the attirbutes were duplicated. the quantity on the new items was set to 3 on the dup items. we did not make any changes. Also the order is changing of the items. normally they stay in the order that they are entered but for some reason the cherry low goes into place with the marlboro grouping
Thanks

Originally I had a reply from kobra to install the 'Stock by Attribute' and I downloaded a module from the add-ons:
http://www.zen-cart.com/index.php?ma...roducts_id=310

It seems this is incomplete and not the correct module as it does not subtract stock from the attribute value when an item is sold.

Can anyone confirm the correct one to do this??

Nyone help with my previous posting??? thanks

ButterflyBabies:

If I installed this would I need to re enter all of my products that have attributes? And if not what would happen to those products that already exist with attributes?I can only speak for the plain 4.7 version, but with that no you wouldn't need to set anything up again, You would merely add stock to the attribute combinations for the products whose stock you wish to manage at that level.

johndiaz:

hello everyone! Hope this isn't answered somewhere in this topic... to many pages to search through..

I have a client that is having a problem and this is what he sent me in an email... could someone shed some light on this for me and lead me in the right direction?? Much thanks in advance!Not answered in this thread as your client appears to be referring to a problem with the structure of his attributes. This module does not touch the underlying attributes or their structure and so can't be the cause of the problem.

gprit:

Originally I had a reply from kobra to install the 'Stock by Attribute' and I downloaded a module from the add-ons:
http://www.zen-cart.com/index.php?ma...roducts_id=310

It seems this is incomplete and not the correct module as it does not subtract stock from the attribute value when an item is sold.

Can anyone confirm the correct one to do this??This problem can occur because the AJAX version is incomplete, or because of installation errors with the other versions. There's plenty of information about both repeated several times earlier in this thread.