I just finished a program to update products on my company’s Big Commerce website. Inventory management enters product dimension in Microsoft Dynamics GP. The entered dimensions are then inserted into a database. The data I need is stored in 3 separate tables. Microsoft SQL performs 2 different triggers. When new data is inserted from GP the first trigger pulls the needed data from the 3 separate tables and inserts the data into a single table used to store all data entered by Inventory management. When this table is inserted to, another table is created that acts as a temporary table. Old data is deleted, and only new records are inserted. My PHP script pulls the data from the temporary table and sends a PUT request to our website to update any new products. Everything works correctly when the PHP script is manually executed.

Our current plan is to use task scheduler to run the PHP script multiple times a day, but I am wondering if there is a better way to automate my PHP script, so it runs each time a new product is entered in GP.