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

[athena]

All the files check out... thank you for the quick response.
It must be a db connection issue but it is a new db and I simply imported the data from the active site into the new db to test it. It stands alone right now as a new cart down for maintenance. I'll try and approach it from a db path angle and see if there is an issue there.

[athena]

I can navigate to the stock_by_attr_install.php file. Any recommendation on what to choose in the drop down to make it install? Default SQL looks like the thing to do.... nope, scratch that. Full/Upgrade i reckon.

So here is what I got:
FAILURES:
There were ERRORs Reported.
Review results below:

Results from the selection Full Install: (Errors!)

File needs to be removed: /home/mysite/public_html/admin/ajax/jquery.form.js
File needs to be removed: /home/mysite/public_html/admin/ajax/jquery-1.10.2.min.js

Clean-Up, Removing from configuration:
• Deleted STOCK_SHOW_IMAGE
• Deleted STOCK_SHOW_LOW_IN_CART
• Deleted STOCK_SHOW_ATTRIB_LEVEL_STOCK
• Deleted STOCK_SHOW_ORIGINAL_PRICE_STRUCK
• Deleted STOCK_SET_SBA_SEARCHBOX
• Deleted STOCK_SBA_SEARCHLIST
• Deleted STOCK_SBA_DISPLAY_CUSTOMID
• Deleted SBA_SHOW_IMAGE_ON_PRODUCT_INFO
• Deleted PRODUCTS_OPTIONS_TYPE_SELECT_SBA
• Deleted ATTRIBUTES_SBA_DISPLAY_CUSTOMID
• Deleted SBA_SHOW_OUT_OF_STOCK_ATTR_ON_PRODUCT_INFO
• Deleted STOCK_SBA_CUSTOM_FOR_MODEL

Clean-Up, Removing from products_options_types:
• Moving option types from SBA Select List (Dropdown) Basic to an equivalent type to prepare for removal.
• Deleted products_options_types_name

Clean-Up, Removing from admin_pages:
• Deleted productsWithAttributesStock
• Deleted productsWithAttributesStockSetup
• Deleted productsWithAttributesStockAjax

Clean-Up, Removing from configuration:
• Deleted PRODINFO_ATTRIBUTE_PLUGIN_SINGLE
• Deleted PRODINFO_ATTRIBUTE_PLUGIN_MULTI
• Deleted PRODINFO_ATTRIBUTE_SHOW_OUT_OF_STOCK
• Deleted PRODINFO_ATTRIBUTE_MARK_OUT_OF_STOCK
• Deleted PRODINFO_ATTRIBUTE_OUT_OF_STOCK_MSGLINE
• Deleted PRODiNFO_ATTRIBUTE_NO_ADD_OUT_OF_STOCK
• Deleted STOCK_SET_SBA_NUMRECORDS
• Deleted PRODINFO_ATTRIBUTE_DYNAMIC_STATUS
• Deleted SBA_ZC_DEFAULT
• Deleted PRODINFO_ATTRIBUTE_POPUP_OUT_OF_STOCK
• Deleted PRODINFO_ATTRIBUTE_DYNAMIC_STOCK_READ_ONLY

Clean-Up, Removing Dynamic Dropdowns from admin_pages:
• Deleted configDynamicDropdownSBA
• Deleted Dynamic Drop Downs from configuration_group

Adding to admin_pages:
• Inserted into admin_pages productsWithAttributesStock.

Adding to configuration (SBA option switches):
Inserted into configuration:
• STOCK_SHOW_IMAGE
• STOCK_SHOW_LOW_IN_CART
• STOCK_SHOW_ATTRIB_LEVEL_STOCK
• STOCK_SHOW_ORIGINAL_PRICE_STRUCK
• STOCK_SET_SBA_SEARCHBOX
• STOCK_SBA_SEARCHLIST
• STOCK_SBA_DISPLAY_CUSTOMID
• SBA_SHOW_IMAGE_ON_PRODUCT_INFO

Adding to admin_pages:
• Inserted into configuration_group Dynamic Drop Downs.
• Inserted into admin_pages configDynamicDropdownSBA.

Adding to configuration (Dynamic Dropdowns option switches):
Inserted into configuration:
• PRODINFO_ATTRIBUTE_PLUGIN_SINGLE
• PRODINFO_ATTRIBUTE_PLUGIN_MULTI
• PRODINFO_ATTRIBUTE_SHOW_OUT_OF_STOCK
• PRODINFO_ATTRIBUTE_MARK_OUT_OF_STOCK
• PRODINFO_ATTRIBUTE_OUT_OF_STOCK_MSGLINE
• PRODINFO_ATTRIBUTE_NO_ADD_OUT_OF_STOCK
• STOCK_SET_SBA_NUMRECORDS

• products_with_attributes_stock Table Fields: stock_id | products_id | stock_attributes | quantity | sort |

Altered Table products_with_attributes_stock to add DEFAULT value of 0.
Added customid field to table products_with_attributes_stock.
Added title field to table products_with_attributes_stock.
Added product_attribute_combo field to table products_with_attributes_stock.

Added Table orders_products_with_attributes_stock:

Added New Table products_with_attributes_stock_attributes_non_stock.

Adding to admin_pages:
• Inserted into admin_pages productsWithAttributesStockSetup.
Updating PRODUCTS_OPTIONS_TYPE_SELECT, UPLOAD_PREFIX and TEXT_PREFIX
Updated PRODUCTS_OPTIONS_TYPE_SELECT, UPLOAD_PREFIX and TEXT_PREFIX

Verifiying products_options_types:

Finding highest products_options_types value:

Adding to products_options_types:
• Inserted into products_options_types "SBA Select List (Dropdown) Basic".

Adding to configuration:
• Inserted into configuration "Selection list product option type (SBA)" .
File not found: /home/mysite/public_html/mysite/includes/modules/pages/checkout_success/header_php_sba.php

[mc12345678]

All the files check out... thank you for the quick response.
It must be a db connection issue but it is a new db and I simply imported the data from the active site into the new db to test it. It stands alone right now as a new cart down for maintenance. I'll try and approach it from a db path angle and see if there is an issue there.

While the database install itself doesn't really care what version of ZC it is on and I realize the question relates to SBA, but if all that was done was to import the old 1.5.1 database into the database referenced by ZC 1.5.4 and nothing else, then there are other steps still to be taken such as updating that database to ZC 1.5.4. Otherwise, again, if the file stock_by_attr_install.php is accessed, that should at least initiate the "install" of the admin's configuration option to again return to that same menu. Then you can do an install/upgrade, or a remove (without removing the database table(s)) followed by an install/upgrade in order to make the other options/settings again available. There really should generally be no other modifications necessary to move from the older store to a newer yet still old store. If there are, please advise so that can either incorporate into the code to address automatically or incorporate into some level of instruction beyond a potentially "lost" post.

[mc12345678]

I can navigate to the stock_by_attr_install.php file. Any recommendation on what to choose in the drop down to make it install? Default SQL looks like the thing to do.... nope, scratch that. Full/Upgrade i reckon.

So here is what I got:
FAILURES:
There were ERRORs Reported.
Review results below:

Results from the selection Full Install: (Errors!)

File needs to be removed: /home/mysite/public_html/admin/ajax/jquery.form.js
File needs to be removed: /home/mysite/public_html/admin/ajax/jquery-1.10.2.min.js

Clean-Up, Removing from configuration:
• Deleted STOCK_SHOW_IMAGE
• Deleted STOCK_SHOW_LOW_IN_CART
• Deleted STOCK_SHOW_ATTRIB_LEVEL_STOCK
• Deleted STOCK_SHOW_ORIGINAL_PRICE_STRUCK
• Deleted STOCK_SET_SBA_SEARCHBOX
• Deleted STOCK_SBA_SEARCHLIST
• Deleted STOCK_SBA_DISPLAY_CUSTOMID
• Deleted SBA_SHOW_IMAGE_ON_PRODUCT_INFO
• Deleted PRODUCTS_OPTIONS_TYPE_SELECT_SBA
• Deleted ATTRIBUTES_SBA_DISPLAY_CUSTOMID
• Deleted SBA_SHOW_OUT_OF_STOCK_ATTR_ON_PRODUCT_INFO
• Deleted STOCK_SBA_CUSTOM_FOR_MODEL

Clean-Up, Removing from products_options_types:
• Moving option types from SBA Select List (Dropdown) Basic to an equivalent type to prepare for removal.
• Deleted products_options_types_name

Clean-Up, Removing from admin_pages:
• Deleted productsWithAttributesStock
• Deleted productsWithAttributesStockSetup
• Deleted productsWithAttributesStockAjax

Clean-Up, Removing from configuration:
• Deleted PRODINFO_ATTRIBUTE_PLUGIN_SINGLE
• Deleted PRODINFO_ATTRIBUTE_PLUGIN_MULTI
• Deleted PRODINFO_ATTRIBUTE_SHOW_OUT_OF_STOCK
• Deleted PRODINFO_ATTRIBUTE_MARK_OUT_OF_STOCK
• Deleted PRODINFO_ATTRIBUTE_OUT_OF_STOCK_MSGLINE
• Deleted PRODiNFO_ATTRIBUTE_NO_ADD_OUT_OF_STOCK
• Deleted STOCK_SET_SBA_NUMRECORDS
• Deleted PRODINFO_ATTRIBUTE_DYNAMIC_STATUS
• Deleted SBA_ZC_DEFAULT
• Deleted PRODINFO_ATTRIBUTE_POPUP_OUT_OF_STOCK
• Deleted PRODINFO_ATTRIBUTE_DYNAMIC_STOCK_READ_ONLY

Clean-Up, Removing Dynamic Dropdowns from admin_pages:
• Deleted configDynamicDropdownSBA
• Deleted Dynamic Drop Downs from configuration_group

Adding to admin_pages:
• Inserted into admin_pages productsWithAttributesStock.

Adding to configuration (SBA option switches):
Inserted into configuration:
• STOCK_SHOW_IMAGE
• STOCK_SHOW_LOW_IN_CART
• STOCK_SHOW_ATTRIB_LEVEL_STOCK
• STOCK_SHOW_ORIGINAL_PRICE_STRUCK
• STOCK_SET_SBA_SEARCHBOX
• STOCK_SBA_SEARCHLIST
• STOCK_SBA_DISPLAY_CUSTOMID
• SBA_SHOW_IMAGE_ON_PRODUCT_INFO

Adding to admin_pages:
• Inserted into configuration_group Dynamic Drop Downs.
• Inserted into admin_pages configDynamicDropdownSBA.

Adding to configuration (Dynamic Dropdowns option switches):
Inserted into configuration:
• PRODINFO_ATTRIBUTE_PLUGIN_SINGLE
• PRODINFO_ATTRIBUTE_PLUGIN_MULTI
• PRODINFO_ATTRIBUTE_SHOW_OUT_OF_STOCK
• PRODINFO_ATTRIBUTE_MARK_OUT_OF_STOCK
• PRODINFO_ATTRIBUTE_OUT_OF_STOCK_MSGLINE
• PRODINFO_ATTRIBUTE_NO_ADD_OUT_OF_STOCK
• STOCK_SET_SBA_NUMRECORDS

• products_with_attributes_stock Table Fields: stock_id | products_id | stock_attributes | quantity | sort |

Altered Table products_with_attributes_stock to add DEFAULT value of 0.
Added customid field to table products_with_attributes_stock.
Added title field to table products_with_attributes_stock.
Added product_attribute_combo field to table products_with_attributes_stock.

Added Table orders_products_with_attributes_stock:

Added New Table products_with_attributes_stock_attributes_non_stock.

Adding to admin_pages:
• Inserted into admin_pages productsWithAttributesStockSetup.
Updating PRODUCTS_OPTIONS_TYPE_SELECT, UPLOAD_PREFIX and TEXT_PREFIX
Updated PRODUCTS_OPTIONS_TYPE_SELECT, UPLOAD_PREFIX and TEXT_PREFIX

Verifiying products_options_types:

Finding highest products_options_types value:

Adding to products_options_types:
• Inserted into products_options_types "SBA Select List (Dropdown) Basic".

Adding to configuration:
• Inserted into configuration "Selection list product option type (SBA)" .
File not found: /home/mysite/public_html/mysite/includes/modules/pages/checkout_success/header_php_sba.php

Full/Upgrade is/was a good choice generally speaking. Does look like one file (at least) was not put to the server as identified by the last line of the above response (File not found: /home/mysite/public_html/mysite/includes/modules/pages/checkout_success/header_php_sba.php). Then of course there are a few files that should be removed from the server (somehow left over from the "old" install???) as it relates to SBA. If something else accesses them, then so be it, but SBA does not need those files as located at that location.

[athena]

I believe I must have accessed the install page once before and used it to try and uninstall as I do recall running it to check if all the files were present. I then must have methodically gone through and removed then re-uploaded the pages, missing checkout_success/header_php_sba.php. It is now replaced.

I checked all my other mods and none are using the ajax/.js files so removed. Everything appears to be in place in the admin now. I will put this install through its paces to make sure SBA is working. Just one more mod and we can go live with 1.5.4. Thank you so much again

[mc12345678]

I believe I must have accessed the install page once before and used it to try and uninstall as I do recall running it to check if all the files were present. I then must have methodically gone through and removed then re-uploaded the pages, missing checkout_success/header_php_sba.php. It is now replaced.

I checked all my other mods and none are using the ajax/.js files so removed. Everything appears to be in place in the admin now. I will put this install through its paces to make sure SBA is working. Just one more mod and we can go live with 1.5.4. Thank you so much again

Good to hear and glad is working. Please report any issues back so that they may be addressed even if you self fix them.

[catmint]

Hi

Many thanks for putting the work into this addon, it is a great help. I am how ever having a problem with the stock quantity and out of stock notifications in the drop down box, in that I cannot get them to appear. I have been through the previous posts and tried what has been suggested before but to no avail. I am probably doing something stupid, but it is beyond me now.

ZC is 1.5.4 and the addon I used is from https://github.com/mc12345678/Stock_...butes_Combined, downloaded this morning using the 1.5.4 files. The site is live and otherwise works fine. The only other addon installed is multi cross sell

A test page for a product is here
https://www.catmint.biz/shop/index.p...bvtkgpbcn7llo3

"Right hand drive set" has a stock of 3
"Left hand drive set" has a stock of 0
"Right hand drive box dash only (no passenger side)" has a stock of 2
"Leftt hand drive box dash only (no passenger side)" has a stock of 0


Configuration/stock is as follows

Subtract stock true
Allow Checkout false
Mark product out of stock ***
Stock Re-order level 5
Products status in Catalog when out of stock should be set to 1
Show Sold Out Image in place of Add to Cart 1
Product Quantity Decimals 0
Show Shopping Cart - Delete Checkboxes or Delete Button 3
Show Shopping Cart - Update Cart Button Location 3
Show New Products on empty Shopping Cart Page 1
Show Featured Products on empty Shopping Cart Page 2
Show Special Products on empty Shopping Cart Page 3
Show Upcoming Products on empty Shopping Cart Page 4
Show Notice of Combining Shopping Cart on Login 1
SBA Show Available Stock Level in Cart (when less than order) true
SBA Display Images in Admin true Info
SBA Show Stock Level on Product Info Page true
SBA Original Price Struck Through true
SBA Display Search Box Only false
SBA Display Search List Box true
SBA Display Custom ID true
SBA Display Attributes Images 1
SBA Display Non-DD Out-of-Stock Attributes 1
SBA CustomID replaces products_model 1

Configuration/dynamic drop downs


Product Info Single Attribute Display Plugin sba_sequenced_dropdowns
Product Info Multiple Attribute Display Plugin sba_sequenced_dropdowns
Use ZC default HTML Attribute Tags false
Show Out of Stock Attributes True
Mark Out of Stock Attributes Left
SBA Number of Records to Displayed 25
Display Out of Stock Message Line True
Prevent Adding Out of Stock to Cart True
Display Javascript Popup for Out-of-Stock Selection True
Count Read Only as Stock false

Any help would be greatly appreciated

Many thanks in advance, Gordon

[mc12345678]

A very informative post, thank you for the details. There was one setting missing from the dynamic dropdowns section, but looking at the site I would say that I was able to determine its setting.

For the option name: Box Dash selection, go back into admin->catalog->option names manager and modify the type of attribute from "dropdown" to the one that is likely at the end of the list having the words SBA Select in it...

It appears that the option type is the standard dropdown and SBA has not been written to just "take over" aspects such as that.

[catmint]

Many thanks for the reply and help. I think the settings you mentioned are as they should be.

Sorry, I thought I had caught all the details - the missing dropdowns setting is to "enable dynamic dropdowns" and is set to 1, with the sub menu box set for "On for all SBA Tracked"

In the options name manager, the dropdown option is set to " SBA Select List (Dropdown) Basic"

Would there be anything in the SBA setup that I may have missed? When installing I did the file check which came out OK and then ran the full database install. I also ran the stock_by_attr_install.php from my browser, but I am not sure if it was successful.

Thanks again, Gordon

[mc12345678]

Many thanks for the reply and help. I think the settings you mentioned are as they should be.

Sorry, I thought I had caught all the details - the missing dropdowns setting is to "enable dynamic dropdowns" and is set to 1, with the sub menu box set for "On for all SBA Tracked"

In the options name manager, the dropdown option is set to " SBA Select List (Dropdown) Basic"

Would there be anything in the SBA setup that I may have missed? When installing I did the file check which came out OK and then ran the full database install. I also ran the stock_by_attr_install.php from my browser, but I am not sure if it was successful.

Thanks again, Gordon

Restore "enable dynamic dropdowns" to its default value of 2 (on for multiple attributes only) and you should be a-okay. It's an "under-the-hood" thing. The SBA Select dropdowns were incorporated well before Dynamic Dropdowns were merged into this fileset and were functional out-of-the-box. DD still needs/needed work, so they were kept separate.

Anyways, that should get the stock quantity showing (even though those items out-of-stock should not be allowed to be added to the cart).