Im in test mode and currently integrating FoxyCart into my website. I have successfully implemented the SSO/API flow and am working with the subscription data feed.
I need to be able to immediately access the value of one of the checkout form input fields upon a completed purchase so I can update my database. Here is the input whose value I need:
<input id="my_value" name="Value<?php echo get_verification('Value', '--OPEN--', 'my_code'); ?>" type="text" maxlength="5" autocomplete="off" placeholder="Type a value" value ="" />
I need to be able to get this value (which is typed in by the user) after checkout has completed so that I can immediately update values in my database. I can't rely on the user clicking the 'continue to store' link on the receipt page in case they close out the window, because even though they think the transaction is finished, I haven't yet updated my database to show that they completed the transaction.
So basically, I need a way to update my database immediately upon a successful transaction, using the foxycart id and the value of that custom field. Can I do this via the subscription data feed PHP script? If so, how can I access the input value mentioned above from this point?