Setting up your Job Board account
How to connect Quickbooks Online to the Job Board version
Launch jobs from Orders - Job board version
Job Board Only version Vs Pro version
Setting up your Pro account
Flagging a user as a "Sales Rep"
shopVOX Pro User Types
Forms: Editing the User Interface
How to Change Password
How Do I Create a New User?
What size should my logo be so it can appear in email PDFs?
Account Settings for your Pro account
shopVOX Work Flow - The Big Picture
Roles: How to restrict access for certain users
Protect Your Bottom Line with Terms and Conditions
Transferring data from my old system to shopVOX
POS Settings - General
Outsourced PO PDF - details your Vendors need to know
How are Users Billed?
Common Questions About Users
How to import your customers and contacts from a spreadsheet
How to configure the SMTP settings for your email
User Roles and Permissions Explained
POS Settings – Sales Taxes
Five challenges to consider when setting up your Account
Adding new customers
shopVOX Pro Job board Filters
Create your first Pricing Template - a visual guide
What is a product?
shopVOX Pricing Templates
Building a Product: The Basics of Using Pricing Templates
Accounting sync setup
Transaction Number Sequencing
Setup Xero accounting integration
Common QB Questions
shopVOX Setup of Tax Codes for Quickbooks Canada Desktop/Online
How to Connect to Quickbooks Online using the Setup Wizard
How to Connect to Quickbooks Desktop version using the Setup Wizard
How to setup Sage Business Cloud Accounting integration
Getting started Guide
Save Time with Emailed Document Templates
Notifications: Keep your entire team up to date
Top 10 flows in shopVOX for a typical shop
Introduction to ShopVOX
How to create a Sales Order
Microsoft Outlook - Two Factor Authentication
Avalara AvaTax - Sales tax setup guide
Managing Customer and Leads
Managing dates on Quotes, Sales Orders, and Invoices
How to Add a Special Note to a Customer Document ?
How Do I Group Contacts Together?
Customer Alerts & Flags
Inactive Customers Report
How Do I Group Customers Together?
Adding new Contacts to Existing Customers
Set up different pricing levels for different customers
Update: Editing Existing Contacts - GDPR Compliance
What are Sales Leads?
Sales Lead or straight to Quote?
Sample Sales Lead Pipeline
What is a CRM system?
Win more business with Sales Leads
Why use Sales Leads?
Sales Leads Guide
Create Sales Leads automatically from the contact form on your website
How do I add a Quote from a Sales Lead?
Sales Order States
How to Create a New Sales Lead in shopVOX
How to Create a Quote
Sales goals - Setting up for Success!
Drive results with the Sales - Production Thermometer
Adding Shipping Charges to a Transaction
Quote Approval Email Feature: Adding Attachments
Use the Roll Up feature to combine pricing for multiple line items
Adding Images to a Quote/Sales Order/Invoice PDF
What is the Sales Process?
Quote Review - Send Approval Email
How to use the Quick Quote Feature
What is a Sales Pipeline?
Mark invoices as Delivered, Shipped or Picked up
Quoting Screen Printed Apparel
Products & Pricing
Basic Pricing concepts
What are Pricing Types?
Create Your First Product
What is the difference between Standard, Cost+ and Product Pricing?
How do I add a product category?
Materials - Understanding, Adding and Adjusting
Labor Rates and Machine Rates
Shipping, Setup, Finance & Miscellaneous Charges
Building a Product and understanding Pricing Templates. Watch the webinar!
Building Products using Grid Pricing
Pricing products using the Panels UI
Using Variants for different Pricing Structures
Advanced Pricing concepts
Modifying Starter Products: Remove installation and design services if they are not taxable in your area.
Setting up second side pricing for a Product
Vendor Pricing: adding to Materials
Using Logic in your Pricing Templates
How does Wastage work in shopVOX?
Job Costing - Estimated vs. Actual
Modify Material, Labor rate & Machine rate formulas within a Product
Deactivating and Deleting Products
How to make your invoice line items editable
Re-Calculating Bill Of Materials (BOM)
What's the difference between Margin, Markup %, and Markup Multiplier ?
How to adjust the bill of materials (BOM) for situational purposes
No Total PDF: How to give a customer options without totaling the whole Quote
What is the Sell/Buy Ratio?
Customizing Line Item Descriptions
Custom Fields in shopVOX
How to increase prices for your Products by a percentage
How to Copy Products Shared by the VOX Community
Setting up Products priced by the Square Inch
Product: Business Cards using Grid Pricing
Adding Pricing Template to a Grid Product
Problems with Grid Product - Who can I contact for help?
How to Import Grid Pricing from a Spreadsheet ?
What is the difference between range and volume discounts?
How can I give a discount for a product for a single customer?
Grid Pricing Webinar
Examples of Grid Pricing Products
Master Pricing Guide
Job Board management
Adding your Job Board to your TV
Why create jobs and use the job board?
How to Generate a Completed Jobs Report
A guide to the Job Board
Job Board - Different Views
Change default job view
Full screen Job Board
Making Job Board Line Items More Unique
How and when to use Create Combined Jobs
How to upload a proof to your job ?
How do I send Multiple versions as options to the customer to choose from?
How do I send several proofs for the different items on my transaction?
Does shopVOX support multiple page proofs?
Get artwork approved faster with Online Proofing
Managing your schedule with the Shop Calendar and Shop Scheduler
Shop Calendar and Shop Scheduler: Overview - is it right for my shop?
Will changes made on an Invoice or Sales Order Line item be updated to the Work Order details?
Is Inventory for Me?
How Do I Require a Payment before a Job can be started?
Using Create Combined Job to group line items for production
What are Projects?
Accounting and Reporting
How to export customer data from QuickBooks Online
Quickbooks Online: Common Sync Errors
Automatic Sales Tax Rates and QuickBooks Online
How to Sync to Quickbooks Online
How to export customers & contacts from Quickbooks Desktop?
Quickbooks Desktop: Common Sync Errors
How to Sync to Quickbooks Desktop
How to send invoice statements to customers with the Collections report
Daily Sales and Payments report
Daily Activity Report
How to create progress invoices ?
Sales Tax Groups and Combined Tax Rates
MYOB Export & Sage 50 Export
How to refund credit card transactions processed via shopVOX & Authorize.net
Square Payment Integration
Prevent QuickBooks sync errors by excluding special characters and limits
Take in-store credit card payments with a USB credit card swiper
Line item Taxable / Non-Taxable logic - Video
How Do Credit Memos and Refunds Work in shopVOX?
Differences between USA QuickBooks Online and Non-USA QuickBooks Online
Accounting wins! Strategies for using shopVOX for business growth.
Creating & sending Statements in shopVOX
Sales Tax Rates
Industry Specific Content
How to Price Vinyl Printing
How to Price Banners
How to Price Banner Stands
Pricing Scenarios: Banners
Product: Yard Signs using Grid Pricing
How to Price Vehicle Wraps
Promotional Items: adding Labor cost & Base Product cost to Purchase Orders
Adding your own Variants for Embroidery and Screen Printing
How do I stop the price for my apparel from recalculating when I update the quote or sales order?
How do I add customer supplied garments to a quote or sales order?
Blank Apparel - Integrated Supplier Catalogs
Adding Promotional Products to your Quotes and Sales Orders
Dynamic Size Selection on Apparel UI
Apparel UI - Catalog Pricing Flag
How to add Screen Printed Apparel to Quotes and Sales Orders ?
How to price Screen Printing
How to customize the standard Screen Printing locations
How do I quote multiple options or quantities of shirts or hats?
How to price Screen Printing - case study
How do I add apparel styles that aren't listed in the integrated catalogs?
Importing custom catalogs for apparel from other suppliers
How do I see a detailed breakdown of cost and price of apparel?
How do add additional apparel styles or colors to a quote or sales order?
Apparel Decoration Order Guide
Master Guide to Apparel Decoration
MSRP Catalog pricing - setting a Fixed price for Apparel items
SanMar apparel catalog integration
Taking Payments in ShopVOX - what your customers will see
Setup a private storefront for your clients to place orders with a cPortal
How do I enable the free cPortal for a customer?
What is the difference between the Paid and Free versions of cPortal?
Online Ordering Account settings for cPortals & Shopping Cart
How is online payment processing set up?
Webstore & Shopping Cart Examples from shopVOX Users
Webstores for your customers - What are they? and... How to setup!
How to setup Products for a given customer to be able to order from cPortal?
White Label setup instructions
Steps to setup custom URL for paid cPortal
Setting up a Shopping Cart to sell online
What will my customers see on their cPortal?
Webstore vs Shopping Cart
How to create a Discount Code in the eCommerce feature
Automation & Integrations
UPS Shipping Integration - Access Keys
FedEx Shipping Integration
Creating a shipment
How does an API work?
What is JSON?
Where can my get my shopVOX API credentials?
What is an API?
Can the shopVOX API accept tracking numbers on shipped orders?
Does shopVOX do custom development?
Setting up the Gmail and Outlook Email Integrations with @mail feature
Master Guide to Automation & Integration
How to update your current contact form integration to include uploaded files
What are some popular advantages when using Zapier?
How to add form submissions as Sales Leads in shopVOX
How to send Shopify orders to Sales Orders in shopVOX
How to add Third party Shipping account to a Customer ?
I'm having an issue with the shopVOX APIs. Who do I contact?
How do I build my own custom integration?
Does shopVOX integrate with Salesforce?
Does shopVOX integrate with Microsoft Project?
How Purchase orders work in shopVOX
Setting up Mailchimp integration
Customize your account with Add-on Features
Scheduled Actions - What are they and what can I do with them
API/WebHooks integration feature
Setting up Constant Contact integration
shopVOX specific terms
What happens when a Job is completed?
QuickBooks - Classes
Key terms explained
Uploading vs Linking Assets
Why doesn't Material have Volume Discount, only Range Discount?
What does Capacity in Minutes mean?
Why can't I print the PDF documents directly, instead of downloading?
How can I print invoices to mail to my customers?
I can't use my email address? shopVOX says email has already been taken.
How do I re-activate the disabled user?
How can I send a quote and a proof together in one email to my customer?
Where do jobs "fit" in the order process in ShopVOX?
What is the Admin checkbox for when creating a new user?
How to Set Up and Use the Inventory Feature
How can I change the workflow template for a job?
How Can I Upload an Image of a Product on a Job Line Item?
Customers- Credit Limits, Stop Supply & Disable
What Does "Group" Mean When Creating a New Customer?
New to Quickbooks While Using ShopVOX
How to increase Database size ?
Hex Color file to match PMS color chart
Can customers download uploaded proofs?
How do I update contact info?
How can I raise a PRO-FORMA or DOWN-PAYMENT Invoice?
How do I add new products?
Can we chat internally with other users?
How to enable login only from static IP address
How can I delete a job?
Who should be assigned the Customer Review step in online proofing?
Opening PDFs directly in your browser
How to hide the thumbnail image in proof emails
What does the number next to workflow steps mean?
Bulk deleting customers
Optimization tips for the Job board
Errors and Troubleshooting
How do I remove / delete materials, material types, or material categories?
When I convert a quote to a work order, does the name of the order and the line item description carry forward or do I have to rewrite?
shopVOX Chat Feature not working on Firefox Browser
How to clear history from Chrome browser?
Flags to control what prints on customer facing vs internal PDFs
Keep Important Documents Handy with Account Level Assets
How to round your pricing to 2 decimals or 4 decimals
ERROR - Property: amount_in_cents, reason: greater than payment balance.
Control custom line items
Existing Approved Proofs for ReOrders
Advanced Search & Filters
How do I cancel my account?
Powerful Global Search in shopVOX
How can I setup a minimum order amount?
How to optimize your browser for shopVOX
Unable to change the Customer on Order ?
Asset Images and using Image Notes
What is our IP address for the mail server ?
Custom PDF in shopVOX
shopVOX Job Board version
- All Categories
- Getting Started
- Setting up your Pro account
- How to import your customers and contacts from a spreadsheet
How to import your customers and contacts from a spreadsheet
Updated by Haylee Benton
Learn how to upload contacts from your past system into your shopVOX account
Where are you exporting your customer list from?
We’ve got a few articles to help export customers and contacts from your current software.
- Exporting customers from Quickbooks Online
- Exporting customers from Quickbooks Desktop
- Exporting customers from Xero
- For Casper, Activity POS, Cyrious Users, Estimate or other programs - Let US do the importing for you!!
What should I do before importing?
Clean up your data 🛀
It’s always a good idea to clean up your customer and contact lists before you start a new system. If you’ve been in business for 25 years - then there’s probably a few customers in your current database that you are no longer doing business with.
This type of cleanup is much easier in Excel before you import rather than trying to clean it up after you import.
Test a few records before uploading the whole list ️
When creating your upload file - create two .csv or .xls files.
- The main file with all your customers and contacts
- A test file with only the first five or ten rows
You’ll want to get this right the first time - and avoid any headache caused by a bad import.
- Upload your test file first.
- Go to Customers and Vendors > Customers.
- Check out one of the Customers you imported.
- If all looks good, then upload your main file.
Sample file templates 🗄
Save yourself some time. If you use this template - shopVOX automatically recognizes all the column headers for you. Make sure you save it in either .XLS or .CSV format only. XLSX files will NOT work.
Go to File > Then click on " download as ", and download to .CSV.
Download the Google Docs Import Template
Download the file, add your data, and save as .XLS or .CSV.
Download the Microsoft Excel Import Template
How to import 🚢
Customers in shopVOX are the companies or organizations that you are selling to.
Contacts are the people at those companiesYou can upload your contacts if the data is in a csv/xls file.
However make sure the mapping is done right and try to do a sample of 2-3 contacts so that you know you have done the mapping right, because the names you think what they are and the names what we have set in shopVOX could mean different things. So first do a sample test to make sure the mapping is right.
***NOTE: IF YOU DO THE MAPPING WRONG AND LOAD THE CONTACTS, THEY HAVE TO BE MANUALLY FIXED ONE BY ONE. *** VERY VERY VERY IMPORTANT *** DO A TEST UPLOAD OF UNDER 5 RECORDS FIRST.
Also this upload is a combination of two things, it is basically a contact upload, how ever it also has lot of "Customer" details that are part of these records. If the customer already exists in shopVOX it will create the contact if the contact does not exist. If the contact exist the row will be skipped. IT WILL NOT UPDATE THE CONTACT.
How to get to that screen? First go to Customers & Vendors > Customers
Then go to this menu item as shown below.
Once you click that "Import Contacts" you will see this screen.
From the drop down of Select Type what type of file you have the data in. Here are the choices.
Unless your file is exported out of the first three card scanning tools, pick Custom, if not pick what ever is the right one.
Card Scan/Neat Receipts/World card Scan are files that these respective card scanning tools provide which can be used also.
Once you pick Custom you will see a screen like this, click the Choose File to pick the file where these contacts data is in either csv/xls on your network or local machine somewhere.
Once you upload the file, you will see this screen.
Click the button, Import and then you will see the mapping fields like below...
If your file first row column headings match with the column headings of shopVOX then they will auto match (if it takes a few seconds to match, wait for it). If your file has columns that do not match shopVOX fields it will say "NO MATCH" meaning if you want that column data to be imported, click the drop down and pick what ever you think is the right data field that the data should go into. Scroll to the right to see all the columns
****BE VERY CAREFUL WHEN YOU TRY TO DO COLUMNS MAPPING! IF YOU MAP WRONG AND LOAD THE DATA YOU HAVE TO MANUALLY FIX THEM. HENCE AS A TEST DO A SMALL NUMBER OF RECORDS FIRST AND THEN CHECK THE DATA IMPORTED TO MAKE SURE THE DATA HAS BEEN IMPORTED INTO THE RIGHT COLUMNS IN SHOPVOX. WE CANNOT FIX IT AFTER IT IS LOADED OTHER THAN YOU GOING INTO EACH RECORD AND MANUALLY FIXING THE MAPPING ERRORS****
Once you do the mapping of columns and you are satisfied and double checked them,scroll to the bottom to click the button, "Upload" like below.
Once you click upload wait for the process to be completed and a screen like this shows up.
Follow the instructions on screen for the next steps.
****NOTE: PLEASE CHECK ONCE THE FIRST BATCH IS IMPORTED TO MAKE SURE THE MAPPING WAS DONE CORRECTLY BY YOU SO THAT YOU DON'T HAVE BAD DATA.