I am looking for suggestions. We are doing some experimenting with future subscription orders that requires the orders to be paid, and I am sure I will have to do this entire operation several times. What is the cleanest way to handle mass payment of multiple orders in Test?
Clarke
I know your question says via SQL, but consider that it may ultimately be easier to do this via the API. Pick whatever scripting language you're most comfortable with that knows how to make HTTP requests, figure out the sequence of calls that you need in Postman, and then script out a sequence that loops through those calls for however many orders you need to pay off. If this were me I'd probably reach for Node.js or PowerShell to do the actual scripting.