How To Generate An Order Confirmation Number

Hi @nobuhlesibusiso,

Trust you are doing good today.

I assume that you are using the submission ID as the order confirmation number. You can modify the AUTO_INCREMENT on the database, please find an example of MySQL query below.

ALTER TABLE PREIX_frmt_form_entry AUTO_INCREMENT=100000;

Make sure to take a complete backup of the site before further proceeding and also replace the PREFIX_ adding your website prefix.

I hope that helps.

Kind Regards,
Nebu John

I’m well. Thank you for asking, and for all the assistance you are providing me with thus far.

I must warn you – and maybe I should have done so on the outset – I’m not exactly what you would call very tech-savvy, nor am I that great of a mathematician, so I solicit your patience while I get this all figured out.

Now, I have seen no submission IDs in any of the form fields, nor could I find any while checking through the various field tabs/options. Please kindly direct me to where I could find that option, as the two tests I performed resulted in the same order confirmation number of #0. I really don’t mind the confirmation number starting from increments of 1, but I just feel lost as to where to go to ensure that will happen.

Thank you.

Hi @nobuhlesibusiso

Thank you for response!

I think there’s been some confusion in this case, on both sides, so I’m sorry for it and let’s make sure first that we are on the same side.

You are referring to “Order confirmation number” but there’s no such number/feature available in Forminator (it’s not really an “e-store” even though it handles payments). The number that you are most likely using is a “submission_id” which is an automatically generated number for each and every form submission, directly in the DB.

I believe that’s what you have in your form’s e-mail Subject line:

Order Confirmation #{submission_id} for {form_name}

and that is what you mean by “Order Confirmation ID”. This is the number that is always at 0 in your e-mail notifications, right?

It shouldn’t be like that and the form that you shared in your other ticket works fine (sending correct number) when I’m testing it on my own test setup.

It suggests some kind of either “undiscovered yet” bug or a conflict or that we are missing something specific ot the site here. Therefore, can you please:

– temporarily remove PayPal field form the form and check if the number is correct then after form submission?

– tell me if you have added any custom code related to Forminator to the site whatsoever (e.g. suggested by us in some other ticket)?

– did you apply the change in DB that was suggested by my colleague already? (If not, please do not do it for now!)

– could you try re-installing Forminator on site?

As for the last point, please do it this way:
– go to “Formiantor -> Settings -> Data” page and make sure that “uninstallation” option is set to “Preserve” then save settings
– go to “Plugins -> All plugins” page and disable and then delete Forminator
– then re-install it (it would pick-up all the settings and forms)

Kind regards,
Adam

Hello @nobuhlesibusiso ,

We haven’t heard from you for some time now, so it looks like you don’t need our assistance anymore.

Feel free to re-open this ticket if needed.

Kind regards
Kasia

I’m so sorry for the silence. I’m sure I’ve done at least one of the options immediately after receiving your response, but I must have forgotten to let you know the results. Just now, after removing and replacing the Paypal button, It no longer includes that order confirmation number. Instead, it includes a transaction ID and merchant ID which are just fine.

Thank you for your help, and again, apologies for the delayed response.

Hi @nobuhlesibusiso

I’m glad to her that it works for you now, thanks for letting me know!

Have a great day,
Adam