Stock by Attribute v4.0 addon for v1.3.5-1.3.9

tatebn:

how do I go about displaying QTY/In Stock status on the product info page per variant instead of per product?

Same q! I just installed on 2 sites, and have it working for an event at JonesCoffeeCompany.com. I'd like it to either change an attribute to (sold out) in the drop down, or make it disappear. This would make this mod a huge addon to zen cart(in my opinion). I know you said not to ask for extra features, but I'm willing to help with this if it's possible.

Thanks!

tatebn:

I have 2 questions. First off, is it possible to combine attributes, such as color and size, into one dropdown? Secondly how do I go about displaying QTY/In Stock status on the product info page per variant instead of per product?

Thanks,
BrandonI've lost count of how many times this question has been both asked and answered in this forum, and indeed this specific thread. This is part of the reason why the thread has gotten so long.

However <sighs> one last time, if you have more than one attribute, then there isn't an easy answer. There is a long and complex explanation as to why earlier in this thread. Though this will probably get easier in the future as we start AJAXing more and more.

If you have just one attribute then you're in luck, there is a solution. Just scroll back a few posts and you'll come across some pointers to it.

chuckienorton:

Same q!Same a!

kuroi:

Same a!

Sorry dude, I'm usually good about not double asking, but did a thread search and didn't see anything like that. Now I've searched for "Grayson" and found some good stuff.

kuroi:

Because f**k me, you've spent a lot of time on these forums, amassed an almost unfathomable number of posts.

I agree. Dude, you are AWESOME!

Thanks!

ps - I know zen is supposed to add this (per your very first post here), but wouldn't your life be easier (since you're already posting all the time) if you just updated the mod with some of the changes. Maybe I can help.

I don't believe that I actually said that first met. That would be just too immodest even for me!

chuckienorton:

wouldn't your life be easier (since you're already posting all the time) if you just updated the mod with some of the changes.LOL. It would be even easier if I just stopped supporting the mod. However you have a point, and if I'd known how long it would be before the mod was rendered redundant, then I probably would have integrated some of the specific requests that come up over and over again in this thread.

However, the logic that I applied when I originally started the thread is even stronger now than it was then; the mod is almost at the end of its life. And there are two impediments to my integrating this specific change to it: firstly, that I have never actually needed to use the Grayson solution, which is why I only ever point people towards it, and secondly that somebody else has made changes to this mod which means that the version generating most of the questions now differs from that which those of my clients using it have installed.

But this is open source, so if somebody else wishes to continue the development, I was but the last to date in a fairly long line of developers who carried this functionality forward, and they would be most welcome to take up the mantle.

I think I m ay have posted this question in the wrong thread before. Sorry!

I followed all the instructions, all the files seem to be in place. However when I access Admin > Product with Attributes Stock I just get the following unformatted text:

Product ID Product Name Product Model Quantity for all variants Add Quantity For Product Variant Sync Quantities

I'm at quite a loss about what's happening. I went through and deleted all the backup files I had left on the server (ie old_orders.php) but all that did was make the spacing between the headings slightly larger.

:( Please help me someone!

I tried installing the Stock by Attribute add-on and when I click on it in the admin area I get a blank screen that says "No input file specified."

I'm not very experienced with databases so I don't know if I did something wrong with the database table or if I screwed up when I copied the files over to the server.

If someone can help me I can give me my login info if you need it.

Thanks!!

Nevermind!! I overlooked one of the files to be moved over. Thanks!

Please help - I ran the SQL patch then moved my files over - I cannot find anywhere in the attributes where I add an amount per attribute. It all still looks the same as before.

Also - how do I remove the database (I can't find it) so I can re-install? If I need to re-install.

DeAnna
https://www.raspberryjamcloth.com/shop

raspberryjamcloth:

Please help - I ran the SQL patch then moved my files over - I cannot find anywhere in the attributes where I add an amount per attribute. It all still looks the same as before.

Also - how do I remove the database (I can't find it) so I can re-install? If I need to re-install.

DeAnna
https://www.raspberryjamcloth.com/shop

Never mind, I am so silly - found it!

Jenniferea:

I followed all the instructions, all the files seem to be in place. However when I access Admin > Product with Attributes Stock I just get the following unformatted text:

I'm at quite a loss about what's happening. I went through and deleted all the backup files I had left on the server (ie old_orders.php) but all that did was make the spacing between the headings slightly larger.Sounds like you're missing the stock_attributes.css file from admin/includes

Hello!!

Thank you for the fantastic add-on! I installed it on a website running on version 1.3.8a and it works perfectly!

My question is.....is there anyway to have the products put in order by Product Model number instead of Product name?

Thanks for any help you can give!

hi carilivia

You can change the sort order by edit file
products_with_attributes_stock.php in your admin folder

Please make backup up of this file first before you try to change.

First find the following code that create the sql query as below

// Show a list of the products
$query = 'select distinct
attrib.products_id, description.products_name, products.products_quantity, products.products_model
FROM
'.TABLE_PRODUCTS_ATTRIBUTES.' attrib, '.TABLE_PRODUCTS_DESCRIPTION.' description, '.TABLE_PRODUCTS.' products
WHERE
attrib.products_id = description.products_id and
attrib.products_id = products.products_id and description.language_id='.$language_id.' order by description.products_name ';

$products = $db->Execute($query);

once found change the line

attrib.products_id = products.products_id and description.language_id='.$language_id.' order by description.products_name ';

to

	attrib.products_id = products.products_id and description.language_id='.$language_id.' order by products.products_model ';

to have it sort by product model.

You could also pleace it with

attrib.products_id = products.products_id and description.language_id='.$language_id.' order by products.products_id desc ';

this will sort by product id in descending order so it will show newest product added first which is usually the one you want to edit.

Hope this helps

This worked PERFECTLY!!!! Thanks a million Stog!
=0)

I have the initial page in the admin working.

Once I click "Define Variant" i receive this error notice:

1146 Table 'dirtsq5_zc1.products_attributes' doesn't exist
in:
[SELECT pot.products_options_types_name AS name FROM products_attributes pa INNER JOIN (products_options po INNER JOIN products_options_types pot ON po.products_options_type = pot.products_options_types_id) ON pa.options_id = po.products_options_id WHERE pa.products_attributes_id = 195]
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.

I don't understand what to do. Speak slowly when answering I am new with tables, db's, sql, etc.

Hello buddies,

Any way to have the variants sorted on the products_with_attributes_stock.php page in the same order as the attributes in the dropdown menu? For example, on the product page, the T-shirt sizes are ordered from small to x-large. There seems to be complete randomness in the display order on the PWAS page. There's the large variant listed before the small. Medium listed after the large. It looks correct in the dropdown box to the customers but what about the poor sap (me) who has to toil away, entering quantities for hundreds upon hundreds of variants? Alas, my labor is for naught, for my hard work is rife with mistakes because the variants are all unorganized. It's total and complete utter chaos. First, it's just a variant sort, then it escalates. White becomes black. Dark becomes light. What we have is everything we hold sacred in ruins at our feet. Please, help me. We must have order.

Thanks!

G-

I have spent much of yesterday and today trying to find the particular problem in the archived messages and can't find the exact problem addressed.
i am using zen 1/3/7 and I've installed Stock by Attributes v.4.7. I have attributes for color for some of my products. I am testing with one product until I work this out. The product has 3 color choices, clear, pink, purple. In stock are 2 pink,2 clear and 1 purple.
In the attributes controller, I had the flag set to "for display purposes only" as directed in the tutorial.When I select color and quantity and click "add to cart" I get this error message in a yellow box on the product page.

Please correct the following:
On the Option for: color You picked an Invalid Selection: Pink

So, I want back to the attributes controller and selected NO on the flag for display only. I did the same and, on got no error on the product page, but on cart page was this message:
Please update your order ...
Product Name: Jelly Sandals for American Girl ... Quantity Units errors -
You ordered a total of: 1 Units: 5

I updated the cart, but the message remains.

I know I must be doing some little thing wrong, but I can't figure it out and can't find it in the archives. I have searched several different ways, but I'm at a loss. I have many more shoes to list, but don't want to do it until I can set the color options.

I hope someone can help.

Also, one more request, please. I can't seem to find any link to start a new thread. all I can do is reply to threads already in progress and they don't always fit my situation. :frusty:
If anyone can tell me how to get the "post new thread" link, I would be so grateful. I have seen it in the past, but can't get it now.

stog:

First off I must thank for a great mod as this has been most useful for me on my own website.
I have just finished writing stand alone add on to this mod to do bulk update of stock value and will be submitting it soon.
When I was writing is I created a search and sort function in it.
As I was putting more stock on recently I was having to scroll right down to bottom of screen to add more attribute when I thought I might try to add the search and sort function I had just written to file products_with_attributes_stock.php.

I have now done this and seam to be working OK.

My question is where best to submit it as it only a small update would it be best to as full upload or on forum section

Regards

Steve

Hi Stog,

I'm wondering if you ever got an answer to your question... a bulk update of products would be AWESOME. I'm finding it very tedious editing the quantity for a product, then reverting back to the main listing... just to do it over and over again. I lose my place every time. Where can we find this awesome addition?

I'm also wondering if there is any way to get a listing page with all products and quantity on one single page, regardless of whether they have attributes. Right now you have to go back and forth when looking at products with and without attributes... there is no central location for updating stock... unless I am mistaken. Am I?

gregoryhenry:

Hello buddies,

Any way to have the variants sorted on the products_with_attributes_stock.php page in the same order as the attributes in the dropdown menu? For example, on the product page, the T-shirt sizes are ordered from small to x-large. There seems to be complete randomness in the display order on the PWAS page. There's the large variant listed before the small. Medium listed after the large. It looks correct in the dropdown box to the customers but what about the poor sap (me) who has to toil away, entering quantities for hundreds upon hundreds of variants? Alas, my labor is for naught, for my hard work is rife with mistakes because the variants are all unorganized. It's total and complete utter chaos. First, it's just a variant sort, then it escalates. White becomes black. Dark becomes light. What we have is everything we hold sacred in ruins at our feet. Please, help me. We must have order.

Thanks!

G-

I'm also wondering this... ordering the attributes by stock ID would be ideal. Especially when dealing with many many products. Is anybody able to provide insight into this?

swamyg1:

I'm also wondering if there is any way to get a listing page with all products and quantity on one single page, regardless of whether they have attributes. Right now you have to go back and forth when looking at products with and without attributes... there is no central location for updating stock... unless I am mistaken. Am I?

I made a while ago an addition

Amendments from 4.7 to 4.7ajax
added ajax functionality

* search filter: "%ma" filters all produchts with "ma" in products-name or in products-model; the search value will be stored in a cookie
* a click at the "quantity in stock" value adds an input-field & you can enter the new value; the store button saves all changed values
* added files in /ajax folder
* changed products_with_attributes_stock.php
* added products_with_attributes_stock_ajax.php

you can see it in action at :: http://demo.zen-cart.at/index.php?main_page=page&id=26

download the test version at :: http://demo.zen-cart.at/images/products_with_attributes_stock_4.7.ajax.zip