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

magz:

Hi,

I'm testing SBA 1.5.2 (upgrade from 1.5.0) on ZC 1.5.1, and am grateful for the fact that available stock appears in the cart for products both with and without attributes. However, I'm having trouble with miscalculated stock for products with attributes. It's probably just a setting somewhere that I need to change, but can't figure out which one. Here's the situation:

I have ukuleles that can be purchased with or without optional gig bags. In my test, I use 2 ukes of the same model. The desired behavior is: if someone orders 1 or 2 ukes (both with bags OR both without bags OR 1 with and 1 without), they should NOT get an insufficient stock message. If someone tries to buy 3 or more ukes (with or without bags), they SHOULD get the insufficient stock message. Currently, the system somehow thinks that I have 2 ukes with bags and 2 separate ukes without bags, so someone can put 2 ukes with bags and 2 without in their cart and not get the low stock warning, though they should. What am I doing wrong?

Here's how I have the uke set up:
- the gig bag attribute type is check box
- quantity of the product (on product setup page) is set to 2
- qty of attribute is 2 (when it was 0, I was getting low stock msg even when ordering 1 uke with bag, and available qty was blank, not even 0)
- in Configuration->Stock, "SBA Show Available Stock Level in Cart (when less than order)" is set to true, the other SBA items are set to false.

• settings in attributes controller:
  

I'll appreciate your guidance.... Thank you!
Magz

PS- sorry for this duplicate post, I didn't know before that I could change the subject and I think my msg from Dec 1 drowned in the flood and went unnoticed...

Can you provide a screen shot of the product setup in the SBA stock page, this may help in understanding the issues cause.
I will attempt to duplicate your settings this weekend and see what I find.

potteryhouse:

Can you provide a screen shot of the product setup in the SBA stock page, this may help in understanding the issues cause.
I will attempt to duplicate your settings this weekend and see what I find.

Thanks, Potteryhouse, here are the shots:

Above quantities are NOT synchronized. Syncing changes total # to 4.

If you'd like to see this in action, the test product is at http://test.allstringsnylon.info/cordoba-ukulele-15sm .

Thanks for all your work!
Magz

Ok, I may have missed something but, if the quantity amount for an attribute isn't filled in, is this treated as a zero quantity of stock or an infinite quantity of stock

I think it shows out of stock with quantity of zero.

nigelt74:

Ok, I may have missed something but, if the quantity amount for an attribute isn't filled in, is this treated as a zero quantity of stock or an infinite quantity of stock

The way I updated the code it should do the following:

Option A: Product with no associated attributes, this uses the qty assigned to the product in the catalog.
Option B: Product with Attribute(s), If no attribute is created in the SBA Stock page, this will use the qty from the product catalog.
Option C: Product with Attribute(s), and attributes are created in the SBA stock page, this uses the qty from the SBA Stock page.

In all cases,
if the qty is zero, than the flag is set to indicate out of stock.
if the qty is less than the order requested in the cart, than the flag will indicate low stock.
The flag display is based on the settings in the "Configuration -> Stock" (Check Stock Level = true)

There seems to be other configurations to support:

1. Where the base product is to use the quantity in the catalog, and there is an "Optional" attribute to add something like a "Gig Bag".
2. Where the same product is added to the cart, but one has a selected attribute combination as A,B,C, and the second entry for the same product has attribute combinations A,C. etc. These do not properly cross check the other attributes of the same product to test for available qty.

Since I had not considered these configurations, the qty calculations in the cart may not work as expected.
I will look at an update and will post for others to test if I can resolve these.

If there are other configurations I did not account for please provide the configuration scenarios, with some expected results and explanations to help with understanding what you are looking for as a result. Since I am doing this in my spare time, the update may take some time.

Additionally, as a note, the SBA versions in the Plug-ins, to-date support one attribute per row (Stock ID) in the SBA Stock page.
The new test version I posted supports attribute combinations i.e., two or more attributes per row (Stock ID) in the SBA Stock page.
I posting an updated version of this below and would like some feedback, looking for errors, etc.
I believe this version resolves some errors on web hosts that do not permit the PHP eval() command.

New Test version [Attachment no longer available]

magz:

Thanks, Potteryhouse, here are the shots:

Above quantities are NOT synchronized. Syncing changes total # to 4.

If you'd like to see this in action, the test product is at http://test.allstringsnylon.info/cordoba-ukulele-15sm .

Thanks for all your work!
Magz

It is looking like the code needs to be updated to support your configuration scenario, I will give it a try and let you know.

potteryhouse:

It is looking like the code needs to be updated to support your configuration scenario, I will give it a try and let you know.

Thanks Potteryhouse, I do appreciate!
Magz

magz:

Thanks Potteryhouse, I do appreciate!
Magz

Hi,
This took much longer than I thought, but I think it resolves most of the duplicate product issues you identified.
It is not perfect, but much better I think than it was.

It is a big change so you should try this on a test machine before trying on any production site.
Verify everything works as you want. No guarantees, but I hope it will work for you.

A note, for products that have attributes, you must have "None" or "All" of the products attributes setup in the SBA Stock page, it will not work if you only put one attribute in the stock page but there are others for the product.
Also, the "Attributes Controller" for the "Uke" product should be set like I have in the attached image sample.

[Attachment no longer available]

If you find other things or have suggestion please post them.

Thank you, Potteryhouse! Nothing wrong with how long it took, we're all busy and you're doing this with no pay so those of us who don't know the first thing about coding can have functional ecommerce websites... I do appreciate all the time and effort you and many others are putting into Zen-Cart and its plugins, and hope to be able to send out lots of donations sometime soon.

The update seems to be functioning fine (done very limited testing so far), except it now doesn't say what the available quantity is. Unless it's a quick and easy fix, I can live with that until the "perfect" version is released. :smile: I'm also noticing a few "cosmetic" issues... Although I set sort order of "base" to 1 and "add" to 2 and in Attributes Controller they do appear in that order, on the product page and in the shopping cart, "add" is first and "base" second. Short of numbering them, how do I force them to display in the desired order? Also on the product page, the vertical space between the 2 attributes is quite large and the text doesn't align vertically with the checkbox. How do I fix that?

Thank you!
Magz

potteryhouse:

Hi,
This took much longer than I thought, but I think it resolves most of the duplicate product issues you identified.
It is not perfect, but much better I think than it was.

It is a big change so you should try this on a test machine before trying on any production site.
Verify everything works as you want. No guarantees, but I hope it will work for you.

A note, for products that have attributes, you must have "None" or "All" of the products attributes setup in the SBA Stock page, it will not work if you only put one attribute in the stock page but there are others for the product.
Also, the "Attributes Controller" for the "Uke" product should be set like I have in the attached image sample.

[Attachment no longer available]

If you find other things or have suggestion please post them.

magz:

Thank you, Potteryhouse! Nothing wrong with how long it took, we're all busy and you're doing this with no pay so those of us who don't know the first thing about coding can have functional ecommerce websites... I do appreciate all the time and effort you and many others are putting into Zen-Cart and its plugins, and hope to be able to send out lots of donations sometime soon.

The update seems to be functioning fine (done very limited testing so far), except it now doesn't say what the available quantity is. Unless it's a quick and easy fix, I can live with that until the "perfect" version is released. :smile: I'm also noticing a few "cosmetic" issues... Although I set sort order of "base" to 1 and "add" to 2 and in Attributes Controller they do appear in that order, on the product page and in the shopping cart, "add" is first and "base" second.** Short of numbering them, how do I force them to display in the desired order?** Also on the product page, the vertical space between the 2 attributes is quite large and the text doesn't align vertically with the checkbox. How do I fix that?

Thank you!
Magz

(1) The qty display on the page was not changes, you will need to turn it back on in the "Configuration -> Stock" page in admin.
When you run the installation script it resets all the display flags to false.

(2) You control the Option order by the setting the applicable "Sort Order" in the "Catalog ->Options Name Manager" Product Options page in admin.

(3) I think the layout alignment you mentioned is a template thing you will have to adjust to make it look as you need, the file to work with is:
\includes\templates\YOURTEMPLATE\templates\tpl_product_info_display.php

Thanks Potteryhouse!
I should have known re #1, oops; that's working well now. I did set the sort order via Options Name Manager, but it's trying to alphabetize them instead. I just changed the names so their alpha order matches the order in which I want them to appear. Found the css styles that control the labels and was able to get them to look more or less the way I want.
Take care, have a wonderful New Year!
Magz

potteryhouse:

(1) The qty display on the page was not changes, you will need to turn it back on in the "Configuration -> Stock" page in admin.
When you run the installation script it resets all the display flags to false.

(2) You control the Option order by the setting the applicable "Sort Order" in the "Catalog ->Options Name Manager" Product Options page in admin.

(3) I think the layout alignment you mentioned is a template thing you will have to adjust to make it look as you need, the file to work with is:
\includes\templates\YOURTEMPLATE\templates\tpl_product_info_display.php

I am running Zen Cart v1.5.1 and just installed Stock by Attribute v1.5.2 and now my attribute selection drop-downs contain html as well as the price differential. See pic:

I have not seen anything about this error in this thread. How do I fix this?

Mal

Malaperth:

I am running Zen Cart v1.5.1 and just installed Stock by Attribute v1.5.2 and now my attribute selection drop-downs contain html as well as the price differential. See pic:

I have not seen anything about this error in this thread. How do I fix this?

Mal

This was noticed previously, and is fixed in the new version under TEST.
I would like to get more feed back before posting to the plugins.

In the mean time, you can use the guidance here:
http://www.zen-cart.com/showthread.php?47180-Stock-by-Attribute-v4-0-addon-for-v1-3-5-1-3-9&p=1225837#post1225837

or the new test version:
http://www.zen-cart.com/showthread.php?47180-Stock-by-Attribute-v4-0-addon-for-v1-3-5-1-3-9&p=1231102#post1231102

Let us know how it works for you.

potteryhouse:

This was noticed previously, and is fixed in the new version under TEST.
I would like to get more feed back before posting to the plugins.

In the mean time, you can use the guidance here:
http://www.zen-cart.com/showthread.php?47180-Stock-by-Attribute-v4-0-addon-for-v1-3-5-1-3-9&p=1225837#post1225837

or the new test version:
http://www.zen-cart.com/showthread.php?47180-Stock-by-Attribute-v4-0-addon-for-v1-3-5-1-3-9&p=1231102#post1231102

Let us know how it works for you.

The programatic fix in attributes.php worked fine, thank you very much! And thank you for making/updating/fixing this plugin, it is a lifesaver!

The link to your new version does not work, however and I would be more than happy to try it if I can get it.

Also, I am having another problem although I can't say for sure it has to do with Stock by Attribute, but it did not show up until I installed it. Every product I have that has attributes and claims to set the quantity to 1 says out of stock when added to the shopping cart. In the product definition page, it says quantity 1 and lists quantity 1 on the page shown to the public. I did notice something odd when I initially added the attributes. It changed the quantity to 1+eo6 I believe it was and that was what was initially displayed. Sorry, but I'm old and may be a bit senile, but I can't remember if I changed the amount manually or it changed while editing the product again. However, I cannot get the product to add to the shopping cart without the out of stock error. And, what's worse, I can't even remember what/where I looked to attempt to fix it. I know I didn't change anything, just searching.

Mal

Malaperth:

The programatic fix in attributes.php worked fine, thank you very much! And thank you for making/updating/fixing this plugin, it is a lifesaver!

The link to your new version does not work, however and I would be more than happy to try it if I can get it.

Also, I am having another problem although I can't say for sure it has to do with Stock by Attribute, but it did not show up until I installed it. Every product I have that has attributes and claims to set the quantity to 1 says out of stock when added to the shopping cart. In the product definition page, it says quantity 1 and lists quantity 1 on the page shown to the public. I did notice something odd when I initially added the attributes. It changed the quantity to 1+eo6 I believe it was and that was what was initially displayed. Sorry, but I'm old and may be a bit senile, but I can't remember if I changed the amount manually or it changed while editing the product again. However, I cannot get the product to add to the shopping cart without the out of stock error. And, what's worse, I can't even remember what/where I looked to attempt to fix it. I know I didn't change anything, just searching.

Mal

This link will bring you to the post that has the file to download (Post 1790):
http://www.zen-cart.com/showthread.php?47180-Stock-by-Attribute-v4-0-addon-for-v1-3-5-1-3-9&p=1231102#post1231102

The file name / download is:
stock_by_attribute_1.5.X_TEST_3.zip

There are a number of changes, some of them affect the very thing you described above, the out of stock issue "might" be related to how you entered the products in the SBA stock page. this version under test handles many variations of product entries, but since it is a test version I suggest you try it before adding too many products.

You can turn off the out of stock warning in the "configuration -> stock" page, it is one of the switches, the switches are explained in the instructions provided with the version 1.5.2.

potteryhouse:

This link will bring you to the post that has the file to download (Post 1790):
http://www.zen-cart.com/showthread.php?47180-Stock-by-Attribute-v4-0-addon-for-v1-3-5-1-3-9&p=1231102#post1231102

The file name / download is:
stock_by_attribute_1.5.X_TEST_3.zip

There are a number of changes, some of them affect the very thing you described above, the out of stock issue "might" be related to how you entered the products in the SBA stock page. this version under test handles many variations of product entries, but since it is a test version I suggest you try it before adding too many products.

You can turn off the out of stock warning in the "configuration -> stock" page, it is one of the switches, the switches are explained in the instructions provided with the version 1.5.2.

I'm using IE9, and I'm assuming it's another wonderful "feature" of another wonderful Microsoft product (which I consider viruses, but I'm a bloody sheep and use it) and when I click on either of those links I am brought to literally a blank page. The page is so blank, I can't even right-click on it to view source... I love my life... I'll try another browser and see what happens...

Mal

Malaperth:

I'm using IE9, and I'm assuming it's another wonderful "feature" of another wonderful Microsoft product (which I consider viruses, but I'm a bloody sheep and use it) and when I click on either of those links I am brought to literally a blank page. The page is so blank, I can't even right-click on it to view source... I love my life... I'll try another browser and see what happens...

Mal

I was able to download the zip with Google Chrome, but now Windows Vista claims it doesn't know what to do with a zip file. Again... I love my life... Time for a reboot and maybe a Military grade disk wipe and complete reinstall. I LOVE MY LIFE!!!

Thank you very much for your efforts to this community. I only wish I could remember half of the things I used to know so I could contribute something more than whining about issues that I should be able to fix by myself, but alas, my mind has failed me as my body has and I'm rather useless except that I can spell PHP. Other than that, I'm pretty much a lesion on society.

I will install the new files and hopefully do it correctly and not leave any 'leftovers' to cause issues. Thanks again for helping me I really appreciate it!

Mal

Malaperth:

I was able to download the zip with Google Chrome, but now Windows Vista claims it doesn't know what to do with a zip file. Again... I love my life... Time for a reboot and maybe a Military grade disk wipe and complete reinstall. I LOVE MY LIFE!!!

Thank you very much for your efforts to this community. I only wish I could remember half of the things I used to know so I could contribute something more than whining about issues that I should be able to fix by myself, but alas, my mind has failed me as my body has and I'm rather useless except that I can spell PHP. Other than that, I'm pretty much a lesion on society.

I will install the new files and hopefully do it correctly and not leave any 'leftovers' to cause issues. Thanks again for helping me I really appreciate it!

Mal

Reading between the lines, it sounds to me you know much more than you let on!

Windows Vista was a bit of a pain... I use 7-Zip on all my PCs to deal with zip files, it works well for me.

http://www.7-zip.org

I also use Beyond Compare to merge files and look at differences, just in case you need something like that, you could also look at winmerge.
http://www.scootersoftware.com
http://winmerge.org

potteryhouse:

Reading between the lines, it sounds to me you know much more than you let on!

Windows Vista was a bit of a pain... I use 7-Zip on all my PCs to deal with zip files, it works well for me.

http://www.7-zip.org

I also use Beyond Compare to merge files and look at differences, just in case you need something like that, you could also look at winmerge.
http://www.scootersoftware.com
http://winmerge.org

Everything was fine once I actually rebooted this Winblows pig and cleared whatever program is causing the memory leak (still can't identify it yet). I have a compare program, but I don't think it merges, so I will take a look at the scootersoftware prog. Anything with 'win' in it makes my sphincter tighten beyond normal so I try to avoid them. :yuck: :P

Again, I appreciate all the effort you are puttin into this for free. I tried Magento because it was recommended by my hosting provider as a 'user friendly, easy to set up, free full ecommerce platform'. Other than 'full ecommerce platform' the rest is horse hockey... It's about as user friendly as poison ivy in your shorts. It took me two months of agony and multi-multiple calls to tech support just to find out that in order to make my site work, the tech people would have to rewrite my entire theme installation along with many core files. Magento is a bloated piece of garbage that I'm surprised that eBay allows to stay alive (well except if you buy the Enterprise edition, then they bend over backwards to help you and you get a separate version without all the hundreds of literally duplicated files located in about 30 different places in the code). I found Zen Cart, and in a few days had damn near a fully functional ecommerce site. The things that were lacking were things that needed to be produce on our end (product images, text for various items and pages etc), but Zen Cart should be called God Cart or something like that. Well, enough babbling from an old fool. I got a LOT more than I paid for (yup, that's right, NOTHING) when I found Zen Cart. It's the best thing I've found since my wife! Ok... I'm gonna shut up now...

Mal

I am putting together the next version (based on the test version I posted in this forum) to be provided to the "Plug-Ins".

Is there anyone available that can do the translation that can be included as samples?

I would like to get the following translated into a couple other languages, French, Dutch, etc.
Just the text in the defines below: after the comma, in the single quotes.

Thanks in advance.

This is used in the Admin:

define('PWA_DELETE_VARIANT_CONFIRMATION', 'Are you sure you want to delete this product variant?');


define('PWA_PRODUCT_ID', 'Product ID');
define('PWA_PRODUCT_NAME', 'Product Name');
define('PWA_PRODUCT_IMAGE', 'Image');
define('PWA_PRODUCT_MODEL', 'Product Model');
define('PWA_QUANTITY', 'Quantity: ');
define('PWA_QUANTITY_FOR_ALL_VARIANTS', 'Quantity for all variants');
define('PWA_ADD_QUANTITY', 'Add Quantity For Product Variant');
define('PWA_SYNC_QUANTITY', 'Sync Quantities');


define('PWA_EDIT_QUANTITY', 'Edit Quantity');
define('PWA_DELETE_VARIANT', 'Delete Variant');


define('PWA_STOCK_ID', 'Stock ID');
define('PWA_VARIANT', 'Variant');
define('PWA_QUANTITY_IN_STOCK', 'Quantity in Stock');


define('PWA_SORT_ORDER', 'Sort Order');
define('PWA_CUSTOM_ID', 'Custom ID');
define('PWA_CUSTOMID_NAME', ' Item # ');


define('PWA_EDIT', 'Edit');
define('PWA_DELETE', 'Delete');
define('PWA_SUBMIT','Submit');

This is used in the Admin:

define('BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK', 'Products with Attributes Stock (aka SBA)');
define('BOX_CONFIGURATION_PRODUCTS_WITH_ATTRIBUTES_STOCK_SETUP', 'Products with Attributes Stock (aka SBA) Setup');

This is used in the Store front end:

define('PWA_STOCK_AVAILABLE', ' Available Stock: ');
define('PWA_OUT_OF_STOCK', ' Out of Stock: ');
define('PWA_STOCK_QTY', ' Qty: ');
define('PWA_LOW_STOCK', ' Low Stock! ');
define('PWA_CUSTOMID_NAME', ' Item # ');