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

niclopez’s picture

Hi 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,

AndyF’s picture

Status: Active » Postponed (maintainer needs more info)

Hi starpoli,

some of the submissions on the forms have not properly registered the payment form after checkout from de bank.

What payment method are you using?

I need to check every of the submissions comparing the order_id corresponding to each of the submissions. How could I get it?

If you look in the table uc_order_products there's a field data. This contains what you're looking for: unserialize it and look for $data['uc_event_registration']['sid']. This is the submission ID from the tables webform_submissions and webform_submitted_data.

Does anyone know how to print order id in submission webform

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.

I can't find a way to verify whether the submissions are actually paid or not

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

niclopez’s picture

Hi 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.

AndyF’s picture

Status: Postponed (maintainer needs more info) » Fixed

Great, glad it's working.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

AaronBauman’s picture

Title: Relation/connexion between order_id and submitted webform » update webform submissions with uc_order_id and uid
Version: 6.x-1.2 » 6.x-1.x-dev
Category: support » feature
Status: Closed (fixed) » Active

it's not possible to know the order ID from the webform, as the order isn't created until checkout.

Nothing 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?

AndyF’s picture

Hi, thanks for your input. Issue #1496376: Create link to submission from order and vice versa is connected with linking the webform submission and order.

Just use the same method that updates the order status.

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.

AaronBauman’s picture

Status: Active » Closed (fixed)

Thanks for the quick response. I'll followup on the other issue.