One-off Items

[KOKO]

Hello everyone,

I'm brand new to Thirty Bees (I installed it probably 4 hours ago), and so far I think it's great, and everything but one question has been answered by these forums.

I've set up the shop for my partner who makes one-off pottery items. Each item is unique, and sold individually. In WooCommerce on Wordpress, when I created a product for sale, I would set it having a quantity of 1, and when it sold, it would not show up in the gallery any more. This item will never get listed again, unless it gets returned for some reason, at which point I would like it to come back to life when the return is done and the stock level returns to 1.

Is this possible in Thirty Bees in a plug-in or a native setting that I've overlooked?

If it's not possible, if someone could point me to the SQL query that pulls the items available for sale for the front office, I'm happy to modify that myself to not pull products with a stock level of 0 - assuming it would be that easy.

Many thanks in advance,

KO

 

[datakick]

No, this is not supported. You can disable ordering out-of-stock items, but they are still displayed in categories.

You can either

1. edit your theme, and simply omit out-of-stock items from listing
2. periodically run SQL update query to hide products that are out of stock. Something like this might work (please test)

UPDATE tb_product_shop 
SET visibility = 'none' 
WHERE (SELECT SUM(quantity) FROM tb_stock_available sa WHERE sa.id_product = tb_product_shop.id_product) <= 0;

 

[haylau]

We use this module which you can use to set a cron which runs how often you want it. It will disable out of stock items, and LOADS of other great features

https://codecanyon.net/item/prestashop-tidy/18965736?s_rank=13

[KOKO]

Thank you, both.