It should not be recordset driven. Only static.
The suggestion i am making is to add an add to cart button to the conform page, and modify the trigger so that it is only added when the customer 1) Clicks the Confirm order button and 2) when the total of the cart is over 1000.
The item will be added before the transaction is processed with the gateway, and before the order information is stored in the database. Since the item is added to the cart before these things happen, it will become a part of the order receipt, and will be stored in the database.