Stocks by attributes

DivaVocals:

Of all the many modifications to SBA, this is one of the few mods that I always thought SHOULD be a part of SBAs core..

I agree...

creinold:

Word!!! LOL Thanks DivaVocals... Took the words out of my mouth.
Had to say it.. I appreciate your efforts.. It's always astounding to me that there's this expectation that free open source software donated by the efforts of others is supposed to be EQUAL to commercial software.. :no:

I had a HORRIBLE man recently approach me on my personal email and he got psycho postal with me because I told him that I would not answer support questions regarding free add-ons (in this case Edit Orders) outside of this forum.. He was upset and acted like I was SUPPOSED to answer his question. Ummmmm no... Like most folks who volunteer to maintain these add-ons, you do it when your time permits (and usually because you are updating it for a client anyway..)

@diva and creinold

I do kind of agree with a previous psoter who said that the threads on SBA are deeply confusing. I know that this is not your fault. Basically I think the versions of SBA are deeply confusing.

But it would be interesting to know what version of SBA you are dealing with here, Creinold. Some of what you are talking about does not exist in the version I use. And I really had very little issues ( apart from admin visibility obviously) in adapting that version to use with 1.5. I'll look and see what version that is.

creinold:

URL don't work. Also not sure what you are asking?

Originally Posted by wyocraft
Hello All, I cant be the first person with this problem, but here it goes.

OK so lets say I have 2 items in-stock, I add 3 to the cart and then I view the cart, there is no warning that the qt in my cart is more then the amount in-stock. Currently my cart is set to prevent checkout if items are out of stock and when you checkout it bounces back to the same page with no warning what so ever. Now if I assign an attribute to the item and try to check out it shows a warning.

Link to original thread:

http://www.zen-cart.com/forum/showthread.php?t=175661&page=2

Stock by attribute is messing up the error message in the shopping cart. You can only see the not enough stock warning on items with stock by attribute. This thread I posted above explains the whole situation.

I can not get this working. If nothing else, can someone PLEASE tell me how to uninstall this mod safely. I lost two more orders this morning because they could not check out!

I am using version 1.4.13 in zen 1.3.9h

Will this uninstall work:

@gsdcypher, If you're using the current version, 4.7, then running the following SQL should neuter it
Quote:
**DROP TABLE products_with_attributes_stock;
DELETE FROM configuration where configuration_key = "STOCK_SHOW_LOW_IN_CART"; **

Thank you for your time.

niccol:

@diva and creinold

I do kind of agree with a previous psoter who said that the threads on SBA are deeply confusing. I know that this is not your fault. Basically I think the versions of SBA are deeply confusing.

and you will get no argument from me.. I said as much in the "other" SBA support thread..

http://www.zen-cart.com/forum/showthread.php?t=47180&page=144

It's not that I don't appreciate what creinold is doing.. I REALLY do.. He's not obligated to share, and the fact that he is willing to do so with a version others have liked and used is terrific..

However, I was still hoping that whomever took on updating SBA for v1.5 would consider taking the extra step of combining the three variants of SBA into one solid functional add-on. I think that fixing and incorporating the HALF WORKING Dynamic Dropdowns makes good sense..

The fragmentation over the years of this add-on makes it a nightmare for shopowners. (eg: this feature works in one version, but not that version.. It's a hot mess!!!) The multiple support threads are a bloody mess to follow..

I have identified what looks like three variants to this mod

1. Stock by Attributes
2. Stock by Attributes 4.7Multiadd WITH TABLE FILTER 1.6
3. StockByAttributes with my stock id MOD 1.0.0
   Creinold's version (from what I can tell) is now yet a forth variant of SBA..

I looked at the three versions in the downloads section. Some of the differences could have been added as an admin configurable option for others who needed the same functionality without requiring the creation of YET ANOTHER completely separate SBA mod. (like the addition of part numbers as part of the product variants)

Other variants of SBA have included similar alleged "one-off" features that I believe also could have been made admin configurable options without splitting off as a new variant.

The fact that this support thread is LITTERED with posts from different variants of this one mod, the fact that there are MULTIPLE threads covering SBA "support" is a testament to how this code fragmentation has become problematic. People say they are using the latest version, but WHICH version is the one they are using the latest version of??? There are bugs in each one of these versions, some carried over from the versions they are based on, and some are new bugs introduced in the enhanced features that these versions bring..

With that said... there is an error in my last alpha version in the sql file. I forgot to put an insert --->

INSERT INTO `configuration` VALUES (1286, 'Disable drop down menu when stock equals zero', 'sba_zero_disable ', 'true', 'Set drop down menu to automatically disable when the attribute quantity equals zero:', 9, 6, '2010-07-25 15:29:27', '2010-07-25 14:44:56', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

I fixed the tpl_module_attributes.php issue. Now I am working on getting the functions_lookups.php working. Once I fixed that file I will upload the next alpha version.

One of the real problems with SBA is that each version works with an older version of zen-cart. Then someone tries to add it to a new version of zen-cart which as we know breaks stuff. Especially security fixes, etc. My codes have always used the latest zen-cart codes with the add-ons. I merge the files with the newest zen-cart releases. Not just overwrite the new zen-cart fixes with old files. **That why I am saying my version only works with 1.5.0. **

Now the old files has issues also, this mod was an oscommerce mod ported over to zen-cart. A lot of mistakes were made porting it over. Such as missing "quotes" > brackets, queries, whitespacing issues, etc... and those same mistakes were ported over to each version of SBA mods because they were never fixed. Some of the mod versions were simple updated to make them work with other mods, such as Numnix Fast and Easy Checkout.

Other mod added a simple column so you can add stock product ID number. (Which needs to be expanded to be actually being more usefully in my opinion. IE: could be used for Google product search queries) but the same mistakes are still made and then you have to read through 20 different post to figure out the fixes.

My version has all the fixes and a few more. Hopefully it'll be the last promising version (doubtful) before zen-cart 2.0 comes out. Since I won't have time to support it. Since I am doing this for only one client till I move her off zen-cart to this other cart I am using. This will be my last version and hopefully the best one.

Now I am just sharing my codes so all you can reap from this. I do not plan to make it an official version add-on. So if someone else wants to take my final version when done and submit it to the add on section. Feel free...

:clap:

EC web:

Link to original thread:

http://www.zen-cart.com/forum/showthread.php?t=175661&page=2

Stock by attribute is messing up the error message in the shopping cart. You can only see the not enough stock warning on items with stock by attribute. This thread I posted above explains the whole situation.

I can not get this working. If nothing else, can someone PLEASE tell me how to uninstall this mod safely. I lost two more orders this morning because they could not check out!

I am using version 1.4.13 in zen 1.3.9h

Will this uninstall work:

@gsdcypher, If you're using the current version, 4.7, then running the following SQL should neuter it
Quote:
**DROP TABLE products_with_attributes_stock;
DELETE FROM configuration where configuration_key = "STOCK_SHOW_LOW_IN_CART"; **

Thank you for your time.

To remove add-on you must all replace any files that have been overridden by the 1.4.14 with the original zen-cart 1.3.9 files.

Did you go through the 500 support threads for all the misc. fixes. The real issue is there a lot of bugs in those files.

creinold:

One of the real problems with SBA is that each version works with an older version of zen-cart. Then someone tries to add it to a new version of zen-cart which as we know breaks stuff. Especially security fixes, etc. My codes have always used the latest zen-cart codes with the add-ons. I merge the files with the newest zen-cart releases. Not just overwrite the new zen-cart fixes with old files. **That why I am saying my version only works with 1.5.0. **

Now the old files has issues also, this mod was an oscommerce mod ported over to zen-cart. A lot of mistakes were made porting it over. Such as missing "quotes" > brackets, queries, whitespacing issues, etc... and those same mistakes were ported over to each version of SBA mods because they were never fixed.Which is why I've watched with KEEN interest ALL OF YOUR WORK on this add-on..

Because thus far you seem like the ONLY modifier/maintainer to date who's actually tried to FIX this mod and get it back to being as cool and stable as Kuroi's last release of SBA vesus putting a bandaid on a bullet wound so to speak to get it to "look" like it works or getting it to "kinda work", or even settling for "it works good enough"..

creinold:

Some of the mod versions were simple updated to make them work with other mods, such as Numnix Fast and Easy Checkout.

Other mod added a simple column so you can add stock product ID number. (Which needs to be expanded to be actually being more usefully in my opinion. IE: could be used for Google product search queries) but the same mistakes are still made and then you have to read through 20 different post to figure out the fixes.I agree.. I also though that the feature SHOULD have been an admin option so those who need it can use it versus adding a field in a parallel version of the SAME broken add-on..

Plus fixing an add-on SOLELY to work with another add-on while leaving it still half functioning is not "helpful" IMHO.. :no: I appreciate that free mods are volunteer efforts, but I guess I'm just a stickler for attention to details 'tis all..

creinold:

My version has all the fixes and a few more. Hopefully it'll be the last promising version (doubtful) before zen-cart 2.0 comes out. Since I won't have time to support it. Since I am doing this for only one client till I move her off zen-cart to this other cart I am using. This will be my last version and hopefully the best one.

Now I am just sharing my codes so all you can reap from this. I do not plan to make it an official version add-on. So if someone else wants to take my final version when done and submit it to the add on section. Feel free...

:clap:If it's as good a version that it sounds like it is, with all the bugs worked out AND it's v1.5 compatible, I'll probably submit it for ya.. I'm upgrading a client to v1.5 and frankly this mod is a HUGE stumbling block. We were thinking about turning it over to an outside developer, but I can wait for your version.. :yes:

creinold:

To remove add-on you must all replace any files that have been overridden by the 1.4.14 with the original zen-cart 1.3.9 files.

Did you go through the 500 support threads for all the misc. fixes. The real issue is there a lot of bugs in those files.

Found the solution!

http://www.zen-cart.com/forum/showthread.php?p=1106796&posted=1#post1106796

Post # 1466

Thank you!

EC web:

Found the solution!

http://www.zen-cart.com/forum/showthread.php?p=1106796&posted=1#post1106796

Post # 1466

Thank you!

Sweet! Glad you got it to work. :smile:

I just installed this on Zen Cart v1.5 & it's working fine so far. The only thing is it is not showing up anywhere in the admin menu. Did I miss something? :)
To pull up the 'products with attributes' page, just point your browser to yoursite.com/your_admin/products_with_attributes_stock.php

Another thing for those who may overlook it. You have to rename the admin folder in the archive to match the name of your admin folder.

Thank you so much for the update on this!:clap:

yeah read this page I am working on a fix :

http://www.zen-cart.com/forum/showthread.php?t=47180&page=148

Newest Alpha test version:

http://www.zen-cart.com/forum/showthread.php?p=1109282#post1109282

I have installed your new version of stock by attributes 1.5 and it works perfectly!

But I want to know 1 thing is it possible to show my customer the stock level!
Now it only shows that the product is available and if it is not available it marks "out of stock" in the drop-down menu. But I want my customer to see how many products of a type I have in stock.

Khonsracing:

I have installed your new version of stock by attributes 1.5 and it works perfectly!

But I want to know 1 thing is it possible to show my customer the stock level!
Now it only shows that the product is available and if it is not available it marks "out of stock" in the drop-down menu. But I want my customer to see how many products of a type I have in stock.

It does not have that feature built in. Maybe one day It'll be added. The functions are there for it. Just need to be queried and called from the sql database and displayed in the dynamic drop down codes...

creinold:

It does not have that feature built in. Maybe one day It'll be added. The functions are there for it. Just need to be queried and called from the sql database and displayed in the dynamic drop down codes...

Ok thanks!

Another question. In all the drop-downs my customer can see if a product have stock! But if I have a product that doesn't have an option like size or something else so now drop-down menu.
My customer can't see if a product have stock and he also can't see if a product is out of stock!
Is it possible to let my customer see if I have stock? Or that the product is market "out of stock" when I don't have stock?

all drop-downs will work as normal but if one has qty attached to it and it is out of stock, it will show (out of stock or backorder.. etc) next to it in the drop down. Wording depends what you set it as in the stock configuration.

creinold:

all drop-downs will work as normal but if one has qty attached to it and it is out of stock, it will show (out of stock or backorder.. etc) next to it in the drop down. Wording depends what you set it as in the stock configuration.I think Khonsracing's asking what I want to know too..

Does your SBA version work with products that don't have drop-down attributes (ie: no attributes or checkbox attributes or radio button attributes)

DivaVocals:

I think Khonsracing's asking what I want to know too..

Does your SBA version work with products that don't have drop-down attributes (ie: no attributes or checkbox attributes or radio button attributes)

Yes that is what I want to know!!

Sorry if my english is not so good hihi :blush:

No that is still broken. Only dropdown works at the moment. (old dynamic drop down issues.) My client only uses dropdowns. So didn't try to fix the radio button/checkbox attributes issue of Dynamic Drop Downs. I'll try and look into it if I have a chance. No Promises... ;)