You have a couple of options when creating a new customer or updating an existing customer record. You can access your customer list by following the Customers link on the dashboard or navigating to the Sale Module. Then you can create a new customer or viewing an existing list.

How to create a new customer through the user interface:

  • Select the New Customer option.
  • Within the New Customer screen you will be required to fill all fields marked with the red asterisk in order to save this customer in the system.

  • Starting from the very top you will be required to fill the customer name and select their status.

  • There are two statuses available, either active or deprecated. When deprecated status is selected for a customer, that customer does not show up in any of the lists unless specified otherwise. You also have the ability to delete deprecated customers as long as they don’t have any transactions associated with them.


  • Next is the currency. You will need to identify the currency in the customer uses. When this currency is different to your base currency, currency conversion would take place when creating a sale for this customer.


  • Next is Payment Term. You will need to set up the payment terms within the Settings and Reference Books area before being able to use them within the customer record.


  • Account Receivable refers to the Chart of Accounts, which is sourced from the accounting application. If you are unable to see any accounts in this drop-down, it means that you first need to create them in the accounting application, sync them over to DEAR Inventory, and then you will be able to pick them up on the Customers screen.


  • The same applies to the sale account. This is driven by the Chart of Accounts, which is first generated in the accounting application. The same applies to the Tax Rule. You can change the name of the tax rule in Settings and Reference Books.


  • You then have the ability to set a price tier that will apply to this customer. There are up to 10 price tiers available in the DEAR Inventory Large plan. You can rename these price tiers however you like and you can do this in Settings and General Settings.


  • You then have the ability to attach a sales representative to this customer as well as a default carrier and default location. You can provide a tax number and discount percentage if applicable as well as the credit limit.


  • The credit limit has a couple of applications. It can either notify you that their credit limit has been reached at the time of creating the sale order for that customer or it can physically stop you from processing the particular sale order if the credit limit has been reached.


  • Next, you are able to set an Additional Attribute set. Additional attributes can be set in Reference Books and then picked up within the customer record. Additional attributes allow you to store information regarding the customer, if there are no generic fields available in the system.


  • You also have the ability to add a number of tags to the customer separated by a comma. If you would like to classify your customers you can categorize or group your customers. You can specify the tags in the customer record and be able to search based on the tag at a later point in time.


  • You can also attach comments to this customer and use that information to fill various documents. You can attach multiple addresses for the customer. The addresses have types associated with them.

Address Types:

  • Billing
  • Business
  • Shipping

You will need to make sure that you specify an address for this information to be picked up on the relevant documents that are produced for this customer.

You can add multiple contacts per customer record. Once you have specified a contact, you can select a particular contact to be a default contact when generating a document for this particular customer.

Entering as much information as possible for the customers will save you a lot of time when actually generating sale orders or any other types of documents for the customers as this information will automatically appear on the documents. Once you have  entered all this information, you can save the customer and this customer can now be used to produce sale orders or sale invoices.

Another way to add customers to the system:

  • Return to View All customers list.
  • There are two functions here:
    • Import
    • Export
  • If you don’t have any customers in the system at all, you will need to navigate to Import and select the Customers template.

  • You will need to download this CSV template to your computer.
  • Provide all the customer details in the template.
  • Save the template.
  • Then use the Browse function and Upload function to upload the data into DEAR Inventory.

You should not change any of the column headers. You should not delete them or change their names. If you don’t have any data to put into that particular column, simply leave it blank.

If you already have customer records in the system and you would simply like to import multiple addresses for those customers, you can download the Customer Addresses template.

For example if you had four different addresses that you wanted to specify for a particular customer.

  • You would need to repeat the customer details four times 
  • Then enter the various addresses. 
  • Then complete the rest of the information.
  • Save the data in the template 
  • Then use the Browse and Upload function to upload the data into DEAR Inventory. 

This will automatically update all customer addresses in bulk rather than having to enter them in individually at the customer record.

You can also use the Export function to bulk update a customer list already in DEAR Inventory as well as customer addresses.

  • Export the list into an Excel file.
  • Make all the relevant changes within the template:
    • Changing the status for example for bulk clients.
    • Changing the currency, payment terms, any of the details that appear in this template.
  • Saving those changes
  • Then, as in the previous scenarios, using the Import function to upload the relevant template.