Import Items: Difference between revisions

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Jump to navigation Jump to search
Line 14: Line 14:


==Importing Items from QuickBooks==
==Importing Items from QuickBooks==
When the [[Commit-QuickBooksLink]] is in use, you can import items from QuickBooks into CommitCRM or link existing Items in CommitCRM to existing Items in QuickBooks. Changes to Items will then be synchronized between CommitCRM and QuickBooks.
When the [[Commit-QuickBooks Link]] is in use, you can import items from QuickBooks into CommitCRM or link existing Items in CommitCRM to existing Items in QuickBooks. Changes to Items will then be synchronized between CommitCRM and QuickBooks.


It is recommended to read the [[Commit-QuickBooks Link|QuickBooks user manual]] before starting to work with the Commit-QuickBooks Link. In this manual you can find initial setup instructions for the Commit-QuickBooks Link, as well as how to synchronize information between CommitCRM and QuickBooks.
It is recommended to read the [[Commit-QuickBooks Link|QuickBooks user manual]] before starting to work with the Commit-QuickBooks Link. In this manual you can find initial setup instructions for the Commit-QuickBooks Link, as well as how to synchronize information between CommitCRM and QuickBooks.

Revision as of 10:38, 29 July 2009

Items in CommitCRM are a catalog of all the services and products you offer. The Items list in CommitCRM acts as your price list.

There are three types of Items in CommitCRM:

  1. Parts Items - hardware, software, or any other items you ship to your customer. These items have fixed prices.
  2. Labor Items - services you provide to your customers, such as server installation, network installation, on-site technician visits, etc. Each Labor Item can have a fixed price, a fixed hourly rate, or a dynamic hourly rate that varies depending upon the employee who performs the service.
  3. Expense Items - used to charge expenses, such as travel and special deliveries. Expense Items can have a fixed price per unit or a fixed hourly rate.

Items can be imported from various data sources including Excel® files, CSV files, QuickBooks, etc.

To import Items:

  1. Open the Items window and select Tools > Import & Export > Import Items.
  2. Select the type of file to import.
  3. Select the type of Item to Import (Product/Expense/Labor).

Importing Items from QuickBooks

When the Commit-QuickBooks Link is in use, you can import items from QuickBooks into CommitCRM or link existing Items in CommitCRM to existing Items in QuickBooks. Changes to Items will then be synchronized between CommitCRM and QuickBooks.

It is recommended to read the QuickBooks user manual before starting to work with the Commit-QuickBooks Link. In this manual you can find initial setup instructions for the Commit-QuickBooks Link, as well as how to synchronize information between CommitCRM and QuickBooks.

However, if you are already familiar with the initial settings for the Commit-QuickBooks link, the following will help you to import Items from QuickBooks into CommitCRM Items:

  1. It is recommended to perform a full BACKUP of CommitCRM before importing Items from QuickBooks.
  2. If all your Items are already in CommitCRM, do not use this import feature until you have created links between existing records in CommitCRM and their related records in QuickBooks. To learn more about how to create these links, click here.
  3. In the Items window, go to the QuickBooks drop down toolbar menu and select Import New Records/Update Linked Records from QuickBooks.
  4. The import wizard will open and you should select the QuickBooks records you would like to import into CommitCRM. By default, all active Items are imported.
  5. Click Finish and the Items will be imported from QuickBooks into CommitCRM.

From this point on, you can synchronize changes to Items between CommitCRM and QuickBooks using the Update linked record option in the QuickBooks menu.

Again, it is recommended to read the QuickBooks user manual before starting to work with the Commit-QuickBooks Link for the first time.

See Also