unpublish products with variants with zero stock

-- url of the page with the problem -- : dodowear.nl
-- HikaShop version -- : 2.2
-- Joomla version -- : 2.5
-- PHP version -- : x.x.x
-- Browser(s) name and version -- : Firefox
-- Error-message(debug-mod must be tuned on) -- : Error_message

Hello,
we work with products with variants
As most of the products are seasonly (only delivered once) they need to be unpublished when sold out.
So when all variant of a product have no stock anymore the parent product should become unactive.
Up until now I do this manualy with import and export in excel or walking trough the website.
But as you can understand this is a lot of work.
So I was wondering if you could tell me a simplerer and more time winning method

thanks in advance Boudewijn

Hello Jerome,
It looks like the massaction can help me on this, but I want to be sure if it's working the way I would like.
After reading your documentary on this I have created the your example on out-of-stock.
But now I would like to test it. And I'm bit afraid that the product will be massed up.

In the product database the parent-product are all 0, the stock is on the variant.
Should this batch working correctly. So, move product which have no stock anymore on the variant to a category called out-of-stock.
And is there a way to test this. Something like a report or it shows me the products which will be moved.

I hope the everything is explained it correctly.
If this works this is a very powerfull tool.

Regards

Hello,
previously I mentioned that I get a script error on Massaction.
In the attached file you'll a picture of this message

Hi,
Last days I have been playing a bit with the massaction tool.
I did some queries. And in chrome it works fine instead of firefox.
Still I would like to get a hint.
What I have created as a report now shows me all variants with 0-stock.
I selected to show on screen. So manualy I can unpublish the product.
But I actualy need to unplubish the parent-product.
How can I manage that?
So summarized: the massaction needs to show all parentproducts where all variants have no stock (=0).
This would help me a lot

Hi Nicolas,
Yes I would say also that is simple but all my main product are on 0 or -1 stock.
Then I first need to update the stock of the main product.
Can I do this also in massaction?

Hi,
Sure, you'll just have to add an "Update values" action and apply it on the "product_quantity" field.

Hi,
Can you be a bit more specific
Where can I select the option update values?

By creating a new mass action, and using the options under the "actions" tab, for example you can update every quantity field of your products to 10000 like this :

Hello,
After I have read through the different steps and process I'm not completly convident on the different actions.
I will try to explain.
Nicolas suggested that all parent product should have the total stock of all variants.
Which is not the case in our database.
So you optained to give those product stock by another mass-action.
But then I can only give those product a hard quantity.
For instance 10.
But the when I do a massaction to show all products where the variant has zero stock I don't think that all correct information is there
Perhaps I see wrong
I would expect to see
product_parent_id product_code product_quantity product_published
01234 0 1
01234 01 0 1
01234 02 0 1
And if that's the information: unplublish the parent product

I hope you can tell me how to do so

Hi,

Actually you cannot get the total quantity of each variants of a product to change the product quantity.
This is something that you should do before.

To do what you need, I think that you will have to create your own plugin based on the massactions.
A plugin which will get the quantity of each variants of a product, and if this quantity is 0 then unpublish the product.

Hello Xavier,
That is exactly what I would like to have.
But I am not that skilled to program
Who can help me on this?

Hi,

I think that the best thing is to post a request on the commercial jobs section of this forum.
This require some development and we are not able to provide this kind of codes on the forum.

Hello Xavier,
Thanks for your reply.
I gonna manage it through my POS system in the store.
There is already a connection between them for my stock.
and pricing.
But it would be nice to have build in something like that in the future

Hi,

I have added it on our TODO list

Hello Xavier,
Yesterday I noticed that you have published the new version of hika shop.
In the changlog there was something written on the mass action with variants.
Is it possible to do this query now.
And if so, can you tell me.

Thanks so far

Hello Xavier,
Perhaps you missed my latest reply.
When you have time you can take a look at it