Stocks by attributes

Here's another candidate for the beta-force!

I've tested the code with php 5 and there are some '<?' php tags in the main php file that needs to be changed to '<?php'.

Is this module available for beta testing yet? I would like to work with it as well. I am trying to start with my first zen cart store which requires this module.

I'm hoping to be able to start with version 1.3.5 from the beginning, but I absolutely need the stock by attribute for this store.

Thanx,
Steven

:wacko:

Will the new (beta) version enable customers to search attributes?

art03: as you're not in the beta testing the current version (to my knowledge), I assume that you are referring to the current version. However, this has been fixed for the 1.3.5 version due for release shortly.

davale: No. I'm afraid that the new version will no provide additional functionality to allow customers to search attributes

**beta testers: **please remember to send feedback via [email protected] rather than by PM as my mailbox is getting overwhelmed at the moment and I'd hate to see your carefully constructed feeback lost because it can't get delivered. If you have feedback and haven't yet sent it, please do so ASAP.
**
prospective beta testers: **WOW. There are a lot of you. This is clearly going to be a much used add-on. As managing requests to beta test is now taking more of my time than actually preparing this add-on for formal release and more importantly (for me at least) blocking my mailbox for people with whom I am discussing paid work, I am closing beta testing to new participants. However, I will make exceptions for people actually running multi-lingual or non-English stores who promise faithfully to give me feedback. For everybody else, a little patience please, the finished add-on should be along shortly.

Well after upgrading my old zen to the latest new one, i thought that everything was in order... until my brother asked me how he could change the "attributes with stock" so Loh and Behold, it wasn't there! The way our stock works at the moment is different to most;

ive written a php program to retrieve xml product information from our suppliers server, which then updates our stock counts, whether they have attributes or not... Though our products will need attribute stock levels soon because we're going to start buying products and holding real stock!

I tried the function rewrites as with the old version of the attributes with stock contribution, but it failed miserably, as stock levels did not reduce when products were purchased.
I wish you the best of luck with writing this, its quite a shame really that the zencart developers didnt write this functionality into the core of their fantastic program.

Will be following this thread eagerly for progress :-) :-)

I have read through every page and am still not sure how to upload the files for the attributes by stock module. In phpmyadmin i accessed the database and found a table called zen_products_with_attributes_stock but am not sure what to do with it. All the settings for each component are correct ie stock_id but when i click on import, im not sure which files I am supposed to upload so i have tried the complete zip which obviously has not worked. Any ideas please?

pro_2k:

...its quite a shame really that the zencart developers didnt write this functionality into the core of their fantastic program.

This will actually be part of the core code in an upcoming version, I believe it will be in 1.4 :clap:

fashionistawear:

I have read through every page and am still not sure how to upload the files for the attributes by stock module. In phpmyadmin i accessed the database and found a table called zen_products_with_attributes_stock but am not sure what to do with it. All the settings for each component are correct ie stock_id but when i click on import, im not sure which files I am supposed to upload so i have tried the complete zip which obviously has not worked. Any ideas please?

You have to upload the files in the zip file to your website, usually via FTP, making sure to upload them to the correct folders for your template. The readme.txt file that is part of the zip file should help with that. The sql file is the one you upload to the database, you can do this by going into your zen admin, clicking Tools-Install SQL Patches, and then uploading the sql file from your computer.

Danielle:

This will actually be part of the core code in an upcoming version, I believe it will be in 1.4 :clap:

woooohoooo!! I'm sure I read that somewhere a long long time ago, back in the days of version 1.2.x!! :book: Does anyone have any idea on the "timescale" (dare I say? :lamo: ) of zencart 1.4?

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

kuroi:

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?

tajul_ashyqin:

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 :smartass:

see the attachment for and example of how it looks :wink2:
Attachment #656

hope this helps!

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

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

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

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

nice piece of job, kuroi! :yes:

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.

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.

davale:

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.