Import Items: Difference between revisions

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Jump to navigation Jump to search
No edit summary
 
(9 intermediate revisions by 5 users not shown)
Line 1: Line 1:
[[Items]] in CommitCRM are a catalog of all the services and products you offer. The Items list in CommitCRM acts as your price list.
{{importandexport}}
__TOC__
<br>
==Before importing your items==
Before you import your Items for the first time, we recommend that you go over the following checklist to make sure you perform the import in the most efficient way


There are three types of Items in CommitCRM:
* '''Taxes''' – using Taxes in RangerMSP is optional. If you plan on using Taxes within RangerMSP, this requires defining the relevant Tax code per Item. Before importing Item, you can define the default Tax Code which should be used for newly created Items, to make sure all imported Items will already have the correct Tax code defined for them. [[Charges#Charging_Using_Taxes|Click here]] to learn more about using Taxes within RangerMSP, and defining the default Tax Code for Items.
 
* '''Backup your database''' – it is very important to backup your data before performing any imports. This will assure that you can undo the import if needed very easily. [[Backup_and_Restore_FAQ|Click here]] for more details about performing a backup to your database
<br>
 
==Importing Items==
 
[[Items]] in RangerMSP are a catalog of all the services and products you offer. The Items list in RangerMSP acts as your price list.
 
There are three types of Items in RangerMSP:
#'''Parts Items''' - hardware, software, or any other items you ship to your customer. These items have fixed prices.
#'''Parts Items''' - hardware, software, or any other items you ship to your customer. These items have fixed prices.
#'''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.
#'''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.
Line 12: Line 25:
#Select the type of file to import.
#Select the type of file to import.
#Select the type of Item to Import (Product/Expense/Labor).
#Select the type of Item to Import (Product/Expense/Labor).
<br>
==ReImporting/Updating Your Items List==
Note that the Item Code field is a unique key for items. This means that you can re-import your Items in case you wish to update any values in your items list (such as prices), and they will be updated according to the Item Code in the input file.
<br><br>


==Importing Items from QuickBooks==
==Importing Items from QuickBooks==
When the [[QuickBooks Link|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.
When the [[QuickBooks Link|RangerMSP-QuickBooks Link]] is in use, you can import items from QuickBooks into RangerMSP or link existing Items in RangerMSP to existing Items in QuickBooks. Changes to Items will then be synchronized between RangerMSP and QuickBooks.


It is recommended to read the [[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 [[QuickBooks Link|QuickBooks user manual]] before starting to work with the RangerMSP-QuickBooks Link. In this manual you can find initial setup instructions for the RangerMSP-QuickBooks Link, as well as how to synchronize information between RangerMSP 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:
However, if you are already familiar with the initial settings for the RangerMSP-QuickBooks link, the following will help you to import Items from QuickBooks into RangerMSP Items:


#'''It is recommended to perform a full BACKUP of CommitCRM before importing Items from QuickBooks.'''
#'''It is recommended to perform a full BACKUP of RangerMSP before importing Items from QuickBooks.'''
#If all your Items are already in CommitCRM, <u>do not</u> 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, [[QuickBooks Link#Link Item To QuickBooks Service / Part/Assembly / Other Charge Item|click here]].
#If all your Items are already in RangerMSP, <u>do not</u> use this import feature until you have created links between existing records in RangerMSP and their related records in QuickBooks. To learn more about how to create these links, [[QuickBooks Link#Link Item To QuickBooks Service / Part/Assembly / Other Charge Item|click here]].
#In the Items window, go to the QuickBooks drop down toolbar menu and select '''Import New Records/Update Linked Records from QuickBooks'''.
#In the Items window, go to the QuickBooks drop down toolbar menu and select '''Import New Records/Update Linked Records from QuickBooks'''.
#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.
#The import wizard will open and you should select the QuickBooks records you would like to import into RangerMSP. By default, all active Items are imported.
#Click '''Finish''' and the Items will be imported from QuickBooks into CommitCRM.
#Click '''Finish''' and the Items will be imported from QuickBooks into RangerMSP.


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


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


==See Also==
==See Also==
*[[QuickBooks Link|Commit-QuickBooks Link]]
*[[QuickBooks Link|RangerMSP-QuickBooks Link]]
*[[Items]]
*[[Items]]
*[[Charges#Charging_Using_Taxes|Using Taxes]]
*[[Backup_and_Restore_FAQ|Backup & Restore FAQ]]
*[[QuickBooks Link|QuickBooks user manual]]


[[Category:New Users]]
[[Category:Items]]
[[Category:Items]]
[[Category:QuickBooks]]
[[Category:QuickBooks]]
[[Category:Import and Export]]
[[Category:Import and Export]]

Latest revision as of 08:33, 8 July 2020

Import and Export > Import Items


Before importing your items

Before you import your Items for the first time, we recommend that you go over the following checklist to make sure you perform the import in the most efficient way

  • Taxes – using Taxes in RangerMSP is optional. If you plan on using Taxes within RangerMSP, this requires defining the relevant Tax code per Item. Before importing Item, you can define the default Tax Code which should be used for newly created Items, to make sure all imported Items will already have the correct Tax code defined for them. Click here to learn more about using Taxes within RangerMSP, and defining the default Tax Code for Items.
  • Backup your database – it is very important to backup your data before performing any imports. This will assure that you can undo the import if needed very easily. Click here for more details about performing a backup to your database


Importing Items

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

There are three types of Items in RangerMSP:

  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).


ReImporting/Updating Your Items List

Note that the Item Code field is a unique key for items. This means that you can re-import your Items in case you wish to update any values in your items list (such as prices), and they will be updated according to the Item Code in the input file.

Importing Items from QuickBooks

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

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

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

  1. It is recommended to perform a full BACKUP of RangerMSP before importing Items from QuickBooks.
  2. If all your Items are already in RangerMSP, do not use this import feature until you have created links between existing records in RangerMSP 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 RangerMSP. By default, all active Items are imported.
  5. Click Finish and the Items will be imported from QuickBooks into RangerMSP.

From this point on, you can synchronize changes to Items between RangerMSP 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 RangerMSP-QuickBooks Link for the first time.

See Also