Biz School

Created with Sketch.

How can we help?

  1. Welcome to Bizuno-U
  2. FAQs
  3. Quick Start
    1. Installation
    2. Configuration
    3. Your Dashboards
    4. Your First Product
    5. Your First Purchase
    6. Your First Sale
  4. Working With Bizuno
    1. Navigation
    2. Dashboards
    3. Currencies
    4. Locale
    5. Settings
  5. Users Guide
    1. Customers
      1. Manager
      2. CRM Manager
        1. Promotion Manager
      3. Sales Manager
        1. Request for Quote
        2. Sales Order
        3. Sale
        4. Credit Memo
      4. Prices
      5. Amazon Interface
        1. Uploading Inventory
        2. Downloading Orders
        3. Confirm Shipments
        4. Reconciling Payments
      6. Order Fulfillment
      7. Returns Manager
      8. Reports and Forms
    2. Vendors
      1. Manager
      2. Purchase Manager
        1. Request for Quote
        2. Purchase Order
        3. Purchase
        4. Vendor Credit Memo
      3. Prices
      4. Reports and Forms
    3. Inventory
      1. Manager
        1. Accessories
        2. Attributes
        3. Images
        4. Options
        5. Vendors
      2. Assemblies
      3. Adjustments
      4. Build Manager
      5. Inventory Bulk Edit
      6. Receiving/Inspection
      7. Reports
    4. Banking
      1. Customer Receipts
      2. Customer Refunds
      3. Vendor Payments
      4. Vendor Payments - Bulk
      5. Vendor Refunds
      6. Account Register
      7. Cash Reconciliation
      8. Reports and Forms
    5. General Ledger
      1. GL Manager
        1. Intuit Online Payroll
      2. Budgeting
      3. Reports and Forms
    6. Quality
      1. Document Control
      2. Quality Manager
      3. Maintenance Manager
    7. Tools
      1. Shipping Manager
      2. PhreeForm - Reports/Forms
      3. OpenCart Interface
      4. PrestaShop Interface
      5. WooCommerce Interface
      6. Google Interface
      7. Image Manager
      8. Translator Assistant
      9. Import/Export
      10. Backup/Restore
    8. My Business
      1. Profiles
      2. Employees
      3. Fixed Assets Manager
  6. Administrators Guide
    1. Module Settings
      1. Bizuno Settings
        1. Linking Your PhreeSoft.com Account
        2. SMTP Configuration
        3. Creating a New Store
      2. Contacts Settings
      3. Inventory Settings
      4. Payment Settings
      5. PhreeBooks Settings
      6. PhreeForm Settings
    2. Extension Settings
      1. Multi-Store Extension
      2. Service Builder - Job Templates
    3. Security
      1. Data Encryption
    4. Roles
    5. Users
    6. Maintenance
      1. Protecting Your Business Data
      2. Backing Up Your Data
      3. Restoring From a Backup
    7. Reloading and Importing Reports and Forms
    8. Using Barcode Scanners
    9. Importing and Exporting
      1. Importing Contacts – Customers and Vendors
      2. Converting from Another App
      3. Converting from PhreeBooks
  7. Advanced Topics
    1. The Bizuno Journals
    2. Working With Taxes
    3. Fixing Trail Balance is Out of Balance Errors
    4. Editing Reports and Forms
    5. Entering a Vendor Deposit
    6. Entering a Customer Deposit
  8. Tutorials
    1. Mastering Price Sheets
    2. Installing the Bizuno/WooCommerce Interface
    3. Translating Bizuno
  9. Technical Stuff
    1. Developer Information
    2. Bizuno API
    3. Adding New Themes
  10. More Resources
    1. Glossary

Importing Contacts – Customers and Vendors #

NOTE: AS OF THIS WRITING ONLY MAIN AND SHIPPING ADDRESSES CAN BE IMPORTED!

One of the quickest ways to get up and running is to import your existing customer and vendor database records. Bizuno provides a tool to aid in that effort.

HINT: If you are starting with a new business importing data from your old accounting software, it may be wise to start with a small, two to three row, sample until you get a feel of how the process works and what the results look like.

How Bizuno Stores Your Contacts

Bizuno uses a master/slave table structure to store all your contacts whether they be Customers, Vendors, Stores, Employees or CRM Contacts. The main or master table is named contacts and contains all the high level information about the contact. The slave table is linked to the master table and contains the address information for the contact. One or more addresses may be linked to a single contact. However, there can be ONLY ONE main address (type = m) linked to a contact record. The remaining records must be either billing (type = b) or shipping (type = s). If no billing or shipping addresses are present, Bizuno defaults to the main address as the billing and shipping address.

Required Fields

The following is a list of required fields as of this writing. Import files that do not contain the required fields will be rejected and the import will not continue.

  • ContactType – The type of contact to be imported, all types can be imported in a single operation, i.e. customers, vendors, employees, etc.
  • ContactContactID – The textual id you will search for when pulling up the contact database information. Commonly referred to as the ‘Short Name’
  • MainAddressPrimaryName – Name of the business or individual being imported.
  • ShipAddressPrimaryName – [Required ONLY if a shipping address is imported] Name of the business or Individual

Import Procedure

  1. Navigate to the import tool: Tools -> Import/Export -> Contacts tab
  2. Press the Download Template from Step 1.
  3. Edit the downloaded .csv file with your list of contacts to import. The file contains the properly formatted headings of the fields available to import. There is also a list of the available tags and fields with descriptions below the heading row to help explain the contents of a given column. NOTE: These rows need to be removed from your import file as it will result in a failed import.
  4. Once the file is complete, Complete Step 2 on the screen to import your file. The import results will be displayed in a message box on the screen.

Import Sample

The following is a sample of a contact import file. Note that ‘proper’ .csv formatting is imperative, Also keep in mind that only one header row should be present and blank rows should be avoided in your import file.

ContactType,ContactContactID,MainAddressPrimaryName,MainAddressAddress1,MainAddressCity,MainAddressState,MainAddressPostalCode,MainAddressCountryISO3,MainAddressTelephone1
c,"Customer 1, Inc.",Tom Franks,4343 Main St.,Fort Worth, TX,76090,USA,817-555-1234
c,jSmith,John Smith,543 21st St.,Dallas,TX,76020,USA,214-555-5492
v,Bix Box,"Big Box, LLC", 3043 Maple Ave,Dallas,TX,76031,USA,214-555-7473

Multiple Imports

Bizuno uses the ContactContactID as a unique identifier for each contact type. The same identifier can be used for a vendor and customer as these are treated differently in Bizuno. If the same file is imported multiple times, Bizuno will first see if the Contact ID exists in the database and if so, overwrites the information. This can be a helpful feature as small chunks and bulk updates are possible without duplicating contacts.

Help Guide Powered by Documentor
Suggest Edit