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

Sorry if this is an inappropriate post, but I am desperate to get this mod working correctly.

I am looking to hire someone who is confident in being able to correct this mod on my site.

There seems to be a lot of things wrong. The save button doesn't work when loading the quantity in admin(this is the less important issue)

The big issue is it allows checkout of items no matter the stock status. Also once the item is in the cart it only shows the parent product name it does not show the attribute name.
Please PM me if this is something you think you can fix.

site link - http://gator1736.hostgator.com/~peimei/

You need to re-send your SQL patch for this mod. Parts are missing from your database.

I have reinstalled those tables so many times now.

I actually fixed the table error with the save button. It was because I had a prefix and one of the files with the mod was not setup to see the prefix. So I removed the prefix from my tables hoping it would cure all my issues. It only fixed the save button

I have hired 2 people over the weekend to fix my problem. Both have failed.

I have asked them to just take both SBA and dynamic dropdown off and do a complete reinstall, but i don't think either did this.
I would do it myself but I am alittle scared to mess with the databases and remove the table entries for those mods.

Whats frustrating is it worked when I first installed it. I don't understand what went wrong. I know everyones favorite answer is it was installed wrong, but I have gone over the files atleast 5 times. Checking the version id on the top of the phps. All of them match, I have removed all the files and reinstalled them numerous times.

mysh:

I have reinstalled those tables so many times now.

I actually fixed the table error with the save button. It was because I had a prefix and one of the files with the mod was not setup to see the prefix. So I removed the prefix from my tables hoping it would cure all my issues. It only fixed the save button

I have hired 2 people over the weekend to fix my problem. Both have failed.

I have asked them to just take both SBA and dynamic dropdown off and do a complete reinstall, but i don't think either did this.
I would do it myself but I am alittle scared to mess with the databases and remove the table entries for those mods.

Whats frustrating is it worked when I first installed it. I don't understand what went wrong. I know everyones favorite answer is it was installed wrong, but I have gone over the files atleast 5 times. Checking the version id on the top of the phps. All of them match, I have removed all the files and reinstalled them numerous times.

Dynamic dropdown seems to really create problems when used with SBA. I have read post that would disagree, but it does cause problems.
Try removing the Dynamic Dropdown files and just use SBA. Don't worry about the database files, they can remain but just won't be used.

Yes I finally removed it and started making progress. I think I have everything working well now and I even paid someone last night who wrote a code so SBA without dynamic would still show the out of stock text next to the OOS items in the dropdown

SInce I asked so many questions here and some of the info in this thread helped get me to the point I am now. Once I launch I will write up the steps i took to maybe help save someone else hours or days of messing around

mysh:

Yes I finally removed it and started making progress. I think I have everything working well now and I even paid someone last night who wrote a code so SBA without dynamic would still show the out of stock text next to the OOS items in the dropdown

SInce I asked so many questions here and some of the info in this thread helped get me to the point I am now. Once I launch I will write up the steps i took to maybe help save someone else hours or days of messing around

On your web sit you have E-Liquid 10ML 0MG
Flavor
SpearmintOut of Stock
StrawberryOut of Stock
If you have SBA properly installed and are showing a zero stock level for this attribute, the choice will not display to the customer in the dropdown list. You can still click on this and add it to your cart (with warning messages of course).

For the most part this is how I want it. I don't want the out of stock items to disappear from the dropdown. I prefer they stay in the dropdown with the out of stock text.

The perfect scenerio would be to have a pop up warning come up when someone tries to add a out of stock item, but I'll settle for the warning in the cart for now. Most people won't add a item that clearly states out of stock next to it(i hope)

I have a zen install running 1.3.8a with SBA installed -- this addon has not been updated in several years. Please tell me how to determine what version of SBA is installed? I seem to have downloaded all updates but cannot determine which one I am currently running :oops:

Took a chance and upgraded step by step from 4.7 to 4.10 and I am THRILLED with the improvements. HOWEVER, the SAVE button does not seem to work after changing multiple stock quantities? Am going to pour back through this thread to see if that's already been addressed.

Then my next (long overdue) adventure will be (finally) updated to ZC 1.3.9 ...

aly22:

Took a chance and upgraded step by step from 4.7 to 4.10 and I am THRILLED with the improvements. HOWEVER, the SAVE button does not seem to work after changing multiple stock quantities? Am going to pour back through this thread to see if that's already been addressed.

Then my next (long overdue) adventure will be (finally) updated to ZC 1.3.9 ...

The fix is here
http://www.zen-cart.com/forum/showthread.php?p=1068750&highlight=save#post1068750

Pablo:

The fix is here
http://www.zen-cart.com/forum/showthread.php?p=1068750&highlight=save#post1068750

Hi Pablo,
I actually tried that "fix" earlier -- I was able to click the "Save" button -- but got the following error:

1146 Table 'mysite_zc1.products_with_attributes_stock' doesn't exist
in:
[UPDATE products_with_attributes_stock SET quantity = '17' WHERE products_with_attributes_stock.stock_id =55 LIMIT 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have run the sql update for version 4.10 through admin and am unable to re-load the sql as the table already exists. Not sure what to try next. Am I missing something about this error message?

Ok, I tried again by making the change referenced in your link: http://www.zen-cart.com/forum/showthread.php?p=1068750&highlight=save#post1068750
by editing the file admin/products_with_attributes_stock.php
This makes the "save" button clickable

But I still had the above-mentioned error.
Found a fix for that here: http://www.zen-cart.com/forum/showpost.php?p=1005389&postcount=1035
by editing admin/includes/classes/products_with_attributes_stock.php

This seems to work now ... I was able to update quantities and click save (and it saved).

Its likely because you have a prefix. There is another fix you need to apply if you are using prefix on your databases.
Or you can drop the prefix off all your databases.

I don't remember what file needs to have the correction but it is referenced in this thread

Right, mysh -- I think that's what I did.
I added the prefix zen_ to line 227 in admin/includes/classes/products_with_attributes_stock.php

using code recommended by kuroi:
$sql = "UPDATE " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " SET quantity = '$value' WHERE stock_id =$id LIMIT 1";

and that resolved the error.
My SBA seems to be working now, at least as far as being able to use the "save" button and update multiple quantities at once.

NEW QUESTION: Does anyone also use Zen Lightbox with SBA Ajax version? I'm having an issue now where my lightbox popups are showing up blank! I do not know whether this is a related issue or something I failed to notice was broken before today.

It doesn't appear that this mod was incorporated into v1.5.0, any plans to verify / port it to work with 1.5.0?

Thanks,

--Ron

I am currently modifying this add-on to include a unique part number for each stock variant. I think I have seen other people asking for this feature. This will allow me to sync the Zen product quantities with my internal inventory control system quantities via SQL command line tools and a scheduled task. I'm not a PHP programmer, but I'm pretty good at hacking up existing code to make it do what I want. I have the bulk of it done but have hit a wall. If anyone wants to jump in and help finish it up, I'll be glad to share what I've done. The unique part number exists, I can add the part number in the Admin, the number displays in the admin and cart. I can't figure out how to carry the part number through the rest of the checkout process and put it on the invoice...

Added field to products_with_attributes_stock table:

Modified the Admin module to include populating this field:

Modified the Admin module to show this field:

Modified tpl_shopping_cart_default.php to display the part number:

Thanks,

--Ron :frusty:

rhuseby would that allow me to make specials for a specific attribute?

Sometimes I just want a certain attribute on sale and rightnow I can only see how to make the parent product as a whole on sale

No, I am only modifying it to have a unique part number for each variant of an item. I'm sure someone could modify it for you for $...

--Ron

Hi.
Some of my items are suddenly showing up as Sold out, with stock 0 in the shop.
This happens only to some products, and all but 1 or 2 of the items are used in stock by attribute page.
Any idea why this happens?
Is there an issue with products_with_attributes_stock.php?
I've added a .htpasswd to the admin directory in hope of preventing this from happening.

Cheers

Endre

Not sure if this is the correct place to post but I have been searching the forums for information and this is the only one that comes close.

I am using Zen cart 1.3.9h (new install)
and have installed SBA 1.4.13
view here trial site

I have a problem trying to figure out how to use only one attribute for tracking the stock of an item with several attributes

I have a specific shirts and hoodie of 1 color for a product then I have attributes for size, if it is personalized, where it is personalized, and what name.

I am given 6 variations (in SBA) per size when all I am trying to track is the number in stock for a particular size as the other attributes are done after the order is made.

the old saying size does matter.. :blush:

So am I doing something wrong or does this module not handle this type of scenario. If not can someone recommend one that does? or a process I can follow to correct this.

Thank you in advance.

Gary