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 https://jbitpro.com/Account/Login
  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!


Comments

Post a Comment

Self promotion not allowed. Comments with links to ERP systems other than JBitPro.com will be deleted.

Please respect others, and share your thoughts with the author. Criticism and critiques are welcome!

Popular posts from this blog

10 Reasons to Sign up for JBitPro ERP now!

You might be content with your current ERP solution, or you might not have one currently.  If you don’t have one, you might be thinking about how expensive an ERP solution is.  This is the one truth in the ERP market today.  Most are very expensive, when you add up all of the things you will need to get it working for your business.  So, what makes JBitPro different?  There are 10 things that make JBitPro different, and the one option you should give strong consideration to.  Let’s consider them, and you be the judge. 1. Simplicity Have you ever used SAP, or even seen their interface?  If you have, can you confidently say “I can setup and use SAP without the assistance of a consultant or expensive training?”  This is one of the key differences with JBitPro.  Our ERP is designed to be simple, and to prove it we want you to see our simple interface for free.   Sign up for you free 30 day trial  and have a look at how simple our system is. 2. Cost of Ownership If you have ever lea
Post a Comment
Read more

Why Choose Managed IT Services?

Why would anyone want to hire a IT consultant to handle complex technology needs for their business?  Doesn’t it make more sense to hire a full time IT person to make sure everything is running tip top? These are questions well worth their weight in gold.  Any smart business owner or leader serves their company well by pondering these questions.  If you are to succeed you must have the right technology in place.  And it must be reliable! Communications At the core of your business, is the need to communicate with your clients and employees.  This means you must have a set of tools that allows your team to engage those customers and personnel that keep things moving forward positively.  With the increased reliability and security offered by big cloud providers at an affordable price, it makes sense that companies are flocking to services such as Office365 and Google S-Suite for their company email and inter-office communications platforms.  This doesn’t mean that everything is
2 comments
Read more

4 Myths About ERP - DEBUNKED!

You know the reasons to get an ERP to run your business, but are plagued with the common fears of all businesses when selecting the right one for your needs.  I'm here to tell you that you're wrong! All ERP Systems are Expensive Of course this is the most easily proven belief when it comes to choosing an ERP system.  You don't have to look very long before you find that ALL of the top brands in the ERP game are going to cost you a large portion of your revenue to implement and maintain.  For this reason it makes getting an ERP almost impossible for most businesses, and for small businesses trying to stay on top of things it could be "the nail in the coffin". But why do all of the top brands in the ERP market charging so much for their solution?  Are they worth it?  The simplest answer is, they have a Name that you brag about.  "I'm in charge of company X and I use SAP to run my business!"  You paid for those bragging rights.  What else do you
Post a Comment
Read more