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

[kuroi]

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

[carilivia]

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!

[stog]

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

[carilivia]

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

[stalb33]

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.

[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-

[cpaulson]

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.
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.

[swamyg1]

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?

[swamyg1]

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?

[hugo13]

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/produ...k_4.7.ajax.zip