Cuball

I had issues logging into the back office, managed to get it working by disabling the Customers/Merchant Expertise module (or via ftp rename the "gamification" folder/module) . Looks like that's the main issue for a lot of people.

Hi, I just wanted to see if anyone is able to help work out a Trigger that will add an item to a specific category once it's quantity has reduced to 1? I have a section on my website that shows all stock that only has 1 left, right now im having to manually look up each product with 1 quantity and assigning the category manually. I'm wanting to make this an automated process, Is there anyone that can help?

Hi, I just wanted to see if anyone is able to help work out a Trigger that will add an item to a specifc category based on quantity? I have a section on the website that shows all stock that only has 1 left. I'm fairly new to SQL and i've tried to merge 2 different sql triggers to make it work, but i keep getting errors UPDATE ps_product, ps_product_shop SET ps_product.id_category_default = '216', ps_product_shop.id_category_default = '216' WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity=1); If anyone is able to help, that'll be great. Thanks.