TOPIC:

Stripe EZ Mode, Record Transacton ID to custom table 3 weeks 2 days ago #253608

  • Topic Author
  • shinzan
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 62
  • Thanks: 0
Ok thanks, that would be a great feature request, but that brings me to my 2nd question, the email that goes out to the customer via Breezing Forms has an invoice number on it (Example Receipt #1755-7376 )

So Receipt #1755-7376 is in the email sent out but the stripe transactionid is not on there.

How can I relate the Receipt #1755-7376 back to transactionid 2yau8n1K9MaJMCek from stripe?

Where in the database are these two piece of data stored and related?

2yau8n1K9MaJMCek is stored under jos_faceilforms_records but where is the #1755-7376 stored? I saw this the api log shows "receipt_number": "1755-7376", in the payload but where is that in the mysql database?

I need a way to take that receipt number and relate it back to the transactionid of stripe and update my database backend.

Please Log in or Create an account to join the conversation.

Last edit: Post by shinzan.

Stripe EZ Mode, Record Transacton ID to custom table 3 weeks 2 days ago #253610

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 3733
  • Karma: 3
  • Thanks: 302
Hi,

please check if this is stored in #__facileforms_subrecords

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Stripe EZ Mode, Record Transacton ID to custom table 3 weeks 2 days ago #253611

  • Topic Author
  • shinzan
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 62
  • Thanks: 0
It is not, the only thing stored there is the fields of the actual form.

Please Log in or Create an account to join the conversation.

Stripe EZ Mode, Record Transacton ID to custom table 3 weeks 2 days ago #253623

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 3733
  • Karma: 3
  • Thanks: 302
Hi,

yep, the database is structured so that facileforms_records holds a line for each record that was made and _subrecords has a line for each element from the forms.

I will check where it is stored, and get back to you

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Stripe EZ Mode, Record Transacton ID to custom table 3 weeks 1 day ago #253670

  • Topic Author
  • shinzan
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 62
  • Thanks: 0
Ok disreguard on that, I can pull it from the API of Stripe.


Long story short:

Install composer and stripe-php json on your server

setup a webhook using github.com/Pellmellism/PHP-Stripe-Webhook-Script

This fantastic simple script to pull whatever you need when a payment succeeds, update your database or whatever you want, super simple and easy to read.

When this hook fires on the charge successful I find this stripe transaction id from the JSON data, then look up that value in the facileforms_records, then mark my other table paid and im good to go.

Thanks

Please Log in or Create an account to join the conversation.

Stripe EZ Mode, Record Transacton ID to custom table 3 weeks 1 day ago #253682

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 3733
  • Karma: 3
  • Thanks: 302
Hi,

ok, super!

I'm glad you did it :D

Regards,
Tihana

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Time to create page: 0.039 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!