Hello,
I'm using zen 1.3.9h now.
Is your v1.4.14 good for zen v1.5 ?
How to merge files while FTP, since I have many add-on mods installed?
Thank you!
Printable View
Hello,
I'm using zen 1.3.9h now.
Is your v1.4.14 good for zen v1.5 ?
How to merge files while FTP, since I have many add-on mods installed?
Thank you!
Thanks for the info :) I'm rebuilding fresh from a new install in a test directory on my server but it will be awhile before I get that far with it.Quote:
Originally Posted by drolex
It sure would be nice if someone could point me in the right direction. Trying to load the page with 1000's of products with all the attributes on one page is too time consuming. Ideally I would like to set it up sorta like the admin area product listing page such as 20 per page with the next and previous buttons
Quote:
Originally Posted by thefather
This MOD is finished, I have submitted it for approval...Quote:
Originally Posted by rhuseby
I am having the same issue except my installation is english only.Quote:
Originally Posted by cricri
Any help would be appreciated.
Brent
I noticed an error within stock_by_attributes_1-4-13 which is what I used to create this new MOD. If you add a product that is out of stock, it will display out of stock as it should. But it will also show out of stock on any additional items you add after that, even items that have plenty of stock available. I found a piece of code in an older version that appears to be missing and fixes this issue. It is in includes/modules/pages/shopping_cart/header_php.php, need to put back in at line 85...
if (STOCK_CHECK == 'true') {
$flagStockCheck = zen_check_stock($products[$i]['id'], $products[$i]['quantity']);
if ($flagStockCheck == true) {
$flagAnyOutOfStock = true;
}
$stockAvailable = zen_get_products_stock($products[$i]['id']);
}
I have modified the admin to include buttons at the top to take you straight to the product you want to work with. This won't help the load time but it makes it much easier to work with...Quote:
Originally Posted by thefather
http://b2c.bauerfeindusa.com:8080/we...mp-buttons.jpg
That does not look bad but that would still be cumbersome and bulky for anyone with lots of products.
I would just like to have a way to load lesser amount of products. Such as by brand, or by starting letter or even 25 per page with simple ways to navigate it.
Guess I need to keep looking for my answers
Quote:
Originally Posted by rhuseby
Does anyone know if it is possible to assign a quantity to ALL products that have attributes set in one go?
The reason for this is that I upload hundreds of products at a time and having to individually go in a add a quantity for each attribute for each product is painful!
So essentially once I have a category's full of say 100 products, all with say small medium and large set to them, I would really like a script I could run that could set every option to say qty 10 in one go?
If anyone can give me some direction on this I'd be very grateful.
Thanks.
Using :
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2011-11-20 22:01:01] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-08-16 10:59:26] (Fresh Installation)
PHP Version 5.2.11
And getting this error when trying to go to the Catalog>products with attributes stock.
1054 Unknown column 'sort' in 'order clause'
in:
[select * from zen_products_with_attributes_stock where products_id="107" order by sort ASC;]
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 help is greatly appreciated, we need to update our inventory.
SBA 1.4.14
1.3.9h
PROBLEM #1: I installed SBA, everything looked good but when I add a product to the cart it shows it as out of stock even if there is a qty of 100 in the size.
PROBLEM #2: I have Fast and Easy Checkout installed. Now when I try to checkout it gets to the 'confirm order' page and I get this:
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 '.product_attribute_is_free, pa.attributes_discounted ' at line 11
in:
[select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.product_attribute_is_free, pa.products_attributes_weight, pa.products_attributes_weight_prefix, pa.attributes_discounted, pa.attributes_price_base_included, pa.attributes_price_onetime, pa.attributes_price_factor, pa.attributes_price_factor_offset, pa.attributes_price_factor_onetime, pa.attributes_price_factor_onetime_offset, pa.attributes_qty_prices, pa.attributes_qty_prices_onetime, pa.attributes_price_words, pa.attributes_price_words_free, pa.attributes_price_letters, pa.attributes_price_letters_free, pa.products_attributes_maxdays, pa.products_attributes_maxcount, pa.products_attributes_filename pa.product_attribute_is_free, pa.attributes_discounted from products_options popt, products_options_values poval, products_attributes pa left join products_attributes_download pad on pa.products_attributes_id=pad.products_attributes_id where pa.products_id = '150:d589ee96db65a5fd30e81707a211f4a4' and pa.options_id = '1' and pa.options_id = popt.products_options_id and pa.options_values_id = '6' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '1' and poval.language_id = '1']
I have turned off FEC and the problem still happens.
Any ideas what I did wrong or what needs to be fixed? Desperate - site is basically useless at this point. :(
My attributes with stock are radio buttons and/or drop-down lists. I would like to use code similar to the one above, but instead of making the attributes disappear I would like to cause them to be grayed out (unselectable) and (ideally) apply a new style to them so that I can customize the "out of stock" options with a little CSS (which I suppose would be more applicable to radio buttons than it would be to drop-down lists).Quote:
Originally Posted by athenaHere is a link to a post in a thread called only: "Stock By Attributes" rather than this thread called: "Stock by Attribute v4.0 for Zen Cart 1.3.5+"
I think some of us have gotten lost in there but this post is significant - I just haven't had time to try it yet:
Quote:
Originally Posted by limelites
Thanks!
Also, is it possible to display the quantity remaining for each attribute? For instance "(3 in stock)" or soemthing like that next to the radio button for the "Blue Shirt" option.
It is possible.Quote:
Originally Posted by hockey2112
part of the answer is in this thread. start looking at post #517
There may be a few modifications to that code. look at the posts before page 55 or something. messy info i know. its in here somewhere. look before 2008 posts maybe...
hi, please please can someone help..
currently using zencart 1.3.9 and stock by attribute 1.4.14. everything seems to be working fine until we try to add the quantity to a product variant. once we enter in the quantity and click submit we are given this error message
1364 Field 'sort' doesn't have a default value
in:
[insert into `products_with_attributes_stock` (`products_id`,`stock_attributes`,`quantity`) values (486,"1577",2) ON DUPLICATE KEY UPDATE `stock_attributes` = "1577", `quantity` = 2]
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.
another error message for when we select to sync all quantities.
1265 Data truncated for column 'products_quantity' at row 1
in:
[update products set products_quantity="" where products_id="71"]
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 help would be much appreciated as we are currently unable to update our stock count. :no:
Awesome, I will check it out ASAP.Quote:
Originally Posted by ArtRat
Another question... is it possible to have the stock auto-reset to a certain number at midnight each night? I will be using the stock to set up available local deliveries each day (30 per day). Once there have been 30 deliveries ordered that attribute option will be disabled, but I would like for it to automatically become available again that night at midnight so that people can "order" it the next day.
Possible?
It doesn't work for v1.5:(Quote:
Originally Posted by hara
Is anybody working on making this module compatible with zen cart 1.5?
in my view this is one of the most important modules because who is using it can't simply stop using it..:unsure:
I agree, I am stuck without this! :smile: Looking for a new shopping cart unless it gets updated fast.Quote:
Originally Posted by tesefoti
I would suggest approaching someone like Numinix to upgrade teh module. If need be you might be able to get some others such as myself to pool funds to pay for the upgrade.Quote:
Originally Posted by storminyte
-lindasdd
How come?Quote:
Originally Posted by storminyte
Isn't 1.39h working fine for you at the moment?
What's the need to update "fast" now?
Quote:
Originally Posted by tesefoti
If you feel you MUST upgrade RIGHT now to v1.5 (and IMHO the only ones who need to RUSH this upgrade are those running a version of Zen Cart older than 1.3.9h), and SBA is VITAL to your business, then you should consider INVESTING in paying a developer to make the v1.5 updates for you. Otherwise if you wish to wait for someone to take "ownership" of SBA and make the v1.5 updates for free, AND you are running v1.3.9h, there is no reason to RUSH your upgrades.. However, keep in mind that some mods may take some time before they get upgraded to v1.5. So given this, paying for updates might be worthwhile business investment.Quote:
Originally Posted by storminyte
I agree.. it's like there's v1.5 fever and unless you are running a REALLY old version of Zen Cart there's no reason to rush to an upgrade just yet.. It will be a while before all of the really popular mods are all upgraded.. I think folks need to exercise a little more patience or if it's REALLY that much of a stat requirement, invest in getting mods upgraded for their stores.. You can't always reply on FREE add-ons to be updated on the same time schedule as the core application.. People do this work on their free time and may not be able to update things as quickly as folks like. and factor in the numberof mods that don't really have an "owner".. Those mods will take even longer to get updated sometimes..Quote:
Originally Posted by gilby
This should be part of the zen cart core. More people need this than say, um, record company code...:yes:
and you know this because............?Quote:
Originally Posted by ArtRat
That is a great idea, like a Ron Paul money bomb.Quote:
Originally Posted by lindasdd
I pledge 10$ to whoever updates it!
Hello - when an order is deleted (due to being fraudulent) the stock is not re-stocked even though it has been requested? Is this a known issue with Stock by Attributes or is this a problem with my installation?
Thanks
Andy
It's a known issue:
http://www.zen-cart.com/wiki/index.p..._by_Attributes
Does this mod automatically restock attributes when an order is cancelled?
No.
Actually, it does restock. We are using 1.3.9h with Edit Orders mod and SBA with the old MULTI-ADD file - (see post #1293 for that)
In my opinion whomever takes on updating SBA for v1.5 should consider taking the extra step of combining the three variants of SBA into one solid functional add-on.
The fragmentation over the years of this add-on makes it a nightmare for shopowners and the support thread a bloody mess to follow.. (eg: this feature works in one version, but not that version.. It's a hot mess!!!)
I've read here that one of the originators has a working version but is hesitant to submit it due to the many modifications done to the original mod without the original submitter being consulted. Understandably, it has been frustrating to monitor a support thread with these issues. I'm all for the function being integrated into the basic zencart if possible. I wish I had the skill to contribute to the cause. I'm grateful to all those here who help with the thread and make it possible for us to have these amazing features in our carts.
And that's been precisely why the code is fragmented right now.. Consult the original submitter about WHAT??? It's OPEN SOURCE for goodness sakes!!!!Quote:
Originally Posted by athena
If there is no active "maintainer" (to borrow a Drupal term) and you want to update the add-on, and can do it so it's tested and bug free, then by all means DO IT gosh darn it.. You won't be stepping on anyone's toes. If you have ideas for an update and there is an active "maintainer", then contact them about working together.. (that's JUST how the PDF packingslip was added to Super Orders)
The REAL originator of SBA, Kuroi stopped updating this as of v4.7, and has said openly LONG ago that he will be making NO FURTHER updates to this mod.. So no offense, but what is this person waiting for???
Seems like NO ONE wants to just submit a bloody update and be done with it.. So folks have submitted these variants because they didn't want to ruffle someone's feathers.. I don't get it.. :no:
I have identified what looks like three variants to this mod
- Stock by Attributes
- Stock by Attributes 4.7Multiadd WITH TABLE FILTER 1.6
- StockByAttributes with my stock id MOD 1.0.0
If what you say is true then it means there is now a FORTH variant of SBA floating around???
from what I can tell there's no reason why any of these variants should have been split off from the original at all.. Seems most were split off just to add one or two additional features and the submitter didn't want to step on the originators toes... so they submitted a NEW version?????? (WTH??) Bloody hell!!!! Why???
If someone has a working version of this mod where the functionality off all three variants has been consolidated and is WORKING bug free (relatively), then for goodness sakes.. SUBMIT the darn thing!!!
done ranting..:blush:
The last person that kindly updated the mod, thanking everyone here for bringing the error to their attention was contacted by a few of us over the months to alert him/her that the change was flawed.
They provided rude pm responses to our friendly let-me-help-you-test-it inquiries. Not very zen-like.
Understandably we now tread lightly.
Kuroi has been great BTW hanging in there so long and helping where the code was theirs.
and I understand why you would be hesitant to jump in to assist anyone else after that less than warm reception.. I find it interesting when poeple get mad when you find an issue with something when you bring it to their attention.. I especially am irked when you offer to help, and then get your nose bitten off.. Not Zen like at all..:no:Quote:
Originally Posted by athena
Agree Kuroi is awesome! And his continued input here has been invaluable..Quote:
Originally Posted by athena
However, IMHO SBA versions which have followed Kuroi's last release have been flawed and buggy.. the multiple variants and bugs found in all three variants make this an unreliable mod for production use. Those using it will no doubt disagree. So I say that when the common questions being asked in this thread begin to be more about the usual install errors and less about flaws in functionality that's when IMHO this mod will be a reliable add-on again..
Mysh,Quote:
Originally Posted by mysh
have you looked at this module- "product attribute grid" http://www.zen-cart.com/index.php?ma...roducts_id=876 which will give you a grid showing the qty in stock and grey out the box if it is out of stock.
it might be one answer which gets you the same result even if it is not the neatest or most sophisticated finish.
For the record I could care less about stepping on toes... My MOD serves a diffrent purpose (having part numbers for every variant). The creation was strickly self served, I needed it to do this, so I did it. Sharing it in case anyone else wanted it was as Zen like as I could be :smile:. I did find a few bugs in the release I started with and have fixed them. The latest version is pending approval. If you have tried my version and found bugs, let me know and I will fix it if I can... http://www.zen-cart.com/forum/showthread.php?t=191415 You could always clean up SBA yourself and post it as the new bug free version. :PQuote:
Originally Posted by DivaVocals
I looked at your version and did a file comparison.. The ONLY difference was the addition of the part numbers as part of the variant. I do believe this option could have been added into the core as an admin configurable option for others who needed the same functionality without requiring the creation of a completely separate SBA mod.. 'tis all I was saying..:yes:Quote:
Originally Posted by rhuseby
Other variants of SBA have included similar alleged "one-off" features that I believe also could have been made admin configurable options without splitting off as a new variant.
The fact that this support thread is LITTERED with posts from different variants of this one mod, the fact that there are at MULTIPLE threads covering SBA "support" is a testament to how this code fragmentation has become problematic. People say they are using the lastest version, but WHICH version is the one they are using the latest version of??? There are bugs in each one of these versions, some carried over from the versions they are based on, some are new bugs introduced in the enhanced features that these versions bring..
It's why I say that SBA as a whole is unreliable for a production store at this moment. Others are free to disagree.. I still think the only STABLE version is Kuroi's last release of SBA (v4.7).. I get that each release after v4.7 was trying to improve upon Kuroi's 4.7 release, but there are bugs in each one of these variants.
ETA: Speaking of variants.. here's the FOURTH SBA variant I found: http://www.luxuriousslippers.com/Sto...s_V5.0Beta.zip
I don't think this one ever was submitted to the downloads section..
You know what?? You are absolutely right.. I sure could clean up SBA and submit it if...Quote:
Originally Posted by rhuseby
- I had time
- didn't have PAYING clients (who will come first)
- didn't have a full time job
- wasn't working on updating the 4 or 5 mods that I have been actively involved in maintaining already..
Yep I sure could work on SBA too..:yes: if I had time:no:.. in the meantime I've decided to contribute my three cents instead.:laugh: Hoping whomever decides to update this for v1.5 decides to stop the madness and put all these variants into ONE version of SB that covers all (or many at least)..
Hi,
I hate to jump in here with a post, as I notice a lot of anger within the thread - which I can really understand.
I set up ZC 1.5 for a small shop. I want to stock-take items as individuals (e.g. XL/blue, XL/white, XXL/white etc.). I loaded up one variant of SBA only to find that the "readme" does not fully relate to the files given. Anyway, the whole thing went haywire and I had to get a server roll-back. I checked other add-ons only to find they are basically all the same.
I take it that SBA does not work with 1.5, it does not work properly, it has no author support and it is not worthwhile.
I take it then that my only option is to list each item as is, meaning singly, and not in a group thus not being able to link them through drop-downs?
Being new here I do not know if there is a process for all the millions of ZC users to request add-ons be implemented as standard in the next release.
Mark
Hey spbw, I sense no anger, just a lively discussion.
As a new zenner, this is my must have feature, and, imho, it should be a feature of all shopping carts.
Having said that, prior to using zen cart, I did some checking and found that SBA has not been adapted to v1.5, so I made the choice to install v1.3.9h, where SBA does work. When SBA is ready for v1.5, I will upgrade. It is not a show stopper.
People who develop free add ons must do so in their free time because they have to make a living. While it would be nice to have all add ons ready to go when a new version of zen cart is rolled out, it will never happen.
Thanks Coopco, "lively discussion" it is then. :laugh:
I hate the thoughts of wiping 1.5 and going back to 1.3 for one add-on that does not work. We are not commercial, just people who like beer and have a few clothing items for members. I guess there is a sound reason for the jump from 1.3 to 1.5, so maybe I will just set up individual items rather than go backwards.
I suppose I am used to PHPBB forums and the Mods & support structure (those guys do the same thing on their own time - and I do understand the time & commitment they give for free).
Mark
No worries spbw. If you have zen cart installed under wamp for testing, you do not have to lose what you have done so far.
My zen cart site is installed under wamp, and I am testing add ons.
When finished testing, and understanding zen cart as oppossed to the mother cart, I will go live and convert my existing site.
Don't assign any emotions to me.. I sure as heck NEVER SAID I was angry..Quote:
Originally Posted by spbw
EXACTLY!!!:clap:Quote:
Originally Posted by coopco
Nods in agreement:yes:Quote:
Originally Posted by coopco
Hey everyone. Sorry I bailed on this mod. During the time I was reading it and fixing it. I got fired from the job I was working. I am now doing websites for some new clients and use a different shopping cart that has this featured and more I needed built in. So I stop furthering this mod.
Now one of my old client re-hired me to do work on their existing website which used Zen-Cart. I just upgrade it to 1.5.0. I will be readoing this mod to.work with 1.5.0. I don't promise anything new. Just getting my last version to work with the update. Stay tuned...
P.S.
Go Patriots!!! LOL
Was suppose to say, " I was redoing it and fixing it." Dang Android cell phone typing.Quote:
Originally Posted by creinold
I know what you mean!!!:laugh::laugh::laugh:Quote:
Originally Posted by creinold
Question for you.. Perhaps you saw my rant on the last pages.. :laugh: Will YOU be making strides towards creating a UNIFIED SBA for Zen v1.5??
The code fragmentation and the fact that the readme files are updated to CLEARLY indicate what changes have been made in each submitted version are problematic.. It would be nice to see a fully unified version of SBA for the first time since v4.7 by Kuroi.. Your version had always seemed to be the most promising of the many variants as (if I recall correctly) you seemed to be leaning towards incorporating the half working Dynamic dropdowns mod..
I am about half way upgrading my version to work with 1.5.0. Hopefully have it out by the end of the week for beta testing. Spent about 5 hours just to get the admin settings to show up in the 1.5.0 Menu. LOL *sigh* For now I am not adding any new features it does have the dynamic drop down add on included in my version. I may remove all the radio buttons stuff that don't work and just have the dropdown options. I am just getting this mod to work with my one client I have left on zen-cart. If I had to do any more work on it... I'll just switch them over to the other cart system I am using instead. :wacko:
In post #1293 I shared the following fix for zencart version 1.3.9h using the SBA version .13 - it is a no fuss no muss solution to get your store up and running. I have not worked with .14 but if you go back to 1.3.9 I highly recommend this fix. It has solved the problem for many here:
Quote:
Originally Posted by athena
RE: no stock alert message on shopping cart page for non attribute orders
I have stock_by_attributes_1.4.13 installed and zen cart v1.3.9h - if i add an attribute of a product to cart, which uses stock by attributes for stock, and i order more than stock available for that attribute, an alert message is displayed on the shopping cart page. this is great.
However, if i add a product to cart that is not an attribute (doesn't use stock by attributes, default stock system only) and order more than available stock, although i am stopped from continuing to checkout, there is no alert message as per above.
I think it is due to code changes in modules/pages/shopping_cart/custom_template/header_php.php.
I have tested on a different site with no stock by attributes installed and stock alert message is displayed if I try and order more than stock available.
If anyone can advise how i fix the code, or why this is happening that would be great.
I am still looking for the answer on how to paginate the stock by attribute page. I have been looking for a way to implement some code for this but have not had any luck. I did find some code that I think will work but just am not sure where to add it in. The code I would like to use is:
Can anyone give me some advice on how to modify the above code to work with this module?PHP Code:<?php
//connecting to the database$error = "Could not connect to the database";mysql_connect('localhost','root','') or die($error);mysql_select_db('pagination') or die($error);
//max displayed per page$per_page = 36;
//get start variable$start = $_GET['start'];
//count records$record_count = mysql_num_rows(mysql_query("SELECT * FROM data"));
//count max pages$max_pages = $record_count / $per_page; //may come out as decimal
if (!$start)
$start = 0;
//display data$get = mysql_query("SELECT * FROM data LIMIT $start, $per_page");
while ($row = mysql_fetch_assoc($get))
{
// get data
$name = $row['name'];
$age = $row['age'];
echo $name." (".$age.")<br />";
}
//setup prev and next variables$prev = $start - $per_page;$next = $start + $per_page;
//show prev buttonif (!($start<=0))
echo "<a href='index.php?start=$prev'>Prev</a> ";
//show page numbers
//set variable for first page$i=1;
for ($x=0;$x<$record_count;$x=$x+$per_page)
{
if ($start!=$x)
echo " <a href='index.php?start=$x'>$i</a> ";
else
echo " <a href='index.php?start=$x'><b>$i</b></a> ";
$i++;
}
//show next buttonif (!($start>=$record_count-$per_page))
echo " <a href='index.php?start=$next'>Next</a>";
?>
Thanks in advance
Hi all,
I am having a hell of a time getting this to work. Im on 1.3.9h. Ive tried all of the stock by attributes add ones with no dice.
The one im trying to install is THIS one.
This is the procedure ive followed:
1. install sql patch.
2. Rename includes/templates/YOUR_TEMPLATE to my template name.
NOTE: the instructions say to rename includes/modules/YOUR_TEMPLATE yet there is no /YOUR_TEMPLATE folder in /modules
3. Use fillzilla to move the files to my online directory.
The instructions say click on Catalog->Products with Attributes Stock to modify inventory levels but i have no such option.
Any help working this out would be appreciated.
Brent
mentose457 - i'm not sure if there is a dedicated thread for 'Stock by Attributes 4.7 Multiadd WITH TABLE FILTER 1.6', but, if there is, prob worth posting there.
I haven't used 'Stock by Attributes 4.7Multiadd WITH TABLE FILTER 1.6', only 'stock by attributes'.
but, referring to:
yes, you need to create a folder in includes/modules/ with the name of your template folder, the same name as YOUR_TEMPLATE in includes/templates/YOUR_TEMPLATE. Although you dont have to do this, you could and it would work, it is better to add customised files to a template folder to override the original (but not overwrite the original), it looks like if you didn't create a template folder here and put the files in there you would be overwriting core files (avoid as much as poss).Quote:
NOTE: the instructions say to rename includes/modules/YOUR_TEMPLATE yet there is no /YOUR_TEMPLATE folder in /modules
always, always make sure all files are uploaded, sometimes the best way to do this is NOT upload files one at a time, in this case add the /admin/ and /includes/ folder... however, before you do this, rename the admin folder to the name of your admin folder, and, also create the /YOUR_TEMPLATE/ folders with the correct template name as per above, including in the /includes/modules/ folder
Because of the fragmented codebase for SBA (there are 4 versions of this mod floating around) Each only SLIGHTLY different than the next. The authors of all of these variants unfortunately didn't BOTHER to update the readme/installation instructions so they are accurate.
You are right, there is NO such folder.. I don't know if the variant you installed needs this folder and files in it, but you might want to download one of the other versions and see if the files/folder you are looking for is in one of the other SA variants..
Quote:
Originally Posted by mentose457
You misunderstood mentrose457. There is NO FOLDER called "includes/modules/YOUR_TEMPLATE" in the install package of the SBA variant he installed.. So yes he could create that folder in his store, but why if there are no files in the install package to copy over.. Not sure if the variant of SBA heis using needs this file..
Quote:
Originally Posted by mattys
Zen Cart 1.3.9h
Stock by Attribute 4.14
I have seen the mods in this thread that show a stock quantity after each type (as long as you have only 1 attribute). However, when I use them, I lose my display only option value. For instance if I have Select Color, Brown and Black in a drop down, Select Color disappears and Brown is selected. Any one able to help?
IF you have positive brown and 0 black it will automatically exclude black and only show brown.
If doesn't make sense to allow people to select black since you don't have it.
Has anyone actually got this to work? I am trying Stock by Attributes v4.7a
I know it does not work on V1.5, so I installed a new shop using V1.39h. I tried to follow the readme but it makes little sense when it comes to folder/file names.
In Admin, Catalog I can see "Products with attribute Stock". When I go there I get this error:
When I go to the shop I see a blank page which I take is to do with the fact I am using another template design: dezina_advent138Quote:
1054 Unknown column 'sort' in 'order clause'
in:
[select * from products_with_attributes_stock where products_id="1" order by sort ASC;]
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.
Is there anyone who has got this thing working that can write a simple idiots guide to help us all get started? Please?
Is it worth all the effort or is it less stressful to add items on an individual basis (e.g. T-shirt/XL/white, T-shirt/XL/Blue, T-shirt/L/White etc. etc.)?
Mark
Quote:
Originally Posted by mentose457
Well I don't know what I was thinking or seeing. It turns out i forgot to rename the admin folder. Ay iz derp.
I just gave up on the whole thing and moved on to V1.5 for security. I think I will redo product types and use seperate items.
Mark
Zen Cart V.1.3.9
Like many others, I'm trying to get Products with Attributes Stock installed on my Zen Cart website.
The instructions are very brief and somewhat vague, especially when it come to installing the files on the server. Drag and drop into public_html with FileZilla leaves me a bit uneasy with the possibility of overwriting key files.
Also, I found that there is no includes/modules/YOUR_TEMPLATE folder. It has been suggested in this thread that we need to add the theme folder name here. Okay, what goes there? Or, does it merely need to be in place in case Zen Cart needs to put something there?
If anyone has clear concise instructions on installing this plugin, please post a link.
Thank you,
Mike
BTW, I know that this plugin works. A friend is using it on his website. The person who did the installation is not available.
I am posting a link to a thread here, I'm not sure if I'm doing this right, but I need help with the stock by attributes mod and this particular problem discussed here:
http://www.zen-cart.com/forum/showth...=175661&page=2
I am using Stock By Attributes version 1-4-13
Will this uninstall work with version 1.4.13Quote:
Originally Posted by kuroi
creinold stocks by attribute zc 1.5.0 alpha version:
http://www.zen-cart.com/forum/showpo...postcount=1091
Okay, I figured out that I needed to change the name of the "admin" folder in the addon to the name of the Admin folder in my Zen cart installation. After that, the installation went smoothly.
I ran the SQL script in Zen Cart (Tools/Install SQL Patches) and then uploaded the module files with FileZilla. Note that I backed up my database before doing this.
There is now a new menu choice on the Catalog dropdown, "Products with Attributes Stock" that enables the admin to add quantities to his various product sizes.
So, if you have renamed your Zen Cart Admin folder (and you should), rename the "admin" folder in the unzipped files to exactly match the name on the server. Hopefully, the author will add this small but important bit of information to the install instructions.
No one has updated those instructions in YEARS.. but it's sort of a known deal with most mods.. So most storeowner figure it out..
Quote:
Originally Posted by GArmour
I had a problem with the shopping cart letting customers add too many products to cart with no warning (non attribute products). But the cart would not let them check out and it didn't say why. This solution worked for me, maybe it can help others too. I replaced the code in includes/modules/pages/shopping_cart/header_php.php :clap:
This was done with SBA version 1.4.13 in zen 1.3.9h
Quote:
Originally Posted by athena
I want to install stock by attributes on v.1.5.0
I seem like this doesn't work. I NEED this module for my site.
When and where can I get this to work?
It's AMAZING what you find when you look up the page just a few posts..
Quote:
Originally Posted by creinold
Quote:
Originally Posted by creinold
Quote:
Originally Posted by perezosoo
Hi, I updated my cart (version v1.3.9e) with Version: 1.4.14 of Stock by Attributes
I renamed stuff as directed for my template and checked to see that all the files were over written but I still can't save attribute quantities,Quote:
This update fixes an XHTML error which causes the inline editing of quantities to not get saved. Only one file affected (see readme.html).
Any help would be appreciated. A easy work-around would be great!
Sorry if this is a duplicate, I can't seem to find anything specific to my problem using search.
Thanks
Hey Creinold,Quote:
Originally Posted by creinold
I've installed your latest alpha of this module (I'm running zencart v1.5) and it doesn't show up at all, I've made sure the template folder was renamed and installed the SQL patch in zencart's admin area as per the instructions.
I've used a previous version of the module for a old install of zencart (1.37 or 1.38 I think??) would this affect the install of the alpha?
What version of zen-cart are you installing this on?Quote:
Originally Posted by SlyRick
Okay I see the problem. Got to fix the SQL insert for admin page registration. Will do later tonight. Sorry about that ;)
The latest version, 1.5. As I said in my post I had SBA installed for v1.39 of Zen-cart (Can remember version number of SBA) would this be affecting the version of your's I've installed?Quote:
Originally Posted by creinold
Quote:
Originally Posted by creinold
Ah sweet as will be good to get this sorted for my client (She's pregnant and overdue so stress levels are whacked :shocking: ) and have it back up and running fine as.
Not sure what is happening, I got it to show up on my Admin menu on my clients live site without a problem, with my test site: that's a whole new story. It won't show.
I decided to move all the configuration setting into the "stock" settings in admin. IE: Configuration --> Stock
The settings have to deal with stock so I felt they best go there. Best of all don't have to register the page in Admin page since that by default is already registered.
Now getting it to show up to work in the Catalog --> Products with Stock is making me mad. LOL So for a work around type the url to get to it. (Make sure you log in to your admin first)
I'll keep working on getting it to register on the Admin menu. I am just baffled why I can get to work on one site but not my others?Quote:
YourDomain.com/Admin/products_with_attributes_stock.php
Here is an update SQL that puts the settings into the admin Stock Configuration:
Code:CREATE TABLE products_with_attributes_stock (stock_id INT NOT NULL AUTO_INCREMENT, products_id INT NOT NULL, stock_attributes VARCHAR( 255 ) NOT NULL, quantity FLOAT NOT NULL, sort INT NOT NULL, PRIMARY KEY ( `stock_id` ));
ALTER TABLE products_options
ADD products_options_track_stock tinyint(4) default '1' not null
AFTER products_options_name;
INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Images in Admin', 'STOCK_SHOW_IMAGE', 'false','Display image thumbnails on Products With Attributes Stock page? (warning, setting this to true can severly slow the loading of this page):','9','6',NULL,now(),NULL,"zen_cfg_select_option(array('true', 'false'),");
INSERT IGNORE INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (9, 'Stocks With Attributes', 'Stocks With Attributes', 9, 1);
INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false', 'When customer places more items in cart than are available, show the available amount on the shopping cart page:', '9', '1', NULL, now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Product Info Single Attribute Display Plugin', 'PRODINFO_ATTRIBUTE_PLUGIN_SINGLE', 'multiple_dropdowns', 'The plugin used for displaying attributes on the product information page.', 9, 1, now(), NULL, 'zen_cfg_select_option(array(\'single_radioset\', \'single_dropdown\',\'multiple_dropdowns\',\'sequenced_dropdowns\'),');
INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Product Info Multiple Attribute Display Plugin', 'PRODINFO_ATTRIBUTE_PLUGIN_MULTI', 'sequenced_dropdowns', 'The plugin used for displaying attributes on the product information page.', 9, 1, now(), NULL, 'zen_cfg_select_option(array(\'single_radioset\', \'single_dropdown\',\'multiple_dropdowns\',\'sequenced_dropdowns\'),');
INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Show Out of Stock Attributes', 'PRODINFO_ATTRIBUTE_SHOW_OUT_OF_STOCK', 'True', 'Controls the display of out of stock attributes.', 9, 10, now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'),');
INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Mark Out of Stock Attributes', 'PRODINFO_ATTRIBUTE_MARK_OUT_OF_STOCK', 'Right', 'Controls how out of stock attributes are marked as out of stock.', 9, 20, now(), NULL, 'zen_cfg_select_option(array(\'None\', \'Right\', \'Left\'),');
INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Display Out of Stock Message Line', 'PRODINFO_ATTRIBUTE_OUT_OF_STOCK_MSGLINE', 'True', 'Controls the display of a message line indicating an out of stock attributes is selected.', 9, 30, now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'),');
INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Prevent Adding Out of Stock to Cart', 'PRODINFO_ATTRIBUTE_NO_ADD_OUT_OF_STOCK', 'True', 'Prevents adding an out of stock attribute combination to the cart.', 9, 40, now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'),');
INSERT IGNORE INTO `configuration` VALUES (1286, 'Disable drop down menu when stock equals zero', 'sba_zero_disable ', 'true', 'Set drop down menu to automatically disable when the attribute quantity equals zero:', 9, 6, '2010-07-25 15:29:27', '2010-07-25 14:44:56', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
# Register the pages for Admin Access Control
INSERT IGNORE INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('products with attributes stock', 'BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK', 'FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK', '', 'catalog', 'Y', 100);
Update to my files including the last SQL I posted in post above:
http://www.sidewalkstyles.com/Stock_...V1.5.0alpha1.3
Link doesn't work and the SQL patch gives meQuote:
Originally Posted by creinold
Code:WARNING: An Error occurred, please refresh the page and try again.
Need to use phpadmin to delete these table:
CREATE TABLE products_with_attributes_stock (stock_id INT NOT NULL AUTO_INCREMENT, products_id INT NOT NULL, stock_attributes VARCHAR( 255 ) NOT NULL, quantity FLOAT NOT NULL, sort INT NOT NULL, PRIMARY KEY ( `stock_id` ));
and this column:
ALTER TABLE products_options
ADD products_options_track_stock tinyint(4) default '1' not null
AFTER products_options_name;
Then run the SQL again
I re-uploaded file. Seems to download okay for me?
Hi, I updated my cart (version v1.3.9e) with Version: 1.4.14 of Stock by Attributes. I am also using a free template from picaflor.
I'm a total newbie at this so sorry if this is a stupid question. I think I have installed the files correctly, as I'm getting the stock and products with attributes stock menus, and I've tried adding a few quantities for a few attributes (size ones) - but when i get to my website it still doesn't show? I choose a size in the dropdown, but the quantity available doesn't update... effectively in the actual website I can't see anything indicating the stock level by attribute. The website is jibadoo.com.au/products.
Help anybody? :(
To register the page here's the edit:
remove 'CATALOG' from 'language_key': 'BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK' should be 'BOX_PRODUCTS_WITH_ATTRIBUTES_STOCK'Code:# Register the pages for Admin Access Control
INSERT IGNORE INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('products with attributes stock', 'BOX_PRODUCTS_WITH_ATTRIBUTES_STOCK', 'FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK', '', 'catalog', 'Y', 100);
-OR-
To do it manually on Admin Page Registration page, enter the following values:
Page Key: products with attributes stock
Page Name: BOX_PRODUCTS_WITH_ATTRIBUTES_STOCK
Page Filename: FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK
Page Parameters: [leave blank]
Menu (select): Catalog
Display on Menu?: [check]
Sort Order: 999
Thank you creinold for your fix, it works for me on v1.5, however, there's just one thing:
On the product info page, I have 2 attributes options. The new drop down versions and the old radio button options. How do I get rid of the old radio button option?
Thanks again for your help, I wouldn't have been able to get this far without your efforts. :clap:
One more thing, I'm assuming the dynamic drop down menu is supposed to be ajax based. The function doesn't seem to be working though for example length + color option. If the user selects the length option first, the colors drop down menu should refresh to display the available colors that are in stock.
This is beyond the scope of my knowledge so I'm unable to troubleshoot further. I wouldn't know how to check if it's an ajax problem or sql problem.
You can ignore the previous post, I got the it to work.
the duplicate attributes drop down is from tpl_modules_attributes.php
I still got to troubleshoot it. looks like the settings on line 17 is in it twice (its also on line 46ish.) Could be the problem but I am not at home to test it.
Ajax is not enabled for the dynamic drop down. Just the admin page settings.
Thanks for the SQL fix. can't believe it was one darn word that was messing me up! LOL
lol! it's always the ones that are hiding in plain sight that cause the problem =]
I also fixed the tpl_modules_attributes.php page, and yes attributes options was listed twice:
I think that's about it. Dynamic Drop Down ajax menu is working, Stock by Attributes is working, the product with their attributes are displaying on the order, stock is being deducted accordingly from the DB, I'm receiving order confirmation emails.Code:<?php
/**
* Module Template
*
* Template used to render attribute display/input fields
*
* @package templateSystem
* @copyright Copyright 2003-2005 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: tpl_modules_attributes.php 3208 2006-03-19 16:48:57Z birdbrain $
*/
?>
<div id="productAttributes">
<?php if ($zv_display_select_option > 0) { ?>
<?php
$products_attributes = $db->Execute("select count(distinct products_options_id) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$_GET['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = ". (int)$_SESSION['languages_id'] ."");
if ($products_attributes->fields['total'] > 1) {
$products_id=(preg_match("/^\d{1,10}(\{\d{1,10}\}\d{1,10})*$/",$_GET['products_id']) ? $_GET['products_id'] : (int)$_GET['products_id']);
require(DIR_WS_CLASSES . 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN_MULTI . '.php');
$class = 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN_MULTI;
$pad = new $class($products_id);
echo $pad->draw();
}
elseif ($products_attributes->fields['total'] > 0) {
$products_id=(preg_match("/^\d{1,10}(\{\d{1,10}\}\d{1,10})*$/",$_GET['products_id']) ? $_GET['products_id'] : (int)$_GET['products_id']);
require(DIR_WS_CLASSES . 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN_SINGLE . '.php');
$class = 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN_SINGLE;
$pad = new $class($products_id);
echo $pad->draw();
}
?>
<?php
if ($options_attributes_image[$i] != '') {
?>
<?php echo $options_attributes_image[$i]; ?>
<?php
}
?>
<br class="clearBoth" />
<?php
}
?>
<?php
if ($show_onetime_charges_description == 'true') {
?>
<div class="wrapperAttribsOneTime"><?php echo TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION; ?></div>
<?php } ?>
<?php
if ($show_attributes_qty_prices_description == 'true') {
?>
<div class="wrapperAttribsQtyPrices"><?php echo zen_image(DIR_WS_TEMPLATE_ICONS . 'icon_status_green.gif', TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK, 10, 10) . ' ' . '<a href="javascript:popupWindowPrice(\'' . zen_href_link(FILENAME_POPUP_ATTRIBUTES_QTY_PRICES, 'products_id=' . $_GET['products_id'] . '&products_tax_class_id=' . $products_tax_class_id) . '\')">' . TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK . '</a>'; ?></div>
<?php } ?>
</div>
Thanks again creinold! :clap:
Glad you got it working. I will update my alpha version tonight when i get home. =)
Found one more thing to add to includes/languages/english/your_template_name_/product_info.php
Find:
Add after:Code:define('TEXT_OUT_OF_STOCK_MESSAGE', 'The combination of options you have selected is currently out of stock. Please select another combination.');
This is for customers who tries to click add to cart button before selecting all options.Code:define('TEXT_SELECT_OPTIONS', 'Please select a preference for each option before proceeding');
Someone is on a roll. :wink:
Newest Alpha test version:
http://www.zen-cart.com/forum/showth...82#post1109282
Quote:
Originally Posted by Sheryll
Was this for me? If so... what does it mean... sorry!
If you are running Zen-Cart 1.5.0 then it would be. ;)Quote:
Originally Posted by callmeal
Phew - ok then it's fine that I didn't understand a word of it!Quote:
Originally Posted by creinold
Can anybody help me with my problem on Version: 1.4.14 in post 1479? I just can't figure out why it won't show up on my web page even though the menus are in my zen cart :(
Thanks for all the help so far guys, I've got to the point now where customers can choose an item by it's attribute and it'll deduct from the database etc etc and I know that by going to the stock by attributes page (By typing the link manually) that this area's still working fine.
But for the life of me it still won't show in the catalog drop down. I've tried both of Sheryll's methods of getting it to show with no luck.
Ideas?? Also I installed your lastest Alpha version of plugin.
Need help please..
Ive installed this mod on another site no problem, so I understand how it all works.
But Ive just installed it on a second site and after completing all the steps can now no longer access admin. All I get is a white page in Firefox, IE shows -The website cannot display the page HTTP 500.
Its like a URL error or htaccess or something?
I have since tried uploading the entire standard admin folder and that didnt fix it to my amazement.
Im running 1.3.9h. Theres a few other mods, IH2, admin_profiles_v1_1_1 and some other simple ones that shouldnt effect this.
How can I fix this? Might it be the sql patch? I did run it before uploading the files as instructed.
Since there are FOUR versions of this mod floating around, you will need to say which one of these you installed..Quote:
Originally Posted by Chargin
Good trouble shooting hint. Since your main website is the problem. Delete/ and reinstall original overwrite files in the include folder one at a time. Check/refresh website untill site comes back up. Then you'll know what file is causing this. I would start with includes/functions/functions_lookups.php
Ok it looks like it was NOT the attributes mod. Ive totally uninstalled the admin profiles mod and now Im able to login again.
Very strange though because the admin profiles mod was working fine until I installed the attributes mod. Perhaps they arent compatable? I used the latest one I could find via the "Free software addons" link.
Thanks for replies.
I would compare files and see what files cross over that are the same file folder & name. Then compare the files with winmerge or similar program and merge files together.
Quote:
Originally Posted by Chargin
And to add to this it's possible that your issue was caused bu some setting in the admin profiles mod that needs to be tweaked.., so I would try posting your issue on their support forum as well..Quote:
Originally Posted by creinold
[tumbleweeds roll by... ]Quote:
Originally Posted by callmeal
Please?
Did you go through all the support pages and find all the fixes for SBA.... It's a daunting task but the old SBA has a lot of broken files that need to be fixed. My current version for Zen-Cart 1.5.0 is the most fixed version but doesn't work on older version of zen-cart.
Try actually adding an item to the cart and going to checkout, using an attribute for that item that you have set to no stock available.
The checkout should tell you theres no stock.
Quote:
Originally Posted by callmeal
My version allows it to show out of stock up in the dropdown menu but it made for zen-cart version 1.5.0. =(