Skip to main content

How to lmport Customers into JBit Pro Cloud ERP

One of the most important aspects of any ERP system is the ability to import data. You likely have a large list of customers, either in a spreadsheet or another database.  So how do you get those customers into JBit Pro Cloud ERP?

The Template

We have designed the system to provide a template for you on demand.  The system allows importing a CSV format.  And the necessary fields are included in the template you will download as part of these instructions.

To download the template:

  1. Login to your Account at
  2. Go to the Data Import tab
  3. Click on "Customers"
  4. Click on "Click here if you need the template"

  5. Fill in the downloaded CSV Template (copy paste your data to it)

    Important CSV Fields:
    • CustomerId - The database will make sure that the Contact has the correct value here.  The column is required, and it doesn't require any value.
    • CustomerName - This is the Name of the Company you are importing to the Database.  A value is required for this column and should be the "Company" to associate contacts with later.
    • Address1 - This is the Address for the company you are adding, and it is required.
    • Address2 - This is used for additional company address information, and it is not required.
    • City - This is the name of the City for your Customer (example: Houston), and it is required.
    • StateId - This is the "ID" for the state that your customer is associated with.  It is a Numeric value, and the list of states and values can be found here:  States
    • ZipCode - This field is required, and it is the postal code for your customer
    • Phone - This field is required. If you don't have the phone number, use something like 0000000000
    • Website - This field is not required.
  6. Save the Template
  7. Login into your JBit Pro Account
  8. Go to the Data Import tab
  9. Click Customers
  10. Click "Choose File"
  11. Select your CSV template (from step 5)
  12. Click Upload

Let us know if you find any problems while uploading your Customer data, and enjoy your ERP experience!

Popular posts from this blog

What is the Best Way to Manage Inventory?

This question has many answers and really depends on the type of business you are running.  If you are dealing in perishable goods, such as food or medication, you will want to employ the FIFO method for your inventory.  If you are in the manufacturing business you will want to use JIT method.  There is also EOQ, if you are into forecasting.  If your inventory moves in waves or surges of demand, such as during seasonal times, you may use Safety Stock.
Help for Managing Inventory Before we dive into the details of inventory management types, lets consider a few options to implementing them.  Let's consider your options, you could use good old fashioned pencil and paper, if you never make any mistakes.  Most people choose a software solution to assist in managing their inventory, as it automates things such as reorder points and reminders when stock is low.  One option, and the only one we will suggest here is a new one, and it is Free for a limited time, it is JBit Pro ERP.  A clou…

Top 7 Things you MUST do When Selecting a Vendor

There are several reasons a business might be selecting a vendor, and the 2 most common are:

To replace an existing, failing or outdated To fill a need for new materials or services Both of these reasons, and any others, should follow the same process for selecting a vendor.  There are 7 things you must do to select the right vendor: We need to define the problem to solveCreate scenarios that must be tested Test the scenarios against new vendorDefine a time line for selecting the new vendorDefine a budget for the materials/services provided by the vendorGet feedback from your employees on the vendor shortlistCheck the vendor's social media and market ratings Since scenarios are one of the major components to selecting a new vendor, we will discuss them a bit more.  The scenarios should include all of the important issues that you are currently experiencing.  An example of problems to solve might look something like this:
Need Service on demand (24/7 service)Need to have monthly billi…

How to import inventory with JBitPro Cloud ERP

One of the first few things you will need to do in your new ERP System, is to import your customers and inventory.  This will allow you to easily move forward with your business, with out much effort.  If you haven't looked at the "How to import customers into JBitPro Cloud ERP", then click the link above.
Simple Import Process First thing you will need to do is download the Inventory template, and then paste your inventory into the provided columns.  To do this, click the yellow "Click here is you need the template" button.
So let's get started!

Login to your JBitPro accountGo to the "Data Import" module (tab)
Next, click on ItemsDon't forget to download the template if you don't already have it
Paste your inventory items into the template columnsBe sure to include the Id for column "UOMId", possible values are listed here.
Once your template is filled in, click the "Upload" button
Conclusion We hope you find this to be th…