Printable View
Hi,
My stock levels are not being adjusted to reflect stock sold when customers place orders. Changing the status of the order does not affect the stock levels either.
My Products are all set up with Stock by Attributes.
Is this a problem with the way I've set up Stock by Attributes, or the way I've set up ZenCart, or just operator [my] error??
Thanks!
Could you kindly tell me which files I need to update if I want to move from "Stock by Attributes" v4.7 to v4.7a(MULTIADD)?
If I can skip some would be great since I need to check and merge them all, thanks :)
I am currently running last Zen cart version 1.3.8.
My stock will work after upgrade or I need to go product by product to make changes?
Thanks
When someone places an order in my store, it appears that the Product total is reduced, but not the Stock by Attribute stock levels.Quote:
Originally Posted by skybluepunk
For example I had a product in three different colours, with only two items in stock (one green, one blue). When the blue item was sold, the Products with Attributes Stock page showed that I had a total of 1 item in stock (which was correct), but still showed 1 in green and 1 in blue.
When I clicked Sync Quantities, the Product total changed back to 2, whereas I would have expected the blue quantity to change to zero.
This seems to be opposite to the behaviour described in this post:
Could you please tell me how to get the Stock Levels adjusting correctly, as we are finding it impossible to keep track!Quote:
Originally Posted by kuroi
Thanks!
@skybluepunk
See posts #308 and#319
As I've added and deleted variants, I run into a major problem with the UI of this mod. For some items I have 30-50 attributes, different lengths and colors of a product. Every time I add a new attribute it seems as though it gets shoved randomly in this long list.
I want all of my attributes in order, preferably by the column with the heading "variant" so that all my lengths are lined up with each color appropriately.
Can somebody tell me how to do this? Here's a visual of the problem I have:
http://www.perfectlocks.com/temp/attrib.jpg
OK....so I'm getting somewhere but now I'm stumped (again...I know...shocker)..
So I THINK I've uploaded everything I need to upload...and I can set the number of attributes and everything. Wonderful...thank you kur :)
But.....now I've tried to implement the AJAX version and I'm running into a problem...it's not working. The dropdowns on the item page are the same as always...
I uploaded the ajax files and everything so is there somewhere that I'm missing something? Maybe there's a litte snippet of code in another file that I somehow missed?
I'm still banging my head :censored:
I've been trying to figure out where I'm missing something and the only thing I can come up with is that the ajax javascript files aren't being accessed...I currently have the folder in the main directory...is this the right place? Is there a way to find it if the pages are referencing it??
the 3 *.js files must be placed in the folder ShopRoot/ajax/*.jsQuote:
Originally Posted by laurenjj
the same way as the other files
OK.....well I had it in the right place...so I went back and checked one more thing...and I'm an idiot because the problem that I have started with the Dynamic Dropdowns for SBA mod. The problem had been noted before (a while ago) but I didn't see any update to it...this is where the initial problem was noted http://www.zen-cart.com/forum/showpo...&postcount=399 and I noticed that kuroi is the one who noticed this as well so perhaps there's been an update on how to fix this in the last year or so??
All help is greatly appreciated and sorry for being so naggy about the awesome mods that you guys contribute...:)
OMG I figured it out!! Well I'm sure someone else figured it out first but since I couldn't find it....
The problem was in the includes/database_tables.php where it says to add:
define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');
it's missing the DB_PREFIX in between...so it SHOULD be:
define('TABLE_PRODUCTS_STOCK', DB_PREFIX . 'products_with_attributes_stock');
Now I haven't really tested anything but at least I answered my own question...for now.... :)
:oops:I recently updated from from 4.7 to 4.7a, in order to stock by more than an attribute.
My t-shirts already have a Size attribute and I need to add a Type (mp3/mute) attribute to price by this.
But as soon as I insert the second attribute in my product, and I add quantities for all the combinations, the second attribute is empty.
Changing the attribute insertion order, it's always te second one EMPTY. So, I f I add the Size attribute dropdown as second attribute, the dropdown is empty.
Could anyone help me please?
It's important for me to solve this....
Thanks :wacko:
Sorry to ask this if it's already written somewhere in the forum...I am keeping on reading all the pages but I do not know if I will find the solution.Quote:
Originally Posted by m_and_s
Please, help me...
Installed this mod. All files seem to be in the appropriate place but I do not find a new option entitled "Products With Attributes Stock" under Admin -> Catalog
Any ideas as to what i did wrong?
:yes: Solved!Quote:
Originally Posted by m_and_s
For those who can have the same problem, the solution is the following:
Delete the following file (unless you have made other changes to it):
- includes/modules/YOUR_TEMPLATE/attributes.php
I think I skipped this step when I had installed the 4.7...
Hi Guys,
Can Someone Please have a look at tell me what is going on, I've asked this a few times over the past month or so and noone has directly responded to me, I didn't follow up as I was moving house and i wasn't rushing things, but I'm now in the new house, ahve my new workroom setup and really need to get the site going.
my test site is at http://www.sabrerose.com/testing
The only item with attributes is the category/product called testin.
I have chosen one category (size). As soon as I adjust the stock by attributes section however, the product displays with 2 of each category... I can't figure out what is going on.
PLEASE HELP lol
Nyssa.
figured out what i was doing wrong. I had renamed my admin folder therefore the admin files ended up in the wrong place. Just an FYI in case someone else runs into the same problem.Quote:
Originally Posted by flowerchild5
I am still running 1.3.7 because I am always terrified of an upgrade. If I install this mod will it work with my version seeing how it is up to speed with 1.3.8?
Thanks,
Marc
[FONT=Verdana]I just installed the new Stock by Attribute on a new site and it is working but the "Products with Attributes Stock" admin is missing its tables and says "Suchen" where is suppose to say "Search" but I swear I did not install the german SQL patch. Please see attachment screenshot,
I hope someone can tell me what to do![/FONT]
This was 4.7.ajaxQuote:
Originally Posted by buzzville
I uploaded an old admin folder and includes folder I had from 4-7MULTIADD and it fixed it, maybe there are some bugs in the ajax version
Is there a way to allow you to edit more than one colour product attribute at a time.
So for example:
I edit a t-shirt which I have in S M L and XL
I click edit and can update all quantity in one page.
I have been looking for something like this for some time but could not find anything, perhaps we can find others who want this and all put in something to have someone create it for us $$, or just both you and I could pay some one to make it.Quote:
Originally Posted by Best Price Accessori
Hi Robbyn7,Quote:
Originally Posted by Robbyn7
Were you able to resolve the problem you identified? If so, how did you resolve the problem? I'm having the same problem with the mod not reducing the inventory count when an order is placed. It reduces the total inventory count but the attribute inventory remains constant and has to be manually reduced. Everything else is working fine. I have reinstalled the mod several times with no success. I am using the latest Zen Cart with version 4.7 Products with Attribute mod.
I wouldn't recommend this. Because of its insertions into the core code, this mod is quite sensitive to the version of Zen Cart to which it is added.Quote:
Originally Posted by tat2nu
Instead, I'd recommend popping back and grabbing a copy of version 4.6, which is compatible with Zen Cart 1.3.7
Posts #308 and#319 explain the two most common causes of this problem. Renamed admins can also be a problem if you don't also rename the admin folders in the mod before doing the installation.Quote:
Originally Posted by stevenk
@vandiermen & best price accessori
Building custom loading pages for specific situations isn't too difficult for somebody with programming skills and an understanding of the underlying attribute structure. If you don't have these yourself, then you could try the Commercial Help Wanted section of the forum.
Coming up with a generic approach that would fit all situations is immensely more difficult. I've seen sites using this mod that have as many as ten attributes for some products. Entering the stock for them is a nightmare, but I haven't personally been able to come up with a practical way of representing a 10-dimensional matrix on a 2-dimensional screen other than by reducing it to a linear list.
The multiadd and ajax versions of this mod attempt to alleviate the problem, but I haven't developed any sites recently that needed this functionality, so don't know how successful they are.
I dont understand what you mean by "multiadd and ajax versions of this mod attempt to alleviate the problem" & "haven't developed any sites recently that needed this functionality"Quote:
Originally Posted by kuroi
[FONT=Verdana]Re: adding multiple stock quantities at once [/FONT]
[FONT=Verdana]Me and Daniel are looking for people to contribute to this mod as it is expensive for us to get the mod made[/FONT]
anything will help if we go aheadQuote:
Originally Posted by Best Price Accessori
The problem is that it is difficult to add stock for products with more than one attribute as the number of possible combinations can be very big.Quote:
Originally Posted by vandiermen
The multiadd and ajax versions try to make it easier.
I don't know if they succeed because I haven't used them.
Quote:
Originally Posted by kuroi
I wish you well. The price you were quoted might just get you a custom loader for your site's specific attribute structure. However, if it's for a generic solution that would work for all contributors, then I fear that the developer has either found a revolutionary new solution, or failed to grasp to scale of the task. I wish you well, but advise caution. If you need an experienced pair of eyes to look over your spec or evaluate the quality of the response that you've received, feel free to PM me.Quote:
Originally Posted by vandiermen
Hi,
Im not sure if I am being blind or stupid or both.
I just reread the read me and it says allow multiple attribute combinations to be added at the same time.
How do I do that? I can only get one attribute at a time,
For example I would like:
Colour --> Red
Colour --> Green
Colour --> Pink
All added at the same page,
Thanks
I'm having an issue with this mod that I'm sure is just some oversight on my part.
I have added a quantity for all attributes on a particular product. (Haven't tried more than one product until I get it working for one)
Whenever I show one attribute as sold out, the user gets a notification in his shopping cart that any attribute of that product is sold out. (gets the red ***)
Thank you kurio! I went with 4.6. Easy as pie to install and now my customers will know when an item is on backorder.Quote:
Originally Posted by kuroi
I have one more issue I would like to resolve and that is to get a qty sales report that is broken down to my attributes so that I can manage my inventory better and hopefully avoid back orders all together. Do you have a suggestion for that one?
Thanks again,
Marc
I read that as well now. But I have no answer.Quote:
Originally Posted by Best Price Accessori
[FONT=Verdana]This was the answer from the mod creator. [/FONT]Quote:
Originally Posted by Best Price Accessori
[FONT=Verdana]1) in the field "Suchen" you can filter your products; you see only products with attributes[/FONT]
[FONT=Verdana]2) in the product line you see an entry called "Add Quantity For Product Variant", now you can add quantity & the combinations will be created[/FONT]
[FONT=Verdana]3) if you will change "Quantity in Stock", click at the value and an input-field opens; do it for all your values and do not forget to click the "store" button[/FONT]
[FONT=Verdana]I have not been able to get it to work yet. He provided a link to a test admin but it had protection or something that would not allow me to do a search for anything from the Suchen [FONT=Verdana]field. [/FONT]this totally did not work in my new test site it may or may not have worked if I could test it in his. if you want the link to his test admin PM me. I would love to get to the bottom of this but for now I am going to stop testing and maybe I think someone still needs to work on this mod. [/FONT]
I'm having a problem with the attribute stock count not reducing by the appropriate order number when an order is successfully completed. For example, if someone orders Attribute A, the count for the attribute variant should be one less than prior to the order. However, there is no change in the attribute variant (quantity in stock) count but the main inventory (quantity in all variants) reflects a reduction in inventory. Do I have to manually reduce the quantity in stock (attribute) when an order is placed? Isn't this done automatically? I'm using Zencart vs.1.38. with Products with Attributes 4.7 ajax. I have recheck and reinstalled the mod several times with the same result.
Setup in Admin:
Check Stock Level = True
Subtract Stock = True
Allow Checkout = False
SQL patch successful.
Hello,
I am using zencart 1.38a and upgraded from 4.7 to the ajax version.
The problem I am having is now "catalog", "products with attributes stock" is not displaying correcly, instead it shows as the screenshot below. It was fine before I upgrade to ajax.
Thanks in advance for your help.
Regards,
Tom
Poker Discount
http://www.shootinpool.com/temp/stockbyattribajax.jpg
I think this is the way it was made. I had a look at the admin demo (ajax) of the developer of the update and it also looked like this. This mod needs some work. If you use the 4.7 multiadd version and not the 4.7 ajax version you wont have this problem. multiadd version is just below the ajax version in the contributions.Quote:
Originally Posted by pokerdis
I have not tested it but you could try [FONT=Verdana]installing [/FONT]a different or older version of Stock by Attribute .Quote:
Originally Posted by stevenk
Maybe I am beating a dead horse by suggesting this but. I really need to have SKUs for attributes. Would it be possible to add another input field in the "Add/Edit Quantity For Product Variant" for skus? I know this is a great deal of work to edit each individual attribute but would be worth it for me in the end. It seems like an easy thing to do. I would think you would just create another column in the DB and then add some code to the products_with_attributes_stock.php Admin file, but this is a little beyond my ability at the moment.
I know that many others have tried to do this dynamically, such as adding the product id + attribute to create a new product + attribute id without success. I just thought this might be something that could work very easily.
Dead horse #1 Mod "NewWay to save Attributes Modelnumbers" uses the attributes controller and definitely does not work http://www.zen-cart.com/forum/showth...s+Modelnumbers
Another "dead horse" is Mod "Unique SKU for each attribute?" http://www.zen-cart.com/forum/showth...te+skus&page=3
So I've been trying to get this mod up and working and managed to get it up and working (for the most part...there's an odd issue-or maybe not so odd and I'm just an idiot-that I have to delete the includes/templates/custom/templates/tpl_modules_attributes.php file in order to deactivate the add-on which I have been having to do while figuring out the various issues. So.....I think I'm finally getting somewhere and then I run into a HUGE issue.... what happens when you have a TEXT input field???? For instance. I have a picture frame that comes in 2 colors )black and white. Then you can engrave a name on which ever one you select. You currently can't even attempt this because it appears this mod turns every option into a dropdown...including text input fields.
I'd even be ok to just NOT use this particular mod with those products but since I have to disable the file mentioned above, I can only have it one way or the other....Anyone have any ideas here where I could either make it so that only products that I add variants for make use of the add-on while leaving the other one's alone???
I've just installed 4.7ajax on my test site.
Having a problem with being able to check out with more items than are actually in stock.
For example, I have 6 sachets of Grape kool aid. This is set up as an attribute along with other flavours. It will let me checkout with 7 or more sachets of grape.
But, if I put in a number greater than the total number of kool aid sachets in stock altogether, it won't let me check out.
How do I change it so that it prevents check out based on individual stock attributes, rather than the total number of stock in all attributes?
(Hope that makes sense!) :blink:
Anyone? Please?!Quote:
Originally Posted by Jazzyp
I've uploaded (via Cpanel not FTP) all the SBA 4.7ajax files again and still same problem.
What else should I be looking at?
I would have to test it to know for sure, but I believe this is one of the shortcomings of this mod.. This really seems to be just how it works..Quote:
Originally Posted by Jazzyp
Really? That's a pretty big shortcoming for something that's supposed to control inventory!Quote:
Originally Posted by DivaVocals
Seems to be a problem that people are having specifically with AJAX version. I can confirm that the other two current versions don't have it, but haven't personally used the AJAX version.Quote:
Originally Posted by Jazzyp
I have sucessfully installed.
I tried on one product:
Colour - Black - 10
Colour - ACU - 10
Colour - CYB - 10
Total qty = 30
When i test sell one black. Total quantity becomes 29, BUT black attribute is still 10?
I clicked the snyc quantity and the total quantity became 30 again :P
Is this normal??
No. It means that it's not installed properly so that stock tracking is still taking place at product rather than product variant level. Double check your includes/classes/order.php file. Make sure you have the one that comes with the mod installed and there are no copies or backups in that folder.Quote:
Originally Posted by XxDrAg0nxX
Hmm I just double checked the downloaded files, there is no override for the includes/classes/order.php
However there is one in admin/orders.php
Not quite sure what you mean here. Zen Cart doesn't currently support over-riding of classes, so the file in the base distribution needs to be replaced by the one that comes with the version of the mod that you are using (you haven't actually said which that is).Quote:
Originally Posted by XxDrAg0nxX
Sorry I didnt realise there were different versions.Quote:
Originally Posted by kuroi
I am using the AJAX one.
I just double checked the uploaded AJAX one from the server, there is definately NO includes/classes/order.php
I downloaded the Multiadd version, there IS an includes/classes/order.php
I just copied just the order.php over, and it worked fine after that.
Am I the only one who is experiencing the missing file from the AJAX version? :(
I just downloaded it and took a look, and you are not alone. That rather key file does seem to be missing from the distribution. Other posts in this forum suggest that there are some other formatting wrinkles too. Wonder if there might be other files missing. Shame, because it's basically a good idea.Quote:
Originally Posted by XxDrAg0nxX
Umm... I think that is not the only file missing... lol...
I think i am gonna switch :P
It may be worthwhile installing one of the vanilla 4.7 first (definitely not missing files and without at least one bug in the multiadd version) and then installing the AJAX version (which is theoretically based on vanilla) over the top. That ordering might give you AJAX without gaps.Quote:
Originally Posted by XxDrAg0nxX
Quote:
Originally Posted by kuroi
Ok I think i will do just that :D
BTW I just tested something, if I were to sell black -2, and if I were to cancel the order, the total quantity is restocked +2, back to 30, but black attribute is still short of 2...
Is that normal?
I'm having the same problem. Can you please provide the link or tell me where to go to download the Mutiadd version. ThanksQuote:
Originally Posted by XxDrAg0nxX
Same place you got the AJAX version. Just scan down the list of releases. It's immediately below the AJAX one in the revision history.Quote:
Originally Posted by stevenk
I compared the files delivered by both SBA 4.7MULTIADD and 4.7ajax. From what I can tell the following files are missing from ajax:Quote:
Originally Posted by kuroi
admin\includes\stock_attributes.css
admin\includes\stylesheet.css
includes\classes\order.php
I've removed the ajax files and uploaded clean 4.7MULTIADD, but it is still letting me checkout with 7 attribute stock items when I only have 6 in stock.
So, now I'm going to remove SBA completely and start again with 4.7 vanilla. Wish me luck!
The absence of those files would completely explain both the bugs, i.e. layout and failure to manage stock at the attribute level, that have been observed in in the AJAX version.Quote:
Originally Posted by Jazzyp
No luck wished (shouldn't be necessary), just advice ...Quote:
Originally Posted by Jazzyp
- ensure that your old includes/classes/order.php file gets over-written by the new one (sometimes FTP tools don't over-write files that are already there)
- check that you have your stock settings configured both to check stock and to prevent checkout if its too low (Admin > Configuration > Stock Settings)
- don't leave any backups sitting around in your classes folder (sometimes FTP tools create these automatically)
Right, I've deleted all the SBA multiadd files and uploaded them again. I used winmerge to check the contents of each file against clean Zen files. The only thing I haven't done is touch the database.Quote:
Originally Posted by kuroi
And - it's still not working. Checkout works normally for stock items that don't use attributes, but any attribute items will checkout regardless of stock levels. The warning appears on the shopping cart page but it still lets you checkout.
Am I just going to have to live with it!?
Hi!
I may have the same issue as jazzyp, I downloaded the latest version 4.7AJAX and have set the stock to Subtract and Not Allow Checkout.
It doesn't allow Checkout but after I checkout and look the stock has not subtracted.
I also looked in the files included and couldn't find the required order.php, in fact no directory for classes just admin, ajax and includes (but no classes under includes).
Should I be able to download this version:
Author: mcinallym
Version: 4.7MULTIADD
Zen Cart™ Version: v1.3.8
and just install it etc?
If you are using the MultiAdd version, then the answer is yes.. It will warn the customer that the item is out of stock, but it will allow them to checkout..Quote:
Originally Posted by Jazzyp
I'm subscribed top this thread to keep up with updates on this add-on, and color me silly, but I finally today realized that the AJAX version being discussed of late was indeed a new versionof this add-on (I know.. pardon the blonde moment:laugh:) Sounds like the Ajax version is supposed to prevent checkout, but doesn't adjust stock levels correctly (bummer:().
I wasn't clear, but it sounds like merging the MultiAdd version with the Ajax version didn't work. Did I read that wrong??
I wonder if the author of the Ajax version is aware that his version doesn't work.. Hmmmm
I am having a problem with attribute/variant inventory being updated. It is still updating inventory on a products level versus the attribute level.
I am using vers. 4.7 vanilla I have....
1) verified all of the files uploaded correctly including the includes/classes/order.php
2) I have Configuration -> Stock ->
Check stock level true
Subtract stock true
Allow Checkout false
I am using "Fast and Easy Checkout" but apparently that mod does not conflict with this mod because limelites was able to get his inventory to update with the same mod installed.
I read where there was an "attribute stock exceeded" check is missing from "includes/modules/pages/checkout/header_php.php". This file is unique to the "Fast and Easy Checkout" contribution. I made these changes as was suggested and it does does give a warning that stock is low for the particular attribute that was added to the cart, but yet still does not decrement the attribute stock levels.
The only other mod that I can think of that would possibly interfere is the "product attributes grid" mod. There are plenty of people with that mod that are not having conflicts so I am thinking this is not the problem.
Any suggestions?
After a week now of trying to get the attribute inventory to update correctly I have found out the problem though I don't have a solution to it yet.
It is indeed the "attribute grid" mod that is causing the problem. With this particular mod it is required that you create another attribute for each product. I have the option size with the various sizes as values. In order for the attributes to layout in a grid. You must use another attribute. This I used quantity with no value.
Does anybody no of a work around to this? I will work on it tonight and hopefully come up with something, but I was hoping someone might have run into this problem already.
Is this what I am looking for (a hack to exclude readonly attributes) as Kuroi had suggested to another Zenner http://www.zen-cart.com/forum/showth...137#post482137
If so where would I put this code in the file admin/includes/classes/products_with_attributes_stock.php The post was way back in '07 not sure if it would work with 1.38 and this version of SBA
I was thinking I could only select only the attributes from the database that have an option value since my 2nd attribute does not have a value and is only present to create another axis for the attribute grid.
......couldn't figure this out
I then thought that I could filter the attributes to retrieve only attributes where its option value id was NOT 110 or option id was NOT 20 as these are unique to this particular attribute. I am just not seeing this code where the attributes are retrieved from the the products_attributes table.
Any ideas oh wise Zenners?
Yes, you read it right. I combined the files from both multiadd and ajax and it still didn't work.Quote:
Originally Posted by DivaVocals
Not sure if it is the attribute grid mod that's causing the problem, as I don't use that mod and I have the problem! :(Quote:
Originally Posted by flowerchild5
In my case it definitely was the product attribute grid mod. When I disable it attribute inventory works fine.Quote:
Originally Posted by Jazzyp
I'm studying how to interface the zen database with a sophisticated program managing the store of a dress factory. I've installed the stock_by_attributes_4-7ajax module, and I begun to consider the color and the size of a dress.
The table `products_with_attributes_stock` contains the fields
`stock_id`,
`products_id`,
`stock_attributes`,
`quantity`
and in my test I've the values
(1, 9, '2,7', 11),
(2, 9, '3,5', 12),
(3, 9, '4,5', 13),
(4, 9, '3,6', 14),
(5, 9, '3,8', 15),
(6, 9, '1,6', 16),
(7, 9, '4,8', 0);
The first row tell me that the dress with the product_id=9 has a attribute combination of '2,7', and there are 11 dresses in stock.
Again in my example I have
2 = Grey 7 = size 44
The problem is that the number 2 is not the attribute identificator, but the position in the drop-down menu of the colors. The same thing is for the number 7.
The possibility to update the table from another program seems to be really very complicated!!!
Ha someone dealed with this problem and can give me some suggestion?
Thanks - Giovanni
I installed the stock_by_attributes_v4_7 (zc 1.38).
But as soon as I edit a product, the product description gets deleted.
I also tried the ajax and multiadd. All give me the same problems.
Anyone know how this is possible?
Problem solved! Product attributes Grid has a new version now that does not conflict with Stock By AttributesQuote:
Originally Posted by flowerchild5
Does anybody know how to disable the checking of stock for one particular product? I need to create a special order product that users can configure unlimited attributes for, even attributes that I don't have in stock. In other words, customers should be able to order this product even if it's not in stock.
Does anybody know of an easy way to do this?
Make the number in stock some outrageously large number that the product will never be out of stock any time soon..Quote:
Originally Posted by swamyg1
I've installed also the dynamic_drop_downs_for_stock_by_attributes, and the situation is changed, so that now I can give some suggestions.
Consider a dress named 'Anais' with two or more ORDERED attribuTES, for example
first -> the size
second -> the color
and that we have values for that attributes created via admin.
To buid an external program for modifying the quantities we can:
1) From the TABLE `products_description` create an array
with all the products_id and `products_name` of the products.
With the products_id we'll make a foreach to examine all the
products (in english -> second field=1)
(9,1, 'Anais', '', '', 55),
products_id = 9
products_name = Anais
2) From TABLE `products_attributes` create an hash (**)
containing the values of `products_attributes_id`,
`options_id` and `options_values_id` related to the
current products_id.
(15, 9, 1, 15, ....
(14, 9, 1, 8, ....
(9, 9, 2, 32, ....
(10, 9, 2, 33, ....
(11, 9, 2, 34, ....
(12, 9, 2, 35, ....
(13, 9, 1, 3, ....
(16, 9, 1, 27, ....
`products_id`=9 , `options_id`=1, `options_values_id`=15
`products_id`=9 , `options_id`=1, `options_values_id`=8
`products_id`=9 , `options_id`=2, `options_values_id`=32
`products_id`=9 , `options_id`=2, `options_values_id`=33
`products_id`=9 , `options_id`=2, `options_values_id`=34
`products_id`=9 , `options_id`=2, `options_values_id`=35
`products_id`=9 , `options_id`=1, `options_values_id`=3
`products_id`=9 , `options_id`=1, `options_values_id`=27
3) From TABLE `products_with_attributes_stock` create an
hash containing for all the products_id the values of
`stock_attributes` e `quantity`.
(11, 9, '10,15', 14),
(10, 9, '9,16', 13),
(9, 9, '9,15', 12),
(8, 9, '11,14', 11),
(12, 9, '12,15', 15),
(13, 9, '10,13', 16),
(14, 9, '12,16', 0);
`products_id`=9, `stock_attributes`='10,15', `quantity`=14
`products_id`=9, `stock_attributes`='9,16' , `quantity`=13
`products_id`=9, `stock_attributes`='9,15' , `quantity`=12
`products_id`=9, `stock_attributes`='11,14', `quantity`=11
`products_id`=9, `stock_attributes`='12,15', `quantity`=15
`products_id`=9, `stock_attributes`='10,13', `quantity`=16
`products_id`=9, `stock_attributes`='12,16', `quantity`=0
4) For each element of the hash, by an 'explode'
separate the two numbers of the `stock_attributes`,
remembering that the first number is related to the
size (`products_options_id` = 1), the second to the color,
(`products_options_id` = 2) and so on.
'10,15' -> 10==Size 15==Color
5) With the first number point to the hash (**) ed estract
the value of `options_values_id`.
(10, 9, 2, 33, ....
`products_id`=9 , `options_id`=2, `options_values_id`=33
7) With the value of `options_values_id` estract from
TABLE `products_options_values` the descrition of the
size, (in english -> second field=1)
.....................
(32, 2, 'Taglia 40', 20),
(32, 1, 'Size 40', 20),
(33, 2, 'Taglia 42', 30),
(33, 1, 'Size 42', 30), <--------
(34, 2, 'Taglia 44', 40),
(34, 1, 'Size 44', 40),
.....................
8) Make tha same thing with the secon number obtaining the
description of the color.
(15, 9, 1, 15, ....
`products_id`=9 , `options_id`=1, `options_values_id`=15
.....................
(14, 2, 'Moro', 140),
(14, 1, 'Dark', 140),
(15, 2, 'Nero', 150),
(15, 1, 'Black', 150), <--------
(16, 2, 'Nero e bianco', 160),
(16, 1, 'Black and white', 160),
.....................
9) Now we have all the data to show the product on the screen
for modifying the value of 'quantity'.
10) Continue for all the element of the hash related
to the TABLE `products_with_attributes_stock` and then
continue with the next products_id of the foreach.
Giovanni
Exactly. If you're using the vanilla version of 4.7, don't set any stock for the attribute combinations and it will default to product level stock, then make that a very big number and it won't matter whether it checks stock or not.Quote:
Originally Posted by DivaVocals
The alternative is to start hacking the order class to exempt the specific product from stock checking, but I wouldn't recommend that.
Does anyone know if it's possible to run the Ollacart POS system with Stock by Attributes?
Ollacart POS looks like a great solution for keeping the ZC database updated with physical store sales, but our store relies heavily on Stock by Attributes.
It seems that Ollacart doesn't work at attribute level by default, but is it possible to make it work?
Or is there an alternative POS which works?
Hi guys,
I know this is cross posting (see http://www.zen-cart.com/forum/showpo...&postcount=713), but I didn't know how to contribute back to the PWA codebase. I think I found a bug with michael mcinally's ALL attributes addition.
Line 244 in products_with_attributes_stock.php
should beCode:$strAttributes = implode(",", $arrNew[$i]);
Otherwise the attribute ids don't appear in order when you do the ALL thingy. When not in order Zen Cart cant match the attribute combination and marks all variations of the product as out of stock.Code:sort($arrNew[$i]);
$strAttributes = implode(",", $arrNew[$i]);
I did this but it's still not working right. I set the stock to 10000 on the product level, the add to cart button displays fine but no attributes are displayed at all. Here's a linkQuote:
Originally Posted by kuroi
:laugh: WAY Off Topic.. But this is one of my client's favorite vendors..Quote:
Originally Posted by swamyg1
Vanilla Stock by attributes plays no part in displaying attributes. It only gets involved when a customer adds a product with stock attributes to their cart, and so can't cause them not to be displayed on the product page.Quote:
Originally Posted by swamyg1
Also, when I follow the link you gave, the page says that the product couldn't be found. This too is not something that stock by attributes could cause.
Nice site though. :yes:
Ahh I see. So I do have to stock lots and lots of quantities for each attribute for these products to ensure they never go out of stock. Not a big deal, I'll just go ahead and do that.Quote:
Originally Posted by kuroi
Thanks for the help, and positive comments on the site:smile:
This is now working, but since I have a large set of attributes for this product it seems like the query is taking a pretty big hit on performance. Takes quite a few seconds to load the product.Quote:
Originally Posted by kuroi
Is there any way to not check the attribute stock and allow the attributes to display and checkout for particular products.
Can anybody think of a better way to do this?
If you don't want the products to ever be treated as stock and can just put in (presumably) arbitrary large numbers to prevent that, why bother recording and checking stock at all? Unless I'm missing something, it sounds like a lot of grief with no real benefit.Quote:
Originally Posted by swamyg1
Unless you have made changes to it (e.g. to display attribute stock on the product page), stock by attributes doesn't get involved in the product page at all. So turning it off won't deal with any problems related to the slowness of that page. Normal Zen cart attributes can cause this if the number or complexity is high. I suspect that might be what you're experiencing.Quote:
Originally Posted by swamyg1
I am also having the problem of adding user-edited text attributes to a product that was addressed back on pg. 65. Does anyone know how to do this? I have the the attribute created, but it is not available...
I only want to do this for products within ONE of my categories (called "custom order") All the other product and attribute combinations need to have stock attributes enabled.Quote:
Originally Posted by kuroi
I have modified stock by attributes with the dynamic dropdown mod so only options that have stock are displayed in the dropdowns. We sometimes have many attributes that are not in stock (ie. we carry 8" to 36" lengths for a product in various colors, sometimes we are out of stock of various combinations.)
I hope this explains what I'm trying to do, I just want people to select from the many many attribute combinations for "custom order" products and CHECKOUT even if the items are not in stock for this particular "custom order" product.
I figured out how to do this, it requires creating a new product type. This involves modifying the db, duplicating a number of files in admin and catalog, along with calling the original tpl_modules_attributes instead of the modified version I am using for my other products... therefore no stock check!
If anybody needs to create a product type documentation is here:
https://www.zen-cart.com/tutorials/i...hp?article=114
Here's a good walk through for the not so savvy programmer type:
http://support.smallbusinesspages.or...acking-up.html
My situation might be different because I'm using stock by attributes with the dynamic dropdown mod. Hope it helps!
Hello,
I just installed "products_with_attributes_stock_4.7.ajax" and I have a problem :
When a customer order a product whith an attribute, the quantity of the product is -1, but the quantity of the attribute is NOT modify.
Ex : t-shrit red
Quantity : tshirt : 10
- red : 4
- blue : 6
After the purchase :
Quantity : tshirt : 9
- red : 4
- blue : 6
Could you help me please ?
Thanks,
Sorry, I just found my answer ... :
------
Sorry I didnt realise there were different versions.
I am using the AJAX one.
I just double checked the uploaded AJAX one from the server, there is definately NO includes/classes/order.php
I downloaded the Multiadd version, there IS an includes/classes/order.php
I just copied just the order.php over, and it worked fine after that.
----
I have this module and Dynamic Drop Downs installed. The products by Attribute page is not displaying and my host tells me i'm receiving the following server error message:
[FONT="]PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 29624321 bytes) in /var/www/html/admin/products_with_attributes_stock.php on line 524[/FONT]
Any idea how i can increase the memory size?
Increasing the memory size isn't the answer. Most likely the code being executed is stuck in a loop and will overflow any memory given. So giving it more will just tie up the server for longer before terminating with an overflow.Quote:
Originally Posted by DVDTitan
This isn't a problem that I've seen before, so I'm guessing that you're using one of the newer versions of the the mod. Unfortunately you haven't said which one ... (hint)
I am using 4.7 version and 1.33 version of Dynamic Dropdowns.
As is ay it has been working fine but there are a lot of products and attributes on my site.
I'm having a cross browser problem... here are some screenshots of what I am experiencing....
In Firefox it looks fine as you can tell...
http://img194.imageshack.us/img194/4853/123zjy.jpg
And as you can see in Internet Explorer it's all screwed up...
http://img7.imageshack.us/img7/6526/234exw.jpg
Any ideas on how to fix this problem???
Simple solution is to use Firefox...
yes I know this... but my client doesn't want to use Firefox... why I don't know.. but.. I'm wondering if there is a fix for this cross browsing dilemma..Quote:
Originally Posted by tat2nu
I have installed the latest Stock by Attribute Zen Cart™ Version: v1.3.8
Version: 4.7ajax
I installed everything, but for some reason, when i go to the admin section, and go on "Catalog" the "Products with Attributes Stock" is nowhere to be found. I have no clue why, any help?
It should be under Admin-->catalog
Did you apply the database patch?
Also, you apparently need to grab a missing file from the previous version.
BTW: just what IS the ajax version supposed to do differently? Any one know?
With the Stock by Attrib mod installed, Google button allows checkout if not enough stock based on attrib. Here is small patch to fix for Google Checkout:
In googlecheckout/gcheckout.php find:
Replace this code with:Code:// Stock Check
if (STOCK_CHECK == 'true') {
if (zen_check_stock($products[$i]['id'], $products[$i]['quantity'])) {
$flagAnyOutOfStock = true;
}
}
Now "out of stock" in cart because of SBA shortage will show gray-out Google button and proper "out of stock" reason message.Code:// Stock Check - kiddos hack
if (STOCK_CHECK == 'true') {
unset($attributes);
if(is_array($products[$i]['attributes'])){
$attributes = $products[$i]['attributes'];
} else {
$attributes = '';
}
if (zen_check_stock($products[$i]['id'], $products[$i]['quantity'], $attributes)) {
$flagAnyOutOfStock = true;
}
}
Happy hacking.
Similar patch for making Pay Pal Express not allow checkout with not enough stock according to SBA.
Edit ipn_main_handler.php and find:
Just below that, add the following code:Code:require('includes/application_top.php');
This will not make the yellow button un-active, but will send the customer back to the shopping cart so they can change the cart contents so no out of stock items.Code:// Stock Check - kiddo hack
if ( (STOCK_CHECK == 'true') && (STOCK_ALLOW_CHECKOUT != 'true') ) {
$products = $_SESSION['cart']->get_products();
for ($i=0, $n=sizeof($products); $i<$n; $i++) {
unset($attributes);
if(is_array($products[$i]['attributes'])){
$attributes = $products[$i]['attributes'];
} else {
$attributes = '';
}
if (zen_check_stock($products[$i]['id'], $products[$i]['quantity'],$attributes)) {
zen_redirect(zen_href_link(FILENAME_SHOPPING_CART));
break;
}
}
}
Happy hacking