Stocks by attributes

woodlandsprite:

Comment on the sql update included in the package.
The first line to create the table says:

CREATE TABLE zen_products_with_attributes_stock (

If your sql database automatically ammends with zen_ then you will wind up with a table called:
zen_zen_products_with_attributes_stock

I assume the module is looking for a table called:
zen_products_with_attributes_stock

so i have deleted the 1st table created and recreated a new one with only one zen_

Haven't gotten any further with the install yet though to confirm.

I have corrected this in the files, thanks!

Rich and papacek, check your email, it should be there. Please note that you will need to make the above edit as I sent it off to you before making this correction.

Anyone else looking for this mod before danielcor is able to submit it to the downloads please e-mail me at [email protected] I can't find a way to attach files using the PM feature of this forum. Anybody know if it is possible?

:thumbsup: to danielcor:cheers: :clap:
Audra

Hi i have one problem,
when I install contrib STOCK BY ATTRIBUTES on fresh install ZC 1.3.0.2 it run well, when I add Image Handler, stock by attribute not work...
Have you same problem?
Thanks

I am running both Stocks by attribute and Image handler. I was certain to compare all files before uploading as some file changes for various modules may be overwritten by others.

I do have a question.
I have started adding test products now to test both the stock by attribute as well as my payment functionality :)

The bad news is, I was wondering if this module should indicate stock quantity on the product page similar to how it works on 1.2.7

For example, I was expecting on this product:
http://spritelygoods.com/zencart1301/index.php?main_page=product_info&products_id=49:c1d2b05024b6023d50dcdf5a858e59c0

I have made one size out of stock, and one size has a qty of 2.

I was hoping to see in the dropdown box the quantity available in brackets or some other flag.

Otherwise, the customer goes all the way to check out and only then finds out that certain items are out of stock.

woodlandsprite:

I was hoping to see in the dropdown box the quantity available in brackets or some other flag.

Otherwise, the customer goes all the way to check out and only then finds out that certain items are out of stock.

oh gads. A close review of the module for v1.2.7 indicates that this trick I'm requesting is not a part of the regular build.

Not only that, but there are significant differences between v 1.3 and 1.2.7 that make it impossible for someone of my serious lack of PHP skills to figure out how to make it work :(

Anyone here a coder?

If you look here:
http://www.zen-cart.com/forum/showthread.php?t=25987&page=19
for a post by jettrue it explains how to make what I want work in a v1.2.7 zencart.
Unfortunately the main_template_vars.php file is significantly different and values are called completely differently in v1.3

-Stephanie

General Comment:
If you install this module, all products that you have attributes for will have to have their quantities set using this module.

Even those that only have 1 attribute (such as a downloadable product).

This was not obvious to me at first....

woodlandsprite:

oh gads. A close review of the module for v1.2.7 indicates that this trick I'm requesting is not a part of the regular build.

wahoo! I have it fixed. The trick is to go to the 1.2.7 thread and apply the appropriate changes to the following file:

includes/modules/your template/attributes.php

Audrah - you wouldn't happen to know if Danielcor managed to get the add qty back to work did you?

When I deleted my "test purchases" I clicked to have quantities added back, but they just add them to the total quantity - rather than back to the attribute stock.

Just wondering.

woodlandsprite:

Audrah - you wouldn't happen to know if Danielcor managed to get the add qty back to work did you?

When I deleted my "test purchases" I clicked to have quantities added back, but they just add them to the total quantity - rather than back to the attribute stock.

Just wondering.

I'm guessing not because my cart is acting the same way, and it has absolutely no other modifications to it other than this mod. I know he was asking around before he released this, so he must not have found the solution.
In the read me file by dafonz he made it sound as though it was an easy addition, but my PHP skills...oh wait, I don't have any PHP skills, lol.

Best,
Audra

Is the version for 1.3.0.x ready and could some one post a link to the download.

I could not see it in the down load section of this forum.

thanks

MG

woodlandsprite:

wahoo! I have it fixed. The trick is to go to the 1.2.7 thread and apply the appropriate changes to the following file:

includes/modules/your template/attributes.php

hi woodlandsprite,

can you point to us which fix, probably with the thread number from the 1.2.7 thread, if you don't mind?! :smile:

ehm, do I need to copy over the fix_cache_key.php file to my live server?! :dontgetit

i just installed this mod and i notice that when adding no-attributes-product to my cart, the system wont validate the no-attributes-product for having enough stock to fill the order and this happened after changing the quantity in my shopping cart and refresh it! :dontgetit someone plz help me because i already uploaded it to my live server...ahh,why i didn't check it carefully!:cry:

tajul_ashyqin:

ehm, do I need to copy over the fix_cache_key.php file to my live server?! :dontgetit
Yes, you need to add it to your live server.

tajul_ashyqin:

i just installed this mod and i notice that when adding no-attributes-product to my cart, the system wont validate the no-attributes-product for having enough stock to fill the order and this happened after changing the quantity in my shopping cart and refresh it! :dontgetit someone plz help me because i already uploaded it to my live server...ahh,why i didn't check it carefully!:cry:
oh dear. I noticed this too. Unfortunately I don't know what the fix might be.

Additional "bug"
While this mod does support multiple product attributes for stocking, it seems the attributes can't be dependant on another...
Or I can't figure out how to make it work.

For example, if you look at this gift certificate:
http://spritelygoods.com/zencart1301/index.php?main_page=product_info&cPath=29&products_id=40
the Processing Fee was supposed to be a radio button - but it does not appear as such.

I am in the midst of trying to stock another Gift Certificate (Printable) - I would like for the customers to be able to select what file type their printable certificate is available in, however it seems this mod will not allow me to do so. (neither radio button nor dropdown will appear properly)

tajul_ashyqin:

hi woodlandsprite,

can you point to us which fix, probably with the thread number from the 1.2.7 thread, if you don't mind?! :smile:

if you read up in the thread where I ask if anyone knows how to do the fix, I list the thread and the approximate page.

woodlandsprite:

Additional "bug"
While this mod does support multiple product attributes for stocking, it seems the attributes can't be dependant on another...
Or I can't figure out how to make it work.

nevermind - this appears to be a result of the quantity display module I installed.

woodlandsprite:

oh dear. I noticed this too. Unfortunately I don't know what the fix might be.

This is due to the fact that the original code for checking the stock is disabled in the cart.
You can either do a workaround by adding an attribute to all items in your store - or you can put some comments on top of your shopping cart that indicate if there is difficulty checking out it is due to items possibly being out of stock.

I do not know what would happen if you simply reinstate the commented out code.

woodlandsprite:

This is due to the fact that the original code for checking the stock is disabled in the cart.
You can either do a workaround by adding an attribute to all items in your store - or you can put some comments on top of your shopping cart that indicate if there is difficulty checking out it is due to items possibly being out of stock.

I do not know what would happen if you simply reinstate the commented out code.

hi woodland,

i just found the fix yesterday (our local time!), you need to alter this file header.php in includes\modules\pages\shopping_cart! find these code $attributeHiddenField = ""; (around line 73) and put back (just beneath it) the following code;

if (STOCK_CHECK == 'true') {
$flagStockCheck = zen_check_stock($products[$i]['id'], $products[$i]['quantity']);
if ($flagStockCheck == true) {
  $flagAnyOutOfStock = true;
}

}

that should do it! mine works nicely... :thumbsup:

thanks for posting that :)
I have actually done the work around (by adding a single attribute to the products that originally didnt have any)
Will keep this in mind for the future, though I think I might be upgrading the shop when the Zen Team puts out the next release with their stock by attribute! Though that task is much too large for me to contemplate just yet.

Where in M'sia are you? I have family in JB, KL & Melaka!