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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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?

Quote:

---

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

Quote:

---

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

---

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!

Quote:

---

Originally Posted by 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..

Quote:

---

Originally Posted by 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:

Quote:

---

Originally Posted by 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 14386

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?Attachment 14430

Malaperth

Quote:

---

Originally Posted by 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?Attachment 14430

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!

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by jeking

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

---

Here is the url: http://sweetsagescents.com/index.php...roducts_id=223

And all but 4 scents are out of stock (or supposed to be since I set the stock quantity to 0).

Mal

Check this file:
\includes\modules\YOUR_TEMPLATE\attributes.php

That's where the Out of Stock message is generated which is defined in:
\includes\languages\english\extra_definitions\products_with_attributes.php

Quote:

---

Originally Posted by jeking

Check this file:
\includes\modules\YOUR_TEMPLATE\attributes.php

That's where the Out of Stock message is generated which is defined in:
\includes\languages\english\extra_definitions\products_with_attributes.php

---

Ok, I admit that my PHP skills are damn near non-existant, but in the version of attributes.php that I am looking at, I see code for radiobuttons, checkboxes, and text areas but nothing for drop-downs. Do I somehow have the wrong version of the file or do I simple have no bloody clue what I'm looking for? (and thank you for your response and help! I appreciate it!)

Mal

Quote:

---

Originally Posted by jeking

Check this file:
\includes\modules\YOUR_TEMPLATE\attributes.php

That's where the Out of Stock message is generated which is defined in:
\includes\languages\english\extra_definitions\products_with_attributes.php

---

Ok, I admit that my PHP skills are damn near non-existant, but in the version of attributes.php that I am looking at, I see code for radiobuttons, checkboxes, and text areas but nothing for drop-downs. Do I somehow have the wrong version of the file or do I simple have no bloody clue what I'm looking for? (and thank you for your response and help! I appreciate it!)

Mal

Quote:

---

Originally Posted by Malaperth

Here is the url: http://sweetsagescents.com/index.php...roducts_id=223

And all but 4 scents are out of stock (or supposed to be since I set the stock quantity to 0).

Mal

---

It may be an issue of adding an item that already has a stock quantity of zero. The customer wanted to have all the scents of products shown, but shown "Out Of Stock" so people would know what was available. That may not work. I have deleted all the 'initial zero' products (the customer was NOT pleased), and now we will have to see what happens when an item sells out.

Mal

Seems my reply from earlier did not post...

with all due respect, I'd have to guess 'no bloody clue'. Check your PM.

Well, I now have it working as far as I know. We'll see what happens when a product reaches zero quantity.

But, I have another issue. The customer does not like the Qty: 4 that appears. Thinks it will be too confusing for customers of the site. So now I'm supposed to fit about the contents of War and Peace into that drop-down box. It may be code blindness or irritation, or as mentioned not having a bloody clue, but I cannot find the place to adjust the size of that particular drop-down box. I would appreciate a point in the right direction.

Mal

And thank you for putting up with an old fart with no patience and apparently less coding skills and helping me out.

It's set in the stylesheet.css, line 84:

FORM, SELECT, INPUT {
display: inline;
font-size: 1em;
margin: 0.1em;
}

Be aware changing this will also change other inputs.

Quote:

---

Originally Posted by potteryhouse

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.

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.

---

Nice job on the new plugin. Installation was a breeze!

1. One small language inconsistency. When adding adding a quantity for product variant. It says:

The Title will not be saved if "ALL" is selected.
The Title should be unique for each attribute and combination.
Description:

Title should be Description or vis versa.

2. I also noticed that what I fill in for Description does not show up when I click Submit. This may be part of the 'future planned changes' but wanted to mention in case it was a bug.

3. I get an error 'Missing or bad Quantity!' when trying to add a zero quantity. Attached is a screen shot. The item is from the default Zen Cart install, category 25, id 36, Hewlett Packard - by attributes SALE

Attachment 14444

Quote:

---

Originally Posted by jeking

Nice job on the new plugin. Installation was a breeze!

1. One small language inconsistency. When adding adding a quantity for product variant. It says:

The Title will not be saved if "ALL" is selected.
The Title should be unique for each attribute and combination.
Description:

Title should be Description or vis versa.

2. I also noticed that what I fill in for Description does not show up when I click Submit. This may be part of the 'future planned changes' but wanted to mention in case it was a bug.

3. I get an error 'Missing or bad Quantity!' when trying to add a zero quantity. Attached is a screen shot. The item is from the default Zen Cart install, category 25, id 36, Hewlett Packard - by attributes SALE

---

Thank you,
I found and corrected these bugs, the fix will be in the next draft I upload.

Thank you for the help, jeking. I would still be tearing my hair out if it was not for your help. And as far as adding a product with a zero quantity, what I have installed for Stock With Attributes simply refuses to list it whether I want it listed or not.

Mal

I don't understand your question. Can you clarify?

I thought you mentioned a zero quantity product in your last message. While adding products to the Stock With Attributes list so they can be used, if I try to add a product with a zero quantity, and in the section where you give a product a quantity to be displayed in the dropdown, when you look at the site, that product is not in the drop-down list, nor is it displayed as "Out of Stock", it simply is not there.

Mal

Quote:

---

Originally Posted by Malaperth

I thought you mentioned a zero quantity product in your last message. While adding products to the Stock With Attributes list so they can be used, if I try to add a product with a zero quantity, and in the section where you give a product a quantity to be displayed in the dropdown, when you look at the site, that product is not in the drop-down list, nor is it displayed as "Out of Stock", it simply is not there.

Mal

---

What are you doing when 'adding products to the Stock With Attributes list'? I'm guessing you are actually using 'Add Quantity For Product Variant'. If so, can you include a screen shot and the product url?

Not anymore. I deleted all the zero-quantity products I mentioned (I mentioned that in an earlier post). Try it for yourself and we'll then see if it's just something I did.

(at this point, it's no big deal as I've convinced the customer that showing every option for every product, even if it's out of stock, is going to annoy the hell out of site users so she decided it was ok not to show everything, but at least on my end, even if I wanted to, I cannot).

Mal

Quote:

---

Originally Posted by Malaperth

Not anymore. I deleted all the zero-quantity products I mentioned (I mentioned that in an earlier post). Try it for yourself and we'll then see if it's just something I did.

(at this point, it's no big deal as I've convinced the customer that showing every option for every product, even if it's out of stock, is going to annoy the hell out of site users so she decided it was ok not to show everything, but at least on my end, even if I wanted to, I cannot).

Mal

---

I'm not clear on what you did (deleted all the zero-quantity products - Deleting products is unrelated to this plugin) nor do I have a cart set-up like you did, so couldn't duplicate it anyway. Sorry.

"Deleting products is unrelated to this plugin"

So if I delete a product, the attributes stay? And the cart has nothing to do with the issue I describe. The products I have added through Stock By Attribute, if when I set them up with their quantities, if I input a quantity of zero, they do not show up in the drop-down menu of the product. But at any rate, it's mostly irrelevant now that I have convinced the customer she doesn't need to show every single variant of every single product she sells. And again, I thank you for your help.

Mal

Quote:

---

Originally Posted by Malaperth

"Deleting products is unrelated to this plugin"

So if I delete a product, the attributes stay? And the cart has nothing to do with the issue I describe. The products I have added through Stock By Attribute, if when I set them up with their quantities, if I input a quantity of zero, they do not show up in the drop-down menu of the product. But at any rate, it's mostly irrelevant now that I have convinced the customer she doesn't need to show every single variant of every single product she sells. And again, I thank you for your help.

Mal

---

The way this is designed if a product variant is out of stock it WILL NOT show up in the dropdown.. ONLY the variants which HAVE STOCK quantities associated with them will show in the dropdowns.. Is THIS what you are asking about??? (like jeking, I am not clear about what it is you are asking or saying the module is or is NOT doing..)

Quote:

---

Originally Posted by DivaVocals

The way this is designed if a product variant is out of stock it WILL NOT show up in the dropdown.. ONLY the variants which HAVE STOCK quantities associated with them will show in the dropdowns.. Is THIS what you are asking about??? (like jeking, I am not clear about what it is you are asking or saying the module is or is NOT doing..)

---

From my read of the discussion, I think the above summarizes "the issue". I think the misunderstanding of the plugin showing variants with a stock of zero originated from the discussion of the missing type casting done for quantity in the code provided for ZC 1.5.3 that was in essence pointed out and really only discovered when a value of zero is entered.

As for the possibility of showing variants or at least combinations of variants that are out-of-stock/quantity of zero, I believe there is another plugin that is considered compatible with this version of SBA that can provide a sort of cross reference (table like structure having rows and columns) for a combination of two attributes at a time. I believe this would present attributes/combinations of attributes that might otherwise be available and reflect that they are out-of-stock or similar. I think it is called grid by attribute or something similar. It may be that the store owner would need to add text into the description to identify the attributes that normally might be available and indicate that those missing from the list are not available or some similar wording. It's a thought/patch to the programming side.

Fyi and fwiw, the way that this plugin has been rewritten, unless every desirable combination of attributes is populated in the applicable database, a blanket, this is what is possible type query would result in a huge list as a result of the added functionality of being able to stock all the combinations of attributes associated with a product. (At least for a product that starts to have say three or more attributes with multiple values in each attribute name.)

In post 1920, jeking, I believe it was, gave a link to a site that showed certain variations of a product as "Out Of Stock". This one particular customer (until I talked her out of it) wanted to show every variety of every item she sold even if the stock level was zero so customers could see all the variations she offered. It seems that when an item has originally been entered into SBA with a quantity above zero, it will show in the drop-down as Out Of Stock once the stock has been sold. You cannot, it seems, enter a product into SBA, then when entering quantities, give it a value of zero and have it show up in the drop-down list. I convinced the customer that this was "ill advised" (not the wording I wanted to use) because it would irritate the hell out of a customer to have to look through 30 "Out Of Stock" items just to find out what the heck WAS in stock. There are situations where this would be useful, however. Let's say you're just starting up a T-shirt shop and we'll only stick with one attribute for the moment. Once you get the money, you will be offering sizes from 2T up to 4X, but at the moment all you have is small, medium, large, 1x and 2x. You may want to show the other sizes as choices listed as Out Of Stock since you will be selling them soon and don't want customers to think those are the only sizes you will offer. Now, that may be a lame example, and if you had lots of variations, that could get out of hand quickly and actually drive people away from your site, but, at the time, that is what my customer wanted and the option to do that was not there, that's all.

Mal

Maybe I didn't read enough of the documenatation (or possibly didn't read the right documentation), but I'm trying to figure out how to correct a system response that I was seeing using the beta version posted for Zc 1.5.3.

Product has two attributes, they are dependent on each other, meaning whatever is selected for the first attribute the identifies how what is available of the second attribute. (I'm sure that it could/would work the other way, that picking the second option updates the availability of the first). All available combinations of items have the additional id tied to them in the sBA table. The first option has four values, the second option also has four values When looking at the list of the first option, there are 16 items presented, each having the applicable additional model# field next to the designation. The site is locally hosted, so I do not have a link. The install was performed using the all option. No additional "optional" SQL queries were run.

In reading the immediately available on screen information, I was not able to determine if I needed to run one of the optional SQLs, nor was itclear to me if running the "all" install query included or excluded the optionl queries. I'm guessing that the response seen is expected, and that I need to run an additional optional query, if the documentation available with the otherwise latest copy downloadable from the plugins section (official copy) clearly states this, I fully apologize for askingthe question and will take due diligence to review and answer my own question. I'm wondering in the interim if someone knows the answer if they could help me out.

Thank you, and I am so glad that so much has been done to make this feature available to ZC.

Just installed the mod stock_by_attribute_1.5.3 on latest version of zen-cart. When I went to the domain/admin/stock_by_attr_install.php all I got was a blank page. Now I get the same blank page when I go directly to the admin section to login. What do I do now?

Quote:

---

Originally Posted by webmiss

Just installed the mod stock_by_attribute_1.5.3 on latest version of zen-cart. When I went to the domain/admin/stock_by_attr_install.php all I got was a blank page. Now I get the same blank page when I go directly to the admin section to login. What do I do now?

---

Blank page typically results in n error log in store/logs folder. Please provide with dmin directory information obscured.

Quote:

---

Originally Posted by webmiss

Just installed the mod stock_by_attribute_1.5.3 on latest version of zen-cart. When I went to the domain/admin/stock_by_attr_install.php all I got was a blank page. Now I get the same blank page when I go directly to the admin section to login. What do I do now?

---

Additionally, this plugin is not yet compatible with the 'latest version of zen-cart'. It's in the works though.

Quote:

---

Originally Posted by jeking

Additionally, this plugin is not yet compatible with the 'latest version of zen-cart'. It's in the works though.

---

Quote:

---

Originally Posted by mc12345678

Blank page typically results in n error log in store/logs folder. Please provide with dmin directory information obscured.

---

Doh! Yes, that is true. I thought there was something "off" about the version info, but I didn't chase it before posting.

Do you know how long it will be til a newer version is available? My client really needs this. And I am running zc version 1.5.3.

Quote:

---

Originally Posted by mc12345678

Maybe I didn't read enough of the documenatation (or possibly didn't read the right documentation), but I'm trying to figure out how to correct a system response that I was seeing using the beta version posted for Zc 1.5.3.

Product has two attributes, they are dependent on each other, meaning whatever is selected for the first attribute the identifies how what is available of the second attribute. (I'm sure that it could/would work the other way, that picking the second option updates the availability of the first). All available combinations of items have the additional id tied to them in the sBA table. The first option has four values, the second option also has four values When looking at the list of the first option, there are 16 items presented, each having the applicable additional model# field next to the designation. The site is locally hosted, so I do not have a link. The install was performed using the all option. No additional "optional" SQL queries were run.

In reading the immediately available on screen information, I was not able to determine if I needed to run one of the optional SQLs, nor was itclear to me if running the "all" install query included or excluded the optionl queries. I'm guessing that the response seen is expected, and that I need to run an additional optional query, if the documentation available with the otherwise latest copy downloadable from the plugins section (official copy) clearly states this, I fully apologize for askingthe question and will take due diligence to review and answer my own question. I'm wondering in the interim if someone knows the answer if they could help me out.

Thank you, and I am so glad that so much has been done to make this feature available to ZC.

---

Okay, I have reread the help page for the install (This still is applicable to the 1.5.x Beta version for ZC 1.5.3.) The optional SQL does not appear to offer a change of how the attributes are displayed. So, as I stated above, two attributes (option names), each attribute has four values. In the SBA catalog option have created a total of 16 pairings of attributes (one mixture of each pairing, no single attribute). So, let's say I have attribute #1 that has values of 1,2,3,and 4. attribute #2 has values a, b,c,and d.

Therefore I have 1a, 1b, 1c, 1d, 2a, 2b, etc... Each of those has a customid filled in. (For reproduction, technically the customid is a number or if type cast to a number would have the same "result") When I go to the product_info page, the first attribute listed is populated with in essence all available combinations...

See attached image, if able. :)

Attachment 14463

For other information, the first attribute (misspelled) has a lower option number than the second. The sort order numbers are in the same sequence.

The installation is a vanilla ZC 1.5.3 hotfix 1, with mysql database backup, display logs, and superglobals installed.

I have noticed that after I make a selection (using firefox) that there is an error that is reported regarding the onchange option. that selectItemImage is not defined... Potentially a typing error? missing space? (Action is called on line 51 of includes\functions\extra_functions\products_with_attributes.php) No additional upgrade of jquery has been made beyond what is included in the beta plugin. Internet search has not revealed a similar function yet. Will look to see if that function is covered in the official ZC available version of SBA 1.5.3, but thought I would report it if there is something to be addressed for overall functionality.

Quote:

---

Originally Posted by mc12345678

Okay, I have reread the help page for the install (This still is applicable to the 1.5.x Beta version for ZC 1.5.3.) The optional SQL does not appear to offer a change of how the attributes are displayed. So, as I stated above, two attributes (option names), each attribute has four values. In the SBA catalog option have created a total of 16 pairings of attributes (one mixture of each pairing, no single attribute). So, let's say I have attribute #1 that has values of 1,2,3,and 4. attribute #2 has values a, b,c,and d.

Therefore I have 1a, 1b, 1c, 1d, 2a, 2b, etc... Each of those has a customid filled in. (For reproduction, technically the customid is a number or if type cast to a number would have the same "result") When I go to the product_info page, the first attribute listed is populated with in essence all available combinations...

See attached image, if able. :)

Attachment 14463

For other information, the first attribute (misspelled) has a lower option number than the second. The sort order numbers are in the same sequence.

The installation is a vanilla ZC 1.5.3 hotfix 1, with mysql database backup, display logs, and superglobals installed.

I have noticed that after I make a selection (using firefox) that there is an error that is reported regarding the onchange option. that selectItemImage is not defined... Potentially a typing error? missing space? (Action is called on line 51 of includes\functions\extra_functions\products_with_attributes.php) No additional upgrade of jquery has been made beyond what is included in the beta plugin. Internet search has not revealed a similar function yet. Will look to see if that function is covered in the official ZC available version of SBA 1.5.3, but thought I would report it if there is something to be addressed for overall functionality.

---

FYI, Haven't proven it yet, but I think that the revised SQL statement in the includes/modules/YOUR_TEMPLATE/attributes.php file at lines 101-114 and removal of the previous 122-126 may have caused this issue. Basically thinking (again no proof) that the new SQL returns more lines of data than are applicable whereas the previous first returned a "correct" number and then the second sql used data from the first instead of attempting to push all the response into one sql response... This seems to be the only real change in the file that potentially could affect the quantity of items in a list. Other changes were to identify new/different table abbreviations.

Curious what the affect will be to restore that sql statement and the follow-on changes made to accomodate. Seems to me that it should work like it used to... unless someone saw an issue with the way it worked before?

Quote:

---

Originally Posted by mc12345678

FYI, Haven't proven it yet, but I think that the revised SQL statement in the includes/modules/YOUR_TEMPLATE/attributes.php file at lines 101-114 and removal of the previous 122-126 may have caused this issue. Basically thinking (again no proof) that the new SQL returns more lines of data than are applicable whereas the previous first returned a "correct" number and then the second sql used data from the first instead of attempting to push all the response into one sql response... This seems to be the only real change in the file that potentially could affect the quantity of items in a list. Other changes were to identify new/different table abbreviations.

Curious what the affect will be to restore that sql statement and the follow-on changes made to accomodate. Seems to me that it should work like it used to... unless someone saw an issue with the way it worked before?

---

I see part of the issue... Want to have the quantity associated available and possibly the customid; however, access to that information becomes somewhat more difficult/unreliable without further scripting to reload the other dropdown(s) when the one is selected... Hmm.. Works fine if there is one attribute, but when starting to mix them? Well, seems that doesn't update the other when the one is selected..

So, found a partial solution... That is without additional javascript/ajax... Essentially if the product has one attribute tracked by SBA the solution would provide the ability to see the remaining quantity and designated customid for that product, if there is more than one attribute associated through SBA with the product then only the attribute's value name would be displayed...

Thinking of some alternatives, either the page reloads after an attribute is changed with the currently selected options passed to the new load, or some other means of updating (javascript or otherwise) is implemented to populate the remaining field(s).

The only thing that in my opinion/understanding is that it seems that the customid is intended to be used to designate a combination or particular series of attributes and therefore doesn't necessarily make sense on an individual basis when combined with others... I guess I could be wrong about that and maybe there is a grander scheme, but I've been pondering this aspect for a long time. :/ For the example provided in the previous image, I attempted to designate a quantity of the individual first attribute that also had a combination with the second attribute and can not see how that addition impacted anything other than populating a record in the database. Maybe once I have "sold out" of one or more of its combination attributes it may be clearer...

I'll present my solution if there is any interest soon, but don't really want to confuse things if there is a direction being headed... Don't need to go making more variants of this program which is finally coming together.

Quote:

---

Originally Posted by mc12345678

I see part of the issue... .

I'll present my solution if there is any interest soon, but don't really want to confuse things if there is a direction being headed... Don't need to go making more variants of this program which is finally coming together.

---

Hi,

I have been trying to resolve this issue for sometime (and a related Orders and Basket thing I see), with limited susses. I am currently working a significant change (new concept) to the mode locally as a possible solution. But that may not end up working, so if you have another option please send what you think so we can have other perspectives. As a note, this mod has never to my knowledge supported multiple drop-downs that change when one has a selection change. I think others have used a separate filter plugin to do that, but that plugin does not work well with current changes, so I hope to build that functionality into the mod.

We (jeking and I) have started working together on this, there is a GitHub working copy available, but it is not for formal release, just development. Obviously when a production version is available it will be placed in the normal Zen Cart Plugins.

Quote:

---

Originally Posted by webmiss

Do you know how long it will be til a newer version is available? My client really needs this. And I am running zc version 1.5.3.

---

Free modules are built by volunteers on their own time.. So when it is available will be dependent on the author's schedule. If you are following this thread, you can see dev and testing are in progress... So you will just have to wait patiently while this process plays itself out.. That's how it usually works with free modules.. If your client REALLY needs this now and you don't want to wait, you can consider other options (commercial modules, paying a dev to update for you, etc..)...

Quote:

---

Originally Posted by potteryhouse

Hi,

I have been trying to resolve this issue for sometime (and a related Orders and Basket thing I see), with limited susses. I am currently working a significant change (new concept) to the mode locally as a possible solution. But that may not end up working, so if you have another option please send what you think so we can have other perspectives. As a note, this mod has never to my knowledge supported multiple drop-downs that change when one has a selection change. I think others have used a separate filter plugin to do that, but that plugin does not work well with current changes, so I hope to build that functionality into the mod.

We (jeking and I) have started working together on this, there is a GitHub working copy available, but it is not for formal release, just development. Obviously when a production version is available it will be placed in the normal Zen Cart Plugins.

---

I've identified a solution to the issue of the custid not showing in those areas; however, am awaiting approval to share.

Quote:

---

Originally Posted by mc12345678

I've identified a solution to the issue of the custid not showing in those areas; however, am awaiting approval to share.

---

When you do get permission from your client or whenever, I would be interested in looking at the code.
Thanks.

Quote:

---

Originally Posted by potteryhouse

When you do get permission from your client or whenever, I would be interested in looking at the code.
Thanks.

---

Will be glad to as permitted. Interested in some of the newer features that are being considered such as the new "title" feature.

Btw, trying to figure out, how is one allowed to populate the custid after a "group" of attribute combinations has been generated (without significant other processes)? Did I understand correctly that this could be done through the export/import process?

Quote:

---

Originally Posted by mc12345678

Will be glad to as permitted. Interested in some of the newer features that are being considered such as the new "title" feature.

Btw, trying to figure out, how is one allowed to populate the custid after a "group" of attribute combinations has been generated (without significant other processes)? Did I understand correctly that this could be done through the export/import process?

---

Yes the Export Import was created for another users needs, it allows the "bulk" changing of the Qty and Custom ID. Depending on how other fields play out such as the title/Description, parentid, childid, and siblingid (new concepts) they may be available in the future if it works the way I hope.

Quote:

---

Originally Posted by potteryhouse

Yes the Export Import was created for another users needs, it allows the "bulk" changing of the Qty and Custom ID. Depending on how other fields play out such as the title/Description, parentid, childid, and siblingid (new concepts) they may be available in the future if it works the way I hope.

---

Interesting concepts, curious of their function. At least the sibling field. Seems like it is just an additional field that must be managed that can also be populated/determmined by looking at the parent's children.

Btw, I think I found at least one reason this plugin has not worked with multiple attributes. In the order class, when checking stock quantity for an attribute as compared to the quantity of the product, there is a search that is performed against the products with stock attributes table that is basically bound to fail and disable the product if one attribute has been exhausted. (A situation that I encountered in testing.). The resolution looks like it will take at least three queries in series that are dynamically built depending on the results of a previous query. This code is where products_status is set to 0. I think (since I am away from my computer) that it is in the function that starts with create.

Because this portion of the code deactivates the product if the attribute is exhausted, my plan is to rewrite it so that the only time the product is to be disabled is when there are no attribute options available. Then it will be on to the next applicable attribute disablement/reporting to ensure that the customer can better understand what is available and what is out-of-stock.

As a reminder I had modified the system response back to the way it was before that I only have one instance of each of the first attributes, and one of any subsequent attribute, not a combination/long listing like I showed up above. This condition is different than the current beta code.

As far as code modifications and "previous" versions, yes, there was javascript applied to at least one version that was to update other attribute selection boxes upon picking one attribute selection. IMHO, all well and good, but I prefer to first program from a non-javascript perspective as that is the base work, then addon javascript. Call it old school or something, but if someone doesn't want to run javascript on their computer I'd rather be sure they can make a purchase than prevent them from doing so...

Let me see if I can ask this question coherently, because it is a potentially complicated condition.

Trying to evaluate whether the products stock by attribute table is properly populated for a given product. Already have seen in the forum that when working with more than one attribute for the product that some have either properly or improperly added a product variant to the table with only one attribute tracked (or at least a number of attributes less than the full quantity available).

The question comes to what constitutes the products with attributes stock table being properly populated? (Correct number of attributes included in the combination of attributes.). For example if a product has three attributes, is it acceptable for only two to be considered for stock tracking purposes/existing functionality of the module. What conditions should automatically be considered as non-attributes to consider (ie read only only?)?

It's already evident that there are insufficient means of tracking if an attribute has been "turned off" from being important for stock tracking purposes as this would require an additional table to address properly/sufficiently (attribute when associated with a specific product is not to be considered). Sure it could be stuffed into a field of an existing table; however, that violates normalization principles of databases. (Yes I know that there are more than likely cases in the ZC default coding that also don't follow strict normalization, in fact this plugin doesn't either, but...)

Ideally, once a product is populated with it's stock attributes, the number of attributes to consider won't change, but I'm also trying to address "knowing" that there are not discrepancies in the database population. For example if a product is originally populated with three types of attributes, and then in the future one of those is removed, what also removes that attribute tracking from the database, the user only? If the same product having three attributes, has an additional attribute added to it, what happens and does that too need to be adjusted?

The way I was considering approaching the product is out-of-stock (needing to be made inactive) was to look at the maximum number of attributes being tracked and if the results from the database containing that number of attributes for the product indicated no available quantity when searched on the value of one of the tracked attributes, then to disable the product. Currently it disables the product if there is no quantity returned when there is no quantity for the combination of the attribute and I think it is/was all of it's siblings of that one attribute joined together. Ie, expecting that every possible attribute value of the product is considered for tracking the exhaustion of the product.

This is what I found in the error logs.
[27-Aug-2014 13:07:49] PHP Fatal error: Call to undefined function zen_get_ip_address() in /dir/mydir/public_html/admin-directory/includes/init_includes/init_sessions.php on line 34

Is there actually a commercial module for zc verion 1.5.3?

Quote:

---

Originally Posted by webmiss

This is what I found in the error logs.
[27-Aug-2014 13:07:49] PHP Fatal error: Call to undefined function zen_get_ip_address() in /dir/mydir/public_html/admin-directory/includes/init_includes/init_sessions.php on line 34

---

Didn't by chance uninstall the plugin by removing all the files that were a part of the plugin from your store did you?

That missing function is defined in. Two different (but similar) files:
admin/includes/functions/general.php

And

includes/functions/functions_general.php

If either file is missing or doesn't have that function, then the file appropriate to the path should be uploaded again. The function described (zen_get_ip_address) was new to the admin side in ZC 1.5.3, so if the file is there and it looks complete, but is missing the function, then perhaps is from an older version of ZC. (Ie, the current release of this plugin I believe uses/modifies that file)

Quote:

---

Originally Posted by webmiss

This is what I found in the error logs.
[27-Aug-2014 13:07:49] PHP Fatal error: Call to undefined function zen_get_ip_address() in /dir/mydir/public_html/admin-directory/includes/init_includes/init_sessions.php on line 34

---

The undefined function is not used by this plugin so is being caused by some other problem.

I'm not aware of a commercial module but you could hire someone to write on for you.

Okay, I haven't specifically received direction, but would hate for this product to undergo a significant change over the weekend to resolve something like this. (Although perhaps the result would be an even better product). Regarding the customid, I don't see why I can't provide guidance to find the solution.

Take a look at what is needed in the zen_get_customid function and take a look at what is being fed to it. I believe either of the two of you would be able to narrow down the issue with that.

Quote:

---

Originally Posted by mc12345678

Okay, I haven't specifically received direction, but would hate for this product to undergo a significant change over the weekend to resolve something like this. (Although perhaps the result would be an even better product). Regarding the customid, I don't see why I can't provide guidance to find the solution.

Take a look at what is needed in the zen_get_customid function and take a look at what is being fed to it. I believe either of the two of you would be able to narrow down the issue with that.

---

Have a look at updates on the branch Update3 at

For Zen Cart version 1.5.1
https://github.com/jeking928/stock_by_attribute_1.5.3

For Zen Cart version 1.5.3
https://github.com/jeking928/stock_by_attribute_1.5.4

For anyone interested we have a GitHub Development area.

For Zen Cart version 1.5.1
https://github.com/jeking928/stock_by_attribute_1.5.3

For Zen Cart version 1.5.3
https://github.com/jeking928/stock_by_attribute_1.5.4

These should address many of the issues found, but these changes need testing before they can be uploaded to the Zen Cart Plugins.

There is also an issues tracking feature on GitHub for each of these branches, if anyone has a reproducible issue, they can create a bug report, but please make sure you include details for reproducing the issue and what the symptoms are when the bug is present.

Has anyone found a solution and the best way to mass delete specific attributes from products that their attributes have been discontinued?

Quote:

---

Originally Posted by Kevin205

Has anyone found a solution and the best way to mass delete specific attributes from products that their attributes have been discontinued?

---

This should be easy with the correct query, send me a scenario of what you think is expected, I can generate a query and if it works add it to the new version we are working as one of the optional SQL's, or in some other way that you think makes sense.

What I would need to know is when you place a product out of stock will it always be marked as inactive, will it always need to have the attributes in the SBA removed, things like that are the kind of items I would need to know in the scenario that will work for you overall. I have a guess as to what to expect, but it is best to see what you will be expecting. You could add this as an issue in the Git project so it can be tracked.

https://github.com/jeking928/stock_b...e_1.5.3/issues

Quote:

---

Originally Posted by potteryhouse

This should be easy with the correct query, send me a scenario of what you think is expected, I can generate a query and if it works add it to the new version we are working as one of the optional SQL's, or in some other way that you think makes sense.

What I would need to know is when you place a product out of stock will it always be marked as inactive, will it always need to have the attributes in the SBA removed, things like that are the kind of items I would need to know in the scenario that will work for you overall. I have a guess as to what to expect, but it is best to see what you will be expecting. You could add this as an issue in the Git project so it can be tracked.

https://github.com/jeking928/stock_b...e_1.5.3/issues

---

Thank you for the reply.

I will do that.

The SBA development area has been moved on GitHub to:

For Zen Cart version 1.5.1
https://github.com/potteryhouse/stoc...bute_1.5.3.git

For Zen Cart version 1.5.3
https://github.com/potteryhouse/stoc...bute_1.5.4.git

Can products_model be edited/revised using EP4? If yes which module?

Thank you.

Sorry posted the wrong thread.

Greetings.
I'm currently using:
Zen-Cart 1.5.1
Stock By Attributes (SBA) Version 1.5.3

After adding new products to the database, I can run the "Optional SQL" script and it creates entries in the new products_with_attributes_stock table, based on current products that have attributes associated with them. This seems to work correctly.

What I would like to do at this point is use the SBA "Export Table Data" script to export the SBA table data, enter the Unique ID and stock values for each variant, then import that data using the "Import Table Data" script.

The problem I'm having is that when I run the "Export Table Data" script, the script is exporting data from old products that were previously in the table/database, but have now been deleted from Zen-Cart.

How can I ensure the data that gets exported only contains the current products in Zen-Cart and not old products that have been discontinued and deleted from Zen-Cart? Is there a step I'm missiing that syncs the SBA table data to the current products list in Zen-Cart?

There must be a way to do this because products can be discontinued at anytime.

Thanks for any help that can be given!

Tuxy

More information that might be helpfull..

When I click the menu option "Catalog/Products With Attributes Stock", it displays the products correctly. It displays all the products that have an attribute associated with them.

I assumed that running the "Export Table Data" script from the "Configuration/Products With Attributes Setup" menu, I would get the same list as I do from the "Catalog/Products With Attributes Stock" menu, but that is not the case. When I Export Table Data, I get old products that have been deleted from the Zen-Cart database.

Does this make sense? Is anyone else using the Export/Import feature of this module?

Is this the correct place to be asking this question?

Thanks!

I just discovered this module is being developed on GitHub. I'll take this issue there for further discussion.

I am currently using ZenCart Version 1.5.3 and I uploaded everything up to the site now my admin is white nothing. Plus when I tried to install the SQL file I keep getting errors. Why?

Quote:

---

Originally Posted by morrisgiftshop

I am currently using ZenCart Version 1.5.3 and I uploaded everything up to the site now my admin is white nothing. Plus when I tried to install the SQL file I keep getting errors. Why?

---

The current version of this plugin is not compatible with Zen Cart 1.5.3 yet. There is a beta version on Github, mentioned earlier in this thread.

I'm using the latest version of this module. 'SBA Display Custom ID > Display the Custom ID value in history, checkout, and order forms' is set to true. Setting this to true also shows the custom ID on the product info pages beside each attribute, which I don't want. What the best way to hide the custom ID on the product info pages?

Just a suggested edit, not sure if it was suggested. I kept trying to add quantities of 0 using the "Add Quantity for Product Variant" link on the SBA Page in the admin area. Each time I chose to add 0, I got an error. "Missing or bad quantity." This may be because 0 is registered as null when it is run against line 216's:

Code:

---

elseif( !is_numeric((int)$quantity) || is_null($quantity) ){

---

So I changed that to the following:

Code:

---

elseif( !is_numeric((int)$quantity) || zen_not_null($quantity) ){

---

and that fixed my problem of being able to add a product with zero quantity using the wizard.

Quote:

---

Originally Posted by retched

Just a suggested edit, not sure if it was suggested. I kept trying to add quantities of 0 using the "Add Quantity for Product Variant" link on the SBA Page in the admin area. Each time I chose to add 0, I got an error. "Missing or bad quantity." This may be because 0 is registered as null when it is run against line 216's:

Code:

---

elseif( !is_numeric((int)$quantity) || is_null($quantity) ){

---

So I changed that to the following:

Code:

---

elseif( !is_numeric((int)$quantity) || zen_not_null($quantity) ){

---

and that fixed my problem of being able to add a product with zero quantity using the wizard.

---

Honestly, looking at that snippet of code alone, it doesn't make sense. If the variable that is type cast to be an integer isn't a number or (as originally written) the value is actully null then do the next step.
Now it reads if the variable that is type cast to be an integer isn't a number or the value is actually NOT null then do the next step. It seems as if that section is meant to address situations that do not add value to the process. Why is it important to add a zero value for an attribute quantity that does not exist? That's basically what is being done.

If it is desired to avoid going down the path of the value zero resolving to null then the more specific solution would be:
If (!is_numeric((int)$quantity) || (is_null($quantity) && $quantity !== 0)) {

Note the use of the not identity instead of evaluating against something thatmay be equivalent to zero. (Ie. False).

3000

I'm sorry if this has been asked and answered, but it is impossible to search through a particular thread.

Based on an attribute, you can change the image associated with that attribute, but I can find no way/reference to a way to change the text of the description based on an attribute. Is this already in there and I missed it or has this already been answered in this thread? I have a customer that is rather insistant that I make this possible even though when I took on this customer I explained my lack of knowledge of PHP which Zen Cart is written with. Perforce, I am learning slowly, but, she wants it NOW (isn't that always the way?).

Mal

What you ask, to change the description based upon the attribute selected, cannot be done with this plugin (nor any I'm familiar with).

How to get attributes in Google merchant feeder using stock by attribute? I have installed it but its still not including product with attribute in feed file.

You should try post in the Google Merchant feeder thread:
http://www.zen-cart.com/showthread.p...-for-ZC-v1-5-x

Hello and thanks again for this mod! I've been using the 1.5.x TEST version and noticed today that it is no longer working correctly, so installed the latest module from the Zencart Plugins page, however, behaviour is the same:

1. Existing attributes with quantities will not update
2. Newly added attributes/products will not display attributes in the SBA page.

Please see attached screenshots for more clarity.

Attachment 14683Attachment 14682Attachment 14684

Any help will be greatly appreciated:yes:

Perhaps a hint, my error log shows:

PHP Warning: Invalid argument supplied for foreach() in /home/username/public_html/admin/products_with_attributes_stock.php on line 510

First, rename your admin folder right away. Never post your admin folder name and never use 'admin'.

Second, what is the '1.5.x TEST' version?

Third, what version of Zen Cart are you using?

Hello and thanks for your response.

1. My admin folder is not named 'admin' I did this for sake of posting.
2. The 1.5.x TEST version was a version in this thread that was like a beta 1.5.3 version of the mod
3. I'm using the latest zencart version.

If you're using Zen Cart 1.5.3, you can try the latest BETA available on GitHub.
https://github.com/potteryhouse/stoc...ttribute_1.5.4

I'm using the latest version of Stock by Attribute on my newly upgraded version of Zencart 1.5.3 from 1.5.1

Some of my drop down menus are not working correctly, allowing you to select "out of stock" items.


This product's drop down menu is working correctly, not allowing your mouse pointer to select "out of "stock" sizes.
http://vaultofdriedbones.com/shop/in...oducts_id=1590


However, this product as well as others allows you to select "out of stock" sizes and add them to your shopping cart. The items are out of stock and once added to the shopping cart you cannot proceed with the order until you remove the products with 0 quantities available.
http://vaultofdriedbones.com/shop/in...oducts_id=1577

I go through the same steps for each product when creating the products id, the products attributes and then setting the SBA quantities.

Has anyone encountered this problem, and do you know how to fix it?

The current version of SBA available from this site is not compatible with Zen Cart 1.5.3. A new version is in testing but has not been released yet.

Quote:

---

Originally Posted by jeking

The current version of SBA available from this site is not compatible with Zen Cart 1.5.3. A new version is in testing but has not been released yet.

---

Ok, thanks for the information.

Quote:

---

Originally Posted by P.M.

I'm using the latest version of Stock by Attribute on my newly upgraded version of Zencart 1.5.3 from 1.5.1

Some of my drop down menus are not working correctly, allowing you to select "out of stock" items.


This product's drop down menu is working correctly, not allowing your mouse pointer to select "out of "stock" sizes.
http://vaultofdriedbones.com/shop/in...oducts_id=1590


However, this product as well as others allows you to select "out of stock" sizes and add them to your shopping cart. The items are out of stock and once added to the shopping cart you cannot proceed with the order until you remove the products with 0 quantities available.
http://vaultofdriedbones.com/shop/in...oducts_id=1577

I go through the same steps for each product when creating the products id, the products attributes and then setting the SBA quantities.

Has anyone encountered this problem, and do you know how to fix it?

---

Quote:

---

Originally Posted by jeking

The current version of SBA available from this site is not compatible with Zen Cart 1.5.3. A new version is in testing but has not been released yet.

---

It may not be the version that is the issue. If you notice the difference in the working/not working versions, the one that is "working has the option values greyed out and the text, while the one that is not working has the text only. What is the difference in option name types between the two? My guess is that the one "not working" is a standard dropdown, while the one "working" has the SBA added dropdown type that allows html control.

Quote:

---

Originally Posted by mc12345678

It may not be the version that is the issue. If you notice the difference in the working/not working versions, the one that is "working has the option values greyed out and the text, while the one that is not working has the text only. What is the difference in option name types between the two? My guess is that the one "not working" is a standard dropdown, while the one "working" has the SBA added dropdown type that allows html control.

---

Thanks for the guess mc12345678, there is only one option name, SIZE, and it looks like I selected "dropdown" in option names and not "SBA select list".

I'm updating the products in "option name" and it is now working correctly. Thank you for your help and time!

Hi Jeking - fab module but I am looking for the 1.5.3 version - can I use from github or is it still BETA testing only?

Quote:

---

Originally Posted by jeking

If you're using Zen Cart 1.5.3, you can try the latest BETA available on GitHub.
https://github.com/potteryhouse/stoc...ttribute_1.5.4

---

All code on GitHub should be considered as BETA. You're welcome to use it and provide any feedback. Take the necessary precautions, backup or install on a development cart first.

Quote:

---

Originally Posted by jeking

All code on GitHub should be considered as BETA. You're welcome to use it and provide any feedback. Take the necessary precautions, backup or install on a development cart first.

---

Agree with this fully and ask to take a look at the additional branches off of the master and provide input as well. I've uploaded some additional coding to expand on the functionality/ensure that default zC functionality is not lost for non-SBA tracked product. Awaiting feedback to merge into the master branch.

I'm testing it on a zencart 1.5.4 install.(development version)
On line 47 includes/classes/order.php there is a typo i think :

if ($this->queryReturnFlag === TRUE) return;

But so far so good. I also use super orders, edit orders and COWOA so it took some merging, because they all change this file.
Only thing i cant seem to get to work is editing directly in "Quantity in stock" field, although the "hint" says its possible.

Quote:

---

Originally Posted by karinvd

I'm testing it on a zencart 1.5.4 install.(development version)
On line 47 includes/classes/order.php there is a typo i think :

if ($this->queryReturnFlag === TRUE) return;

But so far so good. I also use super orders, edit orders and COWOA so it took some merging, because they all change this file.
Only thing i cant seem to get to work is editing directly in "Quantity in stock" field, although the "hint" says its possible.

---

No type, that's a PHP construct (===) that means "exactly equal to". The return will be taken if and only if the queryReturnFlag value is TRUE -- not 1, not 'true'. If the statement was coded as

Code:

---

if ($this->queryReturnFlag == TRUE) return;

---

then the return would occur if queryReturnFlag was true or 1 or '1' or 'true' or 'false'. It's a construct used mostly when a variable can contain a "mixed" value (i.e. the value could be true or 1 or 'true').

Oke thanks, i did not know, i thought == meant exactly equal to. I learned something today :-)

I had a problem with combination of zen-colorbox2 and SBA. When i used an attribute with a drop down menu, the image did not load. On line 42 of includes\functions\extra_functions\products_with_attributes.php i found the next code which showed on a product page when i used a drop down menu, if i used a check box or a radio button it did not show and zen-colorbox2 worked fine. So i comment this line out.
Wil i get problems with?

Code:

---

        $field = '<script src="'.DIR_WS_TEMPLATES . $template_dir . '/jscript/jquery-1.10.2.min.js"></script>
                  <script type="text/javascript">
                                $(function(){
                                        $("#attrib-'.$tmp_attribID.'").on("click", function(){
                                                $("#SBA_ProductImage").attr("src", $(this).find(":selected").attr("data-src"));
                                        });
                                });
          </script>';

---