Stock level updates fail in OSC 2.2 MS2

[temgesic]

I'm strugling with an issue where placed or even delived orders doesn't actually substract the stock level of that product.

 

In stock configuration I have the following:

Check stock level "true", Subtract stock "true", Allow Checkout "false"

 

I'm dealing with clothes of different sizes here. So with every product there are different size options that have different stock quantity.

 

Now, when I have for example a stock of 3 pcs in Product X, size A the shop works fine and intervents me when I try to order more than those three pieces. But, when I order some amount that is in stock and hence orderable, I still see the same original stock amount in my admin view. Now, even when I mark the order as delivered, the stock quantity doesn't subtract.

 

Does anyone have a clue what could be the case here?

 

What is the phase that the stock quantity should go down? After the order is placed, or after the order is delivered?

 

Also, what is the effect of the "Product quantity" in the admin's product's information page? That is only a single number that can be manually fed in there, so that is in no way useful when there are many sizes of the same product with different stock amounts. Should that field be left blanck in order to make the stock accounting to work properly?

 

Please, if someone has any thoughts about this, share that with me, since this is a crucial thing for me to launch this webshop. Also, any references to the other articles about this issue is highly appreciated!

[jhande]

Let me guess, you are using product attributes for the different sizes of a particular item?

 

Problem with that is osC see's Product X as having (let's say) 9 in stock. It does not know that there are 3 each for size's A, B, and C.

 

I "think" the only alternative would be to have each size as it's own Product # or see if there is a contribution for it.

[temgesic]

Let me guess, you are using product attributes for the different sizes of a particular item?

Yes, I thought that would be the wise way to do that.

 

Problem with that is osC see's Product X as having (let's say) 9 in stock. It does not know that there are 3 each for size's A, B, and C.

 

I "think" the only alternative would be to have each size as it's own Product # or see if there is a contribution for it.

That would work, but that would also make the shop quite unusable for ordering multiple sizes of the same product.

 

I wonder howcome there is a possibility to tell the shop the exact quantities for each sizes of the product, if doing so affects to nothing?

[jhande]

I am not sure why the attributes cause a problem with keeping track and count of the quantity.

 

For example on my site, I have in stock 12 bottles of aluminum paint.

I set attributes so you can purchase -

1 at $1.39

3 at $1.35ea

6 at $1.30ea

12 at $1.25ea

(you can see it here)

 

No matter which option someone purchases, only 1 bottle of paint is removed from the inventory/database. :blink:

[temgesic]

I am not sure why the attributes cause a problem with keeping track and count of the quantity.

 

For example on my site, I have in stock 12 bottles of aluminum paint.

I set attributes so you can purchase -

1 at $1.39

3 at $1.35ea

6 at $1.30ea

12 at $1.25ea

(you can see it here)

 

No matter which option someone purchases, only 1 bottle of paint is removed from the inventory/database. :blink:

I see what you mean. It seems that you, also, can not have it both ways. It's either different products and a working stock or just a one product with useful attributes and a not working stock...

 

Anyway, I would like to think that someone has an answer to my question (and your's, jhande), since there are masses of webshops running osc. I hope that at least some of them has been solving this exact problem before. Everyone's stock inventory can not be malfunctioning... =)

 

Also, if someone could name a stock related contribution worth testing, I would be delighted. I tried to search, but didn't came up with any clear result. And there's no point in just randomly testing every stock related contribution.

[jhande]

I see what you mean. It seems that you, also, can not have it both ways. It's either different products and a working stock or just a one product with useful attributes and a not working stock...

 

Anyway, I would like to think that someone has an answer to my question (and your's, jhande), since there are masses of webshops running osc. I hope that at least some of them has been solving this exact problem before. Everyone's stock inventory can not be malfunctioning... =)

 

Also, if someone could name a stock related contribution worth testing, I would be delighted. I tried to search, but didn't came up with any clear result. And there's no point in just randomly testing every stock related contribution.

 

I agree, a little guidance in resolving this problem would be very nice. ;)

[temgesic]

I tried to install a contribution "Stock viewer with quantity per attribute"

( http://addons.oscommerce.com/info/4061 )

 

I also did the bugfix included. In my admin section things look promissing: now the product quantity field went grey and it is automatically updated according to attribute quantities. Pretty much what I was looking for.

 

BUT. Now in the customer view, when I select any product, I get this error message.

 

1054 - Unknown column 'p.products_image_med' in 'field list'

 

select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '37' and pd.products_id = p.products_id and pd.language_id = '4'

[TEP STOP]

 

Anyone have a clue where that unknown column is located and how could I fix that? I only know basics about mysql, but I did alter the products_attributes table as I was told by the INSTALL.txt file.

 

Thanks for any advice!

[temgesic]

I tried to install a contribution "Stock viewer with quantity per attribute"

( http://addons.oscommerce.com/info/4061 )

 

I also did the bugfix included. In my admin section things look promissing: now the product quantity field went grey and it is automatically updated according to attribute quantities. Pretty much what I was looking for.

 

BUT. Now in the customer view, when I select any product, I get this error message....

Ok, the "Stock viewer with quantity per attribute" had built in support for some other image add on called "Ultimate Images pack" that I haven't installed. I found the line from where I was able to delete the references to extra images. So problem solved - for now..