Printable View
This was answered just four posts back. It cannot have anything to do with Stock by Attributes as it has neither a table of this name nor a constant defined as per the error message. You need to look at what other mods you have installed to see which should be creating this table, or start a new thread to see if anybody else knows.Quote:
Originally Posted by HGrubb
Hi there,
Just installed the mod and its all working great accept now on the site i get the following error message when logging in or any page on the site that is ssl,
I have copied the files over to both servers,..Code:Warning: include(includes/languages/english/extra_definitions/products_with_attributes.php) [function.include]: failed to open stream: No such file or directory in /home/tb/tbs/tbsm.com.au/ssl/www/includes/modules/extra_definitions.php on line 73
Warning: include() [function.include]: Failed opening 'includes/languages/english/extra_definitions/products_with_attributes.php' for inclusion (include_path='.:/usr/local/lib/php/:/home/ilisys/php/') in /home/tb/tbs/tbsm.com.au/ssl/www/includes/modules/extra_definitions.php on line 73
Is there something i may have missed?
Dynamic Drop Downs for Stock by Attributes.Quote:
Originally Posted by kuroi
I got the same problem.
Do you have one of these daft hosting arrangements where you need to maintain two copies of all the files? Personally I wouldn't go near them as there's too much scope of inconsistencies and errors such as the one that you are experiencing.Quote:
Originally Posted by TBSM
I'd double check that the includes/languages/english/extra_definitions/products_with_attributes.php
file has arrived safely in both locations (especially on the https server) as the message is clearly telling you that it's missing from one of them. But if it's there in both locations, I'm afraid that I therefore don't have much to offer here as the problem is going to be very specific to your hosting set up.
I wasn't aware of that mod, so thank you for drawing it to my attention.Quote:
Originally Posted by uvfch
However, I've downloaded it and you're right. That mod integrates classes from an osCommerce mod which contain a reference (line 87 of the pad_sequenced_dropdowns.php class) to a table that doesn't exist in Zen Cart or Stock by Attributes. This has been raised else where and hopefully the mod's author will sort it out.
Turned out that the SSL server just takes longer to upload so it was running off cached memory. All perfect now, thankyou!!
So, not only do you have to maintain files on two servers (and keep them in sync) but the performance on one of them is so bad that changes are lagged introducing another potential point of failure. I'd be looking for a new host.Quote:
Originally Posted by TBSM
Hi,
I've been looking through this thread and others but I have not been able to find a definitive answer for my problem,
I own a clothing site and have a lot of shirts to upload onto zencart with easy populate from a spreadsheet application. In doing so I need to control the quantities of each size for each Shirt.
Has anyone overcome this problem and if so how. Any tips or tricks will be most appreciated
Thanks!!!
1. I installed the mod, and I have check each and every file (by looking at each one in its correct folder) to make sure they are there.
./admin/includes/languages/english/options_values_manager.php
./admin/options_values_manager.php
./includes/classes/order.php
./includes/modules/attributes.php
./includes/templates/template_default/templates/tpl_modules_attributes.php
( For security reasons, I have renamed my admin folder and I put the files are where they are supposed to be. Could this relate to the problem below?)
2. I ran the SQL command: ALTER TABLE `products_options_values` ADD `products_options_values_quantity` FLOAT NOT NULL DEFAULT '0';
(if I try to run it again, it fails and says it's already there)
Why don't I have a new item on my admin/catalog ?
Why have all the dropdowns on my attributes disappeared (look at my website to see this)
What's missing here? :frusty:
I am using ZEN 1.3.8a
Mods: Cherry_Zen template, Link Manager, Credit card sidebox, Google sitemap - none of which should conflict, right?
Help!!!!
Jeff
To be fair, I have to admit that I didn't use THIS mod to cause all the grief I caused. I used the Attributes Separate Stock (I mitakenly downloaded that one and not THIS one) and now my site is hosed. Of course I backed it up, but when I replaced all the files I changed with originals, it's messed up worse than it is now, so I had to revert to the modded versions that doesn't show attribute options. Something happened but I don't know what. I know I added a SQL command (the one listed above) could that be what's messing me up, and can I easily undo it?
Thanks for any help on this.
Jeff
Sometimes you wish you could delete those panic posts... Anyway it turns out to be ./includes/modules/attributes.php that was the culprit. Now everything is back to sort of normal until I foul it up again.Quote:
Originally Posted by jeffreydesign
Easy Populate's strength is that it takes a single source of data and makes all the connections necessary to split that data between a number of database tables. However, it only knows about the tables in Zen Cart's core code, i.e. knows nothing about the table added for Stock by Attributes.Quote:
Originally Posted by MerchNation
You could amend Easy Populate to add the code needed to recognize and populate it, but this seems unnecessary to me, since this mod only adds one table. You could therefore separate your attribute stock data off into a separate table, save it as a CSV file and use MySQL's built-in csv import capabilities to upload it directly.
Hi JeffQuote:
Originally Posted by jeffreydesign
Sorry to hear about these problems. Glad you got to the bottom of it.
Unfortunately I don't know of a support thread for the "Attributes Separate Stock" mod. If anybody else does, maybe they could post a link here? :yes:
Thanks - I couldn't find a support thread or wiki for "Attributes Separate Stock" either. I did install Stock by Attributes and it works perfectly for my Jewelry store. :hug:Quote:
Originally Posted by kuroi
Now I have a huge inventory to update. I only wish there was an easy way to transfer the inventory qtys from one table to the other, like something that distributes the total qty evenly across all possible derivatives (since for me, that's how it is - I try to have one or two each of each style/size.) Sort of like the reverse of the sync quantity.
Thanks! Jeff
www.jeffreydesign.com
I have just installed Stock by Attribute v4.7 and was very excited to find the Catalog->Priducts with Attributes Stock tag.:clap:
I was celebrating too early though because when I clicked on this it took me to URRL: My site/admin/FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK.php
which of course doesn't exist. I know I need to put in the filename but I have no idea which file it is referring to or how I do this.:frusty:
Please help!
Something is wrong with your admin/includes/extra_datafiles/products_with_attributes_stock_filenames.php file.Quote:
Originally Posted by Mon3
Do you have that file on your server?
What type of server is your site hosted upon?
I have searched the thread but I haven't found the exact answer, has the issue with checkboxes been resolved? I can't set stock levels for attributes that have checkboxes without having one of the checkboxes selected, if you see what I mean. We have many products with multiple attributes which has been a headache with stock levels in themselves. Most attributes are radio buttons and some have checkboxes as well as radio buttons and that is where my problem lies.
Thanks!
Matt
The mod doesn't support checkboxes (or text fields). Most attribute types allow only one value per attribute. Checkboxes allow you to have any number which would represent a huge uplift in the mod's complexity and probably necessitate a completely different approach.Quote:
Originally Posted by lankeeyankee
However, in most of the cases that I seen where clients wanted to mix checkboxes and stock, they were actually trying to cross sell additional products and it was possible to achieve the intended results by treating them as separate products with their own stock (as they really should have been). Though I don't know whether that would apply to your situation.
I have reloaded all the files and is now working fine.
Thanks
just upgraded to 1.38a and reinstalled stock by attribute, and now it doesn't work properly example: if i have 2 x 16oz gloves left in stock but 8 in all, anyone can order 8 16oz gloves without getting a warning, and if they go over the total amount of gloves and the warning now just stats that that there is 0 gloves available. it worked fine before the upgrade and reinstall.
any help would be great.
You upgraded zencart to 1.3.8.a. Did you use correct version ofQuote:
Originally Posted by MB1
Stock by Attributes for zencart version now installed.
misty's suggestion is certainly a possible explanation, but I'd put my money on an FTP problem. Because you've upgraded your Zen Cart I'll bet all the files have sparkling new datestamps. When you then install Stock by Attribute, some of whose files will have older datestamps, and your FTP client may ignore those that appear older than the new Zen Cart files that you need to overwrite. This issue has already been done to death earlier in this thread, so there's plenty of extra detail there if you need it.Quote:
Originally Posted by MB1
i just re stalled all the SBA files last night again and it seems to work now
The following helped me with my blank checkout page problem. I was on the verge of unfollowing the installation instructions, in order to uninstall. I renamed the original files "filename_ORIG.php", adding the _ORIG part to any original files. But, I did not move them. The files that I believe were causing the blank checkout page are /includes/modules/pages/checkout_shipping/header.php and includes/modules/pages/shopping_cart/header.php. After moving the _ORIG files to a newly created directory specifically for saving _ORIGINAL_FILES, the checkout now works as it always has.
Just reaffirming the point kuroi makes in post #324 as seen below. Hope this helps anyone else who is about to pull their hair out of their head with frustration! Good luck!
(and thanks kuroi for having such simple but valuable advice, a virtual slap across the head!)
Quote:
Originally Posted by kuroi
My install works great except it doesn't give an error that there is insufficient stock when you proceed to checkout.
I've installed SbA v4.0 onto a new install of Zencart 1.3.8a. The mods I have are
- image handler 2
- column format product listing
- easy rollovers
... and I've made quite a few cosmetic changes also - as you can see:
(it's pw protected: user: zendev pass: devvingzen)
http://tinyurl.com/5uz7ok
If you try to check out on with the above item (pick a size 12 which has zero stock), it won't let you proceed past the checkout, but it doesn't give you a warning to say there's no stock either - it just brings back the same screen.
Any ideas, anyone?
TIA!
OK - an update, I get the "out of stock" red message on the header IF i have more qty in my cart than I have total stock for that item...Quote:
Originally Posted by speedyvespa
i.e. if I have 1 size 0 in stock for this item (1 qty in all attributes) and try to check out with 1 size 2, it won't let me proceed but no error.
- if I try to checkout with 2 size zeros (or 2 total of any size), it won't let me proceed, but I get the error.
OK, I'm going around in circles here. I've got the mod installed and it's working perfectly, thank you!
I'd like to do one more thing and it's exactly this (copied from the Wiki):
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 "
The files referenced in that Wiki answer no longer exist in the mod. The link takes me to a zen cart page that says I don't have access to that post.
Can you point me to information on how to implement this change? I'm running version 4.7.
It would be a major surprise if SbyA 4.0 worked on Zen Cart 1.3.8.Quote:
Originally Posted by speedyvespa
This mod is extremely sensitive to changes in the Zen Cart code and needs tweaking for each new release. 4.0 was written for Zen Cart 1.3.5. For 1.3.8 you need SbyA 4.7.
If your includes/modules/attributes.php file is missing, then you have a big problem that needs to be addressed.Quote:
Originally Posted by pinkchalkstudio
I suspect that the forum archive has been turned off to speed up the performance of the forum. This is probably sensible as the much of what was in there was out-of-date and therefore misleading anyway.
Unfortunately the odd gem will get lost in this process. Maybe somebody who has made the changes requested above recently could post the code that they used ???
Thank you for putting the request out Kuroi, I was obviously wrong about not having the attributes.php file. :smile: I was looking in my core files for SBA v4.7...
I'll wait to see if anyone can share the mods.
Thanks,
Kathy
Hi All,
What is the best way to uninstall this module?
Thanks.
I have the same question. The module is great, but with my particular setup, it presents a couple challenges that are too time consuming to work around. Great module, but need help uninstalling. I've moved all files (i think) to a 'mods not in use' folder, but I'm still getting database error on frontend and in admin area.Quote:
Originally Posted by gsdcypher
1146 Table 'myb0810212513999.TABLE_PRODUCTS_STOCK' doesn't exist
in:
[select quantity from TABLE_PRODUCTS_STOCK where products_id = '368' AND quantity > 0
Have I missed something somewhere?
@gsdcypher, If you're using the current version, 4.7, then running the following SQL should neuter itQuote:
Originally Posted by gsdcypher
You may wish to also replace the files mentioned in the installation documentation with their originals from the release package of the Zen Cart version that you have installed, but that shouldn't be necessary.Quote:
DROP TABLE products_with_attributes_stock;
DELETE FROM configuration where configuration_key = "STOCK_SHOW_LOW_IN_CART";
@greenraingraphics, installing won't help you as your problem has nothing to Stock by Attributes. See post #405.Quote:
Originally Posted by greenraingraphics
Right you were! I had seen that post previously, but got caught up in removing things that I assumed it was related.Quote:
Originally Posted by kuroi
Thanks for the help!:smile:
I found the post mentioned....and it works like a charm. Just be sure you realize that instead of trying to find the file :includes/modules/pages/product_info/main_template_vars_attributes.php (which doesn't exist)Quote:
Originally Posted by kuroi
You really need to edit : includes / modules / attributes.php
The link to the post in question is : http://www.zen-cart.com/forum/showpo...&postcount=110
Sorry if this is redundant....I've been working on this for like 3 days now only to realize the info was right here all along....
i have a product with attribute. how do i make it so that it allows checkout even when a certain attribute is out of stock and will just notify the customer that the product will be shipped it 3 weeks.
e.g.
product: t-shirt
attribute: yellow = 10
red = 0
green = 8
how would i allow customer to checkout with their order red and will just notify them that it will be shipped in 3 weeks.
thank you so much!
Drew, thanks for hunting that down and posting. Not sure if the wiki can be updated by just anyone, but it would be fantastic if it could be updated with that direct link. The link that had been in the wiki has been broken.Quote:
Originally Posted by drewby07
To drewby07: :hug:
This was driving me crazy, thank you so much for finding the link and posting your results. I implemented this morning and it's working great.
If anyone is curious, you can see how displaying the stock level next to the attribute looks here: http://www.pinkbypost.com/index.php?...&products_id=9
Hi
Have just installed v4.7 and wondering if there is any way of changing the 'Quantity in Cart' so that it changes with the attribute selected, rather than showing the total number of product in the cart.
e.g. at the moment if I add 2 yellow and 1 red item the Quantity in Cart shows 3 whichever attribute I select in the dropdown.
Alternatively is it possible just to remove the Quantity in Cart text and count because it doesn't make sense to me to have "3"
Christine
I really like this contribution. It solves a huge problem for me, because I have several products with color variations set up as attributes. :D
I just installed 4.7a on a Zen Cart 1.38a installation. I have an issue to draw to attention to and a question.
The first time I went to set stock quantities on a product with two attribute variations, I accidentally selected Both for the product to select for change. I got a Headers Already Sent error that I traced to admin/products_with_attributes_stock.php, line 193. The following echo statement generates the error.
The line generated output that displays "att: 1/2".Code:echo "att: $attributes<bR>\n";
I do not get the error when I correctly select a single attribute to change.
I commented the line out and everything seems to work fine.
I really like the feature that displays the amount of stock available in the Shopping Cart when a customer orders more than the current stock level. However, the Shopping Cart displays a message, "Items not in stock will be placed on backorder" and the customer is billed for the entire quantity.
My bank rep that is setting up my Authorize.net account told me that all orders must be shipped within seven days from the order date. Since that is not possible with some backorders, how do I prevent backorders from occurring?
If there are 5 items in stock and the customer is trying to buy 10, is there a way for me to advise them to adjust the order quantity or prevent them from placing an order for items that exceed the quantity that I can ship?
The best solution would be to actually put it on backorder and not bill the customer for backordered items until they ship, but I don't think we can do that with the current version of Zen Cart. *** hint, hint, hint for future release ***
I just installed this and tested it on an item. I put a total quantity of 1000, and an attribute with two selections, one with 999 in stock and the other with 1 in stock. It seems I can put 1000 each in the cart without getting an out of stock message...am I doing something wrong?
Thanks!
I uninstalled zen cart and resintalled it and the module and now everything seems peachy. Obviously some error on my part was to blame.
Ok, I've been using the older version of this mod (4.7 I believe) on my store (1.3.8) and it works fine. However, I just noticed an update to this mod (4.7a) that allows, quote:
"NOTE: This is a simple modification to version 4.7 that allow multiple attribute combinations to be added at the same time."
I installed this mod by overwriting all the files on my server. I also got rid of the file includes/modules/YOUR_TEMPLATE/attributes.php
as it says to do in the instructions when upgrading from previous versions.
However, I do not see how it works any differently than the previous one. How do I add multiple combinations at the same time? Right now I just go to` Catalog> Products With Stock Attributes, find my product, select the attribute and click "Edit Quantity". Then on the next page I modify the quantity and click submit. Where is the difference?
I'm going to try to make this as simple as possible. Try to... haha
I have everything installed and everything works great, but im having three issues.
Ive read thru 90+ pages and havent found a clear cut answer and dont want to spend the time changing every line twenty times till something works (I work full time and this "webstore" is not my full time gig).
I am selling Products that come in many colors.
I have it setup so that on the Product page, there are check boxes for each variation. I need it to stay this way.
Problem 1
If I dont select a checkbox, I can continue the order without anything selected and even check out! Is there a way to only continue if only a check box is selected?
Problem 2
This Product page also serves as a history of the different variations of the product for consumers information. When a product is no longer available, I would like to keep it on the Product page.
Is there a way to eliminate the checkbox for that variation? Or is there a way to have an add to cart on each variation, versus using checkbox's and having one general add to cart?
Problem 3
I have two variations, one with a stock of 4, one with a stock of 0. The stock of 4 works great and doesnt allow someone to check out with more than 4, but the one with zero, even though it gives the warning message, it will let you checkout with an order.
Thanks in advance everyone.
This site has helped me out sooooo much!
I have just updated my stock by attributes to the multi add version.
I am not a programmer and had been looking for something like this to save time so this is great.
I have one small requirement which I hope would improve it for every one and I am sure it would be simple to do but I am not a programmer
I use the word: "please select" as an 'attribute' as the default and I use the feature that this is for display purposes only. However when using this mod to add all varients it pulls in this attribute so I end up with a field/product in the stockby attriibutes list which is irrelevant - eg a product combo of "please select, please select" and then a product combo of: "please select, 0-6 months".
Can this be avoided. I am sure that if the flag for display purposes only is used in the sql statement it would be able to avoid this (on a t-shirt set with colour and size choices it gave me 25 irelevant combinations for example.)
I hope this is possible and would benefit others I am sorry I don't have the skills to do it my self and provide it for the community.
Thanks
MG
Kuroi,Quote:
Originally Posted by kuroi
Thanks for the great mod. I can now stop refunding customers and preventing them from coming back.
However, I have couple of questions since I'm having some difficulty creating query regarding above-quoted message.
How should I match my MS-Access data that does not include Zen-cart's products_id and stock_attributes fields with Zen-Cart's? I'm not in a power to specify neither products_id nor stock_attributes when I created them.
How would you write a query if I could import products_attributes, products and products_options_values tables into my MS-Access DB (or any DB), when I also had, for the convenience, Easy Populate importable table?
Hi,
I am using Stock by Attribute mod, which is great because its for a store selling clothing so it obviously needs different sizes. I don't want to show the total amount of stock but the amount of stock of each size and to not show the sizes that are out of stock. How do I do that? I can do PHP editting and some MySQL so if you could tell me how to fetch it/which tables (no phpMyAdmin here) that would be great!
Thanks
I've installed Stock by Attribute Module Version 4.6 and am running ZenCart Version 1.3.7 . After running SQL file. The admin portion of store is running correctly but customers are not able to check out they get the following error upon checkout:
Fatal error: Cannot redeclare class order in /var/www/vhosts/kasmarpro.com/httpdocs/smokejumpers/includes/classes/order.php on line 20
Hi,
I have a similar question/s to Dzy.
I am working on a store that sells clothing so it obviously needs different sizes and each size that is in stock will have different stock levels.
1. Is it possible to use the Stock by Attribute in conjunction with Easy Populate Advanced in some way so that it is possible to mass upload products to Zencart and have the sizing attribute information, including the stock level on hand for each size, uploaded along with the rest of a products information when using Easy Populate Advanced.
I hope I am not missing something obvious, as it seems a little odd to mass upload say 100 or more products just to have to log into the admin back end, and one by one, set up the stock levels for each size for each shirt.
I am also hoping that if it is possible to do this, or if anyone out there is doing this, that someone/they can post a description of what would be required. If MySQL or PHP are required then I should have the necessary skills to make and test modifications. I am just not familiar with the Zen Cart database structure.
2. Assuming that 1. above is possible. Is it then possible to display the stock level on hand in the shop when on a products page and on the category home page? Or if this is not possible is it possible to stop someone checking out if there is zero stock on hand for a particular sized shirt?
thanks in advance,
Ben
I want to install this Contribution.
Instead of over writing the existing pages what are the codes that need to be over written or inserted?
You can allow checkout even when there isn't sufficient stock by setting Admin > Configuration > Stock > Allow Checkout to true.Quote:
Originally Posted by adoy
You can't notify the customer as to when the stock for the particular product and attribute combination will be shipped as your Zen Cart doesn't have this information to communicate.
Do you mean in the shopping cart? If so, it sounds as though there's a problem with your Zen Cart, as each different combination of attributes should get its own line.Quote:
Originally Posted by xtinexoop
I'm afraid I can't comment on the coding for the 4.7a as I've never seen it (is that the same as the 4.7MULTIADD version in the downloads area?)Quote:
Originally Posted by Tech-E
You can prevent backorders by setting Admin > Configuration > Stock > Check stock level to "true" and in the same menu setting Allow Checkout to "false".
You can also change the text of the message that the customer sees in the shopping cart, by editing the relevant language file.
You "best solution" isn't really feasible and is unlikely to become so. Stock by Attributes doesn't know anything about how your payment module functions, but has to assume that it is in the majority which would have no way of collecting a second payment at a later date. If your payment module doesn't support it, then you would only be able to collect the later payment by holding card information in a way which for most Zen Cart would be a flagrant breach of the stringent card regulations, and therefore no something that you're even likely to see built in to Zen Cart.
No. Stock by Attribute ignores checkboxes. You've told us that you're using them for colors. Most times that would be a mistake as checkboxes represent "AND" options, unlike radio buttons which are "OR" options. Using checkboxes in place of radio buttons would need you to define and hold data about an exponentially larger number of product variants.Quote:
Originally Posted by xNBSx
This is a question about Zen Cart in general rather than Stock by Attributes, but I believe that the answer is again no.Quote:
Originally Posted by xNBSx
Not enough information here to diagnose the problem, but it sounds like it could be a symptom of one of the installation problems that people sometimes ahve and which have been dealt with at length in earlier posts.Quote:
Originally Posted by xNBSx
Are there comment tags to look for so I know what code to insert? I have installed all the other unique pages.
Just installed the contribution. Very tedious as the mods are not clearly defined so you need to compare each incident of // and or attributes when modifying modified core pages.
Perhaps the next version can be more clear.
In admin, the heading shows but no columns or functions.
In the directions where is includes/modules/YOUR_TEMPLATE ? All there is is includes/modules/pages.
Was there another copy of tpl_shopping_cart_default.php to overwrite in includes/templates/template_default/templates/tpl_shopping_cart_default.php ?
Please clarify. See attached image. Thanks in advance.
If I understand your series of posts correctly, you have chosen not to follow the installation process designed for this complex mod, and instead are attempting the apply all the changes to the core files by hand. I'm not surprised that you're finding it tedious. It's not designed to be done this way.Quote:
Originally Posted by webskipper
If you read back over the thread, you'd find that this mod has had multiple owners over a relatively long period of time and is now on life support being kept alive only until it is superceded by changes in core Zen Cart to provide this functionality. So I wouldn't hold out any hope for a new version.Quote:
Originally Posted by webskipper
Implementing the changes by hand would be a long and complex job. It would be unlikely that you would get it right first time. I recommend getting a good file comparison tool such as WinMerge to compare your changes to the files where the changes have already been done for you.Quote:
Originally Posted by webskipper
This is a left over reference to earlier versions where the modules/attributes.php file needed to be over-ridden. Although that was dropped from this mod a few versions back, there is an add-on mod to it (!) where I believe that this is still necessary. If you're just using stock by attributes, just ignore it.Quote:
Originally Posted by webskipper
You wouldn't over-write this file. You would over-ride it by placing the version providing in the release package in your equivalent of the includes/templates/YOUR_TEMPLATE/templates folder.Quote:
Originally Posted by webskipper
I've now taken a look at the multi-add version. It is the same thing as 4.7a, which seems to be it's internal name.Quote:
Originally Posted by Tech-E
I can confirm that you can safely comment out line 193. It's almost certainly a debug statement that has been left in there erroneously.
... or on the part of your FTP program. Your symptoms sound like not all the files made it safely to your server first time around.Quote:
Originally Posted by pRS317
Stock by Attributes can't work without knowing the product ID and attribute IDs to which each stock figure applies. So you would need to upload your data to a temporary table in your database and then use a SQL query to create a join between whatever information your Zen Cart products and your external data have in common, e.g. product name and option name. However, unless these match exactly, you will be unable to make the join.Quote:
Originally Posted by SteveKim
Provided size is the only attribute that you are using this can be done using the method that has been discussed several times already in this thread. I'm afraid I can't be more specific as I've never actually done it myself.Quote:
Originally Posted by Dzy
If you have multiple attributes then it gets a lot more complicated and you would need to use javascript to dynamically display (or not) the attribute combinations that visitors are choosing.
Which tables you need to access would depend upon the complexity of your store setup and which approach you wanted to take to display this reduced information. There is a schema for the product tables that would include all those that you are likely to need.
This error is one of the less opaque that PHP gives and means exactly what it says, that your site is trying to declare the same class twice.Quote:
Originally Posted by thehighlandsgroup
Most likely this is because when you uploaded the stock by attribute mod you, or your FTP program, made a backup of the order.php class in the location quoted and left it there. Zen Cart can't tell the difference between files that are intended as backups and ones that it is supposed to load, so tries to load the same class twice.
I can't answer definitively for Easy Populate Advanced as I don't have it, but I doubt it. Easy Populate and Stock By Attributes are both add-ons to Zen Cart and know squat about each other (though their authors have exchanged pleasantries).Quote:
Originally Posted by whitecliffs
There is a technical impediment in that Easy Populate uses product_model as it's index for linking to external information (assuming rightly, that the Zen Cart products_id will often not be available). However, there is no equivalent for product variants, i.e. product + specific combination of product option. This will be introduced in the next major release of Zen Cart.Quote:
Originally Posted by whitecliffs
2. Assuming that 1. above is possible. Is it then possible to display the stock level on hand in the shop when on a products page and on the category home page? Or if this is not possible is it possible to stop someone checking out if there is zero stock on hand for a particular sized shirt?[/QUOTE]Displaying stock levels for products with attributes has been done to death in this and other forum threads. It is possible but requires increasing degrees of technical knowledge to achieve as the number and complexity of attributes increases.
It is also possible to stop somebody checking out if there is insufficient stock to support the order. This is built into core Zen Cart, extended by Stock by Attributes and controllable via the Admin > Configuration > Stock menu.
Hi kuroi,
Thank you very much for your information.
Kind regards,
whitecliffs
I am using Araxis Merge (araxis com) to verify the changes I have done yesterday.
Except for destroying the Google Cart payment module, I saw no changes as to the hand inserted lines I added yesterday.
So, I just confirmed following the directions.
Admin panel still is not working. Snapshot is the same.
I even added the stock_attributes style to the stylesheet.css. No change.
How do I uninstall the sql patch to retry?
Maybe there is something else wrong with the install?
Thanks for the great add on, easy install and only took about 20 minutes for a newbie like me to get it working.
Two questions, neither of which are very important.
1: If I'm running a single database, does the sync quantities button do anything? Doesn't seem to matter if I click it or not after changing product counts.
2: Is it possible to display remaining quantity of a size to a customer, either when size is selected or at checkout?
I have it functioning for this item:
http://magneticbreeze.com/ZenCart/in...products_id=37
and in the unlikely event that someone should order 13 of the size 8 rings, it gives the backorder message without the customer knowing that only 12 are in stock.
These are very minor concerns, so no big deal if this 2 year old 'emergency fix' doesn't have the feature.
Thanks Kuroi for making life a bit easier.
eb
I just tried upgrading...
What I am getting now is I can get into things on the back end.
But on the front end.
My main and product pages are not commng up. Just my left bar and the header...
What do I do to fix this??? I dont know where to begin.
www.nothingbutcostumes.com
I made sure I renamed the folders. (both of em)
Hope I can get this solved. I really could use this mod.
Quote:
Originally Posted by kuroi
Kuroi - You were exactly right. I had renamed some old files such as order.php to order-old.php and such. ZenCart for some reason doesn't like that. I uploaded all new files and overwrote older files as you suggested. Stock by attribute module is now working like a charm. Thanks much for pointing me in the right direction.
Im not sure what's going on (I think Im just missing something), but the mod is working so far. On my test site in the admin, I setup the attributes and the stock for attributes on product "fred". Then I setup attributes for my next product, "p2" and went to setup the stock for attributes for "p2" but I cannot change products. I can only alter the stock for "fred".
What am I missing here?
thx
I just wanted to jump in and say, I solve my own problem as I did not have any stock setup for "p2" thus it was not showing up in sba.
::smacks forehead, pours another cup of coffee::
You can uninstall it by running the following through your Admin > Tools > Install SQL PatchesQuote:
Originally Posted by webskipper
but might this be something simpler like not having any stock set up on your products ready to be divided between the product variants?Quote:
DROP TABLE products_with_attributes_stock;
DELETE FROM configuration where configuration_key = "STOCK_SHOW_LOW_IN_CART";
I suspect that it doesn't anymore. This mod has been maintained by a number of people over the years, and I have a vague memory that the manual syncing may have been automated somewhere along the way - but I'm not absolutely sure. Certainly there's no harm to it though!Quote:
Originally Posted by Razmear
Yes. Set the Admin > Stock > "Show available stock level in cart when less than order" flag to "true"Quote:
Originally Posted by Razmear
I have installed the mod and all is working great! I would like to know if there is a setting so that when a specific size is out of stock the option for that size will not even be displayed in the dropdown. Is this possible? The way the mod works now the customer can choose the out of stock size and is told in the cart that the item in that size is out of stock and will be put on back order. Thanks in advance for any help.
No there is no such setting, but the code changes needed to do this under limited circumstances (i.e. no more than one attribute per product) have been discussed previously.
Thanks for the reply. As I understand what you said it can only be done with code changes when there is one attribute for the item not multiple sizes available for the product and one of the sizes is out of stock. Have I stated the situation correctly?
Thanks for your patience.
No size (however many values it can take) is just one attribute. You can do it with this.
However, if you had a size attribute and a color attribute, it would be more complicated, since you would no longer be able to say whether or not you were out of stock of small, as you might have them in red, but not in blue. So you need to either publish a table of stock positions (ouch) or use AJAX to get the answer for specific cases once a visitor has made their first choice.
I am having some trouble getting Stock by attribute to work properly.
I am using the latest version of Zencart and the latest Stock by Attribute release but for some reason Zencart seems to be ignoring the stock for each attribute.
For Example:
I have a test item called SHIRT and it has the following Attributes
Small: 5 in stock
Medium: 5 in stock
Large: 5 in stock
Total in stock: 15
Whenever I try to order 6 small shirts it allows me to when it should say out of stock..in fact..I can order any number of any attribute up to 15 (the total in stock) for the item.
I think the problem might be that I'm not Overwriting/installing all the files correctly because in the readme it says to rename "includes/modules/YOUR_TEMPLATE" but in my modules folder all I see is a folder named "page" do I rename this or what? Any help on how to install it more properly is appreciated. Thanks to all.
THANK YOU! This is the best thread that could have happened to me, and thanks for the link tot he thread that helps me define stock in the attributes for the customers to see what we actually have!
MY only question is formatting, how can I get the text for the attribute to sit as follows:
Name
Price
In-stock
I have not been able to figure this out at all....here is a link to a page that shows how it looks now...
http://www.ilovephotogifts.com/index...roducts_id=133
Thanks so much!!!!!!!!!!!!!!!
Problem with MySQL -
Hi there, thanks for the great contribution, however Im having a problem in that on my customers site I have colours and sizes with stock for each of these attributes - if I leave the attrbutes set to 'all' and add a quantity, I get the following MySQL error message:
this only happens if i leave the attributes set to 'all' - if i chooses a specific colour and size and add the quantity and submit, it updates the stock levels with no problems....Quote:
att: 81|80|79|136,84|83|82
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 'ON DUPLICATE KEY UPDATE `stock_attributes` = "81,84", `quantity
in:
[insert into `products_with_attributes_stock` (`products_id`,`stock_attributes`,`quantity`) values (15,"81,84",5) ON DUPLICATE KEY UPDATE `stock_attributes` = "81,84", `quantity` = 5]
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.
Thanks in advance....
Dan.
I kept messing around and found the solution to my problem this morning, If anyone is having a similar problem to the one I posted about on page 48 of this thread try using FileZilla to add stock by attribute files to your zencart folder.
I'm still testing my site on localhost and downloaded the server and client for FileZilla...started the server for it..loaded the client..logged in..navigated to my Zencart folder..and just drug the Stock by attribute folders into the directory and it worked like a charm.
:bigups:
Interesting problem, looking for answer. I love this addon, and thank the developer(s) for their hardwork.
I have been using this for a while, and worked perfectly. However, on one of my new products, I was going in to change the quantities of stock when it duplicated the variant. Now I have two variants for Green/Small. It seems to be only happening with this color, so I tried to delete the color and re-add the value (Luckily its localized to this one product :laugh:), but it still duplicates the variant when I try to go and edit the quantity.
Any thoughts?:wacko:
I have been having trouble getting the additional mod by grayson so the stock level for each attribute shows up.
using the code from post 132 and post 110 mentioned in the wiki I have modified my includes/modules/attributes.php file and also added the
define('TEXT_ATTRIBUTES_PIECES','pieces');
to my product_info.php file in my template. The stock levels do not show up in my store, but my store still seems to work fine (thought I would get a php error or a html rendering error if I inserted the code incorrectly)
I used to have the dynamic stock dropdown mod that marked attributes oos, but to the best of my knowledge I have removed it.
I am running a test site served off of my computer as localhost so I can't point you towards the site, but I have attached the attributes.php file that I modified, please let me know if I made a mistake somewhere.
running zencart 1.38a
I posted this in another post but I think this might be more appropriate for it.
If the quantity for the base item purchased is greater than what is in stock, the message that says these products are out of stock does come up. If a certain style of that base product is out of stock but the amount ordered is less that the total number of the base product in stock an out of stock message for those particular items does not show up.
For example, I tried ordering 6 of the same style/product shirts off my site, 3 in white and extra large, and 3 in black and small. Since I only have 1 of the small black in stock page 1 of the checkout process just cycles when you click checkout. No message will be shown to indicate which item is out of stock. If I try ordering 1 small black and 5 large white of shirt model AA and on the base product page I only enter 5 in stock the message that indicates products are out of stock will show up on both the large and small shirts.
Does anybody know how to fix this?
Also, I noticed if I provide a quantity box for a product (no attributes) and I only have one in stock (or the stock has been reduced to 1) and a buyer enters more than 1, the cart will notify them they need to change the amount ordered but the amount in inventory shown to them displays 0. It apparently removes the specific item the buyer put into their cart from stock. Is there a way to change this to 1. That way they will realize they can only buy one and not think the item is simply not in stock? Should I post this in another forum, prob.
I have added this mod into my zencart but when i go to catalog/products with attributes stock, i sellect all and put 100 (as i have 100 of all sizes) select submit i get the following error message on page at the top
"att: 138|139|140|141" then below it i get
"Warning: Cannot modify header information - headers already sent by (output started at /home2/fomausl/public_html/admin/products_with_attributes_stock.php:193) in /home2/fomausl/public_html/admin/includes/functions/general.php on line 21" when i hit back button and then re select products with attributes stock it shows me all quantity varients.
any help would be appreciated
thanks
As you only have one attribute there is a method for adding stock indicators (or quantities). The second question in this mod's wiki FAQ (about 2/3 of the way down) will help you with this.Quote:
Originally Posted by jill8026
Re-arranging the attributes layout is beyond the scope of this mod. But in essence you would need to over-ride the includes/modules/attributes.php file. This is one of the biggest and most complex files in Zen Cart, so the change would take quite a lot of work to identify (though will probably require only a handful of small changes when you get there).
Please remember to tell us which version of the mod you are using. from your problem I believe that you must be using the multi-add version. The error that you are getting is because that version of the mod uses a MySQL specific piece of syntax with which some versions of MySQL have problems. To get around this you would probably need to re-write the query to use normal SQL, or roll back to the supported 4.7 version (Dec 07) which uses only standard SQL.Quote:
Originally Posted by Dan Lacey
FileZilla is just one of many possible solutions to your problem and a sledgehammer to crack a nut for most people having this problem (though I use and like it greatly myself).Quote:
Originally Posted by Bunkerage
The underlying problem, which has been suffered by many people using this mod, is that some FTP clients seem not to over-write existing files and a server and don't tell you that they haven't done so, with the result that not all the stock by attributes files land safely. Anybody who has had this problem may have problems upgrading Zen Cart too.
So rather than changing FTP clients, for many people changing the default settings for the one that they're already using is enough.
Which verision of the mod and which version of Zen Cart are you using?Quote:
Originally Posted by killertofu
This sounds like a symptom of the mod not being installed properly and trying to execute a mixture of old and new code. I would recommend re-installing the files (the database patch doesn't need to be re-loaded) and checking that each files arrive safely, particularly those over-writing existing files.Quote:
Originally Posted by jjgtrading
This is not standard behaviour and if your cart was working properly it would do exactly what you want. I suspect that this is another symptom of having incomptible bits of code in your store.Quote:
Originally Posted by jjgtrading
You're using the multiadd version which has some bugs in it, one of which is a diagnostic line that should have been removed before it was released. You can safely delete the line referred to in the error message and the problem will go away.Quote:
Originally Posted by gibbyky2
Thanks Kuroi,
I'm going to take down that site (It's all over the place now anyways) and try it again.
Thanks!
I'd recommend that you ensure that your FTP program is set to over-ride existing files, even when the files that you are over-riding with have older datestamps. This would deal with what appears to be the most common cause of problems such as those that you have been reporting. Good luck.Quote:
Originally Posted by jjgtrading
You were right it looks like it was probably due to an installation error. I'm not sure of the specifics as I installed it about a week ago and have been busy with other sites. It's working perfectly now. TY!
Is there anyway to do a mass add? For example setup all the attributes and stock for one product, then copy it to all products? That would make my day!!!
In my case the actual "stock" is not much of a concern; it's either in stock (we carry it) or out of stock (impossible to get) and all products have the same attributes (t-shirt colors, sizes, styles, etc.).
thx
No from within Zen Cart. For a mass add you would need to structure and upload the information directly to the database.Quote:
Originally Posted by Oakwood
hmmm...that sounds tricky.Quote:
Originally Posted by kuroi
Aghhh. Hit a dead end with this. I currently have the Stock by Attribute thing, and the Dynamic Dropdowns for Stock by Attribute mod, and I just can't seem to find that magic setting to fix it all...
Okay, here we go...
http://www.millers-graphics.co.uk/in...products_id=69 !
Sooo.
1. There's two sets of dropdown boxes, like the original dropdown boxes, and the new set with the new mod. Anyone else had this and know what I should do?
2. The dropdown boxes have a bug or something. I've attached what the "Products with Attributes Stock" looks like for this item; the Size works, but nothing happens for Journal Type. Is this a setting or an installation error?
3. We don't really want to monitor stock levels, however if I set the stock to 0 it doesn't show; it needs to be at least 1 or something. Is there a way to fix this? I have a work around where I just set it to 1 and disable anything that subtracts stock and such, but I think this workaround might be the source of some of my problems.
My settings are as follows:
Config/Dynamic Drop Downs
Multiple attribute display -> Sequenced
Single attribute display -> Single
Show out of stock -> True
Mark out of stock -> None
Display message -> False
Prevent adding to cart -> False
Config/Stock
Check stock level -> False
Subtract stock -> False
Allow checkout -> True
Any help you can offer would be greatly appreciated. Thanks.
Attached is what the "Products with Attributes Stock" looks like for this item. Thanks again!
Hi how can I delete products from the stock menu??? I've deleted the whole folders but the products still seem to be left... and stock mod doesn't have delete...
thanks
Oh and can the "are you sure" confirmations somehow be removed=?