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.