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

Let's Hire a Consultant! Why that is a bad idea...

You're in the market for an ERP system.  You have narrowed your search down to 3 major brands, SAP, Oracle Netsuite, and SAGE.  You are reviewing the costs involved, and to this point are still unsure of which one to pick.  Each of those above have the same recurring problem that makes it very hard to decide which platform to go with.  They all have the same core benefits - the promise of making more money by managing your P&L closely, and automating the important tasks that keep your business alive.  But when you balance the cost vs the increased revenue it will bring, by reducing your losses and increasing your efficiency, you find that the increased revenue will cover the new ERP system.

This is where the ERP supplier has done their homework.  You need an ERP, and you need one now.  You start contacting the ERP providers on your list, and they all give you the sales pitch about what their system can do, over the other guys.  How much you will save by going with their option,…

10 Ways To Save Money Using ERP

If you are looking for reasons to buy an ERP to manage your business, and you need more information about the benefits, you need to read our new eBook.  Get your copy for FREE by simply clicking this link:  10 Ways To Save Money Using ERP

We know the difficulties associated with finding the right ERP system, and how expensive it can be to purchase the right tool.  Too many ERP vendors are taking advantage of businesses by charging outrageous prices.  Read the eBook for information you need to make the right choice.

Family Time is VERY Important!

It's the beginning of another new year, and you have a long list of things that you want to accomplish.  One of those things is more important than any of the others.  More important than making more money, more important than loosing weight, more important than exercising more.  What is important that these other goals, so much that it makes them seems small in comparison?  Spending more quality time with your family!  It is one of the most sought after goals around the world, year after year.  We say it every year "This is the year I spend more time with my family!"  And year after year we can't find the way for this goal to be accomplished.
The Problem... To accomplish anything in our lives we must take time away from other pursuits, and use that "bought" time to work on our goal.  Why is this a problem?  All of us have said these words at some point "...there just isn't enough time in the day..."  This is a common problem for anyone who is…