Stocks by attributes

[tajul_ashyqin]

i want to change these color, see attachments! any idea?

[shannda]

OK. The updated add-on is ready to move from alpha testing to beta testing. Here is a list of the amendments and additions:

1. Removed zen_ prefix from table creation SQL allowing it to be run by Admin > Tools > Install SQL Patches (bug fix)
2. Changed quantity field to float in products with attributes table allowing fractional stock quantities (bug fix)
3. admin/orders.php updated for compatibility with Zen Cart 1.3.5
4. admin/products_with_attributes_stock.php updated to pass a languages_id to functions get_products_attributes and get_attributes_name each time they are called (bug fix)
5. includes/functions/functions_lookups.php updated for compatibility with Zen Cart 1.3.5
6. products_with_attributes_catalog_dhtml.php file created so that catalog_dhtml.php no longer needs to be over-written (new feature)
7. Language file for Admin is now used, which together with earlier bug fix should allow full integration with carts whose Admin is not in English (new feature)
8. Re-enabled check stock and disable checkout feature for all products (bug fix)
9. Fixed "Out of Stock" indicators in Shopping Cart for products with attributes (bug fix)
10. Added "Stock Available" to shopping cart page for display when stock is low. This can be turned on and off via the Admin > Stock menu (new feature)
11. Low stock email now triggered by low stock on an attribute, even if overall stock for product remains above stock reorder level (new feature)

My fixes for languages issues, and the "out of stock" messages are different from those posted higher up in this thread and will not suffer from the knock-on problems that those solutions caused.

The robustness of the changes ranges from completely tested with high confidence, down to fairly certain that this will work but needs testing by somebody with more experience in this area. I'm therefore now turning it over to those who have kindly volunteered to beta test (who will be contacted privately), but would still be grateful for a beta tester volunteer who is running a shop with the Admin in a language other than English.

I would like to be a beta tester. Where do I sign up?

[pro_2k]

i want to change these color, see attachments! any idea?

in the file "admin/products_with_attributes_stock.php" around line 416

while(!$products->EOF)
{
    echo '<tr style="background: #ccc">'."\n";
    echo '<td>'.$products->fields['products_id'].'</td>'; 

change "background: #ccc" to your desired hex colour code

see the attachment for and example of how it looks


hope this helps!

[MikeyG]

kuroi

the fixes and additions sound great would love to get my hands on a copy.

Just one thing which has been bugging me on an earlier version is that I added gift wrapping as an attribute, which the customer can select with different papers, to all products but this then mean that all my products in the products with attributes stock table were wrong ie. the table has the field which is comma delimited and is looking for a combination of attributes id including the gift wrap id for each paper.

by the current process for the stock with attributes I manually have to add every line to every product. But I don't hold stock of a t-shirt wrapped in red paper I just hold a t-shirt.

Can you turn off an attribute like this from effecting the table and the stock with attributes process.

This would be a great fix. Has anyone else got a solution?

Thanks

MG

[Danielle]

kuroi

the fixes and additions sound great would love to get my hands on a copy.

Just one thing which has been bugging me on an earlier version is that I added gift wrapping as an attribute, which the customer can select with different papers, to all products but this then mean that all my products in the products with attributes stock table were wrong ie. the table has the field which is comma delimited and is looking for a combination of attributes id including the gift wrap id for each paper.

by the current process for the stock with attributes I manually have to add every line to every product. But I don't hold stock of a t-shirt wrapped in red paper I just hold a t-shirt.

Can you turn off an attribute like this from effecting the table and the stock with attributes process.

This would be a great fix. Has anyone else got a solution?

Thanks

MG

There is a fix for this somewhere in this thread: http://www.zen-cart.com/forum/showthread.php?t=25987. I'm not sure what page it's on though, but I think it's around half way through or maybe a bit further. I haven't tried it so I don't know how it works, but I'm planning to try and get it working on a 1.3.5 shop...

[kuroi]

Tajul: Thanks for drawing my attention to all this inline CSS. I've taken it all out of the 1.3.5 version.

pro_2K: No we have no idea when 1.4 will arrive, probably tomorrow since I've just finished the Stock by Attribute upgrade for 1.3.5.

shannda: Beta testing closed several days back, but not to worry, the release version should be available from the downloads section within the next 24 hours or so.

MikeyG: you don't say which version of Zen Cart you are using, but when I took a look at your problem to see whether there was a quick fix that I could put into the 1.3.5 version, I found that it wasn't necessary. Although text fields show up, it's not necessary to give them a value when creating a variant for stock purposes. So they take up space on the screen (a pain) but don't force you to proliferate variants. As I did nothing particular to make this so, I rather suspect that it was already present in the Danielcor version from which the latest one has been built.

All beta testers: I received a lot of feedback, in many cases the same question or comment arrived several times with the only change being the words used to express it. Rather than respond to every tester individually, I have constructed a Q&A type response to all the points raised and popped it in the Wiki. You can find it at the bottom of this page.

[tajul_ashyqin]

nice piece of job, kuroi!

[davale]

Great job indeed kuroi. Working my way through it right now.

Don't want to sound ungrateful but I still have something to wish for.

As stated in the Wiki:

Quote: - Could attributes for which there is no stock be suppressed from the product information page?
Another one that works best when each product has at most one attribute, but is much more complex when conbinations of product are involved. Let's hope that this is included in the official Zen Cart development.

+ Question: I have only one attribute; size. But there are over 20 options for size and that looks terrible on the product info especially when only 2 or three sizes are in stock.
Is it possible to publish some code that enables me to suppress options without stock and patch AwS for my specific needs with only one attribute?


Quote: - Could we have a quicker way of adding attributes?
I'd love one too. Bunyip's Improved Attributes Controller contributes. However, this is rather beyond the limited scope of Stock by Attributes.

+ Question: Adding 20 options to a couple of hundred products one by one is killing me. Bunyip, would you be willing to look at kuroi's code and see if it is possible to add the 'multiple select' from Improved Attributes Controller' to 'Attributes by Stock'? Your IAC-contrib is a real timesaver for me and it would be so great to have this incorporated into SbA too! Please, please, please.

[kuroi]

The upgrade to this add-on for 1.3.5 deals is now available for download from here.

As it deals with many of the issues mentioned above in this thread, I have created a new support thread specifically for the new version and suggest that we now leave this thread to those users still using danielcor's version for 1.3.0-1.3.02.

The new support thread may be found here.

[kuroi]

Is it possible to publish some code that enables me to suppress options without stock and patch AwS for my specific needs with only one attribute?

If you go this archive thread and seek out post #110 by Grayson, and her correction in #132, she proposes some code that may work for you. She's proposes code to show quantities for each attribute (though it will only work when there is at most one attribute per product), which could easily be adapted to supress display instead when the quantity is 0.