Import Credit Card Fields

By: Rick Warda | Asked: 02/04/2023
ForumsCategory: How-toImport Credit Card Fields
Rick WardaRick Warda asked 2 years ago
I had to do a mass update a bunch of entries.
I figured the easiest way would be to export to .csv, then import back with the field adjusted since there is no "Bulk Field Update" feature in Formidable.
However,  we keep our customer's Billing Addresses and Credit Card info on file (not CVV of course)
I just read that I could import the billing info back by formatting all the address fields into one column separated by commas.
But what about the Credit Card number & exp dates?

I don't see that in the formidable documentation.
Has anyone successfully done this?   Thank You, Rick
1 Answers
Victor Font answered 2 years ago
The credit card field group stores its data as a serialized array as shown in the comment:
Victor Font replied 2 years ago

a:4:{s:2:"cc";s:16:"xxxxxxxxxxxx5638";s:5:"month";s:2:"10";s:4:"year";s:4:"2025";s:3:"cvc";s:0:"";}

Victor Font replied 2 years ago

The credit card field provides 4 options for saving a credit card number. One of these options is to save the entire credit card number, which is not recommended. Saving a credit card number to your database subjects you to PCI compliance. This means if you store credit card details in your WordPress database, the credit card numbers either have to be masked to display only the last 4 numbers of the CC as the default Formidable option does, or you need to encrypt the credit card number if you store the full credit card number. Please see this: https://formidable-masterminds.com/encrypt-decrypt-formidable-form-fields/#What_is_PCIACH.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right