QuickBooks Commerce supports importing products (configurable and simple type) from your Magento Store. Currently, we do not support Magento 2.0 on QuickBooks Commerce yet. However, some of our users have been able to bridge the gap between Magento 2.0 and QuickBooks Commerce by connecting CartRover via API. Click here to learn more.
QuickBooks Commerce imports Configurable products as Products and Simple products, that belong to the respective configurable products, are imported as Variants. For Simple products that do not belong to a configurable product, QuickBooks Commerce imports them as a single product with a single variant.
This guide will take you through the steps needed to get started:
Before setting up the QuickBooks Commerce Magento integration, ensure that:
- All product SKUs are unique
- All simple products only belong to one configurable product
- All simple products have the following product attribute:
- Under “System > Configuration”, then under “General > Web”, the base URL (secure/unsecured) is correctly set to your website domain.
- A QuickBooks Commerce XML/RPC SOAP user is created
Export Magento product data to CSV
QuickBooks Commerce uses your exported Magento product CSV to import your Magento products into QuickBooks Commerce.
To export your product data to CSV on Magento, first log into your Magento Admin, then go to “Systems > Import/Export > Export”. On the “Entity Type” select dropdown, select “Products”. Following at the bottom of the page, click on “Continue”.
Wait for Magento to create a .CSV file and click save when ready to download the product data CSV.
Setting up QuickBooks Commerce-Magento Integration
Login to QuickBooks Commerce, on the side menu, click on “Apps”. On the App Store page, click on Magento and proceed to install Magento.
Insert your Store URL, SOAP Username, and API token.
(Store URL can be found on Magento Admin Panel>System>Configuration>Web>Secure/Unsecure>Base URL)
Set up which Magento Stock Location you wish to sync your stock to, or you can create a new location.
Select the Price List to sync your Magento 'Retail' prices.
Next you need to decide how to import your products from Magento.
Option 1: Import my products from Magento
All of your products from Magento will be imported into QuickBooks Commerce if you select this option. Follow the next steps to import your products. The Import option requires a CSV from Magento, (On Magento: System->Import/Export->Dataflow – Profiles->Export All Products) export CSV" Option in the Magento Integration Setup Guide). Use this spreadsheet during the Import process. This way, SKUs that only exist in Magento can be created in TG. The Variants then will be linked between QuickBooks Commerce and Magento.
Option 2: Match my products from Magento (No CSV needed)
Select this option only if you have previously integrated Magento (may be deleted) OR if you have an existing Magento integration and you are trying to connect another Magento account that has the same products as your first one.
If you choose to match your products it is important to note that products are matched first by product name and then by SKU so it is advisable to ensure your products' names on Magento and QuickBooks Commerce are identical.
For example, let's say you created a product 'Red Shirt' in Magento. As new products will not automatically be imported in QuickBooks Commerce, if you create 'Red Shirt' in QuickBooks Commerce as well and publish it, it will result in duplicates on Magento. To avoid this and to ensure that your products are linked in QuickBooks Commerce and Magento without any duplicates:
1. Create the exact same product in QuickBooks Commerce (Same product name and SKU)
2. Delete the product in Magento
3. Publish the product from QuickBooks Commerce to Magento
Products that do not exist in QuickBooks Commerce will not be pulled from Magento.
Option 3: Don’t import products from Magento
If you do not want all of your products imported over from Magento and would prefer to select which ones to import at a later time, select this option.
Choose if you want to enable or disable your integration. If you choose to enable your integration QuickBooks Commerce will import orders created on Magento. Your products will also be synced between QuickBooks Commerce and Magento.
If your csv file consists of hundreds or thousands of line items, this might take a while.
Now to complete your Magento integration, you must set up your Initial Cost Price promptly.
To do so, click to import your initial cost prices now and you will be taken to the import price list page.
You can check the import progress via the Dashboard in your Magento Channel integration section in your QuickBooks Commerce account.