Stocks by attributes

Hi Kuroi!

First, let me thank you for this excellent addition to zen cart functionality!! :hug:

I have started to get deeper into using this mod and I have realised some of the limitations when you have so many attributes in one product and are trying to update the stock levels.

Perhaps my situtation is somewhat unique, I don't stock individual items with various attributes such as " this t-shirt with this screen print in small, medium, large sizes in green, red and blue". Instead, many items have various options such as "which length mounting screw would you like", "do you want gaskets with that drum lug", etc. Really, it's combining several individual products into one instead of having a lot of similar products that are individual, if you see what I mean.

My problem lies in when one of the attributes, one of these various combined products, is out of stock. I then have to go into SBA and change large amounts of variants.

My question is: Is there a way to make global changes? For instance, say I have a product with the attributes of plating (chrome, brass, gold, satin chrome, black chrome, etc.), screws (6 different types for different drum shells), and gaskets(yes or no), and the gasket is out of stock. I have to go in and make all of the variant changes for the different platings and screws with gasket "yes" and "no". That is a lot of variants. And we have over 2300 products and by the time I am done there will be over 7000(not all with attributes, but many will have them). I would like to be able to specify that attribute "gasket" is out of stock, and therefore any variant that cascades from that is out of stock, instead of having to manually enter every single variant.

Is this possible? I am in the equivalent of my second semester of PHP/MySQL/Javascript/DOM/etc. programming education so I am not yet at the skill level to make the changes or even to figure out if it's possible.

Basically, what I am asking is: Is there a way to select a heirarchy in zencart, and more specifically in SBA, that cascades down with stock levels? So if "chrome" plating is out of stock then all variants that include chrome plating would be out of stock instead of having to go through all of the variants? I know that there are many zen cart users that would benefit from this.

I am willing to pay for this ability, it is really crucial to me since we stock so many items from various vendors and it is becoming a nightmare to try to work through all of the variants since inventory levels can change so much.

It would be most helpful to be able to select which attribute is the "top level" attribute that cascades down to the other variants.

Is what I am saying making any sense? I am having some difficulty expressing what I am trying to say. If you need any further elaboration please let me know.

Thanks again, Kuroi. It's the folks like you that make zen cart even better than it already is, and my hat is off and I am bowing low to your skill level with making these awesome and powerful mods!:hug:

Matt

lankeeyankee:

Perhaps my situtation is somewhat unique, I don't stock individual items with various attributes such as " this t-shirt with this screen print in small, medium, large sizes in green, red and blue". Instead, many items have various options such as "which length mounting screw would you like", "do you want gaskets with that drum lug", etc. Really, it's combining several individual products into one instead of having a lot of similar products that are individual, if you see what I mean.Hi Matt

Glad you like the mod, but I'm afraid that it's not really the right one for your situation. Stock by Attributes is designed for products where the attributes are intrinsic to and indivisible from the products whose stock is being tracked. Yours aren't. A better mod for your store would be this one, which is designed for the situation that you describe.

Hi Kuroi,

Thanks so much!! I go through the downloads section on a regular basis and yet I somehow totally overlooked that mod! :blush::D

Matt

My question about attributes is a bit different - I use attributes typically when I have a product 'X' in Large Medium or Small variants.

What I want is to enter the stock of each variant (attribute) and then to have them treated as separate products for stock levels so that if, for example, I have 10 large, 2 medium and 0 small 'X's left:

the low stock report shows 2 large 'X' and 0 small 'X' left
'Small X' is disabled on the website as out of stock so customers can't order them

The only reason I use attributes is because if someone likes the look of 'X's I want to be able to market Xs as a range or product family, and for customers to see the whole range of Xs together with my description of them and to be able to choose a matching set of different sizes (or colours or whatever) without having to go back to the full catalogue each time, and to keep the search results a manageable length.

Any ideas welcome!

Guys,

have the mod installed and been working for quite a while with 1 problem that i have been working around manually.

We have some attributescombinations that arent stocked but customers are still allowed to buy them as we can order them in.

The problem with this is that it seems to cause any product purchased that has some attributes attached, to not reduce the stock as it should. This happens whether the attribute specified by the customer is in stock or not.

If a product without any attributes is purchased then it reduces stock correctly.

e.g.:
-a T-shirt with size attribute to be defined is bought, Small is selected which is in stock but the stock isnt reduced
-a T-shirt with size attribute to be defined is bought, Medium is selected which isnt in stock (stock is already 0). the stock is left untouched.
-a hat is purchased, not attributes are attached and the stock is reduced as required.

Any way to fix this so that the stock is reduced correctly for items that have attributes with stock? Obviously any items that have attributes attached which arent in stock should stay at 0.

Joe

richardeevans:

My question about attributes is a bit different - I use attributes typically when I have a product 'X' in Large Medium or Small variants.

What I want is to enter the stock of each variant (attribute) and then to have them treated as separate products for stock levelsWhat you're describing is what stock by attributes does. However, it's currently an add-on bolted onto the side of your Zen Cart and so your low stock report knows nothing about it and can only report on "true" products.

I have just updated my stock by attributes to the multi add version.

I am not a programmer and had been looking for something like this to save time so this is great.

I have one small requirement which I hope would improve it for every one and I am sure it would be simple to do but I am not a programmer

I use the word: "please select" as an 'attribute' as the default and I use the feature that this is for display purposes only. However when using this mod to add all varients it pulls in this attribute so I end up with a field/product in the stockby attriibutes list which is irrelevant - eg a product combo of "please select, please select" and then a product combo of: "please select, 0-6 months".

Can this be avoided. I am sure that if the flag for display purposes only is used in the sql statement it would be able to avoid this (on a t-shirt set with colour and size choices it gave me 25 irelevant combinations for example.)

I hope this is possible and would benefit others I am sorry I don't have the skills to do it my self and provide it for the community.

Thanks

MG

Need Help!

Just installed Stock by Attributes v4.7 on my ZCv1.3.8. Follow all the installation instructions in the readme file.

The problem is, in my Admin > Product with Attributes Stock nothing's appears accept this text,

Product ID Product Name Product Model Quantity for all variants Add Quantity For Product Variant Sync QuantitiesWhat's the problem?

Never mind, just added first attribute and there's the item with it's attributes.
But I think there's a something wrong with it's display. Stylesheet maybe? Will find out more about using this mod.

Ok, I've been using the older version of this mod (4.7 I believe) on my store (1.3.8) and it works fine. However, I just noticed an update to this mod (4.7a) that allows, quote:

"NOTE: This is a simple modification to version 4.7 that allow multiple attribute combinations to be added at the same time."

I installed this mod by overwriting all the files on my server. I also got rid of the file includes/modules/YOUR_TEMPLATE/attributes.php
as it says to do in the instructions when upgrading from previous versions.

However, I do not see how it works any differently than the previous one. How do I add multiple combinations at the same time? Right now I just go to` Catalog> Products With Stock Attributes, find my product, select the attribute and click "Edit Quantity". Then on the next page I modify the quantity and click submit. Where is the difference?

Hi,

i have installed all the files as per instructions (i hope), i then ran the script file (from 4.7 multiadd) to create the table, but i get the following error. the tables also do not seem to be created.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO configuration (configuration_title, configuration_key, configur' at line 7
in:
[CREATE TABLE zen_products_with_attributes_stock ( stock_id INT NOT NULL AUTO_INCREMENT , products_id INT NOT NULL , stock_attributes VARCHAR( 255 ) NOT NULL , quantity FLOAT NOT NULL , PRIMARY KEY ( stock_id ) ); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false', 'When customer places more items in cart than are available, show the available amount on the shopping cart page:', '9', '6', NULL, now(), NULL, "zen_cfg_select_option(array('true', 'false')," );]
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.

any help would be appreciated.

thanks

shoulders

I just installed 4.7 multiadd (on 1.3.8) and I get this error when I do a multiadd-

att: 26|24|25,63

Warning: Cannot modify header information - headers already sent by 
(output started at /home/jalansty/public_html/shop/admin
/products_with_attributes_stock.php:193) in /home/jalansty/public_html/shop/admin
/includes/functions/general.php on line 21

It adds the stock number fine. When I hit 'back', I can keep on working with any problems.

Any idea what is causing this?

Thanks-

shoulders:

Hi,

i have installed all the files as per instructions (i hope), i then ran the script file (from 4.7 multiadd) to create the table, but i get the following error. the tables also do not seem to be created.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO configuration (configuration_title, configuration_key, configur' at line 7
in:
[CREATE TABLE zen_products_with_attributes_stock ( stock_id INT NOT NULL AUTO_INCREMENT , products_id INT NOT NULL , stock_attributes VARCHAR( 255 ) NOT NULL , quantity FLOAT NOT NULL , PRIMARY KEY ( stock_id ) ); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false', 'When customer places more items in cart than are available, show the available amount on the shopping cart page:', '9', '6', NULL, now(), NULL, "zen_cfg_select_option(array('true', 'false')," );]
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.

> 
> any help would be appreciated.
> 
> thanks
> 
> shoulders

i managed to get the sql to run from myphpadmin, if anyone else does this make sure you add your zen installation prefix in to the sql script first.

After installing this mod,

I lost everything except my Header and my left bar!

Can someone help me with a way to resolve this??

https://www.mygreenmoon.com

I have been trying to figure out my problem...

However I dont get this...

What I think I really need is the update to the one made by danielcor

The one that allows updated of all three sizes on one page....

Thats the one I have installed now...

Yea that has to be the best one...

http://www.mygreenmoon.com/index.php?main_page=product_info&products_id=15552

I love the fact that they figured out a way to tell people how much stock you have left. (Look at the add to cart button.

Gonna have to fix around the Info_Product_Display Though. Looks horrible.

For some odd reason I am now losing my Left bar of my Main Page.

Sorry for the bunch of posts...

I thought I had this solved I have this error at the bottom I cant resolve.

https://www.mygreenmoon.com (not my live site)

Fatal error: Call to undefined function zen_get_upcoming_date_range() in /home/green/public_html/includes/modules/upcoming_products.php on line 15

milobloom:

Sorry for the bunch of posts...

I thought I had this solved I have this error at the bottom I cant resolve.

https://www.mygreenmoon.com (not my live site)That's nothing to do with Stock by Attributes for which this is the support thread. You're using the latest version of StockAttribute. Here's my assessment of it from earlier in this thread.

kuroi:

You might want to try the latest version of StockAttribute by danielcor which uses AJAX to dynamically update the stock levels depending upon customer selections. However, it's based on an older version of Zen Cart and a slightly buggy version of the Attribute Stock mod from which the mod to which this thread refers was derived.Unfortunately it appears that nobody is supporting that mod, and having spent a considerable amount of time cleaning the earlier version that developed into Stock by Attributes, I'm afraid you're in for a bit of a rough ride with this fork - though your immediate problem can be resolved by doing a merge between your functions_lookups.php and the one in the 1.3.8a Zen Cart distribution pack.

milobloom:

Yea that has to be the best one...

http://www.mygreenmoon.com/index.php?main_page=product_info&products_id=15552

I love the fact that they figured out a way to tell people how much stock you have left. (Look at the add to cart button.

a little off topic, but do you know if there is a downloadable mod for this?

shoulders:

a little off topic, but do you know if there is a downloadable mod for this?You can find it in the downloads section, but please don't hijack this support thread to discuss its problems.