Stocks by attributes

Hey ppl,
I'm going nucking futs trying to get this clothing store up and running. Obviously as it's clothing there are a lot of variants. I think my problem is user-error judging from this thread, but I have no idea where I messed up. :frusty:

I have zen-cart-v138a vanilla install and stock_by_attributes_4-7MULTIADD. Firstly there seems to be discrepencies between the instructions and the delivered files:

Rename "includes/modules/YOUR_TEMPLATE" where in my unzipped download I only had includes/modules/pages.

I bring this up as it was confusing and perhaps is part of my trouble. To install I dropped the "pages" folder into "includes/modules/MY_TEMPLATE".

Admin panels are there and I can alter the stock count. The problem I am facing is in the shopping cart. It's effectively not working. eg

Red = 1 in stock
Blue = 2 in stock

It gives me the "out of stock" protocol if I ask for 4 of either but doesn't seem to register the attribute stock that I have indicated in the "Products with attributes stock" admin page - I can proceed to order 2 or 3 Reds.

I have a feeling i might have to bastardise categories into sizes and colours to get this to my client - going to be messy :(

Thanks in advance for any help. No url atm as I'm just trying to solve my problems in an xampp install.

Ok for starters putting "page" into includes/modules/MY_TEMPLATE is a bad idea - I overwrote the core files in "pages" with the ones from the plug-in and now the backend attributes/stock table has background colour. Unfortunately hasn't solved the ordering issues :censored:

So maybe that part of the instructions is an artefact from a previous version? http://www.nectarina.co.uk/readme.html

I'm going to try copying all the files again... Be soooooooooo good if just the one plug-in would work for me.

Ok I tried installing a test site on the actual server and installed this plug-in and now it seems to work - guess I missed something on the local install.

There is still one issue though and I'm not sure if this is just the way it is or if there is some option I need to tweak: although the customer is notified that the particular item (with an attribute) is out of stock they are still able to proceed with the checkout. I do get "Please change the quantity of products marked with (***). Thank you" instead of the back order notice.

I have changed (in Configure/Stock) "Show Sold Out Image in place of Add to Cart" to on and "Allow Checkout" to false but seems that the checkout button is still there. I have tested this on a test product without any attributes and seems the same :( Is this just an issue with Zen Cart itself?

Seems it just wants a person to login then the "go to checkout" botton doesn't lead anywhere. Doesn't seem to show how much stock is available for a product in the shopping cart though - particularly annoying for customers who then have to incrementally guess how much is there. I thought I saw something about this somewhere in the forums... might see if i can find it

I tried searching through this thread and didn't see this issue, but I admit that I didn't take the time to read all 50 pages.

I have a clothing store that has items with size, and an optional monogram text box.

When I try to add a variant I am presented with 2 dropdown boxes as expected. I choose the size I want and choose ALL for my monogram attribute. Since the only option under monogram is TEXT the item appears out of stock unless someone puts text in the box.

I was thinking of the idea of adding some text in the box by default, like "none", but the monogram attribute adds an additional $10 to the cost of the item. I really need to be able to set stock independent of the monogram attribute. Is there a way to ignore a certain attribute, or in my case I would like to be able to ignore all text attributes in the stock.

Can anyone help me?

I think I've got it!

I set up attributes, then linked them to the product, making all the appropriate ones required, and when I tried to click to purchase without filling in the required info, it gave me a big ol' error message.

Now I just have to go read all the help files on extracting customers' attribute responses from the back end.

Thank you all for advice and allowing me to bounce my lack of ideas until something came through.

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

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

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

/*
		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 https://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.

posted in error

Ok, I haven't made much progress but I do recognize specifically whats going wrong.

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 it is only a portion of the product ordered, specifically if two items are ordered in two different attributes but only one is in stock, the message will 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. 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.

I think this topic has been discussed before, but i never found a resolution for it. Is there any way to make this Stocks by attributes mod use only some attributes but not others? or better yet, link some attributes to other products in the DB all together?

Thank you

bencart:

I have now fixed this so that Product Attribute Grid and Stock by Attributes work when the attribute grid is setup to use single attributes.

The file admin/products_with_attributes_stock.php needs this modification:

Original Code:

        foreach($product_attributes as $option_name => $options)
        {
            echo '<p><strong>'.$option_name.': </strong>';
            echo zen_draw_pull_down_menu('attributes[]',$options).'</p>'."\n";
        }

> ```php
            foreach($product_attributes as $option_name => $options)
            {
                // if the option isn't the attribute grids dummy quantity attribute
                if($option_name != 'Quantity')
                {
                    echo '<p><strong>'.$option_name.': </strong>';
                    echo zen_draw_pull_down_menu('attributes[]',$options).'</p>'."\n";
                }

            }

Wow. I am sooooooo glad you posted your solution. I had the exact same problem and your fix worked, only the "echo '<p><strong>'.$option_name"... part was further under the foreach loop than I expected. After inserting your IF statement, the stock_attribute column stopped displaying the ",quantityID" and then stock started working correctly again.

The weird thing is I could have sworn the two modules (Attributes by stock and product grid) were working fine together. I have no idea what would have stopped them from working though, so I'll assume I just overlooked the issue in the beginning.