Rick 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
Victor Font Staff answered 2 years ago
The credit card field group stores its data as a serialized array as shown in the comment:
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:"";}
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.
Please login or Register to submit your answer
