Stocks by attributes

oops, sorry about that post, I posted in the thread with the answer rather than the thread with my original question.

Quote:

---

Originally Posted by shoulders

i managed to get the sql to run from myphpadmin, if anyone else does this make sure you add your zen installation prefix in to the sql script first.

---

Shoulders, did you just add the prefix to the table with myphpAdmin? Can you send me any advice on this?

Thanks

I've found that the stock doesn't dynamically update (with dynamic stock updates) when I run into this problem trying to add multiple stocks at once-

ex. add 'all' colors in size 38 with a qt of 6-

here's the warning I get

Code:

---

att: 28|27|29,30,84

Warning: Cannot modify header information - headers already sent by (output started at /home/jalansty/public_html/shop/admin/products_with_attributes_stock.php:193) in /home/jalansty/public_html/shop/admin/includes/functions/general.php on line 21

---

Can somebody help me with this?

Thanks.

I found this in the products_with_attributes_stock.php

Code:

---

/*
                michael mcinally <[email protected]>
                heavily modified version to allow inserting "ALL" attributes at once
                also should probably run this SQL command as well:

                ALTER TABLE `products_with_attributes_stock` ADD UNIQUE `products_id_stock_attributes` (`products_id`, `stock_attributes`);
                */

---

Do you have to run the alter table to get the 'all' attributes to work correctly?

If so, do I run this command in the admin SQL Query Executor? (in Tools > Install SQL Patches)

Thanks!

Hello,

It appears i've installed Stock by Attributes 4.7a just fine because it's showing up in my configuration and I can change quantities etc. The problem is, is that it's allowing me to add larger amounts to the cart than what I have listed in inventory.

After hitting checkout at the cart page it also takes a long time to get to shipping and when it does it just shows up blank.

edit: I've fixed the problem where it takes a long time to get to the shipping page but it still shows up blank.

I'm using Cherry Zen also.

Any help would be greatly appreciated. I'm even willing to pay a small amount if somebody could go in and fix it.

Oh this is on www.hawaiianhardwear.com

Thanks,
Jason

I think I know what happend I didnt merge the shipping php files correctly. I just renamed the old one to include _OLD. Can anybody give me any advice on merging these properly so I can still use the Cherry Zen template?

Ok, so after some investigation it appears when I installed stock by attributes, I actually set the new install files to old. I fixed that. It's working better because now if you have over the set amount of an atribute in your cart it wont let you check out, when you hit checkout on the cart page it actually just loops you back to the cart page. If the amount is less that what is in inventory it will take you to the shipping page but it's still blank.

I tried merging the section to check for stock from the Stock by Attributes checkout_shipping header_php.php to the working one, so now it does get to a shpping options page but it's full of errors.

TEXT_CHOOSE_SHIPPING_DESTINATION

TITLE_NO_SHIPPING_AVAILABLE
TEXT_NO_SHIPPING_AVAILABLE
TABLE_HEADING_COMMENTS

(THEN THERE IS A TEXT BOX HERE)

TITLE_CONTINUE_CHECKOUT_PROCEDURE
TEXT_CONTINUE_CHECKOUT_PROCEDURE


The checkout button is still there but it just loops to the same page when clicked.

Also, is there a way for Stock by Attributes to stop a customer from even adding the product to the cart if they choose an amount that is not in inventory?

I fixed it.

I replaced some of the original files that were having problems, particularly the header_php.php from checkout_shipping. I guess I should have just completely removed the add-on instead of trying to patch it up here and there.

Sorry about all this but I have one last question.

The mod is allowing amounts more than what is in stock to be added to the cart, which is ok but when you try and checkout, the page just cycles and no message is presented. Can anybody direct me to what I need to edit to have it show a message, preferably one indicating how much stock is left in that attribute? I noticed on the wiki there were instructions on how to display this on the product page.