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

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

[potteryhouse]

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.

[nigelt74]

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

[whitsolltd]

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

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

[potteryhouse]

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/i...9040418AAGvbXz

[Kevin205]

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/i...9040418AAGvbXz

Thanks for reply and information.

[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!

[DivaVocals]

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

[Christian_Wagner]

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!