Printable View
What SQL patch? Where did you try to use the patch? (Tools->install sql patches or phpmyadmin?)Quote:
Originally Posted by xfourninetwox
There is a search feature, to the thread, doesn't require reading 101 plus one pages. May have ZC 1.5.1, but what version of this software are you trying to use? We aren't at your computer/site to be able to see this information, it must be provided. Please help us help you.
I tried to install via Admin/Tools/Install SQL Patch. Which is where I came up with the error message. I just downloaded the "latest version" of the plug-in. I believe it was 1.5.3.Quote:
Originally Posted by mc12345678
I overwrote all of the other files through my FTP program manually, but when it comes to the SQL patches any other time in the past I have used the admin area to upload and haven't run into any problems. Today I came up with the above error message and am not certain what to do.
So, again what sql patch are/were you trying to run, because the installation of this version of SBA (1.5.3) does not have a SQL patch to be run per se.. Installation is through the use of the admin program stock_by_attr_install.php...Quote:
Originally Posted by xfourninetwox
I guess that is what I'm confused about. I thought that running that would be unnecessary if I was trying to add things manually. I guess what I need to know is what do I need to do, or select at admin/stock_by_attr_install.php if I've already manually overwritten the php files? Would it be the Full DB Install, or something else in MYPHP or Install SQL Patch?
Installation has been made about as easy as it could be possible, copy the files over to the server, then open the stock_by_attr_install.php file. As for which option(s) to choose from there, I would suggest reading the page, evaluating your current systems condition (ie, maybe need the upgrade, though based on your initial post it looks like the SBA of any version isn't in your store's database at this time.) so more than likely would want the full install.. Again though, instructions are provided when going to that address. Please take a moment to read through them, and identify how they could be improved if there is still a question.Quote:
Originally Posted by xfourninetwox
The installation went over with no errors, however the first thing I noticed under the "How To Use Stock Attributes" is you should be able to visit "Catalog / Products with Attributes Stock". I don't see that option in my admin area?Quote:
Originally Posted by mc12345678
Didn't have it after the installation either? Navigate around to at least one other link before viewing the Catalog menu to see if there is an option somewhere in the menu that has at least Product with Attributes Stock in it's button title?Quote:
Originally Posted by xfourninetwox
Still having issues?
Yeah, I noticed the new options for SBA under Configuration / Stock, but nothing else. I even tried doing the additional optional SQL patch, because I already have products with attributes, but I'm not seeing anything. Is there something that possibly needs to be overwritten in more than one place, like for example if a "/YOUR_Template/" section didn't pick up?
A standard install ought to provide the Products With Attributes Stock (aka SBA) menu option to the catalog menu dropdown.Quote:
Originally Posted by xfourninetwox
Perhaps need to remove it through the same install script option... Might suggest running the removal at least twice, then do the full install...
There are some YOUR_TEMPLATE related files where the files within need to be placed in the directory of the current template; however, the admin side is not affected by the YOUR_TEMPLATE aspect provided the files in the admin directory have been brought into the renamed admin directory.
Hi,
I installed a version of zc 1.5.4 and the SBA version 1.5.4 I downloaded from https://github.com/potteryhouse
Not sure if someone got this combination working. I am a little confused about the dynamic drop downs that are supposed to be implemented in this version of SBA, I don't get a "Enable Dynamic Dropdowns" in Admin.
The variants seem to work, only that I get multiple shows of the second attribute name:
i.e. I have two sizes 34 and 35 and three colours. Black, White, Red
On the product page I get size 34 and 35 on top, but the colours show up multiple (one colour for each size) Am I doing something wrong or is this just not working yet?
thanks, ed
Attachment 15140
Yes that was an issue with the version on the main branch. Try https://github.com/potteryhouse/stoc...12345678_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.
Thanks! I'll try that one.Quote:
Originally Posted by mc12345678
ed
I would like to ask a question.
I have zencart 1.5.4
Some of my products are made with the same things. The customer can choose from 12 colors. This means that if 1 color is sold out, it is sold out for all these products.
With this add on, can i eather display that color as temperarly not available, or that the color can not be chosen, or...?
Can i do this with this add on?
Correct, this will allow you take mark that color as Out of Stock or any other language you'd like to use.Quote:
Originally Posted by Pompidompie
To add, if not mistaken for single attributes like described to hide the options that are out-of-stock.Quote:
Originally Posted by jeking
Ok, I've been merging files into and for zen cart v1.5.4 and for the most part it is pretty straight forward. However, there is one file that really has me puzzled. The admin/includes/classes/order.php file that is part of this plugin is no where near similar in any respects to the same file in zen cart v1.5.4! The zen cart version is a much bigger file in size (over 4 times the amount of code), which has left me wondering what do I do now?
I'm upgrading my store to zen cart v1.5.4 for the latest in security upgrades (good to stay current), and all other plugins I use have merged right in without much difficulty. This one though, which I rely on heavily in my store, has me frustrated and not sure what to do. Does any one have any thoughts or suggestions on a course of action I can take? I can usually find my way around in code pretty well and get things working, but this particular problem kinda has me stumped. Any help would be much appreciated.
Thanks!
Can you confirm what version of SBA you are using?Quote:
Originally Posted by batracy
Not sure which branch you have downloaded, but the admin/includes/classes/order.php file in the mc12345678_zc154 branch has basically two changes as compared to the ZC 1.5.4 version, which increases the size only slightly. Hopefully files are being compared one for one and not comparing say an admin file against a storeside file.Quote:
Originally Posted by batracy
Changes highlighted below are entered into the sql that begins around line 157.
That's the only (functional) change made to this file... Should be a snap to "merge".Code:// START "Stock by Attributes" added to array products_options_values_id and 'value_id' => $attributes->fields['products_options_values_id'],
$attributes = $db->Execute("select products_options, products_options_values, options_values_price,
price_prefix, products_options_values_id,
product_attribute_is_free
from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
where orders_id = '" . (int)$order_id . "'
and orders_products_id = '" . (int)$orders_products->fields['orders_products_id'] . "'");
if ($attributes->RecordCount()>0) {
while (!$attributes->EOF) {
$this->products[$index]['attributes'][$subindex] = array('option' => $attributes->fields['products_options'],
'value' => $attributes->fields['products_options_values'],
'value_id' => $attributes->fields['products_options_values_id'],
'prefix' => $attributes->fields['price_prefix'],
'price' => $attributes->fields['options_values_price'],
'product_attribute_is_free' =>$attributes->fields['product_attribute_is_free']);
// END "Stock by Attributes"
I've downloaded the latest from the Stock by Attributes thread. Is this not the right one?
When I looked at the code, I did see the two places you highlighted, but what really gave me pause was the drastically different file sizes.
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. :)Quote:
Originally Posted by batracy
To address that issue, if you need support, please initiate a new thread.
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:Quote:
Originally Posted by mc12345678
"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.Quote:
Originally Posted by edvon
Appreciate the help - I have the issue resolved.Quote:
Originally Posted by mc12345678
Thanks, I have indeed cloned the site for testing purposes on the server when this error popped up. Thanks for your help.Quote:
Originally Posted by mc12345678
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.
It clearly says:Quote:
Originally Posted by Pompidompie
Zen Cart® Versions v1.5.1
Quote:
Originally Posted by Pompidompie
Quote:
Originally Posted by jeking
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).Quote:
Originally Posted by mc12345678
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.
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.Quote:
Originally Posted by Pompidompie
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:
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.Quote:
Originally Posted by Pompidompie
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.
Thank you for the explanation.
I puzzled with it a little, but ran in to another problem.
I´m building this new website to replace the webshop i already have for my business for a few years now(not a zencart website)
Stock by attribute is one of the things i would really like to get to work because it will safe me so much time.
Here's the thing. I have text fields en dropdowns that go together.
In the textfield the customer must add text and in the dropdown they must choose a color. Both are required to be able to put the product in the shoppingcart.
I can make the text field required. But i don't know how to do that with the dropdown.
I can add quantitys for the dropdown, but than the text field goes to out of stock.
I can't seem te get it to work together. Where am I doing something wrong?
If you go back a few pages, you'll see a detailed description of how to get multiple attributes to work to create a variant that is made of two or more attributes.Quote:
Originally Posted by Pompidompie
Basically, when you go to add a variant, provide a designation for each of the attributes at once, don't try to add just a text attribute and a dropdown attribute... Then, be sure to populate all versions/combinations of those attributes. Ultimately, those combinations (variants) that are not available should be given a quantity of zero, while those available have some number of quantity.
zc1.5.4 with SbyA updated version from github and Winchester Black template (which uses zen colorbox).
In the SbyA changelog notes, gives example code changes for tpl_modules_main_product_image.php, with examples for default template and for lightbox. The file in the package has the edit already in it for default, but there is <!-- and --> around the entire code line. I see that these also appear in the default zc package and in my template package. I thought these marks meant 'comment out' but in notepad++ only the marks themselves appear green while the coding between is not green. So - do these marks have a diff meaning? Do I remove them to activate the SbA attribute pictures.
Also, to use this feature is there a naming protocol for pics that would be called to change the image according to attribute selected?
The <!-- and --> result in "hiding" the content between them when displayed on a rendered page. (View the source code of the web page and you will see those "lines" in the source code.). There are a number of reasons to do this, but as to notepad++ I do not know about it's "color coding" rules.Quote:
Originally Posted by soxophoneplayer
As to attribute images, no there is no special naming convention. At the moment support of image swapping based on attribute selection varies depending on the number of attributes associated with the product(s). Single attribute products should support image swapping when properly setup. Multiple attribute products do not currently have the code necessarily incorporated to perform such swapping, or at least no positive feedback has been provided to indicate that it works as expected. That is something still to come.
Oh I realy feel stupid mc12345678. I´m trying to read your text, i´m trying to read stuff in this thread, but its like i´m reading Chinese.
If you go back a few pages, you'll see a detailed description of how to get bla bla bla.... I lost it here allready :blush: The second part of what you wrote is even more abracadabra for me.
May I ask if it is possible for you to take me trough it stap by stap? :blush:
Single Attribute Products with SbA version recently on github updated for zc1.5.4.
If I'm reading forum correctly - the functioning of the mod for single attribute products isn't 'finshed'?
When set for SbA-sequencial-dropdowns I don't get stock levels and I get a "the combination of options you have selected is currently out of stock...." message. Set as single dropdown or radio buttons, I don't get a stock showing, though I do get an 'out of stock' if the level is zero.
I fudged around it by adding a second attribute with only one variant. This works, though customer must select second attribute from a dropdown list of one. A wee bit wonky but its functional and applies to only two products so its not killing me.
Yet, I thought I'd ask if there a cleaner work around that I've missed in the forum?
Don't worry, Pompidompie, I haven't forgotten you, just need some time to reply with a bit more of an "international" perspective. :)
Read slightly wrong. Single attributes are functioning just fine, provided Dynamic Dropdowns is not activated for single attributes... (This is in a way why I didn't want to incorporate Dynamic Dropdowns as the number of possibile options increases significantly and the complexity increases as well.)Quote:
Originally Posted by soxophoneplayer
Simply make sure under the Dynamic Dropdowns configuration screen to not havethe single attributes option appear either by setting the value to 2 or 0.
Thank you for your help. Setting to '0' I get no stock levels other than 'out of stock' for multi or single variable products. Set to '2' I got stock levels for double variable, but still nadda for singles. I fiddled with Option Name Mgr config, where I had both my option names (Size, Colour) set to 'SbA Select List'. By changing Size option to 'Dropdown' and either leaving Colour as 'SbA' or changing also to 'Dropdown' I get the stock levels showing on both multi and single variable products. Yay.Quote:
Originally Posted by mc12345678
Curiously, since I couldn't stop fiddling, I experimented with the other option types in the Option Name Mgr config - radio, checkbox, text - in all of these the single variable products changed to the style selected, but the multi variable products all stayed as dropdowns with the stock showing. Also curiously, under no settings could I get colour swatches to show up. (I don't really need them as my photos cover it - I used the swatches in 1.3.9 site where my SbyA was in grid format.)
Realize that you've found some settings that work, but double check your configuration settings in the stock section regarding some of those settings in relation to single attribute product and the SBA dropdown. If the single SBA dropdowns have been affected, then I would say I've done something wrong because potteryhouse and jeking had worked to make sure that single attribute product (items having only one option name associated) functioned properly and I have tried not to impact thatQuote:
Originally Posted by soxophoneplayer
As for the case where multiple attributes are used (more than one option name), at this time if Dynamic Dropdowns is on for multiple attributes, everything with multiple attributes will be presented as a dropdown. And no it's not just because the plugin is called that, there is the possibility already builtin to use radioboxes, but for me? One thing at a time. :)
Images: supposedly there is a way to work it with single attributes (again not using the Dynamic Dropdown single attributes option) to show images with the attributes. That was something p&j worked on to completion/success. The multiple attributes takes a little work to get there but there is a plan to provide the maximum flexibility in image setup.
Thats oke :smile:Quote:
Originally Posted by mc12345678
That means still would like a better (easier to understand) explanation than what I provided before, correct?Quote:
Originally Posted by Pompidompie
Oh I'm sorry, yes.
All these terms, it's abracadabra to me. I try to follow, but i constanly lose it half way into the sentence.:blush:
Is SBA compatible with with v1.5.4 Zen?
Please, if at all possible, read back a few pages... This question has been asked and answered many times already.Quote:
Originally Posted by Kevin205
Thank you for the reply.Quote:
Originally Posted by mc12345678
Before posting I searched this thread for 1.4.5, and didn't come up with anything. That's why I posted.
I'm sorry and thank you.
I meant 1.5.4 not 1.4.5
Quote:
Originally Posted by Kevin205
No problem. Just attempted the same search and as the case for such searches, no data returned, in fact not even a response indicating that couldn't find the search terms. That type of word search does not work on the forum.Quote:
Originally Posted by Kevin205
Hi,
I have got SBA running on 1.5.4.
Does anyone have SBA running on v 1.5.4 together with Direct Bank Deposit (Aust) add-on Payment module?
https://www.zen-cart.com/showthread....t-Bank-Deposit
The file includes/classes/order.php is modified by both mods and from my (limited )understanding needs to be merged. Just wondering if there would be any incompatibilities?
thanks!
That file is often modified by plugins. Merge it correctly and you'll be fine.Quote:
Originally Posted by edvon
I would agree. This plugin modifies two lines of code in the file. The first collects information not collected in the base code after generation of the order's attribute_id, the second to pass that information on to an observer.Quote:
Originally Posted by jeking
I would agree. This plugin modifies two lines of code in the file. The first collects information not collected in the base code after generation of the order's attribute_id, the second to pass that information on to an observer.Quote:
Originally Posted by jeking
I think I need a bit of a sanity check with the install of this mod - I'm not even sure I'm posting in the right support thread.
Using SBA 1.5.3
Zen v1.5.1
I have a product with two attribute dropdowns
I select 'Giclée Print' from the first and 'Frame' from the second and add to cart
go back to the same product
and select 'Giclée Print' from the first and 'No Frame' from the second and add to cart
all works swimmingly - two items added to cart.
But, if I do the above in the opposite order i.e. 'No Frame' followed by 'Frame' I get an Out of Stock error on the 'Frame' item in the cart.
All my stock levels in SBA look ok. Does anything obvious stand out here?
I have this little (big) problem.
When adding something to the shoppingcart, loggin and click the checkout button, it loops. It keeps refreshing the shoppingcart page, but won't go forward. I don't know what the problem is, but I have this small voice saying it could be something to do with this addon.
This is what chrome elements gives as an error:
And than the 3th line is line 38:PHP Code:Uncaught Reference
Error: $ is not definedzcJS.ajax @ index.php?main_page=shopping_cart:38(anonymous function) @ index.php?main_page=shopping_cart:147
jquery-1.11.1.min.js:4 Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check http://xhr.spec.whatwg.org/.
And the 1sth line is line 147:PHP Code:zcJS.ajax = function (options) {
options.url = options.url.replace("&", unescape("&"));
var deferred = $.Deferred(function (d) {
var securityToken = 'b3a44e98ef6d02b0d4e901a53a237517';
var defaults = {
cache: false,
type: 'POST',
traditional: true,
dataType: 'json',
timeout: 5000,
data: $.extend(true,{
securityToken: securityToken
}, options.data)
},
settings = $.extend(true, {}, defaults, options);
I don't know what this means :blush:PHP Code:zcJS.ajax({
url: "ajax.php?act=ajaxPayment&method=setNoscriptCookie",
data: {test: '1'},
async: false
}).done(function( response ) {
There are several factors not yet explored.Quote:
Originally Posted by Pompidompie
1) Please try a different browser.
2) Does this happen with product not tracked by SBA?
3) Does this happen when temporarily using the default/classic template?
4) Does the item that is in the cart have stock?
5) Is this a test site and are you able to login with or without stock in the cart while using your current template? Does this change when temporarily using the ZC classic template?
There are several factors not yet explored.Quote:
Originally Posted by Pompidompie
1) Please try a different browser.
2) Does this happen with product not tracked by SBA?
3) Does this happen when temporarily using the default/classic template?
4) Does the item that is in the cart have stock?
5) Is this a test site and are you able to login with or without stock in the cart while using your current template? Does this change when temporarily using the ZC classic template?
Zen Cart v.1.5.4
SBA v 1.5.3
Hello - I have not been able to find the answer in the thread so far, so I thought I'd ask here so (hopefully) at least someone can confirm the answer is in here somewhere?
SBA appears to be installed correctly, but when you order ZC is using the total stock to see if the item is in stock.
For example - Widget#1 comes as either Red or Blue.
If the stock is set to Red = 5, Blue = 1
It will not say out of stock if you order 6 Red (because there are 6 widgets - but obviously not 6 red ones, hence the issue)
Similarly, if you order 2 Blue and 5 Red it will say they are both out of stock (because you've ordered 7 in total, and there are only 6 in stock, although the order for Red is in stock)
If someone could point me in the right direction that would be great. Thank you.
Congratulations on merging SBA 1.5.3. With ZC 1.5.4;however, that version was written for ZC 1.5.1. There is version 1.5.4 thatiscompatible with ZC 1.5.3and ZC 1.5.4 available at https://github.com/potteryhouse/stoc...12345678_ZC154Quote:
Originally Posted by OldToot
That version should resolve your issue.
Hi
Is Stock by Attributes - Version: 1.5.3 also compatible with zen cart version 1.5.0?
thanks
Generally, the best way to confirm "compatibility" is to compare the code changes as well as to test. I haven't tested against ZC 1.5.0 and I do not know if potteryhouse, jeking or others have so at this point I can only speak from having done upgrades and worked with both versions of ZC. It seems to me that it should work as well on 1.5.0 as it does on 1.5.1.Quote:
Originally Posted by buildingblocks
Hello,
I am using zencart 1.5.1, and have encountered several issues and would really appreciate any help.
My clothes store has Tshirts with S,M,L sizes. If all sizes are in stock everything works fine.
However, if only 1 size is available, and I hit "Sync Quantities", all sizes show up with the same number. Here 1 only have small size:
https://www.clothes4mom.ca/index.php...&products_id=4
For another one there are 2 sizes (S,M) with L=0; however it shows as a sum on the page: (L should be zero, but instead it is S+M)
https://www.clothes4mom.ca/index.php...&products_id=5
ok, I just figured that one needs to initialize the attributes with non zero values, and then change them to 0.
Is the value also entered for the large as zero, or has large been removed from the table?Quote:
Originally Posted by Olga
True still for ZC 1.5.1, but it has been repaired when using ZC1.5.3 and above.Quote:
Originally Posted by Olga
I set up a test 1.5.0 cart and merged the SBA v1.5.3 code into the stock 1.5.0 files. I set up a couple of products using the picture frame product example in the SBA instructions. The product displayed the individual attribute quantities on the store front product page as expected. With the testing I've done so far the module seems to be working fine except for this next thing I want to ask about. I thought I had come across someone asking about the quantity not displaying correctly. I searched around and can't find the post.Quote:
Originally Posted by mc12345678
On the module download page it says
" For example, if you offered cotton or polyester shirts in green, red or blue and small medium or large sizes, this add-on would allow you to enter and maintain a separate stock level for each of the 18 possible combinations"
I set up a product using this scenario
material
cotton
polyester
color
green
blue
red
size
small
medium
large
In catalog > products with attributes stock, I set up the Quantity For Product Variant using 'all - attributes - combo' for the size, color and material and added a quantity. Then I adjusted the quantities for each variant and clicked the save button. Next I clicked the sync link. The total in stock synced to 119.
In the storefront on the product page each variant shows a quantity of 119 instead of the quantity showing in admin for each variant.
Is there a way to make it show the correct quantity for each variant or is that not going to happen because there are more options making it more complex?
When you sync the variants quantities to the product quantity, what shows is the sum of all variants as the quantity available at the product level. Since all variants are part of the same product, there is really no way to show a specific variant quantity in the storefront without doing some recoding is my understanding. However, when placing a variant into the cart (and if you have check stock turned on), the quantity of the variant is used to determine the stock available. So you will not over sell what you don't have.Quote:
Originally Posted by buildingblocks
Hope that helps.
thanks batracy
Boy, do I feel dense. It took a long time to realize/understand the scenario described.Quote:
Originally Posted by buildingblocks
The deeper reason for the quantity remaining display issue here using: SBA 1.5.3 which is designed for ZC 1.5.1 and appears to work with ZC 1.5.0, is that once 2 or more attributes are presented, determining what constitutes a combination at which to display the available quantity? This eventually is addressed in one option of Dynamic Dropdowns which apparently was developed several years ago specifically for SBA.
The solution that has become accepted by most is a next option sequenced by previous option dropdown style. First selection is made, then the available second selection is presented. Second to third, etc... That plugin is incorporated into SBA 1.5.4 and is expected to be. incorporated into SBA 1.5.3 soon.
At any rate, the functionality of the modifications made to Dynmic Dropdowns in support of this version of SBA includes identifying possible variants that are out-of-stock, quantity remaining of variants identified at the last option in the list or the first option that has a child with no available quantity, whichever comes first.
There are a few other benefits incorporated, one of which is that in times past when using DD, without recoding, the entire store had to have SBA tracked quantities if anything had an attribute. While possibly convenient and necessary for some stores, not every store needs to track the amount of product that has say an option to download or email an attachment.
There are additional improvements in store as well including image changes based on selection of sub-attributes leading to full product selection.
hi guys
I downloaded the versionf rom github for zc1.5.4 but and I am ftping files slowly, but once i transfer the two files in admin/auto loaders, the admin site crashes any ideas?
thanks
Would have better ideas if the generated error messages were provided. (Sorry, forgot to include the where: check the logs folder of your site.). Also if it were explained at what point of transferring files to the site were those files transferred. Are those the only two files transferred, or for some reson the last two files?Quote:
Originally Posted by jagall
not sure if this the same/similar issue to jagall's, but i have merged/uploaded files for stock_by_attribute_1.5.4-mc12345678_ZC154, using zen cart 1.5.3, and i cant access admin, i am getting below error:
[20-May-2015 10:14:30 UTC] PHP Fatal error: Class 'products_with_attributes_stock_admin' not found in /var/www/vhosts/jarbon.com/httpdocs/dev/includes/autoload_func.php on line 79
Are you sure that the files are loaded into the correct directoories?Quote:
Originally Posted by mattys
That class observer is an admin observer and there should be the following file in your paths:
YOUR_ADMIN/includes/classes/observers/class.products_with_attributes_stock.php
yep, correct, thanks for pointing that out - somehow i had missed uploading that file 'YOUR_ADMIN/includes/classes/observers/class.products_with_attributes_stock.php'
i can access admin now
however, when i add a product to cart the content area of the page goes blank https://www.jarbon.com/dev/index.php?main_page=product_info&cPath=62_73&products_id=9
problem is i am not receiving any errors for this in logs
i have double, triple checked that all files are up
I have looked at Stock By Attribute (SBA) installation script and it is showing no errors, all seems to be in order
any ideas?
In the "check" of the files, what has been the method of checking? It may be that files didn't get transferred satisfactorily even if when looking at the directory structure they appear to be there.Quote:
Originally Posted by mattys
Also, how were the files transferred, and suggest addressing the questions posed in the posting tips found just above the message box when generating a message (and not using the mobile template to access this site.)
Hi yaQuote:
Originally Posted by mc12345678
There is no errors generated as once i transfer these two files or either one of them namely:
config.zc154_compatibility.php
config.products_with_attributes_stock.php
my admin site goes blank, complete blank screen. To be honest I didn't do any further installation as I got a bit nervy that something else would go wrong and can't have the site down.
thanks
I've been through the files several times now, all seems to be in order.Quote:
Originally Posted by mc12345678
i use winmerge to merge the files and just upload one by one referring to files list (with notes)
i am using zen cart 1.5.3 and stock_by_attribute_1.5.4-mc12345678_ZC154, sorry, most posts i have included this info, the last one i didnt though
i have just PM'd you though, see if you available to do some paid work on this, i have spent days on it, and it's just about come to a head... :blink:
Installation of plugins (and the store in general) should not be on a file by file basis unless directed to do so. The files interact with each other and the absence of one could cause troubles.Quote:
Originally Posted by jagall
More importantly, installation should initially be performed on a development server/location so that any potential issues can be worked out before thelive site is affected.
I seem to recall the details provided above, but more importantly are things like: other plugins, the source of the ZC store files, was this an upgraded store, if so how, etc...Quote:
Originally Posted by mattys
I'll get back to you shortly, but wanted to assist as able from this perspective.
here is a list of plug ins used
ceon url mapping
google merchant senter feeder (need to uninstall)
products with attributes stock
Ceon Sage Pay Form v2.0.3
Product Listing - Layout Style column plugin (product_listing.php)
database backup mysql
export email addresses
gift wrap
out of these it is only gift wrap that has code in similar files, but i have been very careful to merge properly keeping all code intact
i'm not sure excatly what you mean by the source of the zc store files, but i recently upgraded zen cart to 1.5.3, the files from standard zen cart download
im not sure what you mean by how i upgraded, i just upgraded like you normally do,except it ook me several tries and to this point a few days trying to make sure all files are merged/uploaded correctly
Thanks to some testing performed by mattys, it was identified that there was an error in the zen_get_products_stock function for when a product had multiple attributes that were grouped together as mixed attributes, and that a specific variant of the group was set to a quantity of zero, then the variant did not show out-of-stock even though there was no product.
After some testing, specifically identified, the following situation:
When a product had two attributes,
- one with 3 values the other with 2
- the attributes are added as a combination (a, 1; a, 2; b, 1: b, 2; c, 1; c, 2)
- If the combination of a, 2 is set to zero, then when displaying the product on the store side, the total quantity of a is displayed instead of the expected value of zero.
While a minor fix for that one thing, the branch(es) I started of SBA 1.5.4 have been updated to contain all of the latest fixes and streamline the various corrections into the master branch. The readme.MD file now indicates that it is compatible with both ZC 1.5.3 and ZC 1.5.4. The place to go to see these is: https://github.com/potteryhouse/stoc...ttribute_1.5.4.
Working on bringing all of the fixes and capability of SBA 1.5.4 to SBA 1.5.3 so that those still using ZC 1.5.1 can also have the same benefits. The files have been locally setup and appear functional, now trying to compare the files to a fresh install so that the number of changes necessary in a merge are minimized. Identified a few minor improvements to apply to SBA 1.5.4 that will also minimize some of the core file changes as nice as it would be to make this more of a core program. :)
For what its worth, it is now possible (in SBA 1.5.4, soon to come to SBA 1.5.3) to populate multiple attribute product either by combined attributes or as multiple single attribute variants, but not yet a combination of both. Some thinking needs to be applied before using the multiple single attribute approach as it may not make sense to populate in that fashion and may cause inventory tracking issues. It may also make a lot of sense for some. One use might be something like: flowers are being sold, with or without vases. At the moment a quantity of vases as well as a quantity without vases would need to be populated (Hadn't programmed yet the possibility of one attribute option being used for inventory while the other not). But basically, vases would be populated for the product as a total number of vases (for that product), and the number of flowers of that flower type would be populated. But the inventory would not need to be set such that there were x flowers with vase and y flowers without vase, but there would need to be x flowers, y vases, and z non-vases (which would be suggested to be the same value as x flowers or larger). The code will determine the maximum number of product combination based on the minimum quantity available of each of the attributes, hence the need to ensure that the quantity of non-vase options equals or exceeds the number of flower options. This is just a single scenario and there are many others to consider. Additional coding will continue to address this and several other options and features.
FYI, uploaded to the master branch (meaning no special tricks needed) an updated version 1.5.3 of SBA that incorporates the functionality available in SBA 1.5.4 but is ZC 1.5.1 centric. Available from: https://github.com/potteryhouse/stoc...ttribute_1.5.3
So those issues identified over the last several pages that were identified as being addressed in SBA 1.5.4 are now incorporated. It is still suggested to upgrade to the latest version of ZC; however, if one must continue to use an older version of ZC, at least SBA should still be able to function on it.
Development servers are a MUST. I have no idea why except that our gov't is stupid, but, for example, the United States Postal Service website is worked on LIVE!!! The site cannot be that big, for example, I have a 2 terabyte portable drive that should be able to contain not only the USPS site code but the database code as well. If it can't, and the USPS site and databases are more than 2 terabytes, well, that explains why our gov't is so messed up. They made a change in the code about a year ago and NOONE with an account could print a shipping label for over a week. That means that literally thousands of businesses were screwed and a good portion of them had no way to ship their products. If that doesn't convince you that a development environment is necessary, I don't know what will...Quote:
Originally Posted by mc12345678
Mal
You da MAN!!! As much as I am attempting to upgrade all of one of my customers sites to 1.54, the customer is overloading me with tiny changes and and (although I cannot no matter how hard I try) I cannot convince her to just chill out for a while so I can get her the "latest and greatest", but as lame as it may be, I do have a life and work to do on my property so a newer version of SBA that worked with ZC 1.5.1 would be fantastic!!! Thank you for putting in all the effort that you do, mc12345678 and whatever other coders and testers are involved! This SBA plugin is the most important thing I ever installed other than ZC itself!!!Quote:
Originally Posted by mc12345678
Mal
Yes there are many programmers that over the years have worked on this plugin in one way or another. Hopefully though you have seen the post indicating that SBA for ZC 1.5.1 got updated: https://www.zen-cart.com/showthread....43#post1283243Quote:
Originally Posted by Malaperth
Actually have a minor update to the SBA 1.5.4 version that is expected to prevent any issues with the store if the files are loaded but the install script hasn't been run yet. This has already been addressed in the SBA 1.5.3 version.
I'm not sure if I'm doing something wrong or not, and I've tried my darnedness to search for a answer, but can't seem to find anything so figure I'll post my issue. If it has already been addressed I apologize, but would appreciate a link to the solution.
Anyway, I've installed version 1.5.4 of sba (found it here:https://github.com/potteryhouse/stoc....4/tree/master). And I'm running ZC 1.5.4
Everything for the most part seems to work except for one aspect. I don't want "out of stock" displayed, nor do I want the "all selections of the attributes below this one are out of stock. please select a different option" pop-up, nor the text that appears below the attribute selections. If I have stock in the combination, all works fine, but if my stock is zero for combinations I get all sorts of out of stock popups and such. I'd like everything to look "in stock" until they add to cart, and then flag as backordered and allow them to check out as normal.
I thought I'd be able to accomplish this by setting Admin>configuration>stock I've set "check stock level" to false But it didn't fix the issue.
I also have SBA show available stock level in cart to false, and SBA show stock level on product info page false.
The goal is being a very small business some items I don't carry an inventory of, but will happily order from my supplier if one of my customers wants it. However that would take more time then if I had it in stock. So I'd like to give the impression that I carry everything, however the item they may want is backordered, but still allow them to check out. I can do this now, but I am constantly fighting pop ups and warning messages advising me to select something else, which is not the experience I want for my customers.
Hopefully it is just a simple setting that I'm over looking, and appreciate any help anyone can provide!!
Good detail. One small one that may have been overlooked (some reason it hides so well...) Check the dynamic dropdowns configuration section. That is from where the notifications that you are seeing are controlled. The identification (left/right/neither) of the product being out-of-stock as well as a couple of other settings.
If don't want to have any indication of stock quantities on the product page, could turn off dynamic dropdowns entirely and the customer will not be made known of any stock related options until the product is added to the cart and attributes will be presented as originally "chosen" without a sequencing requirement.
Genius! I never noticed the dynamic dropdowns menu, it was so "hidden" lol! So far I think the few tinkers with those options fixed my issue!! Thanks so much! I'll let you know if any other anomalies creep in, since I'm sure there are other option menus I'm totally overlooking!Quote:
Originally Posted by mc12345678
I would love to run a psychological experiment to figure out why it is, but even after initial testing of the iinstall process, I too missed it. It seems placed in an appropriate location, but is not placed at the end of the list as so many other plugins do.Quote:
Originally Posted by tronage
For further understanding, like how a default install of ZC has all (okay most) options turned on to show the available features, the same was done with this plugin for all functional options.
Glad that worked for you though. Please, if you find something that doesn't work right, post here or as an issue on github. Improvements beyond what has been discussed here also can be so posted. :)
First, just out of curiousity, has the other thread for the new version of SBA been abandoned? I see most of the conversation about the new version in this thread.
Next, I believe it was in the other thread that I was talking about the size of dropdowns and the truncation of their contents. I noticed, but accident actually, that the 'original' 1.5.3 version of SBA (with no changes of the two "32" settings in the attribute creation process nor any css changes to force the dropdown to a certain size) would expand to accomodate and display at least 43 characters (I apologize, I have not had time to find where the cutoff is), but when you add large amounts of characters (my customer wants one that contains descriptions of 10 items in the same dropdown!), something causes it to go back to default and only display 32 wide dropdown, but displays many more characters than shown, but does truncate at a certain point (again, I'm sorry, I did not have time to count the characters to find out at what point the truncation happens). I fully realize that the lack of full information on this is almost as much help as a kick in the ribs, but I thought I'd mention it as something may click for you.
Mal
Now I believe I know why the conversation is now here...
Anyway, with all the fixes and merges that have been done on Github, an old man like me gets confused... or maybe I'm just dense (my wife added that)... But, where can I get the absolute latest functional version for 1.5.1 please?
Mal
Sent you a PM with links to my site. The original item (with 2 attributes) works as expected, but now a new item I made with only 1 attribute is now displaying "out of stock" next to all the attributes in the dropdown. If I add a 2nd attribute to that very item then the "out of stock" messages go away. Is this a "bug" or is there somewhere else to turn off out of stock messages on single attribute items?Quote:
Originally Posted by mc12345678