Importing Customers list from quick book online version

[harish_ps]

Hi all,

Please recommend a process/extension to import the only Customer from the quick book online version to Magento 2.3.x

Harish

[theMageComp]

Hello @harish_ps 

Check these extensions, 

https://marketplace.magento.com/magenest-module-quickbooksonline.html

https://store.webkul.com/magento2-quickbooks-qbo-connector.html

[Robert Rand]

Hi Harish,

If you only need to import the customer list, and you aren't worried about connecting product or order data, you may not need an extension.

You can start by exporting the data from Quickbooks to a CSV file. Here are some instructions, although, you can always reach out to Quickbooks support if you need assistance: https://quickbooks.intuit.com/learn-support/en-us/import-or-export-data-files/export-customer-data-t...

You can then import that data into Magento 2.3 using these instructions: https://docs.magento.com/m2/ce/user_guide/system/data-import.html

You'll need to copy the data from Quickbooks into the Magento CSV format so that it can be uploaded to Magento.

Best of luck!

[harish_ps]

Thanks, @Robert Rand for the suggestion.

I have follow-up clarification, we have 35,000 Customers to import, do you have any other suggestion... 

Sorry to ask follow-up question...

[Robert Rand]

That's not a small data set. My concern would be whether or not your hosting environment could handle the CSV import, but that would be the case even if you used an import extension, like https://marketplace.magento.com/commerceextensions-module-advancedcustomer-import-export.html, inste... of native Magento (this extension has some extra features). Depending on your hosting environment, you might experience timeouts.

Alternatively, you could load the customers through Magento's API, which is easier to throttle. You could do this manually, or you could use a paid service, like Lit Extension. That would save you from needing to set up a custom process for a one-time data migration.