Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
Hi Rob,
First of all congratulations for this great module.
After installation, some of the submissions on the forms have not properly registered the payment form after checkout from de bank.
Now I have a big problem because some of these submissions are really payed but is not update in the results. For this reason I need to check every of the submissions comparing the order_id corresponding to each of the submissions. How could I get it? I looking to get any relationship between the fields of orders and the forms but can not find it in database.
Would greatly appreciate your help.
Comments
Comment #1
niclopez CreditAttribution: niclopez commentedHi again,
I've been trying to find a connection between the generated orders and submissions. Does anyone know how to print order id in submission webform?
I can't find a way to verify whether the submissions are actually paid or not. Payments are recorded correctly in order but not in the submissions.
Would greatly appreciate some help on this topic
Many thanks,
Comment #2
AndyF CreditAttribution: AndyF commentedHi starpoli,
What payment method are you using?
If you look in the table
uc_order_products
there's a fielddata
. This contains what you're looking for: unserialize it and look for$data['uc_event_registration']['sid']
. This is the submission ID from the tableswebform_submissions
andwebform_submitted_data
.I'm not 100% sure what you want here, but it's not possible to know the order ID from the webform, as the order isn't created until checkout.
Yeah, this should be taken care of automatically :) The issue is marked as v1.2: if you're using that, then maybe you need the fix introduced with #1119372: 'Customer Completes Checkout' not firing with WPS. It's currently in dev. Could you try out dev and report back?
HTH
Comment #3
niclopez CreditAttribution: niclopez commentedHi AndyF,
Thank you very much for the information, It was exactly what I'm looking for.
I've installed .dev version of this module and now works well; all submissions are now paid.
I appreciate your big help.
Comment #4
AndyF CreditAttribution: AndyF commentedGreat, glad it's working.
Comment #6
AaronBaumanNothing is impossible.
Just use the same method that updates the order status.
The order id is a pretty critical piece of information for the submission.
Same goes for the uid that gets created (if applicable) when the user checks out.
I don't have time to work on a patch for this now, but maybe in a couple weeks.
Until then, maybe someone else has this working?
Comment #7
AndyF CreditAttribution: AndyF commentedHi, thanks for your input. Issue #1496376: Create link to submission from order and vice versa is connected with linking the webform submission and order.
I'd like to avoid duplicating the order ID in a component as that could lead to mismatches down the line. See also #1445572: Remove the quantity webform component. One way around this would be to create a custom component that looks up the details as appropriate; not sure how much interest there is in having the data as an actual component.
Comment #8
AaronBaumanThanks for the quick response. I'll followup on the other issue.