QuickBooks Online Integration

Overview

Quickbooks online is a cloud accounting service developed by the authors of the most popular solution for the small business accounting in the USA. Quickbooks plays a big part in conducting e-commerce and more than 30 millions users all over the world proves its effectiveness.

The QBO Integration add-on is meant for synchronization of products, orders and users with the QBO service.

Tasks carried out by the add-on:

  1. Transferring to QBO the new client data, update of the client data that already are present in QBO.
  2. Transferring to QBO the new order data, update of the order data that already are present in QBO.
  3. Transferring to QBO the new product data, update of the product data that already are present in QBO.

Tasks that are NOT carried out by the add-on:

  1. Exporting the pack of customers/orders to QBO
  2. Data transferring from QBO to CS-Cart and possible information duplication due to lack of two-way synchronization

The add-on is based on the QuickBooks PHP SDK

Creation of QBO Test Account

Check the work of Quickbooks Online System and add-on by Simtech Developmet by creating a Quickbooks test account:

  1. Register test account on Quickbooks website.
  2. Oserve the QBO pricing policy here.

Note

Simple start rate plan is not relevant as it doesn’t include an inventory support

  1. Fill in the nesserary fields and perform the primary settings to create the QBO test account.

Creation of the new QBO developers account

Create the Developer account

  1. Create the new account.

  2. On Inuit homepage the suggestion to create the QBO developer account will appear.

  3. Open the Dashboard and create an app.

  4. In order to use the production application, all conditions from Dashboard->Production->Keys & OAths must be fulfilled.

  5. Confirm your e-mail. Click the “Resend Verification Email” then open the Sign in & security page. Click the Verify button in the Email address field.

When all conditions are complete, Client ID and Client Secret will be available for production.

Compatibility

The add-on is compatible with CS-Cart and Multi-Vendor 4.5.0 and above.

Support

This add-on is developed and published by Simtech Development Ltd., a CS-Cart developer. You are guaranteed a quality add-on supported by the future versions. If you need help, please contact us via our help desk system.

Managing in the admin panel

Installing the add-on

Install Quickbooks Integration add-on on the add-ons list page (Add-ons → Manage add-ons). Click the + button in the top right corner, select an archive and click Upload & install. You can now find the installed add-on in the list of installed add-ons, just make sure it is set to Active.

Setting up the add-on

When the Developer Account is created and the add-on is installed, the necessary settings are available.

  1. Open the Website tab on the cs-cart admin panel and click on QuickBooks Online connection.
  1. In the Connection Settings tab insert the following data:

2.1 Client ID from QBO Developers (Dashboard->{app}->Production-> Keys & OAuth)

2.2 Client Secret From QBO Developers (Dashboard->{app}->Production-> Keys & OAuth)

2.3 Accounting Base URL

2.4 QBO ID for better interaction with the product (the products are written off incorrectly from the storage if the QBO Code is used)

  1. Copy the Redirect URL from the Token tab and insert it into Production > Keys & OAuth :: Redirect URIs
  1. Then acquire the token manually (Token tab)

As the steps above are successfully completed, the Token tab in cs-cart admin panel should look like this:

Note

Set up the cron to get the new tokens automatically as the tokes is valid for 60 minutes only (such Cron is present in the add-on settings)

  1. Check the connection with QBO (Test connection) prior to getting the accounts.
  2. Then acquire the QBO accounts on the Queue tab.
  1. Insert the Accounts, Payment methods, Taxes data on the Default accounts tab.

    7.1 Create the new QBO account if necessary.

    7.2 Create the QBO account of the particular type for it to appear in the list to select if none.

    7.2.1 Default Inventory Asset Account - create the new one, if necessary (at QBO Accounting > Chart of accounts)

    If necessary, than:

    Account Type = Other Current Asset

    Detail type = Inventory

    7.2.2 Default Income Account - create the new one, if necessary

    If necessary, than:

    Account Type = Income

    Detail type = Sales Of Product Incomes

    7.2.3 Default Expense Account - create the new one if necessary (at QBO Accounting > Chart of accounts)

    If necessary, than:

    Account Type = Cost of Product Sold

    Detail type = Supplies & Materials - COGS

After that all new users, products and paid invoices will be added to the line (it can be set up by cron or started manually (dispatch=qbo.read_queue))

Note

Beside the token update cron, the line reading cron can also be set up (cron is located in the add-on setting)

In order to allow vendors to conduct QuickBooks Online settings, the relative access must be provided via Vendors Priveleges add-on.