Module: Importer

 Created Date: 11/16/2018 8:18:20 PM |  User Level: Regular User |  Views: 3,031

The system allows importing of information from Microsoft Excel-based spreadsheets. All that is required is the first row of the spreadsheet has the appropriate column names set for import. Columns that do not have a common column name are skipped during the import process. If you have two columns with the same column name, only the first column found (starting at column A) will be used.

Supported Modules

The following modules support importing.

  • Accounts
  • Product Lookups (Categories & Vendors)
  • Product Features (Attributes & Specifications)
  • Products
  • Tasks
  • Testimonials
  • Users


In the Import module, there is a section called "Sample Import Templates". This provides all of the currently available columns for the version of the software you are using.

How to Import

The process of importing is straightforward. 

  • Go into the Importer module.
  • Choose the module you wish to import into.
  • Choose your Microsoft Excel-based file.
    • Note: If you have the import file open in Excel, you could have an error as Excel can "lock" the file from being read by other programs. We recommended not having the file open in any program during the import process. 
  • Optional Settings - if you are importing into a module that has the option of sending emails when inserting a new record (e.g., Tasks or Testimonials), you can choose
    • Send Emails on Insert - Sends an email on every record that is inserted into the system.
    • Send Emails on Complete - Sends an email when all records are inserted.
    • Note: If the module you are importing doesn't support sending emails, the system will ignore these options when importing.
    • Note: When importing Testimonials and asking people to leave a testimonial for you (e.g., on Google), it is recommended to have "Send Email on Each Insert" selected.
  • Click on the button at the top labeled "Import". Depending on how many records you are importing, this can take a few seconds to several minutes. Once complete, the system will let you know that it completed the import process.


Available Service Flyers

Our philosophy has always been honesty (this is our rule #1) and transparency in our services. There's no reason to hide costs unless you have something to hide. We've found that those who hide fees charge more successful businesses more money because they can. We do not feel this is the way America was meant to be. We believe in offering a fair price to everyone for the work that is done.

We also believe that once you sign on with us, you trust us, and as our thank you to you, we "price lock" our services for the plan(s) you signed up for at that time. This means while you are on those services, the price will always be the same. As business owners, we appreciate this as it allows us to budget our business expenses better.