How do I remove this mod? I want to change to the other stock by attributes mod.
Printable View
How do I remove this mod? I want to change to the other stock by attributes mod.
I installed this attribute and it was working PERFECTLY! And now I don't know what happened . . . Even though I have stock available, my cart won't allow checkout.
My settings are as follows:
Ok I solved my problem and I wanted to share.
We are using zen cart 1.3.8. My customer had added products to her website and added the attributes and updated her stock levels. The problem happened because one of the attributes was a read only size chart. For some reason (anyone have any ideas?) the cart didn't recognize that the products had any stock available for the products that had the size chart as one of its attributes.
However, simply deleting the read only attribute didn't solve the problem. I had to delete the original variant and REDO each variant for each stock item to make it work finally. FRUSTRATING! But so far very happy with the result that this fab attribute works again.
EchoTasha
Zen Cart v1.3.8a
Mod v4.7
Error Message when try to checkout from shopping cart:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':f7073744a0abbb14cef2678c8463e53a LIMIT 1' at line 1
in:
[SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping FROM zen_products WHERE products_id = 106:f7073744a0abbb14cef2678c8463e53a LIMIT 1]
This happens when the cart includes any product that has attributes (besides read-only attributes, those do not create this error).
Any idea what might be going wrong?
Replace the six files listed in the readme with copies of the originals from a fresh download of Zen Cart. Delete the other files that come in the Stock by Attributes release pack and ignore the database changes as they will be rendered inert by putting the files back into their original state, though if you wanted to your could drop theQuote:
Originally Posted by raspberryjamcloth
products with attribute stock table using a tool such as phpMyAdmin.
Nothing to do with Stock by Attributes I'm afraid. A default installation of Zen Cart does not have products_length, products_width and products_height, and Stock by Attributes doesn't add them. So they are being introduced by some other mod that you have installed, which is then confusing product IDs with the variants used when attributes are attached to them. But which mod this is I don't know.Quote:
Originally Posted by laeta904
Hmmm...I don't have much experience, since I just started building my site this month, so I didn't know exactly where to look. But with that explanation of the error, it sounds like it might have something to do with the "Auction Site Attributes" mod. Thanks so much for your help, I will go search on that thread.Quote:
Originally Posted by kuroi
Finally realized it was an issue with the Fedex module. Recent update at the end of July seems to have fixed the problem.Quote:
Originally Posted by laeta904
That would make sense. A shipping module might have need of the dimensions that were causing the problems. Thanks for posting back with the solution. That may help others who run across the same problem.Quote:
Originally Posted by laeta904
I have a problem that MAY be able to be fixed in a similar way that the google and paypal issues were able to be fixed, but I have no idea.
I've got a sort of 'wishlist' type thing at my store that sits next to the 'Add to Cart' button, but allows people to, instead of clicking 'Add to Cart' they click 'Add to List'. I also have SbA installed and working fine. My problem is that the javascript that checks for those items to indeed be instock when using the 'Add to Cart' button, isn't there for the 'Add to List' button, so this means that empty options are allowed to pass through and rather than that attribute option showing up like it would if you clicked 'Add to Cart' you get the blank 'TEXT' option or a blank one. And while no one can actually purchase this item, it also means that someone can add items to a list that aren't in stock.... so my question is, is there anyway to use the same javascript function that checks the stock when you click 'Add to Cart' and apply it to the 'Add to List' button?
Hi,
I'm using the current version of zencart and and thinking about installing this mod - however I have been using zencart for a while now and have a large product catalouge already set up (with many attributes...hence my need for this mod!)
If I installed this would I need to re enter all of my products that have attributes? And if not what would happen to those products that already exist with attributes?
Thanks,
Emma
PS my site is at www . butterfly - babies . co . uk
I would have thought that there were some advantages to customers being able to add out of stock products to a wishlist as then it would make it easier for them to buy them once back in stock? I suppose the only problem would be if you aren't planning on replenishing stock?Quote:
Originally Posted by laurenjj
Best wishes, Emma
Hi Emma...Quote:
Originally Posted by ButterflyBabies
The problem is that right now, if you go click "add to cart", if you haven't chosen ANY options, you get the following alert:
Attachment 6254
and are then forced to make actual options which then adds them to your cart.
Now if you were at that same page but instead of clicking "add to cart" you clicked "Add to Registry", you wouldn't get an alert, and non-options would be added as show here:
Attachment 6253
There is no 'TEXT' option so I'm assuming this is just the default...it SHOULD look like this:
Attachment 6252
Hi Lauren,
I can see what you mean - it is confusing for the customer. I've not started with this module yet so haven't got an answer for you . Good luck!
Emma
hello everyone! Hope this isn't answered somewhere in this topic... to many pages to search through..
I have a client that is having a problem and this is what he sent me in an email... could someone shed some light on this for me and lead me in the right direction?? Much thanks in advance!
Quote:
Hi John the attribute issue that we are having
except for 1 attribute created in the attribute module all of the attirbutes were duplicated. the quantity on the new items was set to 3 on the dup items. we did not make any changes. Also the order is changing of the items. normally they stay in the order that they are entered but for some reason the cherry low goes into place with the marlboro grouping
Thanks
Originally I had a reply from kobra to install the 'Stock by Attribute' and I downloaded a module from the add-ons:
http://www.zen-cart.com/index.php?ma...roducts_id=310
It seems this is incomplete and not the correct module as it does not subtract stock from the attribute value when an item is sold.
Can anyone confirm the correct one to do this??
Nyone help with my previous posting??? thanks
I can only speak for the plain 4.7 version, but with that no you wouldn't need to set anything up again, You would merely add stock to the attribute combinations for the products whose stock you wish to manage at that level.Quote:
Originally Posted by ButterflyBabies
Not answered in this thread as your client appears to be referring to a problem with the structure of his attributes. This module does not touch the underlying attributes or their structure and so can't be the cause of the problem.Quote:
Originally Posted by johndiaz
This problem can occur because the AJAX version is incomplete, or because of installation errors with the other versions. There's plenty of information about both repeated several times earlier in this thread.Quote:
Originally Posted by gprit
Hi there,
Supposing we wanted to modify this so that it didnt repeat the attribute description in the menu.
At the moment the default value for the dropdown is "UK shoe size (Mens)", but it would make sense to have a shoe size eg 4 as that first value.
Any idea how to do this?
Warm Regards,
Joel
"This", the stock by attributes mod has no involvement in building the pulldown menu. As this thread is over 700 posts just on the mod, it would be a bad idea to extend its scope into other attribute-related queries too. Besides your question warrants a thread of its own.Quote:
Originally Posted by optimalwebsite
But before you start one, could I suggest that you consider whether this really is a good idea. My experience suggests that changing to having a particular size as a default leads to a sharp and expensive increase in the number of orders returned for sizing issues, and hacked off customers who feel that the site is poorly designed.
I'm getting script timeout issues with this module. Is this a known problem? I am a web developer and I have come across similar issues when using jQuery to loop through a large page.
Any thoughts?
It would be useful to know what you were doing when the timeout occurred, which version of the mod you are using and your hosting configuration e.g. PHP memory limit and timeout settings. That said, this is not a problem that I have heard of previously in 3 years of supporting versions 4.0 - 4.7 (I can't speak for multi-add or AJAX).Quote:
Originally Posted by Flipside
Having a problem here using this mod.
I have 2 attributes for T-shirts: Size and Color.
For each variation of instock colors, it shows the attribute value, so if I have 3 sizes of white shirts, it shows "white" 3 times.
My menu now looks like this:
size color
---- --------
S White
M White
L White
X Black
Black
Red
Any fix for this?
Hello,
New-ish ZenCart user here, and first time poster, so please be gentle with me :blink: I've read for hours through this thread and don't see an answer, so here goes...
I've successfully installed this wonderful add-on and have it working great for various clothing items with different sizes. But I'm having a slightly strange problem with an additional attribute that I've just added to one particular item.
The shirt comes in different sizes, as I mentioned, but I've added the option to have a name/number printed on the back. Everything went smoothly in creating a TEXT-type option for this purpose and applying it as an attribute to that particular product. It all looks good for the customer, who can choose the size they want, fill the text field with the name/number combination they want printed on the back... until they add it to the cart. When they do that, a message in the cart screen states that the product is out of stock (when it shouldn't be). However, if the customer then removes the offending item from their cart, selects the same sized jersey again but this time chooses not to enter a name/number in the text field, the cart is suddenly a happy camper!
Any ideas if this is something I messed up or if it's a limitation of the add-on? Any guidance would be greatly appreciated :blush:
I'm using ZC 1.3.8a, SBA 4.7Multi-add, no other add-ons. Here's a link to the product I'm describing so you can see the behavior for yourself.
It's not you. It's a known limitation of the mod.Quote:
Originally Posted by James Calder
Because the mod is looking at the values of the attributes and comparing them to the values for which you have stock, and you don't have a product variant that includes the specific number that the site user enters the mod treats it as out of stock. In other words it doesn't play nicely with products that have text attributes.
kuroi - thank you so much for the swift response!Quote:
Originally Posted by kuroi
I have a problem: I have an helmet with the following choice:
size M and size S, colour red and colour black
I have 2 medium red and 2 medium black, no size S. Total 4 helmets.
If a customer want to buy 4 medium black or 4 medium red or 4 Small in the shopping cart there is no message that they are out of stock, but if he want to buy 5 medium black, it says 0 quantity available.
why? is it normal for this mod?
Common problem, much discussed in thread already. Means that either you haven't installed all the files properly, or are using the AJAX version. More information above.Quote:
Originally Posted by thenax
Yes i've installed the ajax version. which version do you refer? where can I download it?Quote:
Originally Posted by kuroi
i found only the ajax version in http://www.zen-cart.com/index.php?ma...roducts_id=310Quote:
Originally Posted by thenax
Seeing as Zen Cart v2 has been put on hold indefinitely, I have a questions.
1) Has anyone managed, with this mod, to be able to hide an attribute from the drop down list when stock levels equal zero?
2) As the Ajax version of this mod is incomplete, I am going to try installing the previous 4.7 version of this mod (non Ajax). If I download it from the add-on section will it contain all the latest files?
Many Thanks
This is simply not true. I suggest that you head over to the Discussion about 2.0 thread where one of the Dev Team posted recently about the work that is currently being done on 2.0.Quote:
Originally Posted by solarwinds
http://zencart2.com/Quote:
Originally Posted by kuroi
So is there a glimmer of hope that things are moving along?Quote:
Zen Cart 2.0.0 Beta Release Postponed Indefinitely
I'd be very careful about anything that you read about the Zen Cart project on that site. It has absolutely nothing to do with the actual Zen Cart project and the person or persons behind it are not those who actually write and maintain Zen Cart.Quote:
Originally Posted by solarwinds
So yes, there's a helluva lot more than a glimmer. Personally I'd like to see Zen Cart 2 given a 5exy code name, that'd leave the cyber squatter with egg on his face ... but that's another topic and not for this thread, so I'll leave it there.
Is this bug referring to this problem?? I am using version:
Stock by Attributes v4.7a on 1.3.8
Hey there can someone advise me on what seems to be the problem here? I am using 1.3.8 and have stock
Improved attributes mod and
Product with attributes Stock added I have used this no problem with 1.3.7.
What I am doing is this : add an item add the sizes
then add another name with 3 values under attributes see here:
when i go into Product with attributes Stock
Not only do the options for my new drop downs no longer show but I get this error when I try to add the stock count for each?
Warning: Cannot modify header information - headers already sent by (output started at /home/tyler/public_html/shop/admin/products_with_attributes_stock.php:193) in /home/tyler/public_html/shop/admin/includes/functions/general.php on line 21
Help! : ) Thanks in advance
Red
Tried again removing the secondary option and even with using the same quantity for "all" sizes .
So I go to add quanity for product variant and
I get this error when i simply select quantity "1" for all :
att: 5224|5225|5226
Warning: Cannot modify header information - headers already sent by (output started at /home/tyler/public_html/shop/admin/products_with_attributes_stock.php:193) in /home/tyler/public_html/shop/admin/includes/functions/general.php on line 21
I am sorry If this is a repeat but it does not seem that anyone is talking about the same issue I am although I have realized that even though I have set quantities and turned off being about to check out if quantity is 0 that is happening as well creating a -1 etc.. in the catalog.
Renee
[FONT=Comic Sans MS]
[/FONT]
I have read about the multiadd version and to use the order.php file from that mod and it will correct the quantity problem but i have searched and cannot for the life of me find the download. What is the link to this download?
Thanks
You're using the multiadd version in which the author left a debug statement that kicks in and causes this error. You can safely remove line 193 from your admin/products_with_attributes_stock.php file.Quote:
Originally Posted by Redcinamn
It's the same as for the other versions, but you need to scroll down to find it amongst the earlier releases. Currently it's second from the top, or you could do a page search for "MULTIADD".Quote:
Originally Posted by Tagyourbaby
I have just assigned a quantity to an attribute in attribute stock in administration panel. Now I would like to eliminate the attribute created inside the attribute stock panel but it's impossible. why? (i tried to click on Eliminate but it doesn't operate because it's always shown.
Being as there are 3 different "types/versions" for this module [ 4.7 - 4.7MULTIADD - 4.7ajax ] people will have to state which "type" they are using if they have any hope of getting good answers.
It's not right that kuroi should have to carry the brunt of answering questions regarding all 3 when he only created the 4.7.
Maybe the other two Mod updaters / version creators, will step up to the plate and answer questions about "their" version?
Thanks RobQuote:
Originally Posted by Website Rob
Part of the problem is that I often can't answer questions about the other two. I've not had reason to use them, and so have limited knowledge of them.
I've considered a few times consolidating them into a single update, but my version was extensively tested to a high standard and doing the same to two sets of code that I didn't write and for which I have no need ... well you can see why it's sitting near the bottom of my to do list. :wink:
Well I'm glad you're still supporting the 4.7 ver.. (Not that I've EVER had one issue with it -- it does JUST what it promises to do:clap:)Quote:
Originally Posted by kuroi
However based on your posts I did do some testing of the "MultiAdd" version and visited the demo store for the Ajax version..
Personally I saw nothing in these other versions that would complete me to change to one or another of these versions. I didn't see what I was getting in the "MultiAdd" or the "Ajax" version.
That said, I must confess that I did "borrow" the stylesheet from the MultiAdd version as I liked the way it made the product variants easy to distinguish from the parent product..:blush:
Is there anything that i did wrongly during the installation of this mod?
I find it extremely difficult and hard to edit the product stocks qty under products with attributes stocks.
As attached is a screenshot of my layout in my site's backend. please do advise thanks alot! As i spent alot of time editing and there are so many items!
http://img142.imageshack.us/img142/1516/layoutjp.th.jpg
As Rob suggested.. it would help if you said which flavor of this mod you are using..Quote:
Originally Posted by brocolee
Not sure what your question is.. Define what you mean by "extremely difficult and hard to edit the product stocks qty". Not trying to be a smart a$$, but the statement is somewhat vague..Quote:
Originally Posted by brocolee
Again, not trying to be a smart a$$, but the statement is also somewhat vague.. A little more detail on what you are having difficulty with would help others to help you..:smile:Quote:
Originally Posted by brocolee
FREAKING OUT NOW!!
I have installed the AJAX version of this. I assumed that seeing as it was the most recent, it was the best to go with. Now it seems there are files missing...
Now that I have installed this module, I cannot checkout. I keep bouncing between logging in, and the shopping cart.
- I have checked to make sure there is stock
- I have enabled 'Allow Checkout', even though I don't really want this enabled...
- I have installed an earlier version to ensure I have all the files.
Where to from here?? The site needs to be live this weekend, and I was nearly done. Now you can't buy anything!! :yuck:
Site is: www . wooshi . com . au / index . php (you need to include the index.php to get past the 'coming soon' message).
Any help would be greatly appreciated!!
Turns out this module is not to blame. I must have had a burnt cookie on my laptop. Once I discovered everything worked on other computers, I deleted all cookies, and now it works a charm!!
Can anybody tell me if there is a way to sort attributes on the stock page? It seems after deleting attributes and adding attributes they all get mixed up under a product. They are not getting sorted by "stock ID". I'm sure the problem can be sorted with products_with_attributes_stock.php, just need some direction.
Here's an example:
751 Color: 1B = Black Length: 18" 0 Edit Quantity Delete Variant
582 Color: 1B = Black Length: 26" 8 Edit Quantity Delete Variant
581 Color: 1B = Black Length: 24" 5 Edit Quantity Delete Variant
580 Color: 1B = Black Length: 22" 7 Edit Quantity Delete Variant
I would like to reorder these! It's tough trying to stock 30 different lengths for dozens of products!
This mod doesn't affect the display of attributes in any way. It merely attached stock to combinations of them.Quote:
Originally Posted by swamyg1
However, product options from which attributes are created do sort orders. You just set them in the Options Value Manager.
But this mod does use create the new page products_with_attributes_stock.php, that's where I am getting mixed attributes which I would like displayed in an orderly fashion. I need them ordered on the back end so it makes updating not so tedious.Quote:
Originally Posted by kuroi
Does that make sense?
I believe they are ordered by the ID for each variant. It's probably a matter of lacating the query for this display and changing the sort order parameters.. (I know.. I've been LOADS of help huh??:laugh:)Quote:
Originally Posted by swamyg1
We just installed the latest version of this mod on our site and it wasn't reducing the stock for the attributes when an order was replaced. Upon further investigation, the includes->classes->order.php mentioned in the readme wasn't included in the latest zip file. I grabbed it from an older zip and it works fine now. Just FYI.
FYI, the "latest" version (the Ajax version is broken in more ways than that..) Both the Ajax and MultiAdd versions are poorly written and NOT supported by their original authors.. The version written by Kuroi is the one you want.Quote:
Originally Posted by sarabz
[FONT=Times New Roman]STOCK BY ATTRIBUTE PROBLEM[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Is there anyone who can help? I have version 1.3.8 of Zen Cart. [/FONT]
[FONT=Times New Roman]Because I needed two lots of attributes on some products I downloaded Stock_by_Attributes V 4.7.ajax as advised for my version of Zen Cart.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]I’ve followed the read me instructions but they don’t tell you where to put the files held in the Ajax Folder or where to put the Ajax Folder. Apart from that I have another problem – I’ve added products in CATALOG>PRODUCTS WITH ATTRIBUTES STOCK >PWA_ADD_QUANTITY and PWA_SYNC_QUANTITY i.e. Tunic1 Size 8 Colour White amount 7 & Tunic1 Size 8 Colour Black amount 7 on the site it shows overall amount of 14 and when ran through the check out if ordering more than the added amount for white size 8 for instance doesn’t tell the customer it’s out of stock unless ordering more than the overall amount being 14. [/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Also if you ordered 3 of Size 8 colour White it would show on the site page as overall amount reduced by 3 making the amount now 11 instead of reducing the items amount from 7 to 4[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]I’ve read in the forum that this version was missing INCLUDES/CLASSES/ORDER.php so I downloaded V 4-7 and uploaded the file from here but unfortunately nothing has changed.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Any help will be gratefully received. Please, please help![/FONT]
:dontgetit
[FONT=Times New Roman]STOCK BY ATTRIBUTE PROBLEM[/FONT]
[FONT=Times New Roman]Is there anyone who can help? I have version 1.3.8 of Zen Cart. [/FONT]
[FONT=Times New Roman]Because I needed two lots of attributes on some products I downloaded Stock_by_Attributes V 4.7.ajax as advised for my version of Zen Cart.[/FONT]
[FONT=Times New Roman]I’ve followed the read me instructions but they don’t tell you where to put the files held in the Ajax Folder or where to put the Ajax Folder. Apart from that I have another problem – I’ve added products in CATALOG>PRODUCTS WITH ATTRIBUTES STOCK >PWA_ADD_QUANTITY and PWA_SYNC_QUANTITY i.e. Tunic1 Size 8 Colour White amount 7 & Tunic1 Size 8 Colour Black amount 7 on the site it shows overall amount of 14 and when ran through the check out if ordering more than the added amount for white size 8 for instance doesn’t tell the customer it’s out of stock unless ordering more than the overall amount being 14. [/FONT]
[FONT=Times New Roman]Also if you ordered 3 of Size 8 colour White it would show on the site page as overall amount reduced by 3 making the amount now 11 instead of reducing the items amount from 7 to 4[/FONT]
[FONT=Times New Roman]I’ve read in the forum that this version was missing INCLUDES/CLASSES/ORDER.php so I downloaded V 4-7 and uploaded the file from here but unfortunately nothing has changed.[/FONT]
[FONT=Times New Roman]Any help will be gratefully received. Please, please help![/FONT]
@hilarsh
I'd recommend putting the ajax folder in your cart's root folder next to the admin and includes folders, i.e. preserve the structure that they're in in the release package.
As to why it's not working, there is some commentary about this earlier in this thread, but it appears that the version you are using is unsupported, so be prepared for the possibility that there may not be an answer.
[FONT=Comic Sans MS]Kurio [/FONT]
[FONT=Comic Sans MS][/FONT]
[FONT=Comic Sans MS]Thank you for your quick response. Do you think I would be better reverting to backed up version of site and starting again with V4-7? And if so should I use the CSS contained within, will it alter any changes I’ve made?[/FONT]
[FONT=Comic Sans MS][/FONT]
@hilarsh
I can't really comment on the best path as I haven't used the other 4.7 versions. DivaVocals is in a better position to advise on this.
I can tell you that that the vanilla 4.7 version isn't the easiest to use on large sites or sites with lots of attributes, and doesn't do everything that people would like on the cart side in terms of reporting stock against attributes prior to the shopping cart. However on the plus side, it and its predecessors have been very thoroughly tested and despite no genuine bugs have been found for at least two years against carts where it is correctly installed, so it's very reliable.
**Nods in agreement**Quote:
Originally Posted by kuroi
I set up a test store that I use to test out various mods before I install them for my clients.. I had been running the Kuroi version of SBA for a while, and decided to check out the other two versions to see if I could get a sense for two things:In my testing I discovered that there are issues with the MultiAdd version (mostly in that it does not "manage" the inventory counts correctly) It also has a few other quirks one of which is that it does not appear to allow you to enter "0" for a product variant's inventory count. The Ajax version is missing files, and even when I added the correct files it still doesn't appear to work or "do anything" that I found spectacular. Now perhaps this is because it just doesn't work. and given the missing files I would say this that is really the case.
- Were these version as problematic as they seemed to be based on the posts in the support thread
- Was there an real compelling reason to use either one of these versions.
Also telling for me is the fact that the authors of the Ajax & Multi Add versions have never fully supported their versions despite the reported issues with them. (missing files, errors, just not behaving correctly for lack of a better way to put it)
Not trying to be harsh and not trying to call folks out, but one these authors has posted a total of THREE responses to questions regarding his version of SBA, and the other author has posted a total of ONE time to this forum PERIOD.. AND the one post was NOT on either of the SBA support threads.. So for this me this said a LOT..
Now don't get me wrong, I do not look at the mod authors participation on this forum as the ONLY indicator of whether or not to use a mod. (there are plenty of stable add-ons I use that require little to no mod author support becasue they just WORK..) I also evaluate the mods overall stability and the community support as part of my determination to use a mod or not. However in the case of the SBA mod there are three things which stand out for me:So for these reasons I use the Kuroi version of SBA with the stylesheets from the MultiAdd version. I do like the stylesheet used in the MultiAdd version of SBA becasue it makes a very nice visual distinction between the parent product and the child variants. So I this is the only part of the MultiAdd version that is worthwhile IMO.
- Kuroi has ALWAYS very generously supported his SBA mod and for that matter every other mod he's contributed to the community
- The Kuroi version of SBA is tested and STABLE, and if installed correctly, it WORKS as described. (no more no less)
- The community support for this mod is HIGH and full of helpful folks.
Like Kuroi says, for sites with lots of products with attributes it may be a bit overwhelming to manage the stock. However I believe that this could be overcome with a different management interface. Also like Kuroi says the mod does not support "sequenced" dropdowns or visually tell folks which product variants are out of stock from the cart side. However, there is a mod that has been specifically written to work with SBA that might help with that last point. (Product Attribute Grid) For the record, neither the Ajax or MultiAdd versions added any additional functionality in those areas.
Arguably for someone who wants these abilities they should give some consideration to paying a developer to make those changes for. (ScriptLance or Rent A Coder are excellent sources to shop projects like this) However, I have managed to come up with ways to make SBA work for my clients. It's all about product setup planning to get SBA to work well for my clients.
HTH
Let me clarify part of what I posted.. There are at least two very active SBA support threads. Besides this thread there is also this thread:Quote:
Originally Posted by DivaVocals
http://www.zen-cart.com/forum/showthread.php?t=34977
Several (including this one) contain posts which appear to "resolve" this. (an example can be found here: http://www.zen-cart.com/forum/showpo...&postcount=642)
However it should be noted that these solutions only add this functionality for products in which you are creating SINGLE attribute product variants. (ie: Small t-shirt)
If you have product variants which include MORE THAN ONE attribute (ie: Small, blue t-shirt) these "fixes" don't appear to help with display of out of stock product variants which include more than one attribute.
I have a problem.
I have items in many colors and sizes. But I can't prevent a customer from adding a item that is out of stock if one attribute as stock remaining.
I SWEAR I'm not trying to be a smart a$$..:smile: BUT.. if you look at the post RIGHT above yours I JUST talked about this.. This is why I ALWAYS recommend that folks read through support threads in their entirety.. It's very likely that your question has already been answered..:smile: HTH..Quote:
Originally Posted by bebe
Hello to all
I am a new zenner and have uploaded the most recent version of the attribute stock add on to my site. I tested the add on and noticed that the merchandise with stock set to 0 still can be added to the cart and does not show out of stock until the shoppingcart comes up. is there any way to install or modify something in order to say out of stock beside the sizes which have no stock. I am not too familiar with code completely so I do apologize.
Thanx
Steve
Again.. I SWEAR I'm not trying to be a smart a$$..:smile: BUT.. if you look at the other posts RIGHT above yours (posts 762 & 763) I JUST talked about this.. This is why I ALWAYS recommend that folks read through support threads in their entirety.. It's very likely that your question has already been answered..:smile: I KNOW people don't like reading through some of these long threads, but it REALLY IS helpful..Quote:
Originally Posted by Tuffmonkey
HTH..
Hey diva i noticed a few moments afterwards that it was right above. I have added the code so that if the quantity is 0 then it is not displayed. however I tested my site and the product is not removed from my stock once the merchandise is purchased is there any way to have it reduce stock level once something has been purchased? this I could not find in the thread or maybe my sight lef tme for a while and missed it.
The issues with stock not being removed from the inventory seem unique to the MultiAdd or Ajax versions.. I have not had an issue with this functionality working properly using Kuroi's version. Are you using the Ajax version??Quote:
Originally Posted by Tuffmonkey
Hey no Im using Kuroi's version as well.. the link provided in the orignal post is the download I used.
Okay so correction on this one. Apparently as I did read there is an issue with the ajax I told the individual to add kuroi's he did not and added the ajax files. can this be fixed in the ajax module or do I have to download and uplaod kuroi's?
**poof** (AKA - Deleted.. now you see it.. now you don't):laugh:
Like I said, the inventory management issue is unique to the Ajax and/or MultiAdd versions.. The author of the Ajax and MultiAdd versions have never fully supported their work.. So to answer your question, yes I'm sure there is a way to fix it.:smile: However, to my knowledge no one has posted a fix for this issue for these versions, and if they did it would be posted in one of the SBA support threads (so a thread search might turn up the solution)..Quote:
Originally Posted by Tuffmonkey
Your best bet is this:
- Use the Kuroi version of the SBA module
- Use the stylesheet from the MultiAdd
Okay so does poof mean I need to install Kurois? lol im gonna poof the guy who uploaded the wrong one thats forsure
sorry to make life such a hassel but is the style sheet the only thing I add from multiadd? and do the two coexist with one another?
The stylesheet from the MultiAdd stylesheet makes a nice VISUAL distinction between the parent (product) and the children (product variants)..Quote:
Originally Posted by Tuffmonkey
Thanks so much diva I am attempting to do this myself.Quote:
Originally Posted by DivaVocals
This is kind of down to DivaVocals. Following his observations in another thread, praising Kuroi's version, I installed Kuroi's version of this contribution to see whether the sort order of the attributes could be altered. Unfortunately not it would appear.
The problem is getting the attributes to show in an ordered manner, the more you have the bigger the problem
There has been periodic reference to this feature in this thread
Kuroi you have commented very early in this thread that the contribution does not influence the sort order and this is down to Option name value sort order
I have changed their sort order but the contribution still insists on doing the attributes in the original (alpha?) order. From looking at the code the contribution appears to have functions that set the order (contrary to Kuroi's comments)
Can any one please give guidance on this or has anyone found a solution work around please?
Thank you
1st HE is a SHE..:smile:Quote:
Originally Posted by Centec2b
Secondly, my consistent recommendations to install Kuroi's version of this mod has EVERYTHING to do with the fact that FUNCTIONALLY Kuroi's version is the only one to install trouble free, and work as it should without weird errors and other issues that have plagued the other versions of this mod.
Now from a USABILITY perspective is there room for improvement with this mod?? Yes, and Kuroi has on MANY occasions said as much. Features such as the order of the attributes/variants (I assume you mean the order in which they appear in the admin), not showing variants in the store which are out of stock, etc are all desirable features.. However Kuroi has also said VERY clearly that he will not be developing this mod further to close some of the usability gaps since the upcoming Zen Cart release has addressed some of these needs..
The sort order of the attributes and variants in the admin does not stop this mod from working from a FUNCTIONAL perspective as it should. It's a usability issue, and I'm not sure anyone has come up with a fix..
Now if that still gets a "down" to me.. sorry to hear it.. I like SBA, I recognize it's few flaws, and have had NO ISSUES finding ways to work with it for my clients.. I may invest money in a developer to add the few features I think it is missing.. I'm certainly considering that..:yes: For now it works just fine..
Hi, I have install the 'Stock by Attributes v4.7ajax' end work good :D byt a have the problem.
Hay to set up thet the attribute of product in shop showing amount of stock.
I wont to user see hay mach is stock of each attribute??
:blush:
Thenks.
www.kavanali.com
Ahem...........Quote:
Originally Posted by DivaVocals
I seem to have inadvertently caused offence.........
DivaVocals it is very hard to type upside down in the ordure wearing a sack cloth...........................
Apologies for the mistake in gender - I guess I near enough had a 50% chance to get it right
Second - I did not wish to impute any criticism of any individual on the contrary, I have immense respect and admiration for the authors of any contribution and the people that give their time and trouble to help others.
Third - my reasoning was that having made changes in my test system to alter the sort order, based on information gleaned and my own reasoning, if that did not work, would a different version of the contribution make a difference. IE eliminate a "what if"
Having received guidance, I can now go away and tinker with the system to see if I can effect a solution - there was no point in trying to do the work if someone had already found a solution
Best wishes - a chastened Centec
:hug:
Not offended.. well except the part about being called a HE..:laugh::laugh: (seriously, you thought a name like DivaVocals was a MALE screenname??:laugh::laugh:)
Otherwise it seemed as if you were dinging me for a feature that isn't part of the add-on.. So I wasn't offended, just wanted to clear up any misunderstandings is all..:smile:
Of course it may be a cultural difference.. saying "down to you" in the USA is sort of a put down..:yes:
Anyway bygones.. to address part of what you said, the other versions of this add-on started out with Kuroi's as a foundation, so I imagine except for the new features they brought to the table, they would function almost identically. If you want to attempt to find a solution, I suggest starting with Kuroi's version.. It really is the most stable.. Even the new Ajax version does not work correctly still... (I posted my test findings in the other SBA thread..)
Quote:
Originally Posted by Centec2b
Not a feature of this mod. You might try using the Attributes Grid add-on along with the SBA mod.. This is the only mod that has been setup specifically to work with SBA.. For single or two attribute variants, the Attributes Grid add-on will visually indicate to your customers which variants are in stock.Quote:
Originally Posted by kobra8
Am having a layout issue with the "Stock by Attribute" add in
ZenCart version 1.3.8a
Installed the Ajax version and all appears okay except the layout for Admin > Catalog > Products with Attribute Stock is just a mass of text - there is no styling applied.
I did the recommendation on here and added the following files from the MultiAdd download:
- admin/includes/stock_attributes.css
- admin/includes/stylesheet.css
- admin/orders.php
However it still looks like a mass block of text with blue links in it. Any suggestions - and any ideas when ZenCart will include this as part of the build?
Thanks
Just so it's clear, MY recommendation was to use the stylesheet from the MultiAdd version with KUROI's version of SBA.. NOT the Ajax version.. (Not sure who recommended using the orders.php file from MultiAdd version.. I don't remember seeing anyone suggest that)
There are issues with the Ajax and Multiadd versions of SBA, and YES while there is a new version of the Ajax version which addressed SOME it's specific issues, it still is not working as it should.. I posted more about my testing of the latest Ajax version in the other SBA support thread: http://www.zen-cart.com/forum/showth...=34977&page=83
Bottomline is that the only issue free version of SBA continues to be Kuroi's version. The stock tracking by attributes feature are supposed to be included in the upcoming Zen Cart 2.0 release..
Quote:
Originally Posted by andoverit
Quick question...
Here's the functionality I need, and I was wondering if this module provides this or not.
Say I sell Widgets in Blue and Red and Thingies in Green and Orange and I have 200 of each type/color. I also have a package deal where I sell a package of your choice of 5 Widgets and 5 Thingies together for cheaper than buying them separately. Will I be able to make it so that whether someone buys a Widget or Thingie separately, or they buy the package deal, it will subtract it from my pool stock of 200 of each type, so that inventory stays constant?
Thanks! :D
:wacko: That made my head hurt.. :laugh: But I think I get what you are saying, and my suggestion is to take a look at the "Better Together" add-on.. It sounds more like what you are looking for..Quote:
Originally Posted by nitetiger4
Thanks! I'll take a look at it and see if it'll do what I want. :)
Using ZC 1.3.8a and SBA 4.7Ajax.
Have seen this question in the past but not a good answer yet. I am using attributes marked in Attributes Controller as Display Only and Default in order to direct customers to pick an attribute (for example "Pick a Color" or "Pick a Size").
Is there any way to modify Stock By Attributes to ignore attributes that are marked as Display Only? The customers would never be able to select these and therefore there is no stock tracking necessary. Seems to me that it should be an easy mod and desired by everyone using this plug-in.
I know I can delete these manually, but it takes too long when you have a lot of them.
Thank you! :smile:
I tried to search but couldn't find a clear answer. Is there a step by step guide how to install this mod?
Its still great plugin but I just don't need it with our current setup. Thanks!
I just finished upgrading a clients site from 1.3.7 to 1.3.8a. I've applied all the security patches. The site uses the xGiftwrap Module and the Stock by Attributes module. I'm not sure if my problems are related to the stock by attribute add-on, but it seems like it may be.
The issue my client is having is that shoppers are able to go through the purchase process and buy products that are out of stock. When an out of stock product is placed in the cart, the red box warning about something being out of stock shows, but it allows the shopper to continue on and check out.
Any ideas on how to fix this?
I've been wading through the many pages of this thread looking for a solution to my client's problem that I mentioned above. I found a post that reference the same exact problem, but dealing with older versions of ZC and Stock by Attributes. It seems that the issue was and incompatibility between the particular versions of ZC and Stock by Attributes. I'm wondering if that is the problem I'm having. As I mentioned, I just upgraded to 1.3.8a. I installed SbA v4.7ajax. Is there an incompatibility between those versions? I'll keep looking to see if I can find an answer to this. If anyone knows the answer, please do let me know. :smile:
I found posts stating that these types of issues are usually due to either:
- files not being correctly uploaded, or
- leaving old files on the server.
I compared the modified files from the SbA v4.7a with what I had on the server and found a couple of discrepancies between them. The discrepancies weren't in any of the code that was marked as part of the SbA edits, but none the less when I corrected those discrepancies the store is no longer allowing me to check out with items that are out of stock. :clap:
I MEANT TO SAY UNINSTALL! Please advice!Quote:
Originally Posted by poosk
No step by step or uninstall.. You will have to go through and manually reverse everything (SQL entries, and remove SBA specific files..)Quote:
Originally Posted by poosk
Hi
I have had a requirement to create a custom column within the products_with_attributes_stock so that stock level could be automatically updated based on my suppliers product codes.
What I need to do now is to incorporate something that populates this column when adding quantities to variants.
Its very simple really, my codes are always just a number, my suppliers are this number plus a letter on the end Dependant on the size, for example:
1000 would be my code so in the modified table there would be:
stock_id products_id stock_attributes quantity suppier_id
6 1 7 12 1000S
where product id 1's model id is 1000
stock_attributes 7 = small
thus creating 1000S
I see in the products_with_attributes_stock.php file the query is:
So I would need something like this:PHP Code:$query = 'insert into `'.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.'` (`products_id`,`stock_attributes`,`quantity`) values ('.$products_id.',"'.$attributes.'",'.$quantity.')';
to obtain the variable $supplier_id I need two variablesPHP Code:$query = 'insert into `'.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.'` (`products_id`,`stock_attributes`,`quantity`,`supplier_id`) values ('.$products_id.',"'.$attributes.'",'.$quantity.','.$supplier_id.')';
The first being the model_id - easy enough as it can be taken from the products_id already obtained for the page
The second is the option_value_id based on the section made in the form.
From these I can run an if string to get the $supplier_id value - a bit like this:
I am having trouble working out where I need to call the values etc. If anyone is willing to give me pointers I would very much appreciate it :o)PHP Code:if ($options_value_id == 4){
$supplier_id = $product_model.'S';
}
if ($options_value_id == 5){
$fullprodid = $product_model.'M';
}
if ($options_value_id == 6){
$fullprodid = $product_model.'L';
}
if ($options_value_id == 7){
$fullprodid = $product_model.'XL';
}
Cheers,
Phil
my bad that should have been:Quote:
Originally Posted by philip937
PHP Code:if ($options_value_id == 4){
$supplier_id = $product_model.'S';
}
if ($options_value_id == 5){
$supplier_id = $product_model.'M';
}
if ($options_value_id == 6){
$supplier_id = $product_model.'L';
}
if ($options_value_id == 7){
$supplier_id = $product_model.'XL';
}
Kuroi I ran the sql command you advised in order to uninstall but I broke the whole cart down!Quote:
Originally Posted by kuroi
1146 Table '****_products_with_attributes_stock' doesn't exist
in:
[select pov.products_options_values_id, pov.products_options_values_name, pwas.quantity, pa.* from ****_products_attributes pa, ****_products_options_values pov, ****_products_with_attributes_stock pwas where pa.products_id = '318' and pa.options_id = '2' and pa.options_values_id = pov.products_options_values_id and pwas.stock_attributes = pa.products_attributes_id and pov.language_id = '1' order by LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_name]
Quote:
Originally Posted by kuroi
Ok found it :) There was a file called attributes from probably older version in modules folder...Quote:
Originally Posted by poosk
Hello guys,
I wonder is that possible to create a link that shows only products that are INSTOCK.
** I would like to remain out of stock items in my catalog, but i wish to have an additional link to show ONLY INSTOCK items**
Help is appreciated.
Thanks so much!
Regards,
June
Hi zenners!
I took over a client's shopping cart (v1.3.8) about 6 months ago. It has the stock by attributes add-on. I recently added new SKUs and the USPS shipping module seems to be out of whack because of the new SKUs (and only new SKUs) and their attributes with stock. Out of whack meaning that the shipping estimates are outrageously expensive.
These rates are only with the new items and not the old. I have made sure that the new items have correct weights to price out shipping, but I am stumped. :frusty: I am 80% sure that it has something to do with stock by attributes because this is not happening on the old items.
www.innerwaves.org
Thank you,
Michelle Carbone
SBA would not affect shipping rates in anyway. However if you have product attributes which have weight differentials (which would be are added on to the overall product weight), then that might be the source of your shipping calculation issue. (see screeshot attached) If this is the case, this is NOT an SBA issue, but simply something you need to correct in the way your products and attributes are set up.Quote:
Originally Posted by mcarbone