Stocks by attributes

Woops! I never even gave the stock with attributes a second thought after its been working so smoothly with v1.3.02, stupidly i've started my upgrade to 1.3.5 already! well, might as werll bite the bullet and see if it works... if it does/not i'll keep you posted with my progress.

I was just comparing my files and came across the funcion_lookups one, and thats what sparked my thinking :)

I havent read through the previous posts yet, but im sure i'll have to :)

The existing package will fail with 1.3.5. At the least you will need to amend the functions_lookups.php file. I have amended other files too, though don't know if these changes are critical or "nice to have".

Kuroi:
Feel free to add me as a Beta tester - I've a fair bit of experience with a slightly modified version of the stocks by attribute on 1.3.0.2

Unfortunately I'm not yet sure when I'll be doing my upgrade as I'm waiting to see how many of my other modules are being updated.

Thanks for taking pity on those like me, who can't code my way out of a paper bag :P

I'd like to be a beta tester as well. Thanks!

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.

Hey Kuroi, nice going! I've been comparing the mod files to 1.3.5, but I guess I'll spend my time more productively now!
I'm sure danielcor would be more than pleased to hear that someone is running w/ this.
It sounds like you have found some beta testers already, but I would be happy to help if you need additional feedback. Unfortunately, I run an English only shop, so cannot help on that front.

Another appreciative Zen user, who cannot survive without this mod:yes:
Audra

Running a Swedish shop, hook me up..

Is there an accepted procedure to becoming a beta tester or is it just hands up in the air?

Hands up in the air is working fine for the moment. You have a PM (personal message) with more details (as hopefully does everybody else who has vounteered up to this point).

can these updated mod restock the quantity of the attributes stock upon cancellation of order?!

tajul_ashyqin:

can these updated mod restock the quantity of the attributes stock upon cancellation of order?!I haven't done anything explicit to create it and so unless one of my fixes has enabled code already intended to do this (I know that Danielcor tried) to work properly, it is not included.

However, as you are now a beta tester with a better idea than me what you are looking for ... I look forward with anticipation to hearing your answer to the question!

I've downloaded and installed this module.

It appears to me that it will not allow me to keep track of attribute stock separately from real stock.

EG, I've got products where I combine two things to make a single product.

So I can order a small, medium, or large bracelet with design X, Y, or Z

My stock consists of:
12 large bracelets
12 medium bracelets
12 small bracelets

And separately of:
8 design X's
9 design Y's
3 design Z's

When someone orders a small bracelet with design Y, I should decrement the stock for small bracelets and for design Y.

It doesn't appear that this add on will allow me to manage stock as such, correct? Rather, it would only work if I had a fixed number of

12 large design X
14 large design Y
7 large design Z
3 medium design X
11 medium design Y
6 medium design Z
3 small design X
5 small design Y
1 small design Z

Correct?

Does anyone know of a module that handles the situation I am presenting? Would it be simpler to customize this module or start from scratch? It seems to me that starting from scratch would be easier, but I don't know the inner workings of this module...

Thanks very much!

If I understand correctly the situation that you have described, your products have two components: a bracelet and a design. These are separate until a customer makes an order when you combine a bracelet with a design to create the product ordered. The resulting product will have attributes of size and design, but what you quite logically want to track is your stock of raw components. Stock by Attributes is not designed to do this. Nor to my knowledge is there any other add-on that is.

On my previous version of the shop (1.2.7) in combination with attribute stocks I was able to add a little text behind the actual attributes in the product info page.

Example
Size:
Small [In stock]
Medium [Available att supplier] (<- Not as much text in swedish :P)

This was done by editing/adding the following code to: includes/modules/pages/product_info/main_template_vars_attributes.php

if  ($products_options->fields['quantity'] > 0) {
          $products_options_array[] = array('id' => $products_options->fields['products_options_values_id'],
                                           'text' => $products_options->fields['products_options_values_name'] .' [ '. TEXT_ATTRIBUTES_IN_STOCK . ' ]');
		} else {
		  $products_options_array[] = array('id' => $products_options->fields['products_options_values_id'],
											'text' => $products_options->fields['products_options_values_name'] .' [ '. TEXT_ATTRIBUTES_NOT_IN_STOCK . ' ]');
			}

This was something that I found very useful as customers knew what to expect when it comes to delivery time even before adding the product to the cart.

Anyone who has implemented something like this to stockAttribute3.01?

Svanis:

Example
Size:
Small [In stock]
Medium [Available att supplier] (<- Not as much text in swedish :P)

That was a very good idea to maybe have as an option from Admin. I hope it will be implemented also...

/Typhoon

Note:
By adding the above mentioned code in [b]includes/modules/attributes.php[/]
makes the "Not in stock- message" appear.. This is on all attributes though.. :|

I'm looking at it right now :smartass:. It's certainly a candidate. It may not need an admin switch as you could turn it off by setting the text to NULL. I'm also considering three levels equivalent to "in stock", "low stock" and "out of stock".

Downsides - I can see how it would work if there were just one attribute, but how would it work if there were two or more. I'd be interested to hear what you stock experts think :unsure:.

kuroi:

I can see how it would work if there were just one attribute, but how would it work if there were two or more.
I'm pretty sure that it would be in need of either ajaxification or javascript for it to update and match the different attributes.
I think that this has been discussed before. Since I'm not that much of a coder myself I don't know how to do it but similar has been done in the admin part of the site.. I think it's called Improved attributes controller..

Hey,

I'm starting up a new shop with newest ZC version 1.3.5 and I would love to use and beta-test this Stocks By attributes newest beta! :)

I've already downloaded the one from the Downloads but since reading here so much warning it is better to start being a beta tester. Great!

Elli

kuroi:

Hands up in the air is working fine for the moment. You have a PM (personal message) with more details (as hopefully does everybody else who has vounteered up to this point).

I'd like to be a beta tester too :D