Jump to content

SQL Trigger to add to category


Recommended Posts


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?

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More