Congratulations – now that you’ve installed WooCommerce Sync for QuickBooks Desktop, you can begin with the initial setup / configuration of your settings and mappings!
- Haven’t connected to QuickBooks yet? Here’s how to initially connect to QuickBooks.
- Check out our Setup Video that walk you through each step of setup – from start to finish!
1. Refresh Background Data
Once you’re first connected to QuickBooks Desktop, the first step is to pre-load our integration with some current QuickBooks data, like the latest lists of customers, products, etc.
This data is used in your settings / mappings, and when we sync new data to QuickBooks. Don’t worry, refreshing data doesn’t sync anything, we’re just preloading our integration with this background data.
- Go to MyWorks Sync > Refresh Data.
- Turn on the switches for the data you wish to refresh, then save. If this is your first time connecting to QuickBooks, all the switches should be turned on.
- Visit the QuickBooks Web Connector on your computer, and click Update Selected to run a sync. You’ll see a log of activity in MyWorks Sync > Log, while you wait for the progress bars to complete.
- Once the progress bars in the Web Connector show 100%, the refresh data is complete. Visit MyWorks Sync > Refresh Data and turn all the switches off before running the Web Connector again.
NOTE: The AutoRun checkbox in the Web Connector should NOT be enabled while refreshing data. This is to ensure that the Refresh Data request fully completes instead of being automatically looped to start over again.
For more information on how the Refresh Data works, and when you need to refresh data, see our article here.
2. Configure Default Settings
Now that all QuickBooks data is loaded in our integration, it’s time to review your settings!
- Visit MyWorks Sync > Settings to view your settings panel.
- Set and save the Dropdowns in the first Default tab. All of these must be filled out.
- Check the Order tab and set the first option to choose syncing orders as an Invoice, Sales Receipt, or Sales Order.
- Check the Tax tab to assign default tax codes. All of these must be filled out.
- Check the Automatic Sync tab to choose the data you would like to be automatically added to the Queue to sync into QuickBooks when the Web Connector runs.
All other settings are optional and can be left as is, unless specific extra functionality is required, and you understand the functionality of a setting you’re enabling.
Want a complete summary of our settings panel? Check our documentation about configuring your default settings here.
3. Map Existing Data
Now that your settings are confirmed, the last step is to map your existing customers, products, payment gateways and tax rules, then you’ll be all set to go!
- Visit MyWorks Sync > Map > Customers. Only customers that exist in both systems need to be mapped, as we will automatically sync over future customers the next time they order. You can use the AutoMap by Name/Email buttons to automatically map all customers that have a matching name or email in both systems.
- Visit MyWorks Sync > Map > Products. Only products/variations that exist in both systems need to be mapped, as we will automatically sync over future products/variations when they’re added/edited. You can use the AutoMap by Name/SKU buttons to automatically map all products/variations that have a matching name or SKU in both systems.
- Visit MyWorks Sync > Map > Payment Methods. For each active gateway in WooCommerce, there will be shown a section to enable payment sync. You only need to enable payment syncing for gateways you’d like to sync payments to QuickBooks for. Be sure to choose a valid Bank Account in QuickBooks to deposit the payment into.
- Visit MyWorks Sync > Map > Taxes, if you charge taxes in WooCommerce. Each tax rate simply needs to be mapped to a QuickBooks Sales Tax Item with the same rate.
For more information on mapping data, read our Mapping Documentation Page.
Congratulations! Configuration is now complete. New orders will automatically sync to QuickBooks, and you can push over old orders in MyWorks Sync > Push.
Check Your Logs
Now that you’re ready to sync, on’t forget to keep an eye on your logs in MyWorks Sync > Logs to see the syncing activity that takes place. For more information about the Logs, go to our logging documentation.
Review Syncing Methods
We also recommend you take a moment to familiarize yourself with how our integration syncs data to and from QuickBooks! To learn more about how syncing works with the WooCommerce Sync for QuickBooks, check out our ‘How does syncing work with our sync?’ documentation page.
Pushing existing data to QuickBooks
Need to push existing products, orders, customers, or inventory levels from WooCommerce to QuickBooks? Check out our pushing documentation page.