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

Zen 1.5.1
SBA 1.5.2

Two parts here

Part One

I am struggling to understand this mod, I have read the old Wiki and the install instructions and it had been working okay-ish on the site for a while now

Do I need to set a quantity on every attribute?
This particular site has a large number of products with 4-6 options on them and each of these options has 4-5 values under them
The thing is for most of these options we are unlikely to ever run out of stock, there are only a few of the options that we need to have stock control on,
I had naivly assumed that if I didn't set a quantity on a particular variant it would be ignored stock control wise

currently what seems to be happening is that I am having to manually enter quantities for every variant of every product which is slow going, especially when we add 15 products in a hit.

nigelt74:

Zen 1.5.1
SBA 1.5.2

Two parts here

Part One

I am struggling to understand this mod, I have read the old Wiki and the install instructions and it had been working okay-ish on the site for a while now

Do I need to set a quantity on every attribute?
In version 1.5.2 this may be the case, should not be that way in version 1.5.3

This particular site has a large number of products with 4-6 options on them and each of these options has 4-5 values under them
The thing is for most of these options we are unlikely to ever run out of stock, there are only a few of the options that we need to have stock control on,
I had naivly assumed that if I didn't set a quantity on a particular variant it would be ignored stock control wise

currently what seems to be happening is that I am having to manually enter quantities for every variant of every product which is slow going, especially when we add 15 products in a hit.

In the Instructions folder there is a script file 'Optional.sql' (the script in version 1.5.3 has more information and options, suggest you read the new script and have a look at the change log to see what updates were made in 1.5.3) the script will create all the attribute combinations for you, it will use the quantity assigned to the product as the default for each attribute. You can use the query 'manually' just copy the version you need from the file 'Optional.sql' and remember to test, test, test, on a sample database first before using on a active site. Note, read, do not run, the entire file it has a lot of info, you can open it with any text editor.

Also, the version 1.5.3 has a helper function, you can export all your SBA attributes to a '.csv' file, than edit the file (only change quantity and cumstonid fields) and import changes, again make sure you test on a 'test copy' of you database. Guidance is in the instructions folder.

I have recently started looking at an update of this mod to support Zen cart 1.5.3, so suggestions are always welcome. The new version will have many changes and improvements (so I think anyway) when I have a version for others to test I will post here for feedback, help with testing is appreciated.

The problem i was having was that unless i set a quantity for every variant the product would be out of stock, and when i set quantities on one option it seemed to delete the other options, even reinstalling SBA 1.5.2 didn't work

However when I updated to the latest version of the mod SBA 1.5.3,
(excellent and much improved readme by the way),
everything appears to work exactly as it should, I don't need to set quantities on options that don't need them

tflmike:

Hi, is there any plans of getting this mod updated / ported to work with the latest version of Zen Cart 1.5.3 or is it already compatible?

I'd like to second this. I have a new install of Zen Cart 1.5.3 and on replacing the 'general.php' file, the website fails with a blank page. This is also after merging the code. Is there a solution for this as yet?

Thanks

For some reason fields **stock_attributes **and **customid **in zen_products_with_attributes_stock table have latin1_swedish_ci as their Collation. Can this be changed to utf8_general? If changed, would it damage any existing data in the table?

Kevin205:

For some reason fields **stock_attributes **and **customid **in zen_products_with_attributes_stock table have latin1_swedish_ci as their Collation. Can this be changed to utf8_general? If changed, would it damage any existing data in the table?

Hi,
The install script does not set any type of char Collation or encoding.

I suspect you upgraded an old table / database that has latin1 set as the default Collation.

In the past I have used phpMyAdmin (normally part of your web sites hosting account, http://en.wikipedia.org/wiki/PhpMyAdmin) to change the database and table Collations, you might try that on a test database to ensure nothing gets damaged.

have a look at this post
https://answers.yahoo.com/question/index?qid=20090319040418AAGvbXz

potteryhouse:

Hi,
The install script does not set any type of char Collation or encoding.

I suspect you upgraded an old table / database that has latin1 set as the default Collation.

In the past I have used phpMyAdmin (normally part of your web sites hosting account, http://en.wikipedia.org/wiki/PhpMyAdmin) to change the database and table Collations, you might try that on a test database to ensure nothing gets damaged.

have a look at this post
https://answers.yahoo.com/question/index?qid=20090319040418AAGvbXz

Thanks for reply and information.

Hello again Potteryhouse!

Have you had any users mention products being incorrectly purchased for free? I cannot replicate the issue because it happens at random but I have many screenshots of orders in which customers ordered a product and wasn't charged for it. There was no coupon or discount being run. There is no pattern to these occurrences. Customers would add a product to the cart and it randomly would be marked as "FREE."

Any suggestions as to what might cause this?

Thanks!

Christian_Wagner:

Hello again Potteryhouse!

Have you had any users mention products being incorrectly purchased for free? I cannot replicate the issue because it happens at random but I have many screenshots of orders in which customers ordered a product and wasn't charged for it. There was no coupon or discount being run. There is no pattern to these occurrences. Customers would add a product to the cart and it randomly would be marked as "FREE."

Any suggestions as to what might cause this?

Thanks!

Given the purpose of SBA (managing product stock), I sincerely DOUBT that this module is the cause of your issue..

DivaVocals:

Given the purpose of SBA (managing product stock), I sincerely DOUBT that this module is the cause of your issue..

Yea, that's what I thought but I had to ask. Thanks! :( :no:

whitsolltd:

I'd like to second this. I have a new install of Zen Cart 1.5.3 and on replacing the 'general.php' file, the website fails with a blank page. This is also after merging the code. Is there a solution for this as yet?

Thanks

Its not compatible with Zen Cart version 1.5.3 yet, the author is working on it and other improvements as he finds the time. There are incompatibilities in the database queries because of recent changes from MySql to MySqli in the latest version of zencart which is a performance improvement and allows for better compatibility with current and future versions of Php.

Hi all,

Need some testers for this update, please only use/test on a development system, not a live site!

I have posted the updated SBA mod, this one is only usable with Zen Cart 1.5.3, this is due to the many changes that are specific to the new version.

I made updates and tested on a locally installed copy of Zen Cart 1.5.3, there are still a number of changes and additions I would like to make but I think it would be good if others tested this version and provided feedback on problems they encounter.

DO NOT use on a production site, this is for testing only. There are bugs I have not seen!!!
If anyone has suggestions to add or update in the instruction please send them so I can incorporate.

[Attachment no longer available]

Changes / Updates

1. All affected files have been merged with Zen Cart 1.5.3 version.
2. Updated to the attributes.php file for getting attribute quantity and to support a new feature "change image on select" in a selection list.
3. Database table now has two additional fields, product_attribute_combo and title. These are to support future planned changes.
4. Many other smaller updates to improve user interface.
5. Installation script has many updates, and now supports installing the various "Optional SQL" command, also the Help screen notes have been updated. Additionally, the 'File Check" has been updated to find old/obsolete files from previous versions (user must manually remove files).
6. The AJAX folder has been removed, files are now located in the "includes\templates\YOUR_TEMPLATE\jscript" and admin folders as applicable.

Please provide feedback, with examples, screenshots, and explanations when you find problems. This is so I can more quickly duplicate the issue and make the update.

In the mean time I will be making a few other updates and fixes as I find them.

Thanks.

Excellent. I'll take a look and report back

I have just installed Stock By Attribute v1.5.3 and see no place to add number in stock. What am I doing wrong?

Malaperth

Malaperth:

I have just installed Stock By Attribute v1.5.3 and see no place to add number in stock. What am I doing wrong?

Malaperth

That's your Attribute Controller. In your ZenCart admin, go to Catalog ----> Products With Stock Attribute (SBA) and you'll be able to enter your stock there.

Best of luck!

Christian_Wagner:

That's your Attribute Controller. In your ZenCart admin, go to Catalog ----> Products With Stock Attribute (SBA) and you'll be able to enter your stock there.

Best of luck!

My apologies as the search function leaves a lot to be desired. I followed your instructions (and I feel a bit stupid for not looking there, but, what is, is). Now I have all the drop-down menus with the variants showing where they are supposed to, but all the items show "Out Of Stock". I am rather sure that this question has been asked/answered before, but reading 192 pages worth of material when the vast majority of it pertains to v1.3.9 (approximately) makes my head spin. Soooooo... How do I get the stock to show correctly? As in, some of the choices in the drop-down may actually be out of stock but most are not, but the entire product shows out of stock... Again, I have a feeling I'm going to feel stupid once I get the answer, but I need people to be able to order what is in stock in the drop-down and "Out Of Stock" to show what has a stock of 0. I apologize in advance for being a dense old man that hasn't coded for about 20 years and I very much appreciate your help.

Mal

Malaperth:

My apologies as the search function leaves a lot to be desired. I followed your instructions (and I feel a bit stupid for not looking there, but, what is, is). Now I have all the drop-down menus with the variants showing where they are supposed to, but all the items show "Out Of Stock". I am rather sure that this question has been asked/answered before, but reading 192 pages worth of material when the vast majority of it pertains to v1.3.9 (approximately) makes my head spin. Soooooo... How do I get the stock to show correctly? As in, some of the choices in the drop-down may actually be out of stock but most are not, but the entire product shows out of stock... Again, I have a feeling I'm going to feel stupid once I get the answer, but I need people to be able to order what is in stock in the drop-down and "Out Of Stock" to show what has a stock of 0. I apologize in advance for being a dense old man that hasn't coded for about 20 years and I very much appreciate your help.

Mal

Click "Sync Quantities" and you're good!

Christian_Wagner:

Click "Sync Quantities" and you're good!

I did as you suggested and am now halfway there (Thank you!)... It does show items in stock, but the variants that really ARE out of stock show that they are in stock.

Mal

Well, since I couldn't edit my last post, here is some more information. After the customer adds the out of stock item (which shows IN stock on the product page) to the shopping cart, it does show that the item is out of stock. However... My customer wants the items to remain listed there to show what they used to have in stock, but if they have 50 flavors of candy, and 48 of them are out of stock, by about the 10th try at adding an item to the cart that insinuates it IS in stock on the product page, they're going to be pretty frustrated and quite possibly leave. Is this the way Stock By Attributes is supposed to work that it shows in stock on the product page but out of stock in the shopping cart?

Mal

Can you share your irl?

This is how it should look:
http://shopasgoodasgold dot com/index.php?main_page=product_info&cPath=4_5&products_id=9