123Pet

Please be advised that we are aware that our Online Booking service may be experiencing issues. This is under investigation and will be resolved shortly

Happy Holidays! Please be advised that our offices will be closed December 24th, 25th, 31st, and January 1st to allow out employees to spend time with their families this holiday season.
Thank you for your understanding.

System Maintenance is scheduled Sunday night, April 22nd, between 10:00 PM and 5:00 AM EST Monday, April 23rd. While these database upgrades and maintenance is necessary, it will mean that our online services will not be available during this maintenance window. These services include: online booking, messaging, remote access, memberships or any account management. We apologize for any inconvenience this work may cause and thank you for your service and patience.

We recently experienced a service outage related to some Amazon Web Services, which affected key functionality of our Remote Access Service. This interruption happened on Thursday, June 22nd, between the hours of 9:00pm and 2:00am EST. The Remote Access Service is now fully restored. If you continue to experience issues with your Remote Access Service, please follow the directions on this Support Article to restart the Remote Access Service and try reconnecting again. You can also restart your computer to restart your service. If you are still experiencing issues afterwards please contact our support team at 1 (800) 604-2040.

All of our services have been restored after a brief interruption that impacted our Cloud online services. This interruption occurred between 9:45 a.m. and 10:55 a.m. EST on September 18th. We apologize for the inconvenience and thank you for your patience!

Importing Overview

This article how to format data and database tables from another program, such as another database program or Microsoft Excel, properly to be imported into your software. A separate file is required for each list of information that can be imported. At minimum, each of the following fields from the list below must be present for a new record to be created successfully in a table:
  • ID (will vary depending on the table, i.e. ClientID for Clients, GiftCertID for Gift Certificates)
  • FirstName
  • LastName
  • Name (for Pets & Suppliers)
The following information types can be imported:
  • Clients
  • Client history
  • Pets
  • Vets
  • Products
  • Services
  • Employees
  • Suppliers
  • Gift Certificates
The database table fields are indicated by the Column Name in each of the tables below. Be sure to maintain the correct spelling and capitalization or the entries will not import into that field. The software will only import a .txt file. If you are using a spreadsheet or database program for creating your files for importing, make sure to save a copy of each file as a Text (tab delimited) file and use this for importing. We recommend naming each file you create the same as the data type you will be importing.

Importing Your Files
  1. Select the File pull-down menu.
  2. Hover over the Import fly-out menu and select a data type to import.
  3. Select the desired import options and navigate to the corresponding file.
  4. Your files will import based on the settings selection in Step 3.
  5. Repeat these steps until all data types are imported.

​Data Type Formatting Tables

​Clients
Column Name Description Type Example
FirstName First Name Text Mary
LastName Last Name Text Smith
Address Address Text 123 Anystreet
Address2 Second line of address Text Apt. 201
City City Text Anytown
State State Text California
Zip Zip or postal code Text 12345-6789
E-Mail E-mail address Text mary@email.com
HomePhone Home phone number Text (555) 555-1212
WorkPhone Work phone number Text (555) 555-1212
CellPhone Cell phone number Text (555) 555-1212
Gender Gender Text (M for
male, F for
female)
F
Comment General client comment Text Has two children
Class Class or category. Short phrase describing the type of service the client frequents Text Tan
DateOfBirth Date of birth Date 2/1/1975
Anniversary Date of anniversary Date 5/7/1998
TotalVisits Total number of visits Number 54
FirstVisit Date of first visit Date 3/4/1997
LastVisit Date of last visit Date 10/5/2011
Mailing Indicates if the client wants to receive mail or not Text (TRUE for yes, FALSE for no) FALSE
FirstEmployeeName Name of the first employee to provide service to the client Text Bill Rogers
FirstEmployeeID ID of the first employee to provide service to the client Number 100
LastEmployeeName Name of the last employee to provide service to the client Text Jenny Johnson
LastEmployeeID ID of the last employee to provide service to the client Number 101
Balance Balance the client owes. Positive number means the client owes money, negative number means the client has credit to use Number 19.95
BalanceComment Comment describing the balance Text Owes $19.95 from
10/2/2011 visit
ProductDiscountPercent Default discount percentage on products Number 10
ServiceDiscountPercent Default discount percentage on services Number 0
Link Path and name of a file related to the client. Text c:\My Documents\Bill.xls
ClientHistory Notes or other history Text Use color formula #123. Let set extra 5 min.
ClientID ID number for the client Number 1000
Title Title before name, i.e. Mr., Mrs., Dr., etc. Text Mrs.
Item The unit assigned from the Options - Clients tab Text minutes
ItemComment Comment for the item described above Text Comments
IDCard ID card number for the client Number 1000

Pets
Column Name Description Type Example
ClientID Client ID of the pet's owner Number 1064
FirstName First name of the pet's owner Text Mary
LastName Last name of the pet's owner Text Jones
PetID Pet ID number Number 104
Name Name of the pet Text Buttons
Type Type of pet (Cat, Dog, Other) Text Dog
Breed Pet breed Text Beagle
Weight Weight Text 25lb
DOB Pet's date of birth Date 2/20/2009
Gender Pet's gender Text (Male or Female) Male
Comments General comments about the pet Text Likes playing fetch
Burns Burns easily Text (TRUE/FALSE) FALSE
HairDryer Afraid of hair dryer Text (TRUE/FALSE) TRUE
SensitiveSkin Has sensitive skin Text (TRUE/FALSE) FALSE
GroomLevel Groom level (easy, average, challenging) Text (TRUE/FALSE) Easy
Length Groom length Text Short shave
Color Color of fur Text White with brown spots
Texture Fur texture Text Silky
GroomComments Grooming comments Text Allergic to pink dye
AgWithPeople Aggressive with people Text (TRUE/FALSE) False
AgWithAnimals Aggressive with animals Text (TRUE/FALSE) TRUE
Barker Is a barker? Text (TRUE/FALSE) TRUE
Biter Is a biter? Text (TRUE/FALSE) FALSE
Hyper Is hyper? Text (TRUE/FALSE) TRUE
Shy Is shy? Text (TRUE/FALSE) FALSE
PersonalityComments Comments about personality Text Likes to snuggle
LeashOn Keep leash on? Text (TRUE/FALSE) TRUE
Chews Does pet chew? Text (TRUE/FALSE) TRUE
Exercise Exercise instructions Text Walk 30 mins. per day
KennelComments Kenneling comments Text Needs own kennel
Diabetic Is the pet diabetic? Text (TRUE/FALSE) FALSE
Deaf Is the pet deaf? Text (TRUE/FALSE) FALSE
Blind Is the pet blind? Text (TRUE/FALSE) FALSE

Vets
Column Name Description Type Example
VetID ID number to the vet Number 1000
Business The business name that the vet uses Text Tom's Vet Clinic
FirstName First name of the veterinarian Text Tom
LastName Last name of the veterinarian Text Jones
Address Address of the business Text 111 State St.
City City of the business Text Anytown
State State of the business Text MI
Zip Zip or postal code of the business Text 12345
Comments Comments about the vet Text Just north of the freeway
PhoneHome Veterinarian's home phone number Text (555) 555-1212
PhoneMobile Veterinarian's mobile phone number Text (555) 555-1212
PhoneWork Veterinarian's workphone number Text (555) 555-1212

Products
Column Name Description Type Example
ID Product ID or SKU number. The ID must be unique Text Sham100
Description Description or name of product Text Lilac Shampoo
Category Category Text Shampoo
Backbar Backbar items are used in-house to support services. No commission is made on backbar items Text (TRUE or FALSE) TRUE
Make Make, usually the item's brand name Text Great's Shampoo
Size Size Text 12 oz
Wholesale Wholesale Price Number 4.50
Retail Retail Price Number 8.99
Tax1 Indicates if tax1 should be applied to product sales Text (TRUE or FALSE) TRUE
Tax2 Indicates if tax2 should be applied to product sales Text (TRUE or FALSE) FALSE
Tax3 Indicates if tax3 should be applied to product sales Text (TRUE or FALSE) FALSE
Inactive Is the product inactive? Text (TRUE or FALSE) FALSE
Balance Currency amount to automatically increase or decrease the client's balance Number 1.00
Supplier Supplier of the product Text My Supplier
StockCount Current stock quantity Number 4
ReorderAuto Indicates if the product should be automatically added to the reorder list Text (TRUE or FALSE) TRUE
ReorderPoint The stock quantity at which the product will be added to the reorder list Number 5
ReorderQuantity The quantity that will be added to the reorder list Number 10
OnOrder Quantity currently on order Number 10
DateOrderHold Keep this product off the reorder list until a specific date Date 11/1/2015
OrderDate Date put on order Date 10/1/2015
CommissionBonus Currency amount added as a commission bonus Number 2.00

Services
Column Name Description Type Example
ID ID Text Color
Description Description Text Color Service
Category Category Text Hair Styling
Backbar Backbar amount taken out before commission determined Number 3.50
Price Price Number 45
Tax1 Indicates if tax1 should be applied to service sales Text (TRUE or FALSE) FALSE
Tax2 Indicates if tax2 should be applied to service sales Text (TRUE or FALSE) FALSE
Tax3 Indicates if tax3 should be applied to service sales Text (TRUE or FALSE) FALSE
Setup Setup duration (length of time) Number 45
Process Process duration (length of time) Number 30
Finish Finish duration (length of time) Number 15
Inactive Is the service inactive? Text (TRUE or FALSE) FALSE
Link1 Link to a specific product used for the service Text Sham100
Link2 Link to a specific product used for the service Text Cond100
Link3 Link to a specific product used for the service Text Hydrator
Balance Currency amount to automatically increase or decrease the client's balance Number 0
CommissionBonus Currency amount added as a commission bonus Number 10

Employees
Column Name Description Type Example
FirstName First Name Text Rita
LastName Last Name Text Doe
EmployeeID ID Number Number 1000
Address Address Text 100 Park St
Address2 Second line of address Text Apt. 100
City City Text Middleville
State State Text FL
ZIP ZIP or postal code Number 44444
Phone Phone Number Text (555) 555-1212
CellPhone Cell phone number Text (555) 555-1212
E-mail E-mail address Text rita@email.com
Gender Gender Text (M for male, F for female) F
Comment Employee comments Text Wants Saturdays off
DateOfBirth Date of birth Date 5/10/1975
DateOfHire Date of hire Date 2/7/2002
W2Local City name if local withholding tax is being deducted Text Anytown
W2State State name if state withholding tax is being deducted Text FL
Active Is the employee actively employed? TRUE or FALSE TRUE
Independent Is the employee a independent contractor? TRUE or FALSE FALSE
SSN Social Security Number Text 000-00-0000

Suppliers
Column Name Description Type Example
Name Name of the supplier Text ABC Distributions
FirstName First name of the primary contact person Text Mark
LastName Last name of the primary contact person Text Albert
Address Address Text 123 Mystreet
City City Text Mytown
State State Text CA
Zip ZIP or postal code Text 12345
E-Mail E-mail address Text abcdistributions@email.com
Phone General phone number Text (555) 555-1212
TollFree Toll free phone number Text (800) 555-1212
Cell Mobile phone number Text (555) 555-1212
Fax Fax phone number Text (555) 555-1212
Comment General comments Text Doesn't ship after 5pm Friday
Products List of products the supplier supplies Text Sham100, Cond100
Total Current amount owed to or from the supplier Number 120.50
Check Name that should appear on the "To" section when printing checks Text ABC Service, Inc.
SupplierID ID number for the supplier Number 1000
History History and other information Text Started account on Jan. 10, 1998. This supplier only ships UPS

Gift Certficates
Column Name Description Type Example
GiftCertID The gift certificate ID number Number 1000
OriginalAmount The original amount on the gift certificate Number 100.00
Balance The current amount on the gift certificate Number 50.00
FromFirstName First name of who the gift certificate is from Text Larry
FromLastName Last name of who the gift certificate is from Text Jones
ToFirstName First name of who the gift certificate is for Text Kerry
ToLastName Last name of who the gift certificate is for Text Williams
DateCreated Date the gift certificate was created Date 8/10/2011
GiftCertComment Comments or additional information Text Birthday gift

Did you find this article helpful?