my python script changes Order status, and Shipping status when orders are prepared and shipped. Now my questions is how can I trigger OrderShipped email to be sent at the same time via SQL query, if that is possible at all, thanks
I am making a small script where I will be entering a tracking numbers for the shipments, and as I noticed first I have to create a shipment in order to enter a tracking number. When shipment is created new row in the dbo.Shipment is created in order to have a tracking number saved.
Now the questions is, is the dbo.Shipment the only table that is affected when a new shipment is created through admin interface?