Jump to content

SQL Trigger to add to category


Cuball

Recommended Posts

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?

Link to comment
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...