Stocks by attributes

Hi folks.. Haven't tested the latest SBA version.. Sounds like it too has issues..

So let me say what I have consistently said in this and the other SBA support thread.. I ONLY use the version created by Kuroi.. EVERY SINGLE VERSION released after Kuroi's version is close but no cigar IMHO. If you look through this support thread, you will see that CONSISTENTLY the problems with SBA all relate to versions other than the one created by Kuroi..

My advice?? Rollback to the Kuroi version.. Unless someone (like the author of the latest version) steps in to help..

mvstudio:

Hello everyone.

I've being running into a problem with this mod, no matter which version I'm using and I can't figure out how to fix it.

My zencart installation 1.3.8a
This mod version 1.4.9 (4.9) the last new on the list.

Whenever I add more than one attribute and add the quantities, the drop down menus in the store reflect multiple choices of the first attribute and the correct one on the second attribute. Maybe I didn't explain correctly so here this is what is happening http://www.byvalenti.com/index.php?main_page=product_info&cPath=14&products_id=16

The problem is on the first drop down menu as it displays 10 times the same option (one for each one of the options).

Has anyone ran into a similar problem? any fix for this?

Thanks!

valvoj:

I have a similar issue. I'm trying 2 drop down menus on a page. One using product stock w/ attributes, the other w/o. If I don't assign a quantity to the dropdown value, my box is empty. If I go into Product Stock w/ Attribs and give the value a quantity, I get an error about "Warning: Cannot modify header information - headers already sent by.... includes/functions/general.php on line 21". I click back, it says product updated and shows the same value duplicated. Example here:
http://guardianangelsocietysyr.org/zencart/index.php?main_page=product_info&cPath=1&products_id=2&zenid=12ffd8dc3145fb4ea7b4923c5fbee289 Anyone have ideas?

Sorry if I've double posted this on v4.0 + here.. I don't see the difference between those two..

Is it possible to set a "global" stock for each attribute?

Let's say I have 3 main products (Napkins).

All 3 main products have 3 attributes (smaller napkins).

To sell more, I want to make packages of napkins.
Main napkin + smaller napkin

So the main products:
Napkin Red
Napkin Blue
Napkin Green

can all be ordered with the same attributes:
Smaller Napkin - Yellow
Smaller Napkin - Purple
Smaller Napkin - Black

My Problem:
When someone order main Red Napkins, with Smaller Yellow Napkins as an attribute. I want the "Smaller Yellow Napkin" to be subtracted in stock on all the main products having the Yellow-Napkin attribute.

Did anyone understand this?
And is it possible?

Anyways - thanks for a great mod! It works perfectly well on my other products, having separate attributes..

How do you uninstall the SQL for this mod...? I've tried everything to try and get my totals to update when items are added to the cart but just can't get it to work.

Tried every single version of the mod, every suggestion, everything, so i'm gonna have one last crack but when i completely put the files back to the original state the cart won't show because of the SQL patch.

How do i uninstall the patch. The patch is the one from version 1.4.7ajax.

Any help is much appreciated.

Gomlers:

Sorry if I've double posted this on v4.0 + here.. I don't see the difference between those two..

Is it possible to set a "global" stock for each attribute?

Let's say I have 3 main products (Napkins).

All 3 main products have 3 attributes (smaller napkins).

To sell more, I want to make packages of napkins.
Main napkin + smaller napkin

So the main products:
Napkin Red
Napkin Blue
Napkin Green

can all be ordered with the same attributes:
Smaller Napkin - Yellow
Smaller Napkin - Purple
Smaller Napkin - Black

My Problem:
When someone order main Red Napkins, with Smaller Yellow Napkins as an attribute. I want the "Smaller Yellow Napkin" to be subtracted in stock on all the main products having the Yellow-Napkin attribute.

Did anyone understand this?
And is it possible?

Anyways - thanks for a great mod! It works perfectly well on my other products, having separate attributes..

In my experience, this mod cannot do that. That is not to say there isn't another mod out there that may accomplish that, but I do not personally know of one.

Cunk:

We're having some trouble with this addon. I've managed to copy all the files over to our cart (after making sure they weren't going to wipe out anything) and I can successfully add stock quantities for product attributes.

However, if I then go to purchase something and proceed to the checkout I'm told the item is out of stock (I added 20 items of every combo available). This happens no matter which item or combination of attributes I choose.

Any ideas what I should look for?

Here's our cart in case you want to see what I mean:

http://www.rasebike.com/cart/

Can you outline your exact steps in setting up a products attributes and setting stock? That might help us to see where the problem lies.

Ok so I'm confused. What exactly is "Sync All Quantities" supposed to do?

When i first clicked it, it set all my products to 0... which i figured was because there werent specific attributes defined. So I added one and clicked it again, nothing. The added attribute stayed the same(20), but the other shirts stayed at 0 with no Variants showing.

I tried clicking the products specific "Sync Quantites" as well. Still nothing.

I just installed version 4.9 although I did notice that the instructions were for 4.7ajax. Am I missing something?

Hi- can anyone help please - I followed the advice of entry #642 about only showing attribute options for those items 'in stock' - by altering the attributes.php file as described:

but I get this error message in my product page:
1146 Table 'cheekyshoe.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
in:
[select pov.products_options_values_id, pov.products_options_values_name, pa., pwas. from products_options_values pov, products_attributes pa LEFT JOIN TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK pwas ON pwas.stock_attributes = pa.products_attributes_id where pa.products_id = '180' and pa.options_id = '20' and (pwas.quantity > 0 or pwas.quantity IS NULL) and pa.options_values_id = pov.products_options_values_id and pov.language_id = '1' order by LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_name]

I checked the database and the table is there, but I'm new to all this so I'm a bit stumped as to where to go next.
Any help much appreciated.

Many thanks

PS. Most recent version installed

I've searched this thread and the rest of the forum with no luck, so here goes...
We sell t-shirts and donate $1 of each shirt to the customer's choice of one of three local charities. I've got SBA set up to keep track of the stock of the different sizes of each shirt (M, L, XL, XXL), and that works perfect. What I'd like to do is add another dropdown for the customer to choose between the three charities, but I don't want it to interfere with SBA. The way it was initially set up (which makes sense because I think it's the way SBA was designed) I would have to set up the stock like this:
-Shirt#1 ; Size: M ; Charity: A
-Shirt#1 ; Size: L ; Charity: A
-Shirt#1 ; Size: XL ; Charity: A
-Shirt#1 ; Size: XXL ; Charity: A

-Shirt#1 ; Size: M ; Charity: B
-Shirt#1 ; Size: L ; Charity: B
-Shirt#1 ; Size: XL ; Charity: B
-Shirt#1 ; Size: XXL ; Charity: B

-Shirt#1 ; Size: M ; Charity: C
-Shirt#1 ; Size: L ; Charity: C
-Shirt#1 ; Size: XL ; Charity: C
-Shirt#1 ; Size: XXL ; Charity: C

And so on for each shirt.
I obviously don't need to set inventory dependant upon the charities chosen, because which charity they choose has no effect on the number of shirts I have. Is there a work around to not include the "Charity" attribute in SBA? Can anyone think of a different way to do the charitable donation? Thanks in advance.
I'm running ZC 1.3.8a and SBA 1.4.9.
Brian

Simply set up another option in Attributes in your admin area. Call it carity donation and have your options in there. Set a default charity also. When your customer buys a shirt they can select a charity and if they dont a default will always be selected.

This would require you to then see which charity was selected by viewing their order and you would then need to send the money to the charity.

Thanks for the help, first trading!
Isn't that what I was explaining above, though? With Stock by Attributes I need to set stock levels for each of my two attributes, Size and Charity. I'm wondering if there's a way to make the Charity not a part of SBA. I already set it up using the two attributes (Size and Charity) and when I try to check out after selecting both attributes, it tells me the shirts are out of stock. I assume this is because SBA is sending a signal that the shirt isn't in stock because I haven't entered how many of each combination I have in inventory. I'd like to have SBA ignore the Charity attribute. Any ideas?
Brian

In case I didn't explain it clearly enough earlier, what I'm trying to do is have SBA basically ignore setting stock for one of my attributes and use another. I'd like to be able to set the stock levels of t-shirts with the Size attribute, but I don't want to have to set stock for t-shirts by Size and Charity.

bhensarl:

In case I didn't explain it clearly enough earlier, what I'm trying to do is have SBA basically ignore setting stock for one of my attributes and use another. I'd like to be able to set the stock levels of t-shirts with the Size attribute, but I don't want to have to set stock for t-shirts by Size and Charity.
Short answer this mod doesn't have that feature..

Hello,

I am wondering if this module can be used in the following way - be warned this is complicated.

I wish to use the module to track stock of our products. We sell jewellery and what I wish to do is to use the module in the following way. (I have numbered the issues for ease of reference)

Example product:

Heart Pendant, on a range of chains. The whole item comes in a box.

1. Now I know that if I was to use say chain length & style as an option I could use this mod, for example, 16" Belcher Chain, 18" Belcher chain, 16" Cable chain and 18 cable chain. If defined these as option values it would offer an available quantity.

2. Now alot (not all) of the products come with the box for packaging, if I was to additionally set up a "Read Only" attribute that couldn't be seen by the customer, could this calculate stock levels for this as well?

3. Finally the heart pendant itself is available on a chain, on its own, or with other pendants, so itself needs independant stock management.

4. If the attributes were assigned over multiple products, for example the chains may be sold on a star pendant as well, would the quantities be product or attribute related. ie if we sold 2 heart pendants on 16" belcher and one star on a 16" belcher would the stock on all products with those attributes decrease by 3 or would just the heart decrease by 2 and the star by 1?

Sorry if any of this sounds vercomplicated, its a confusing thing to figure out!!!

Thanks in advance!
Sam

Gonna admit, that I didn't read all of that.. (Sorry too much to digest..) so I'll just say this and you can determine if this module meets you needs. SBA allows you to create multiple attribute combs (variants) per product and you can then assign stock levels to each one of these product variants. Product variants can consist of one or more attributes.

Variant examples:

T-Shirt sizes:
Small - Qty 2
Medium - Qty 3
Large Qty 12

T-Shirt size/color combo:
Small/Blue - Qty 2
Medium/Blue - Qty 3
Large/Blue Qty 12
Small/Red - Qty 2
Medium/Red - Qty 3
Large/Red Qty 12
Small/White - Qty 2
Medium/White - Qty 3
Large/White Qty 12

totalsam:

Hello,

I am wondering if this module can be used in the following way - be warned this is complicated.

I wish to use the module to track stock of our products. We sell jewellery and what I wish to do is to use the module in the following way. (I have numbered the issues for ease of reference)

Example product:

Heart Pendant, on a range of chains. The whole item comes in a box.

1. Now I know that if I was to use say chain length & style as an option I could use this mod, for example, 16" Belcher Chain, 18" Belcher chain, 16" Cable chain and 18 cable chain. If defined these as option values it would offer an available quantity.

2. Now alot (not all) of the products come with the box for packaging, if I was to additionally set up a "Read Only" attribute that couldn't be seen by the customer, could this calculate stock levels for this as well?

3. Finally the heart pendant itself is available on a chain, on its own, or with other pendants, so itself needs independant stock management.

4. If the attributes were assigned over multiple products, for example the chains may be sold on a star pendant as well, would the quantities be product or attribute related. ie if we sold 2 heart pendants on 16" belcher and one star on a 16" belcher would the stock on all products with those attributes decrease by 3 or would just the heart decrease by 2 and the star by 1?

Sorry if any of this sounds vercomplicated, its a confusing thing to figure out!!!

Thanks in advance!
Sam

GeorgieBrown:

Paraphrased...Hi- can anyone help please
I get this error message in my product page:
1146 Table 'zencart.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
in:

The table is there...
I dont have all day to look at 800+ Entries...
ANy insight would be greatly appreciated...:(

Hunterheads:

The table is there...
I dont have all day to look at 800+ Entries...
ANy insight would be greatly appreciated...:(
The problem isn't the table, it's the pointer to the table.

TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK is a constant that holds the name of the table, which is actually "products_with_attribute_stock".

So either you have an incomplete version of the mod (you don't say which version you're using), which is missing admin/includes/extra_datafiles/products_with_attributes_stock_database_tables.php or that file hasn't been installed properly.

Also there's no need to read through 800-odd thread entries - there's a "search this thread" option towards the top that makes finding answers on this topic much quicker.

Hi:

I'm in a bit of a pickle. I installed Stock by Attributes v4.7ajax on ZC 1.3.8a with security patches in place.

Additionally, the following are also included:
Improved attributes controllers
Ordered Step
Ultimate SEO v2.0.6
Admin Profiles v1.0.7.1

On the admin side it worked like a charm, though an explanation of Sync Quantities would be appreciated.

The problem lies on the front end. When I add an item to the cart, I am told
Products marked with *** are out of stock or there are not enough in stock to fill your order.
Please change the quantity of products marked with (***). Thank you

I checked and there is a large inventory for this item. I'm no coder, but can someone please show me what I need to do to fix this? :cry:

I have placed the site under maintenance so as not to confuse buyers.

I'm not going to ask about having the attribute with 0 stock disappear, I know how hard it is to accommodate everyone's request and still make a living, but it would be nice :smile:

I would really really appreciate some feedback today. I'm off on medical leave for 2 weeks and I need this fixed today! Many thanks.

I've never used that version, but know that it has a reputation for being incomplete, maybe somebody who has used it can add to that.

The idea of the sync quantities option is to synchronise the stock being held at product variant level with that being held for the product overall. This can be useful if you decide to stop using attribute level stock for a product.

Kuroi

thanks for replying. I checked the readme file and this is the latest download ( i downloaded Jan 15/2010) and the version is actually 4.7a for zc 1.3.8

In admin > configuration > stock, if I set Show available stock level in cart when less than order = true, the item in cart still has the same message, but next to the item it says Stock Available 0

Would you mind giving me a hand with this? I can add your IP to my list and give you access? if you have a moment, pleas PM me.

The site is https://leladesigns.ca/shop-lela/

newagekat:

Kuroi

thanks for replying. I checked the readme file and this is the latest download ( i downloaded Jan 15/2010) and the version is actually 4.7a for zc 1.3.8

In admin > configuration > stock, if I set Show available stock level in cart when less than order = true, the item in cart still has the same message, but next to the item it says Stock Available 0

Would you mind giving me a hand with this? I can add your IP to my list and give you access? if you have a moment, pleas PM me.

The site is https://leladesigns.ca/shop-lela/
If you have 3 of a product variant in stock and add 5 to your cart, you will get the out of stock message. The store will not show you that you ordered two more than there is actual stock available. (if that's the question you are asking.)