where can I obtain a copy of the Kuroi version please?Quote:
Originally Posted by DivaVocals
Printable View
where can I obtain a copy of the Kuroi version please?Quote:
Originally Posted by DivaVocals
If you look at the page for Stock By Attributes, scroll down through the previous versions. Find ver 4.7 by Kuroi that does NOT have Ajax or MultiAdd after the version number..Quote:
Originally Posted by philip937
Hi,
I read through the features of Stock by Attributes and only want the feature where it shows how many pieces are available when customer attempts to purchase over the available qty in cart.
Right now when someone tries to purchase over the stock amount per product, the message just says "There is not suffcient amt..." but doesn't really say how many are left for them to purchase. This is frustrating to customer who sometimes do not look at the available stock description on the product info page.
Does anyone know which files these are? Is it possible to just extract this portion and still use the regular stock by product feature of zencart?
I'm using zencart 1.3.8a. Thanks
This should be posted in a separate thread as it is not a Stock By Attributes support question.. You'll probably get more answers that way..
Quote:
Originally Posted by Decostyle
I'm nearly fully up and running now. just a few niggles I need sorting..
1. When I have my stock settings to disable product when out of stock, they still show??? is there a fix for this? I did notice that the drop down attributes behave correctly and switch off if the attribute is out of stock, but if all attributes are out of stock and the overall product_id is out of stock, it still shows...
2. I want my products to go out of stock when stock level reaches 30... I found a post saying you only had to change one setting for this, but when I do only what was described below, the product shows out of stock, my attributes stay showing too...
Can anyone advise on any of this??
Cheers.
Phil
forgot to add the suggested change needed:
i figured it out it was really simple actually
this is the only file you have to edit:
/home/rickie/public_html/includes/functions/functions_general.php
Line #1146 : case ($button_check->fields['products_quantity'] <= 5 and SHOW_PRODUCTS_SOLD_OUT_IMAGE == '1')
It originally said case ($button_check->fields['products_quantity'] <= 0 and SHOW_PRODUCTS_SOLD_OUT_IMAGE == '1')
I just changed it to "<=5" and then i showed a sold out button when the product quantity is <=5
thinking about it, if the first probelm is solved the second one will be as if they product disappears then the attributes wouldnt be seen... Hope someone knows a fix for this.Quote:
Originally Posted by philip937
No I was wrong,
I have just noticed that I have the following stock:
Small = 4
Medium = 0
Large = 40
I have done what I mentioned above and set:
Line #1146 : case ($button_check->fields['products_quantity'] <= 30 and SHOW_PRODUCTS_SOLD_OUT_IMAGE == '1')
But this has still just allowed someone to check out when the Small was set to 4!!
Please someone point me in the right direction.. if the attributes disappear when they hit 0, there must be somewhere I can change this value to 30....
You should read through this whole thread.. It will give you a better feel for this mod.. Also you should give a read through the other support thread for this mod. (Stock by Attribute v4.0 for Zen Cart 1.3.5+)
So if you have an attribute called size and had stock as follows:
S = 5
M = 12
L = 0
If I understand your posts correctly, you are asking if this mod will "hide" attributes when the amount of stock for that variant = "0". (In this example this would be size "L") The answer is NO.. if a customer adds a variant that is out of stock to the cart, he will not be notified until he adds the out of stock variant to the cart.
Now there is another mod that has been written specifically to work with Stock by Attributes (the Kuroi version not the "others":laugh:) It is the Product Attributes Grid add-on. This add will allow you to visually see which variants are out of stock.
You can see this in action in this example:
http://clients.overthehillweb.com/ha...rimeter-Medium
Link to the Product Attributes Grid is here
Support thread for Product Attributes Grid is here
Quote:
Originally Posted by philip937
Posted via Mobile DeviceQuote:
Originally Posted by DivaVocals
I have just tested again to make sure I wasn't being stupid..Quote:
Originally Posted by philip937
My attributes most definitely DO disappear when the stock of the particular attribute hits zero.
So for example I have:
S = 4
M= 0
L = 10
When I look at the product info page and select the drop down, I currently get:
Please Select
Small
Large
It has hidden the Medium..
Now just to test there was no glitch, I then wen and changed the value of Small to = 0. the drop down now shows:
Please Select
Large
So it works perfectly how I want it to, but I merely want to change the threshold of these attributes dissapearing from zero to 30..
I hope someone can help :blink:
Phil
My bad, found the solution.Quote:
Originally Posted by philip937
I had already been over this before.. Just forgot!
To make your attributes turn off when stock for attribute hits zero, you have to do this:
http://www.zen-cart.com/forum/showth...=34977&page=65
I had already done this!! Durrr im so stupid..
so quite clearly where the replaced code says to put:
(pwas.quantity > 0 or pwas.quantity IS NULL)
Ive changed mine to say
(pwas.quantity > 30 or pwas.quantity IS NULL)
sorted.
Out the box this behavior isn't there.. Looks like you must've modified it to do this..Quote:
Originally Posted by philip937
ETA: okay.. looks like that's what you confirmed you did..:laugh: I knew I wasn't crazy either!:laugh:
And so this is clear for anyone reading this, you never said which version of SBA you are using.. It makes a HUGE difference if you are pointing people to solutions.. The link you posted looks like this refers to the MultiAdd version.. I haven't looked at the code in the Kuroi version, but if here are differences, a solution meant to work with one version may not apply to other versions of this mod..
Another thing I wanted to point out that this solution only appears to work for SINGLE attribute variants. It doesn't appear to be a solution for variants with multiple attributes (Small shirt versus Small, Blue shirt)
Quote:
Originally Posted by philip937
Hey,Quote:
Originally Posted by DivaVocals
Sorry, yes for clarification, I have only tested this on my scenario, i.e 1 set of attributes.
I am using Kuroi's 4.7 version.
So where as it works perfectly for what I need, be warned it may not work for everyones requirements.
:smartalec:
The original is still the best!!! :yes:Quote:
Originally Posted by philip937
The admin stylesheet from the MultiAdd version is the only improvement I would suggest.. The MultiAdd admin stylesheet really visually helps distinguish the parent product from the variants..:yes:
oh really, cool I shall give that one a try and see what it looks like :DQuote:
Originally Posted by DivaVocals
Help!!!!!!
Latest update
version 4.7 stocks by attrribute....
if I add anything to the shopping cart I get:
1146 Table 'XXdatabasenamexx.TABLE_EF_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
but the table does exist...
Now what?!?!?!?!?!?!
Sounds like you didn't run the SQL file which creates the SBA tables..Quote:
Originally Posted by exeter_acres
Yep...sure did...
first thing
Restored a backup,
re-did the whole upgrade....
store working,
but a bit hesitant to run this mod again...
No reason to be.. Dunno what happened the first time around, but this mod should be a very simple one to install.. IF you install the Kuroi version.. I'd do a backup of site and DB, and install again.. No reason to be hesitant if you can roll back..Quote:
Originally Posted by exeter_acres
How i can make my products option values remove by its self after someone order on website i'm using ( Stock by Attributes ) i want to know how could i make it so on my website the quantity of item could get remove aromatic like if i have 1 of a size 9 sneaker and someone buys it there should by zero remaing could someone tell me how could i do this plz
thanx for tryin to help but i try doin this and all the quantity get delete could you explain how to do this or if maybe i did something wrong thanxQuote:
Originally Posted by limelites
I tried the following on a client's site, and it fixed the problem right away. Out-of-stock attribute values are no longer displayed in my attributes dropdowns. Thank you very much krazykev.
I had first tried Kellan's fix (directly below) without success:Quote:
Originally Posted by krazykev
I strikes me as odd that the Stocks by attributes mod would be missing this functionality.Quote:
Originally Posted by limelites
Actually it's not that odd at all since this FIX only works with ONE SINGLE attributes.. It's not included in the Stock by Attributes code because at best it would be a HALF solution based on what Stock by Attributes allows you to do. If you refer to the readme file included:Quote:
Originally Posted by Springboard SEO
Stock By Attributes is meant to track stock for product variants. A product variant is a combination of attributes which have stock associated with them.Quote:
What This Module Does This add-on allows a store owner to set a stock value for each variant of a product. For example, if you have three sizes, large, medium and small, this module will allow you to keep track of all the different quantities. It will work for a virtually unlimited number of amount of attribute combinations. 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.
This often referred to "fix" only addresses single attribute variants. Hence why it is NOT included in the Stock By Attributes add-on. A REAL solution would be to address the display of ALL product variants not just single attribute variants..
I wanted to make it CLEAR to anyone who thinks this fix will work with multiple attribute variants.. (It doesn't..)
First if this is in the wrong thread - apologies. I am talking about the latest version 1.4.8 by Numinix although I think the question applies to all versions
First - brilliant contribution - respect and thanks to the contributing authors
My query; the sort order of the information generated. Many people have pointed out that the reporting of sub attribute numbers is not hierarchal.
eg you can get a situation like this
Attachment 6624
In this example it would make more sense for the data to be organised by size and then colour
I understand that the sort order is not manipulated by the contribution so the order should be inherited from Option Names and Option Values.
Problem - no matter how many times I change the sort order of these items and update through the Store Manager, the contribution refuses to change the original order (as per the example)
When I start to dig around in the files in Admin (admin/includes/classes/products_with_attributes_stock.php) I see there is a whole lot of data that is hard ordered
Can anyone guide me on this please - ie how do I influence the sort order without tampering with the contribution
Thank you
So I've been testing the latest version of this add-on (v 1.4.8 by Numinix). Looks like it's a corrected version of the 4.7ajax version. Almost everything works (at least it doesn't error out anymore.. The addition of the feature to quickly resync all quantities at once is also nice..
However there are two features that either do not work or do not work intuitively.
(I will post the 1st here, and the 2nd in a seperate post)
First feature:
This feature works, though the UI is not very intuitive. It is not CLEAR looking at the UI that after entering the search criteria that you must click the "Enter" key to execute your search, and it is also not clear that the "Store" button is meant to update the "Quantity in Stock" values. So to help make the UI a little clearer, I made the following changes:Quote:
* search filter: "%ma" filters all produchts with "ma" in products-name or in products-model; the search value will be stored in a cookie
I updated the admin/includes/products_with_attributes_stock_ajax.css file by adding the following:
I then updated the admin/products_with_attributes_stock.php as follows:Code:#store{
float: right;
margin-top: -16px;
margin-right: 40px;
}
#store1{
float: right;
/*margin-top: -1px;*/
margin-right: 35px;
font-weight: bold;
}
#pwas-search{
float: left;
margin-top: 25px;
margin-left: 70px;
font-weight: bold;
}
#pwas-search1{
float: left;
margin-top: 27px;
margin-left: 5px;
font-weight: bold;
}
Around line 453 replace:
with this:PHP Code:echo '<div id="hugo1" style="background-color: green; padding: 2px 10px;"></div>';
echo '<form method="get" action="products_with_attributes_stock_ajax.php" id="pwas-search" name="pwas-search">Search: <input id="pwas-filter" type="text" name="search"/></form>';
echo '<form method="post" action="products_with_attributes_stock_ajax.php?save=1" id="store" name="store"><input type="submit" value="store" id="store" name="store"/>';
echo '<span id="loading" style="display: none;"><img src="../images/ajax-loader2.gif" alt="" /> Loading...</span><hr />';
echo '<a class="forward" style="float:right;" href="'.zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, "action=resync_all", 'NONSSL').'"><strong>Sync All Quantities</strong></a><br class="clearBoth" /><hr />';
These changes make the UI a little clearer IMO..PHP Code:echo '<div id="hugo1" style="background-color: green; padding: 2px 10px;"></div>';
echo '<form method="get" action="products_with_attributes_stock_ajax.php" id="pwas-search" name="pwas-search">Search: <input id="pwas-filter" type="text" name="search"/></form> <div id="pwas-search1">Click Enter to Search</div>';
echo '<div id="store1">Click "Store" to Update Stock Quantities</div> <form method="post" action="products_with_attributes_stock_ajax.php?save=1" id="store" name="store"><input type="submit" value="store" id="store" name="store"/><br />';
echo '<span id="loading" style="display: none;"><img src="../images/ajax-loader2.gif" alt="" /> Loading...</span><br /><hr />';
echo '<a class="forward" style="float:right;" href="'.zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, "action=resync_all", 'NONSSL').'"><strong>Sync All Quantities</strong></a><br class="clearBoth" /><hr />';
Continuing from my previous post.
Second feature:
This does not work for me. When I click in the "quantity in stock" value and enter a new value, then click the "store" button, I get the following error:Quote:
* a click at the "quantity in stock" value adds an input-field & you can enter the new value; the store button saves all changed values
Additionally the error appears as an onscreen error as well as in a popup window.. I would love to fix the error and get rid of the popup window.. The onscreen error message is better IMO..Quote:
1146 Table 'othclients1.products_with_attributes_stock' doesn't exist
in:
[UPDATE products_with_attributes_stock SET quantity = '3' WHERE products_with_attributes_stock.stock_id =12 LIMIT 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Any thoughts??
Well I knew it was too good to be true..:laugh::laugh: The new Ajax version has some of the same issues as the previous Ajax version.. The UI from the Admin side looks like alphabet soup in Internet Explorer.. The ONLY thing that doesn't display like a hot ugly mess are the product variants.. Back to Kurois version I go.. I may mess around with some more to get a feel for why the UI looks so messy, but Kurois version continues to be the only trouble free version of this add-on available..
sorry to interrupt, im a newbie...i installed this mod a while ago and it worked fine, i just dont know how to add another product to this mod. i have to products but only one is showing in stock attributes...how do i configure another product? thanks for any replies
okay i just figured it out..silly me...i just had to add attributes first...silly silly me :wacko:
Quote:
Originally Posted by DivaVocals
Thanks for specifying that, I just realized tonight that it only works for one attribute. What a disappointment. Is there no way to make this work for more than one attribute?
It's software.. of course there is a way to do this.. But the question should be, "Has someone released a version of SBA which includes this feature??" The answer is no..:no:Quote:
Originally Posted by Springboard SEO
Is there some solution to the problem of letting a customer know whether or not stock is available with their chosen attributes before they attempt to go to checkout? This is what seems like it should be basic functionality to me in a shopping cart.Quote:
Originally Posted by DivaVocals
It's software.. It can be done, but if anyone has found a solution, they have not shared it with the community.. The upcoming Zen Cart 2.0 release will include these features..Quote:
Originally Posted by Springboard SEO
You might wanna take a looksee at the Grid Attributes add-on.. It has been written to work specifically with SBA.. If you want to get a sense of what it does, check out this link:
http: // clients dot overthehillweb dot com/hairisle/Stock-Lace-Wigs/Chinese-Remy-Brazilian-Curl-Full-Lace-Perimeter-Medium
Looks good - I'll be all over it first thing in the morning. Thanks DivaVocals.Quote:
Originally Posted by DivaVocals
I installed a fix that will take away the selection if its not in stock.
as in
Small - 0
Med - 0
Large - 8
Will just show
Large
However, when that goes out of stock. I get an error like this listing
http://www.nothingbutcostumes.com/in...ducts_id=17482
Quote:
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 ') AND pa2.products_attributes_id IN (11937) ' at line 3
in:
[SELECT count(DISTINCT pa1.options_id) AS matches FROM products_attributes pa1, products_attributes pa2 WHERE pa1.products_attributes_id IN () AND pa2.products_attributes_id IN (11937) AND pa1.options_id = pa2.options_id]
So I am pretty well versed in mod installs, etc... however in the install file it just says "merge changes if you have other mods installed that use these same files."
Well, I DO have ohter mods that have changed these same files...
How come the install doesn't tell me what relevant code needs to be merged, and where it should be placed in the php files? Am I missing something here?
Thanks all
simply put because the mod author didn't offer the add-on that way.. and honestly almost all Zen Cart add-ons are packaged up the exact same way.. You will need a tool like Winmerge to make sure you incorporate only the changes needed for the add-on to work in any files that may be overwritten by the add-on..Quote:
Originally Posted by shackrock
man really? I feel like a majority of people would fail miserably at this task then... heck I might too, haha. Looks like I might be sticking with OSC afterall.... unless somebody else has some tips?Quote:
Originally Posted by DivaVocals
I think a majority would fail miserably if they were provided only the code changes.. AND, the mod author has no way of knowing what other changes you may have already made for other add-ons.. If this is what you're used to with OSC, then that explains a LOT of the problems I saw with mods when last I peeked in there..Quote:
Originally Posted by shackrock
Yes.. get Winmerge (or a similar tool) and try 1st before giving up.. :smile:Quote:
Originally Posted by shackrock
as for OSC??? IMO staying with OSC is a step backwards.. That project is NOT moving forward at all..
Most recent version.
I think this is a bug. When I do a search that works properly. The sort is achieved. However, clearing that search is a problem.
It looks like a post (or get) parameter is not being cleared. Every time the page refreshes after that - regardless - that search is implemented.
Have others noticed this?
Nick
Trying to get this mod to work.....
I have installed it in a test database..
No errors..
I can adjust the quantities in admin....
but when i add an item to the cart that I have set its attribute to zero, nothing happens and it is allowed to be added to the cart....
did I miss something?
thoughts on this??
Thanks
Exeter
The most recent version (which is supposed to fix the Ajax version) has a few bugs.. Go back to page 83 of this thread.. I posted my musings on the matter..:smile:Quote:
Originally Posted by niccol
Gonna stick with what works.. Kuroi's version still works without any issues..
anyone?Quote:
Originally Posted by exeter_acres
Like many, many others, I also want to hide attributes with 0 quantity.Quote:
Originally Posted by limelites
I'm using drop down menus and only one attribute "category" for each product.
Been reading this thread for a few hours now, tried the solution above, it does not work for me, do I need to do something else as well?
I'm running Zen cart 1.3.8 with Stock by Attributes v4.7ajax.
Noticed some mentioned the MULTIADD version of SAB but that one seems older...
Truly greatful for some advice here. Thank you.
Sorry this thread was the solution for me :
http://www.zen-cart.com/forum/showpo...&postcount=625
Thank you s58smith!
Hi Guys,
I've had a search through this thread and I can't seem to find what I'm after.
Basically, what I'd like to do is create one product, which is available in different colours and styles, assign stock levels to each colour or style, and list each colour/style as a separate product. So, for example, a ########ie's Guitar Strap - exactly the same length and material - but it's available in a star pattern, in checkerboard etc. Can I make a ########ie's Guitar Strap, assign colours and styles as attributes, then generate separate products for those attributes. So I'd have ########ie's Star Guitar Strap, ########ie's Checkerboard Guitar Strap, etc listed separately in the product listing. I'm sure you can imagine when there's 20 or so colours it's a huge job. Can this be done, or have I completely missed the point of this module? If I have could anyone recommend anything...
Thanks very much!
If I understand you correctly, then this mod is not what you want. What you want to do is simply create a separate product for each guitar strap/length/color. You can simplify adding all of those products by creating one product then copying it and editing the newly created product in order to create a new variation. The stock would be product stock defined in the product details, as allowed for in Zen Cart base functioning, not stock by attributes.Quote:
Originally Posted by OK Computer
To simplify the addition of those products even more, check out the Easy Populate mod. Then you could add the new products via spreadsheet.
HTH,
Audra
Super, thanks very much for that, I had looked into it but wasn't sure. After your comment I decided to go for it, and though it's proving a bit of work now, it's going to make life a lot easier in the long run. Thanks very much!Quote:
Originally Posted by audradh
We're having some trouble with this addon. I've managed to copy all the files over to our cart (after making sure they weren't going to wipe out anything) and I can successfully add stock quantities for product attributes.
However, if I then go to purchase something and proceed to the checkout I'm told the item is out of stock (I added 20 items of every combo available). This happens no matter which item or combination of attributes I choose.
Any ideas what I should look for?
Here's our cart in case you want to see what I mean:
http://www.rasebike.com/cart/
I disabled the stock check for now so if you visit our cart you won't see the "No Stock" warning. I don't want customers seeing that while I try to figure this out.
(No editing posts on these forums? That's strange.
edit: Oh, I guess there's a time limit. Still strange.)
Can someone please help me with this error. I'm running version 1.3.8a and have installed stocks by attribute v1.4.9.
1146 Table 'db71128_gmgcart.products_with_attributes_stock' doesn't exist
in:
[SELECT quantity FROM products_with_attributes_stock AS a LEFT JOIN cart1_products_attributes AS b ON (b.options_id=4 AND b.options_values_id=4) WHERE a.products_id = '3' AND a.stock_attributes = b.products_attributes_id AND a.quantity > 0 order by b.products_options_sort_order]
I've tried searching this thread but cannot make sense of it and scared of doing more damage.
Any help greatly appreciated!!!
Nothing to be scared of.. You haven't done any "damage" it simply doesn't work..Quote:
Originally Posted by gl3ny
How did you install the SQL patch for this mod?? The error means that the table needed to store attributes stock is missing..
:smile: I copied the text, Admin>tools>SQL patch>sendQuote:
Originally Posted by DivaVocals
Try uploading the patch instead and see if you get a different result..Quote:
Originally Posted by gl3ny
Uploading patch to where? Sorry noob :huh:Quote:
Originally Posted by DivaVocals
Quote:
Originally Posted by gl3ny
Same place you copied and pasted the SQL patch. Upload versus Copy & Paste..Quote:
Originally Posted by gl3ny
Ok I see what you mean, I'm sorry. It's only my 3rd day using zen so I'm not that familiar with it yet.Quote:
Originally Posted by DivaVocals
I ended up doing a fresh install because of all the playing around I've been doing. I just took my time installing Stocks By Attributes and its working perfectly now.
Thanks for your help!
Anyone??
Quote:
Originally Posted by exeter_acres
OK...riddle me this......
I just went back to test it again....
I SWEAR I didn't change anything...
and it is showing the item out of stock!
It's MAGIC!!!:laugh:Quote:
Originally Posted by exeter_acres
Sorry.. couldn't resist this..
Hello everyone.
I've being running into a problem with this mod, no matter which version I'm using and I can't figure out how to fix it.
My zencart installation 1.3.8a
This mod version 1.4.9 (4.9) the last new on the list.
Whenever I add more than one attribute and add the quantities, the drop down menus in the store reflect multiple choices of the first attribute and the correct one on the second attribute. Maybe I didn't explain correctly so here this is what is happening http://www.byvalenti.com/index.php?m...products_id=16
The problem is on the first drop down menu as it displays 10 times the same option (one for each one of the options).
Has anyone ran into a similar problem? any fix for this?
Thanks!
Quote:
Originally Posted by mvstudio
I have a similar issue. I'm trying 2 drop down menus on a page. One using product stock w/ attributes, the other w/o. If I don't assign a quantity to the dropdown value, my box is empty. If I go into Product Stock w/ Attribs and give the value a quantity, I get an error about "Warning: Cannot modify header information - headers already sent by.... includes/functions/general.php on line 21". I click back, it says product updated and shows the same value duplicated. Example here:
http://guardianangelsocietysyr.org/z...b4923c5fbee289 Anyone have ideas?
Hi folks.. Haven't tested the latest SBA version.. Sounds like it too has issues..
So let me say what I have consistently said in this and the other SBA support thread.. I ONLY use the version created by Kuroi.. EVERY SINGLE VERSION released after Kuroi's version is close but no cigar IMHO. If you look through this support thread, you will see that CONSISTENTLY the problems with SBA all relate to versions other than the one created by Kuroi..
My advice?? Rollback to the Kuroi version.. Unless someone (like the author of the latest version) steps in to help..
Quote:
Originally Posted by mvstudio
Quote:
Originally Posted by valvoj
Sorry if I've double posted this on v4.0 + here.. I don't see the difference between those two..
Is it possible to set a "global" stock for each attribute?
Let's say I have 3 main products (Napkins).
All 3 main products have 3 attributes (smaller napkins).
To sell more, I want to make packages of napkins.
Main napkin + smaller napkin
So the main products:
Napkin Red
Napkin Blue
Napkin Green
can all be ordered with the same attributes:
Smaller Napkin - Yellow
Smaller Napkin - Purple
Smaller Napkin - Black
My Problem:
When someone order main Red Napkins, with Smaller Yellow Napkins as an attribute. I want the "Smaller Yellow Napkin" to be subtracted in stock on all the main products having the Yellow-Napkin attribute.
Did anyone understand this?
And is it possible?
Anyways - thanks for a great mod! It works perfectly well on my other products, having separate attributes..
How do you uninstall the SQL for this mod...? I've tried everything to try and get my totals to update when items are added to the cart but just can't get it to work.
Tried every single version of the mod, every suggestion, everything, so i'm gonna have one last crack but when i completely put the files back to the original state the cart won't show because of the SQL patch.
How do i uninstall the patch. The patch is the one from version 1.4.7ajax.
Any help is much appreciated.
In my experience, this mod cannot do that. That is not to say there isn't another mod out there that may accomplish that, but I do not personally know of one.Quote:
Originally Posted by Gomlers
Can you outline your exact steps in setting up a products attributes and setting stock? That might help us to see where the problem lies.Quote:
Originally Posted by Cunk
Ok so I'm confused. What exactly is "Sync All Quantities" supposed to do?
When i first clicked it, it set all my products to 0... which i figured was because there werent specific attributes defined. So I added one and clicked it again, nothing. The added attribute stayed the same(20), but the other shirts stayed at 0 with no Variants showing.
I tried clicking the products specific "Sync Quantites" as well. Still nothing.
I just installed version 4.9 although I did notice that the instructions were for 4.7ajax. Am I missing something?
Hi- can anyone help please - I followed the advice of entry #642 about only showing attribute options for those items 'in stock' - by altering the attributes.php file as described:
but I get this error message in my product page:
1146 Table 'cheekyshoe.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
in:
[select pov.products_options_values_id, pov.products_options_values_name, pa.*, pwas.* from products_options_values pov, products_attributes pa LEFT JOIN TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK pwas ON pwas.stock_attributes = pa.products_attributes_id where pa.products_id = '180' and pa.options_id = '20' and (pwas.quantity > 0 or pwas.quantity IS NULL) and pa.options_values_id = pov.products_options_values_id and pov.language_id = '1' order by LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_name]
I checked the database and the table is there, but I'm new to all this so I'm a bit stumped as to where to go next.
Any help much appreciated.
Many thanks
PS. Most recent version installed
I've searched this thread and the rest of the forum with no luck, so here goes...
We sell t-shirts and donate $1 of each shirt to the customer's choice of one of three local charities. I've got SBA set up to keep track of the stock of the different sizes of each shirt (M, L, XL, XXL), and that works perfect. What I'd like to do is add another dropdown for the customer to choose between the three charities, but I don't want it to interfere with SBA. The way it was initially set up (which makes sense because I think it's the way SBA was designed) I would have to set up the stock like this:
-Shirt#1 ; Size: M ; Charity: A
-Shirt#1 ; Size: L ; Charity: A
-Shirt#1 ; Size: XL ; Charity: A
-Shirt#1 ; Size: XXL ; Charity: A
-Shirt#1 ; Size: M ; Charity: B
-Shirt#1 ; Size: L ; Charity: B
-Shirt#1 ; Size: XL ; Charity: B
-Shirt#1 ; Size: XXL ; Charity: B
-Shirt#1 ; Size: M ; Charity: C
-Shirt#1 ; Size: L ; Charity: C
-Shirt#1 ; Size: XL ; Charity: C
-Shirt#1 ; Size: XXL ; Charity: C
And so on for each shirt.
I obviously don't need to set inventory dependant upon the charities chosen, because which charity they choose has no effect on the number of shirts I have. Is there a work around to not include the "Charity" attribute in SBA? Can anyone think of a different way to do the charitable donation? Thanks in advance.
I'm running ZC 1.3.8a and SBA 1.4.9.
Brian
Simply set up another option in Attributes in your admin area. Call it carity donation and have your options in there. Set a default charity also. When your customer buys a shirt they can select a charity and if they dont a default will always be selected.
This would require you to then see which charity was selected by viewing their order and you would then need to send the money to the charity.
Thanks for the help, first trading!
Isn't that what I was explaining above, though? With Stock by Attributes I need to set stock levels for each of my two attributes, Size and Charity. I'm wondering if there's a way to make the Charity not a part of SBA. I already set it up using the two attributes (Size and Charity) and when I try to check out after selecting both attributes, it tells me the shirts are out of stock. I assume this is because SBA is sending a signal that the shirt isn't in stock because I haven't entered how many of each combination I have in inventory. I'd like to have SBA ignore the Charity attribute. Any ideas?
Brian
In case I didn't explain it clearly enough earlier, what I'm trying to do is have SBA basically ignore setting stock for one of my attributes and use another. I'd like to be able to set the stock levels of t-shirts with the Size attribute, but I don't want to have to set stock for t-shirts by Size and Charity.
Short answer this mod doesn't have that feature..Quote:
Originally Posted by bhensarl
Hello,
I am wondering if this module can be used in the following way - be warned this is complicated.
I wish to use the module to track stock of our products. We sell jewellery and what I wish to do is to use the module in the following way. (I have numbered the issues for ease of reference)
Example product:
Heart Pendant, on a range of chains. The whole item comes in a box.
1. Now I know that if I was to use say chain length & style as an option I could use this mod, for example, 16" Belcher Chain, 18" Belcher chain, 16" Cable chain and 18 cable chain. If defined these as option values it would offer an available quantity.
2. Now alot (not all) of the products come with the box for packaging, if I was to additionally set up a "Read Only" attribute that couldn't be seen by the customer, could this calculate stock levels for this as well?
3. Finally the heart pendant itself is available on a chain, on its own, or with other pendants, so itself needs independant stock management.
4. If the attributes were assigned over multiple products, for example the chains may be sold on a star pendant as well, would the quantities be product or attribute related. ie if we sold 2 heart pendants on 16" belcher and one star on a 16" belcher would the stock on all products with those attributes decrease by 3 or would just the heart decrease by 2 and the star by 1?
Sorry if any of this sounds vercomplicated, its a confusing thing to figure out!!!
Thanks in advance!
Sam
Gonna admit, that I didn't read all of that.. (Sorry too much to digest..) so I'll just say this and you can determine if this module meets you needs. SBA allows you to create multiple attribute combs (variants) per product and you can then assign stock levels to each one of these product variants. Product variants can consist of one or more attributes.
Variant examples:
T-Shirt sizes:
Small - Qty 2
Medium - Qty 3
Large Qty 12
T-Shirt size/color combo:
Small/Blue - Qty 2
Medium/Blue - Qty 3
Large/Blue Qty 12
Small/Red - Qty 2
Medium/Red - Qty 3
Large/Red Qty 12
Small/White - Qty 2
Medium/White - Qty 3
Large/White Qty 12
Quote:
Originally Posted by totalsam
The table is there...Quote:
Originally Posted by GeorgieBrown
I dont have all day to look at 800+ Entries...
ANy insight would be greatly appreciated...:(
The problem isn't the table, it's the pointer to the table.Quote:
Originally Posted by Hunterheads
TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK is a constant that holds the name of the table, which is actually "products_with_attribute_stock".
So either you have an incomplete version of the mod (you don't say which version you're using), which is missing admin/includes/extra_datafiles/products_with_attributes_stock_database_tables.php or that file hasn't been installed properly.
Also there's no need to read through 800-odd thread entries - there's a "search this thread" option towards the top that makes finding answers on this topic much quicker.
Hi:
I'm in a bit of a pickle. I installed Stock by Attributes v4.7ajax on ZC 1.3.8a with security patches in place.
Additionally, the following are also included:
Improved attributes controllers
Ordered Step
Ultimate SEO v2.0.6
Admin Profiles v1.0.7.1
On the admin side it worked like a charm, though an explanation of Sync Quantities would be appreciated.
The problem lies on the front end. When I add an item to the cart, I am told
Products marked with *** are out of stock or there are not enough in stock to fill your order.
Please change the quantity of products marked with (***). Thank you
I checked and there is a large inventory for this item. I'm no coder, but can someone please show me what I need to do to fix this? :cry:
I have placed the site under maintenance so as not to confuse buyers.
I'm not going to ask about having the attribute with 0 stock disappear, I know how hard it is to accommodate everyone's request and still make a living, but it would be nice :smile:
I would really really appreciate some feedback today. I'm off on medical leave for 2 weeks and I need this fixed today! Many thanks.
I've never used that version, but know that it has a reputation for being incomplete, maybe somebody who has used it can add to that.
The idea of the sync quantities option is to synchronise the stock being held at product variant level with that being held for the product overall. This can be useful if you decide to stop using attribute level stock for a product.
Kuroi
thanks for replying. I checked the readme file and this is the latest download ( i downloaded Jan 15/2010) and the version is actually 4.7a for zc 1.3.8
In admin > configuration > stock, if I set Show available stock level in cart when less than order = true, the item in cart still has the same message, but next to the item it says Stock Available 0
Would you mind giving me a hand with this? I can add your IP to my list and give you access? if you have a moment, pleas PM me.
The site is https://leladesigns.ca/shop-lela/
If you have 3 of a product variant in stock and add 5 to your cart, you will get the out of stock message. The store will not show you that you ordered two more than there is actual stock available. (if that's the question you are asking.)Quote:
Originally Posted by newagekat
No, you misunderstand.
Say I have 500 small blue Item A and place 3 to my cart, I still get the out of stock error message. that's what weird. I may need to add that I am using the Cherry Template with some really modest modification for info appearance. I have not touched the code.
Kuroi, since you created this mod, can you please have a look? Sorry to sound so desperate, but I'm going in for surgery and I need this done today. If I have to pay someone then so be it.
I have turned off the maintenance so you can assist.
Kuroi:
Sorry to be a pest and so persistent. this is not an isntall issue. This is a code issue. I checked one of the other sites where I installed this mod, I get the very same thing. or maybe i missed something. please check http://commonwealthyarns.com/ for similar issue.
in includes/template/custom/template/tpl_shopping_cart_defult.php you have this code
Could this be the cause of it? in Admin > Configuration > Stock, I have Show available stock level in cart when less than order = falseCode:<?php if ((STOCK_SHOW_LOW_IN_CART == 'true') && $product['flagStockCheck']) {
echo '<span class="alert bold">';
echo PWA_STOCK_AVAILABLE;
echo ((isset($product['stockAvailable'])) ? $product['stockAvailable']: 0);
echo '</span>';
}
?>
<br class="clearBoth" />
I would be forever grateful.
Let's be clear.. Kuroi didn't create the SBA version you are using.. The version you are using is based on his original SBA mod.. Since Kurois v1.47 release others have come along to "improve upon" Kurois mod, and IMO all of these "other" versions have been problematic. (a lott through this thread and the other SBA thread will confirm this)Quote:
Originally Posted by newagekat
To his credit Kuroi has been very generous by continuing to participate in a support thread which by and large discusses versions of this mod he had NOTHING to do with other than writing the underlying code upon which subsequent versions were based on..
My opinion has been consistent. NONE of these other versions works well enough in my book to be bothered with. I stick to the original 1.47 version written by Kuroi.
Thank you so much for your response. I did not intend any insult and I do appreciate the work that goes into the mod and more specifically, answering all these questions.
That said, on this add on download page, http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=310, are you refering to this version:
This is a maintenance release that incorporating changes made for Zen Cart 1.3.8. There are no functional enhancements.
Author: Kuroi
Version: 4.7
Zen Cart™ Version: v1.3.8
Update added on Dec 02 2007
Can you tell me if it works with 1.3.8a with security patches? If so, would you be able to tell me what would be involved in reverting back to this version? would I need to make changes to the db or just over right files?
Thank for your time.
I don't run Zen Cart without the latest security patches.. So the answer to your first question is yes.. I don't have an answer for your second question.. I've tested one of the "other" SBA versions on a test store and did not rollback when I was done testing (I simply reset my test store) So I have no real insight on what it would take to rollback.. If I had to guess it would be to compare the files between the two versions and delete any files which do not appear in the Kuroi version and replace any files from other versions with the one's from the Kuroi version..Quote:
Originally Posted by newagekat
Just wanted to give you an update. I reverted back to Kuroi's 1.4.7 version on both these sites. One of them now works like a charm. the other still has the same issue.
Here's a list of the mods also incorporated into the problem site. If you are aware of any conflict, I would really appreciate a head's up.
ZEN CART
Added XSS protection patch dated Nov 30/09
{ http://www.zen-cart.com/forum/showthread.php?t=142927}
Removed unused folders per security patch dated Nov 28/09
( http://www.zen-cart.com/forum/showthread.php?t=142784)
security_patch_v138_20090619
( http://www.zen-cart.com/forum/showthread.php?t=130161)
pci_patch_v13x_search.php Oct 13/09
( http://www.zen-cart.com/forum/showthread.php?t=130701)
---------
Zen cart modules added to cherry template
Stock by Attributes v1.4.7
Contact us subject mod v2
Fedex module
Improved attributes controllers
Image handler 2 for 1.3.x
Ordered Step
Moneirs payment modules
Ultimate SEO v2.0.6
FCKeditor
Newsletter subscribe
Split tax lines
Admin Profiles v1.0.7.1
I rechecked each file against my install, merged them where necessary, and re-uploaded. I even checked the sql file for differences just in case. :no: Someone, please, HELP!
kp
Firstly can I say I have read as much as I can from both of these threads - Stock For Product With Different Attributes (OLD) and Stock by Attribute v4.0 for Zen Cart 1.3.5+ but neither thread seems to have the answer to my problem (though the question has been asked many times I have yet to see a definitive answer)
Sorry to start a new thread about this, but when there are 4 or more threads about the mod and each with hundreds and hundreds of pages not even relevant to my question its not easy :frusty:
What I want to do is illustrated here - if you change the colour and/or sizes, the number of products in stock also changes
I understand after much reading of many threads (all which have 40 plus pages :huh: ) that this isn't possible when using mutiple attributes, when clearly it is somehow...
So... to cut to the chase... I have the STOCK BY ATTRIBUTES already working on this site and it's fine aside from the fact I would like for it to display the number of Blue Size SML T-shirts that are in stock without having to add it to the shopping cart and then only to find it is out of stock
This is exactly what iam after, i sell body jewellery and if i have say
5 x 1mm bars
10 x 2mm bars
It states i have 15 in stock but doesn't say how many of each, you can then add 6 of the 1mm bars to cart but then the cart says its out of stock, which in theory isn't very good for your customer, i think people would get confused.
Would be great if it said how much was in stock for anyone item, then also counts down say if someone brought 2 x 1mm bars it would show stock of 3 left, if then later someone brought the remaining 3 it would then go to out of stock just for that size.
Hope that makes sense :unsure:
I'm not sure I follow you here, or at least I don't understand the description of your stock, are you sure you have multiple attributes? Because if not then what you are after is possible to do.
It's only when you have multiple attributes that Zen-Cart has problems (ie, a choice of colours and sizes together, it can distinguish between one or the other, just not both).
I understand what your on about i do only have single attributes i only deal with different colours.
E.g
If i have a belly bar in 3 colours i.e
6 x red
4 x blue
2 x white
The stock showed up as me having 12 in stock, it allowed me to add 3 white to the cart then when viewing the cart i got an out of stock message.
It doesn't tell the customer i only have 2 white in stock and 6 red etc
Perhaps id done something wrong...:blush:
Okay, that IS possible then.
Check out the FAQ here - http://www.zen-cart.com/wiki/index.p...sked_Questions
Quote:
How can I show the amount of stock available next to each attribute on the product information page?
This is relatively straightforward if you have only a single attribute such as size of color for each product. Code for this is proposed in this archive thread[1]. Seek out post #110 by Grayson, and her correction in #132 and apply the changes to the includes/modules/attributes.php file instead of includes/modules/pages/product_info/main_template_vars_attributes.php
Thanks for your help with this well iam totally lost know i followed the first part of the instruction -
check includes/classes/order.php
make sure line 8 has this
@version $Id: order.php 0000 2007-09-19 00:00:00Z kuroi $
which mine does so far so good, The as instructed i went to forum page
http://www.zen-cart.com/forum/showth...=25987&page=14
said i needed to edit -
includes/modules/pages/product_info/main_template_vars_attributes.php
but i don't have this file !! thought perhaps i didn't upload it so i re-uploaded all files again, but still the php file isn't there, so iam totally lost know.
Can you advise please :blink:
Sorry, the FAQ does read a bit vague when I look at i again, it took me an age and a day to figure all this out as to what is and what's not possible so apologies that I can't remember fully what I did get to work and what I didn't as it was never what I (or a million others actually wanted)
The mod you need I think is this one - stock by attributes - http://www.zen-cart.com/index.php?ma...roducts_id=310 - I managed to get it to work in one language, but most of my sites are multi lingual and never got that far as it wasn't what I was looking for. Pretty sure though it's the one you need.
thats the one i installed so very weird all this specialy to a newbie with limit experience, many thanks for trying to help me though, appricate your time :bigups: i might un-install it and see if i can get another version to work....
I wish I could remember what I did to get it to work. Unfortunately (for you) I tried so many things, in the end once I realised it wouldn't work for multiple attibutes I deleted all my test files and put back the original single attribute file
I also wish somebody could write a definitive guide/FAQ to this, it seems to be one of the biggest failings of Zen-Cart (there aren't many I admit and the support on here from members is excellent) - Zen-Cart v1.4 I have read time and time again is supposedly going to incorporate this feature, but I read this in posts from 3 years ago... and sadly still nothing on it.
Just as a side comment, it does seem to be a blatantly obvious feature that has been missing from ZC given the number of online stores that this feature is surely a must, clothing for a start with colours and sizes is just the first I can think of. Hopefully soon it will be addressed fully and released either as a mod or in an update.
I totally agree perhaps this mod could be included in the next u[pdated version of zancart, quite hard to follow when there is so many pages about this, does get confusing for a newbie.
Many thanks again thou for your efforts :bigups: