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

batracy:

I think I see where the problem is. I've just checked the file sizes and content of the admin/includes/classes/order.php and the includes/classes/order.php file and it seems they are reversed on my test install. This was supposed to be a clean install from BlueHost, and now I'm wondering what else could possibly be wrong - although the test store does seem to be working with out any problems - although I haven't created an order yet ;-)

Hate to say it, but that is one more reason to do the install oneself rather than an automated install generated by modifying the fileset put together by those hardworking to provide the stellar product of ZC that it is. :)

To address that issue, if you need support, please initiate a new thread.

mc12345678:

Yes that was an issue with the version on the main branch. Try https://github.com/potteryhouse/stock_by_attribute_1.5.4/tree/mc12345678_ZC154 which is compatible with both zc 1.5.3 and ZC 1.5.4 as a single download with improvements to handle/address multiple attributes.

That's working a lot better now! all variants are ok...however I get this error on certain clicks in the site, mainly loging on to the account and adding to cart:

"An unknown response null: :text/html; charset=iso-8859-1: :Not Found was received while processing an ajax call. The action you requested could not be completed."

Ever had this before?

thanks, Ed

edvon:

That's working a lot better now! all variants are ok...however I get this error on certain clicks in the site, mainly loging on to the account and adding to cart:

"An unknown response null: :text/html; charset=iso-8859-1: :Not Found was received while processing an ajax call. The action you requested could not be completed."

Ever had this before?

thanks, Ed

I have with ZC 1.5.4 unrelated to SBA. Ie. Suggest a new thread. Occured for me when I had a site setup adjacent to another using a subdomain and the same admin directory name as the other site. (Saw issue when using the site as well as in admin.) And it seemed to happen mostly on my cell phone, but was fine on a desktop for most of the times. Add to that it happened just after setup of a new domain and the sub-domain. Too many variables to identify the cause... Haven't had an issue once some other changes were made, again for me it was unrelated to SBA.

mc12345678:

Hate to say it, but that is one more reason to do the install oneself rather than an automated install generated by modifying the fileset put together by those hardworking to provide the stellar product of ZC that it is. :)

To address that issue, if you need support, please initiate a new thread.

Appreciate the help - I have the issue resolved.

mc12345678:

I have with ZC 1.5.4 unrelated to SBA. Ie. Suggest a new thread. Occured for me when I had a site setup adjacent to another using a subdomain and the same admin directory name as the other site. (Saw issue when using the site as well as in admin.) And it seemed to happen mostly on my cell phone, but was fine on a desktop for most of the times. Add to that it happened just after setup of a new domain and the sub-domain. Too many variables to identify the cause... Haven't had an issue once some other changes were made, again for me it was unrelated to SBA.

Thanks, I have indeed cloned the site for testing purposes on the server when this error popped up. Thanks for your help.
ed

Hello there.
I just downloaded this addon and did the best I could to merge the files. Hope I did everything right.
Then after putting the files where they belong, the readme says, go to...../stock_by_attr_install.php and select full/upgrate and run script....

I do see the /stock_by_attr_install.php page, but clicking on run script doesn't work.
It removes everything under the dropdown - run script. The readme says I need to get a message. I don't get one either.

Then, looking at the catalog, I do see my website, but when I click on a categorie that should had some products in there, I get an error.
WARNING: An Error occurred, please refresh the page and try again.

Looking in de logs, it says
[13-Apr-2015 14:32:05 Europe/Berlin] PHP Fatal error: 1146:Table 'nameofmydatabse.products_with_attributes_stock' doesn't exist :: SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(180,181,182), 1, 0)) as flag FROM products_attributes p2a JOIN products_options po ON p2a.options_id = po.products_options_id AND po.language_id=2 JOIN products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=2 JOIN products_with_attributes_stock p2as ON p2a.products_id = p2as.products_id AND p2as.stock_attributes LIKE CONCAT('%', p2a.products_attributes_id, '%') WHERE p2a.products_id IN (180,181,182) AND p2as.quantity > 0 GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_name, pov.products_options_values_sort_order ==> (as called by) C:\xampp\htdocs\zencart\includes\templates\westminster_new\sideboxes\tpl_dynamic_filter.php on line 402 <== in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 155

I don't have enough experience for all of this, but I can see that it says that a table does not exist.
The problem could be that i have some other add ons build in, so everything has to move over in the database.

What must i do to get the install done?

zencart 1.5.4
fast and easy checkout
css js loader
dynamic filter
flexible footer
westminster new template
second language

What version of this plugin did you download? The version posted here on the forum is NOT compatible with Zen Cart 1.5.4

There is a BETA version available on Github. Do a search in this thread and you'll find the link.

This one
http://www.zen-cart.com/downloads.php?do=file&id=202

Pompidompie:

This one
http://www.zen-cart.com/downloads.php?do=file&id=202

It clearly says:

Zen Cart® Versions v1.5.1

Pompidompie:

Hello there.
I just downloaded this addon and did the best I could to merge the files. Hope I did everything right.
Then after putting the files where they belong, the readme says, go to...../stock_by_attr_install.php and select full/upgrate and run script....

I do see the /stock_by_attr_install.php page, but clicking on run script doesn't work.
It removes everything under the dropdown - run script. The readme says I need to get a message. I don't get one either.

Then, looking at the catalog, I do see my website, but when I click on a categorie that should had some products in there, I get an error.
WARNING: An Error occurred, please refresh the page and try again.

Looking in de logs, it says
[13-Apr-2015 14:32:05 Europe/Berlin] PHP Fatal error: 1146:Table 'nameofmydatabse.products_with_attributes_stock' doesn't exist :: SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(180,181,182), 1, 0)) as flag FROM products_attributes p2a JOIN products_options po ON p2a.options_id = po.products_options_id AND po.language_id=2 JOIN products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=2 JOIN products_with_attributes_stock p2as ON p2a.products_id = p2as.products_id AND p2as.stock_attributes LIKE CONCAT('%', p2a.products_attributes_id, '%') WHERE p2a.products_id IN (180,181,182) AND p2as.quantity > 0 GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_name, pov.products_options_values_sort_order ==> (as called by) C:\xampp\htdocs\zencart\includes\templates\westminster_new\sideboxes\tpl_dynamic_filter.php on line 402 <== in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 155

I don't have enough experience for all of this, but I can see that it says that a table does not exist.
The problem could be that i have some other add ons build in, so everything has to move over in the database.

What must i do to get the install done?

zencart 1.5.4
fast and easy checkout
css js loader
dynamic filter
flexible footer
westminster new template
second language

jeking:

It clearly says:

Zen Cart® Versions v1.5.1

mc12345678:

Yes that was an issue with the version on the main branch. Try https://github.com/potteryhouse/stock_by_attribute_1.5.4/tree/mc12345678_ZC154 which is compatible with both zc 1.5.3 and ZC 1.5.4 as a single download with improvements to handle/address multiple attributes.

Looking at this page and the previous (link in last quoted post above), would identify a version thatworks with Zc 1.5.4 (and 1.5.3 for those still using that).

I have now downloaded that one.
I have no experience so I mis having a readme. Do I have to do exactly the same things as the other readme?
I mean, putting in files, changing them and so on... and then use /stock_by_attr_install.php to install again?

Sitting here for a while, trying to figure out what is going wrong.
I have searched for it, but nothing comes up, or maybe i'm using wrong search words.

Empty categories show nicely (there is nothing there)
But, catagories with products in it, show up wrong.

I have the dynamic filters on the left (and sometimes I switch on the categories left sidebox too)
Normaly the content/products is/are in the middle, but mine now is under the left sidebox.
Like this
Attachment #15158

What could be wrong here?

I don't believe SBA affects the display of categories and is probably not associated withthe installation of SBA; however, the sidebox that you have that includes dynamic filters. Might want to double check your logs directory to see if there are any myDEBUG files.

I double checked but this addon didn't make any productlisting changes.
I also don't have logs that say anything.
Could it be the dynamic filter that is causing the problem? But then, i had that in for a couple off days and didn't have this problem then.

Pompidompie:

I double checked but this addon didn't make any productlisting changes.
I also don't have logs that say anything.
Could it be the dynamic filter that is causing the problem? But then, i had that in for a couple off days and didn't have this problem then.

If your seeing all of the expected content, then more than likely the issue is related to a CSS file... Those issues can be helped with when providing a link to the page(s) having a problem. They can be self diagnosed when using tools such as firebug with firefox or web developer for the same, or similar tools with other browsers.

I will say this, dynamic filters is one of the plugins that are still under review to ensure functionality with SBA (really it's the reverse to ensure that SBA properly supports dynamic filters, though some union may have to occur between the two).

Will it help if I show you the pagecode? (mouse on the website, right mouseclick, show code)
It's a big mess because i'm still building, but maybe it will tell us something?

I am looking at the stylesheet (i have chrome elements) but i haven't found anything yet.
If i remove the % witdh of the onerow.fluid in te responcive.css the categories with nothing in it, also move to under the sidebox.
Makes you think, lets reverse that. If they can move over there, the other categories can move back up. But no. The haven't got a % witdh, they have a px width and no matter what i changes, they don't move back up.
Going to puzzel some more....

I had looked everywhere. Gave up for today. Started to read the Attribute Stock Setup and trying to add a product.
Doing stuff in the admin and checking it in the catalog. And heeee... adding a product did the trick. It moved my products back up again :thumbsup:

Pompidompie:

I had looked everywhere. Gave up for today. Started to read the Attribute Stock Setup and trying to add a product.
Doing stuff in the admin and checking it in the catalog. And heeee... adding a product did the trick. It moved my products back up again :thumbsup:

That my dir sir (mam), would be an indication of a template issue. Suggest all future issues with that problem be addressed in the forum of your template.

Glad though that at least for now the problem is solved.

How do you know that this things are template issues? (try to learn from you)

I also have a question about this addon.
My english is not that good and my experience with building a website is, trying and see what happens.
So in the setup it says create a product.
Option name and type:
Size, radio
Color: read only
Material: read only
Create size and default on the first one.
Display only for the read only (important because of out of stock message)

I did that but, i got the out of stock message anyway.
So I removed the display only, that made it possible to add quantity's for color and material.

My question is, what does read only and display only mean and do I have to put it back on after giving everything it's quantity?

From what was understood to be stated:

• A new category with no product caused display to be wrong.
• Adding a product to the category adjusted the display of the screen.
• Attributes are not displayed on the product listing screen, though the button(s) are different (no quantity add box), but nothing specific about attributes affect the product listing screen.
• Having an understanding of the SBA code further supports that the issue is/was template related.

I think I have seen the example you are describing, but I don't recall the setup being so complicated as described above. Read Only is a "data-type" assigned to an Option Name so that it will be treated like an attribute, but is for display purposes only. The content can not be modified by the customer.

Display Only applies to a single option value that is assigned to an option name. When active, that option value can not be the one selected to add to the cart. Typically it is a value such as "Please select". Therefore when the customer sees the attributes for the product, they are reminded to move along on selecting options in the attributes.

As to the issue(s) having with the recommended reading, it is difficult to understand the situation.