Without transactions, I would be sure to run audit querys afterwards to check for broken RI (e.g. order_products rows where the order_id does not exist in order table), and also to see if there's any "product-less" order table rows (though maybe that's legal.. depending on your use you can delete them or know that they represent an error).