December 8, 2018 at 7:09 pm #17333
I’m transitioning from another invoicing solution to invoiceninja.com. All customer and default card information is currently stored in Stripe, which is now linked with Invoice Ninja as the primary gateway.
Is there any way to import the Stripe customer and default card information into Invoice Ninja? While I plan to recreate each customer’s recurring billing plan in Invoice Ninja, it would be a huge help if customers could avoid having to re-enter their card information.
Thanks!December 8, 2018 at 7:15 pm #17334
Yes, you can export your customer list from Stripe and then import it into the app.
The clients need to exists first and are matched up by their email address.December 8, 2018 at 7:40 pm #17335
Thanks for the quick reply.
I exported the customer list from Stripe and was able to successfully import clients, though not sure how to get the card information on file within Invoice Ninja. When viewing the clients via the portal, they don’t appear to have a credit card on file.
Would this process be required to import the credit cards? https://stripe.com/docs/security/data-migrations/exports
I realize it’s intended for migrating away from Stripe as opposed to an integration partner, but not sure how else to go about it.December 8, 2018 at 7:41 pm #17336
Did you select ‘Stripe’ in the Invoice Ninja import?December 8, 2018 at 7:45 pm #17337
I did, but the import failed, so used CSV instead. (Testing with only one client at the moment.)
I was using an export with “All columns” from Stripe, so tried again with the default 5 columns, but still failing. 🙁
“The following records failed to import, they either already exist or are missing required fields.”December 8, 2018 at 7:47 pm #17338
Does a client exist with a matching email address?December 8, 2018 at 7:49 pm #17339
A deleted (archived) client did exist due to testing, so I tried with another client that did not yet exist and the import is still failing for some reason (both with default and all column Stripe exports).December 8, 2018 at 7:51 pm #17340
An active client needs to exist with a matching email address for the card to be imported.December 8, 2018 at 8:04 pm #17341
I see, so the client needs to exist in both Invoice Ninja and Stripe, then when importing the Stripe file the card will be imported by matching the email address?
I’ve recreated an active client in Invoice Ninja with a matching email address, but when importing the Stripe file the import is still failing (same error message) and unfortunately no card details in the portal.December 8, 2018 at 8:12 pm #17342
Yes, that’s correct.
Sorry, not sure…December 8, 2018 at 8:39 pm #17343
Hmmm… Any other way to match up the card information? This would be a major roadblock to our Invoice Ninja transition 🙁December 8, 2018 at 8:40 pm #17344
Not that I’m aware of, not sure why it isn’t working…December 8, 2018 at 9:18 pm #17347
Understood. Thanks very much for your quick help on this!
What should our next steps be to try to get this resolved? Is there somewhere we should submit a support ticket?
Are you able to recreate the issue on your end?December 8, 2018 at 9:43 pm #17350December 8, 2018 at 9:52 pm #17352
Sent – let me know if you need anything else.December 9, 2018 at 6:21 am #17353
Thanks for the sample file! It worked correctly in my test.
All I can suggest is making sure the email address in the file matches the email address for your client in the app.December 9, 2018 at 2:02 pm #17359
So when you imported the sample Stripe file you were able to see card information in the Invoice Ninja portal for that client? Did you receive the “The following records failed to import, they either already exist or are missing required fields” email message?
I’ve tried again with the same file and multiple other clients but having the same issue 🙁 Triple checked that the emails match on each attempt. We’re currently on the trial version but ready to upgrade to Enterprise if we can get this figured out!December 9, 2018 at 3:03 pm #17360
I received an email stating “Successfully created 1 customers” and I saw a “View in Stripe” button on the client overview page.
Sorry, not sure…December 9, 2018 at 5:14 pm #17361
I purged all account data and archived/re-added Stripe as the primary gateway and now finally getting some success!
When trying to add a new client in Invoice Ninja with this email format, I’m unable to save due to the “The part following ‘@’ should not contain the symbol ‘;'” error message. Is there any way around this limitation?
Ideally I’d add all existing clients with the current “;” format, import from Stripe to match up clients/cards, then clean up clients in Invoice Ninja by separating the email addresses into separate contacts.
Thanks again for your help!December 9, 2018 at 6:04 pm #17362
Never mind, figured this out via the Client import.
Thanks so much for the great support. Upgrading to Enterprise shortly!December 9, 2018 at 6:12 pm #17363
Glad to hear it’s working!
You must be logged in to reply to this topic.