Stocks by attributes

ijashun:

However, my next problem is that when I click on admin/catalog/Products with Attributes Stock I get this :

Suchen: Store
You're using the AJAX version of this mod which is known to be incomplete. If you search this thread for "ajax" you'll find more information about this.

brocolee:

yes i did regarding the installation sql !

Thanks kuroi for answering the noob question..

Now its finally working! Just that i see naother problem and that is when i was testing and proceed for a check out....

When i delete the order in my back end and tick "restock quantity" the stock nv return back to "SBQ table"This mod does not support restocking. I'm afraid that has to be done manually.

Kuroi,

I removed 4.7ajax and installed multiadd. I am able to add to the product stock by attributes table. However I am not able to display the quantities next to the attributes in the product info page. I tried what you had mentioned in wiki (grayson). I have only one attribute currently..size.

Also when quantity is added to cart, the stock does not reduce (when continue shopping is clicked without checking out).

I have checked for the proper installation, as you suggested.

here is the link.. http://ijashun.com/index.php?main_page=product_info&cPath=15&products_id=25

Can you help, please?

Thanks in advance.

Swathi

I have another question...can we combine stock by attribute with product attribute grid module... so that we can have the quantity of stock available next to the attribute and also allow the customer to choose the quantity
eg.

size Small available 4. select 2

Thanks in advance for any help.

Swathi

limelites:

Ahaaaaaaa, figured this one out guys!!

For anyone else having a problem with this issue, just look at re-installing the files that shipped with the stock_by_attributes mod.

I've just cured my problems by overwriting /includes/classes/order.php with the order.php from "stock_by_attributes_4-7MULTIADD mod"

Somehow some other mod had corrupted the data that updates the "Quantity in Stock" in ADMIN>CATALOG>PRODUCTS WITH ATTRIBUTES".

It is now updating the Quantity in Stock Column with each sale. All working perfectly now.

Additionally, if you want the attribute in the drop down menu to automatically disable when the attribute quantity = zero, then you have to open /includes/modules/attributes.php and replace this:

$sql = "select pov.products_options_values_id,
pov.products_options_values_name,
pa.*
from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov
where pa.products_id = '" . (int)$_GET['products_id'] . "'
and pa.options_id = '" . (int)$products_options_names->fields['products_options_id'] . "'
and pa.options_values_id = pov.products_options_values_id
and pov.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
$order_by;

> with this:
> ```php
$sql=	"SELECT  pov.products_options_values_id,
       					 pov.products_options_values_name,
       					 pa.*,
       					 pwas.*
        	    FROM   " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_ATTRIBUTES . " pa LEFT JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " pwas ON pwas.stock_attributes = pa.products_attributes_id
                WHERE   pa.products_id = '" . (int)$_GET['products_id'] . "'
       			and    pa.options_id = '" . (int)$products_options_names->fields['products_options_id'] . "'
				and    (pwas.quantity > 0 or pwas.quantity IS NULL)
      			and    pa.options_values_id = pov.products_options_values_id
             	and       pov.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
				$order_by;

I wanted to be able to not have a particular attribute availble if none is stock eg: black medium no stock but all other availble option still visable. I changed the code as above on the attributes.php but it never worked in the store I can still select it an it then goes on backorder

Was there anything else that I should have done first?

MelB:

I wanted to be able to not have a particular attribute availble if none is stock eg: black medium no stock but all other availble option still visable. I changed the code as above on the attributes.php but it never worked in the store I can still select it an it then goes on backorder

Was there anything else that I should have done first?

Check your settings in Configuration > Stock > Allow Checkout

This should be set to false.

HI there,

I'm new to stock by attributes and have just installed 4.7a on my 1.38a Zen cart.

All looks to be working ok.

However, I wanted to do a test so I went to admin > catalog/products > proucts with attributes stock.

Clicked on Add Quantity For Product Variant and entered an amount say 10 on ALL. then saved. Then I Sync Quantities.

However, if I go back into the same attribite via the Add Quantity For Product Variant and enter another 10 say to all I get this error.

att: 5561|5559|5562|5558|5556,5678|5679|5680|5681|5682|5683|5684

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

It seems as though regardless of the error that it still does work but as I'm new to the mod I wanted to make sure.

It still adds to the total correct amount and I can then sync with now problems.

Thanks for any input,

Murray

Hi there,

I wanted to add a little to the above post. I'm not sure if it is related or not though.

I have entered the admin > catalog/products > proucts with attributes stock area.

I find a product I want to edit. I click on Add Quantity For Product Variant.

I sellect ALL. Then make a change.. say 10. (ALL attributes then have 10 of each in stock)

Then I think to myself.. actually thats out of stock.. so I go back into 'attributes stock area' of the product and do -10. As it lists say 700 items in stock of various attributes.

This then sets all to -10. NOT to 0. I don't know another way to reset this to 0? I have gone back in Add Quantity For Product Variant area and tried to edit to other numbers but now there are a lot if various amounts. Cannot I not edit ALL attributes of the same product at once?

Now I have many attributes of that product listed as -10. If I log back in and edit using 'attributes stock area' ALL feature to say 10 again. Many of the products remain as -10.

I can individually edit each one.. but I have many attributes and as you can edit ALL in the 'attributes stock area' I was wondering what I'm doing wrong or if in fact the error in above post that happens when I process the ALL feature works is working correctly.

I wanted to add the ONLY time I can NOT get an error is when selecting the attributes which I have 2.

Size

Color

If I Add Quantity For Product Variant I select a specific color AND size.

If I select ALL on either of them or both it will have above post error.

ijashun:

Kuroi,

I removed 4.7ajax and installed multiadd. I am able to add to the product stock by attributes table. However I am not able to display the quantities next to the attributes in the product info page. I tried what you had mentioned in wiki (grayson). I have only one attribute currently..size.

Also when quantity is added to cart, the stock does not reduce (when continue shopping is clicked without checking out).

I have checked for the proper installation, as you suggested.

ijashun:

can we combine stock by attribute with product attribute grid module... so that we can have the quantity of stock available next to the attribute and also allow the customer to choose the quantityHi Swathi

I'm afraid you're asking me a pile of questions to which I don't know the answers. But I'll do my best and let's hope that other people jump in with their experience.

I've never had need to use the multiadd version myself, can't really comment much on how that works.

Suimilarly I've never implemented the Grayson solution. I put the link in the wiki because people clearly wanted it, but you will need to read a little further down the thread to get the up-to-date details since the mod's structure has changed from when she first devised the approach, but the implications of those changes are discussed.

I've never really looked closely at the attribute grid mod. I'm guessing that it lays the attributes out in a grid! However, most likely it will be completely independent of this mod and compatible, but will know nothing about quantities so you would need to build that in.

However, even with quantities built into the display, customers won't be able to order multiples. Zen Cart's attribute system doesn't have any attributes that support ordering a quantity of the same attribute. That's a very big deal. I built a partial solution to this once to support a specific requirement for a client. It was horrendously complex and took me about three days to develop and test, test, test.

On stock reduction not occurring, I used to investigate these individually, but the problem was always due to one of the same two issues: either the includes/classes/order.php class hadn't been properly loaded to the server, or there was a backup of the original in the same folder overriding the changed version.

I'm trying to implement qty by attribute for my 1.3.7 site so I can sell shirts in the holiday season.

So far, I'm not having luck. I suspect it's due to the module needing 1.3.8, can someone confirm this?

Can someone point me to something that WILL work for my 1.3.7 cart?

When I did install this, I was able to see the back end and it appeared to work. I.e. I could put in 3 small shirts and 4 mediums and then hit the update link and the main product showed qty of 7 with the appropriate sub-qty. But then, when I went on the front end and purchased 1 small shirt, I would see the main qty go to 6 on the admin view but the sub-qty for small would STAY at 3. The behavior I expected to see was that both the main qty AND the sub-qty would go down.

If I went to the front end and tried to order 4 small shirts, it would tell me there were not 4 available, which is correct. But then I could still order 3 since the sub-qty remained at 3, but in reality I would only have 2 available at this point.

So I'm thinking that either my cart version is not compatible with this and I hope someone can point me to something that works (doesn't need to be fancy). Or, I have misunderstood the purpose of this mod and someone can point me to something more appropriate for my needs. Or .... something else :)

Any help or direction is appreciated.

A few possibilities ...

if you've installed the AJAX version then you won't have all the files needed - there's lots more about this elsewhere

if you've not installed it properly, in particular the includes/classes/order.php file, then it also won't work, and in the way you've described.

the current versions may well not be compatible with 1.3.7, in which case go back to the downloads area and get the version that was written for 1.3.7.

Yep, i grabbed the 1.3.7 version, works like a champ.

One question, is it supposed to "turn off" attributes that have 0 qty or no? Right now, if my "small" is 0 qty, the cart still shows small as an option on the front end. Just wondering if that's expected behavior. Any tweaks out there to turn that off automagically if stock on an attribute is 0?

Thanks for the help

Hello,

I've tried looking for an answer or a solution but could not find it. I'd like to ask if there is any addon that alows you to search based on attributes.

For example I have clothing sizes S, M, L and I want to search for only M, or filter the rest.

If no, could I ask for a quick explanation what's the main problem with that?

Thank you!

trippy1976:

Yep, i grabbed the 1.3.7 version, works like a champ.

One question, is it supposed to "turn off" attributes that have 0 qty or no? Right now, if my "small" is 0 qty, the cart still shows small as an option on the front end. Just wondering if that's expected behavior. Any tweaks out there to turn that off automagically if stock on an attribute is 0?

Thanks for the helpThe base stock by attributes mod merely adds stock to the attribute, and has no impact on its display. The AJAX version may be attempting to go where you want, but I can't be sure as I've never used it.

Vall:

Hello,

I've tried looking for an answer or a solution but could not find it. I'd like to ask if there is any addon that alows you to search based on attributes.

For example I have clothing sizes S, M, L and I want to search for only M, or filter the rest.

If no, could I ask for a quick explanation what's the main problem with that?

Thank you!This mod can't help you with this. It has nothing to do with searching.

The topic generally has been discussed a number of times, but I don't know of any mod that does it, as a general mod capable of handling any combination of attributes would be very complex and slow. Normally when one of our clients wants to to search by attribute we write custom code based either on attributes or on a new product type with additional product codification to meet the specific needs of the store.

However, this thread is already excessively long just from supporting this mod, so if you need more information about how this can be done, please start a new thread.

I've spent countless hours going over these posts...

Is it true that it is still not possible to either

1- display to the customer the different attribute variations and how many of each are in stock

or

2- disable the attribute option(s) from the respective dropdown menu's that are not in stock.

I have the Stock By attributes module version 4.7Ajax (up from 4.7 multi add) successfully installed.

I saw posts by several members years to months ago asking about this / almost solving this / etc - but with no stated solutions... has anyone figured out how to do this?! Could you point me to contributed modules that can do this?! If i'm asking this in the wrong spot could you lead me to the correct place?!

Thank you for any advice you can extend to me.

Schweb Design:

Is it true that it is still not possible to either

1- display to the customer the different attribute variations and how many of each are in stock

or

2- disable the attribute option(s) from the respective dropdown menu's that are not in stock.
This mod out the box does not support this kind of functionality.

Schweb Design:

I have the Stock By attributes module version 4.7Ajax (up from 4.7 multi add) successfully installed.

I saw posts by several members years to months ago asking about this / almost solving this / etc - but with no stated solutions... has anyone figured out how to do this?! Could you point me to contributed modules that can do this?! If i'm asking this in the wrong spot could you lead me to the correct place?!
Been some talk and possible solutions posted in this and the other Stock by Attributes thread.. You can use the thread search tools to narrow your search to posts in the specific threads.. Don't know if any of these solutions are working or not.. (I haven't personally used any of them..)

I've searched and searched... but I'm lost.....

I've installed the mod in our test database. Shows up and all of our inventory is listed....
but when I click on define variant,
I get an error:
1146 Table 'XXdatabasenameXX.products_attributes' doesn't exist

fair enough...

all of our database tables have a prefix....

I, for the life of me, can't figure out any and all places that need to be modified to show the correct table name.....

any help with this would be great

Thanks

You don't say which flavor of the Stock By Attributes mod you installed:
Kuroi's version 4.7
MultiAdd version 4.7
Ajax version 4.7

I could never get the last two to work.. and since the contributors of both of these versions (MultiAdd or Ajax) have NOT ONCE support their version of this mod, I do not use them. My research of the support threads shows that these two versions are the ones with MULTIPLE problems. I use ONLY the version 4.7 Kuroi wrote. He is the ONLY mod author still actively answering questions in these support threads, so for my money this is the one I will use. However I do like the stylesheets used in the MultiAdd version because it visually makes a nice seperation between the parent product and the variants. but THAT'S ALL that I used from that version!:smile:

That said if you used Kuroi's version, it's a VERY straight forward install and should work right away.. No hacks to this mod needed AT ALL!

exeter_acres:

I've searched and searched... but I'm lost.....

I've installed the mod in our test database. Shows up and all of our inventory is listed....
but when I click on define variant,
I get an error:
1146 Table 'XXdatabasenameXX.products_attributes' doesn't exist

fair enough...

all of our database tables have a prefix....

I, for the life of me, can't figure out any and all places that need to be modified to show the correct table name.....

any help with this would be great

Thanks

Do you have a link to the Kuroi version? I cannot locate it.