Import Data into Bravo

After setting up and configuring your store in Bravo, you can schedule Bravo to do a conversion to populate the Bravo database with existing customer, inventory, and loan data. If you want to avoid the manual entry of this information, Bravo provides data import services for a fee. Please contact a customer service representative for more details about the conversion process and its pricing.

Our import service requires you to provide us with up to three separate Excel spreadsheets to be populated with data, one each for customers, inventory and loans. This data is then converted and loaded into Bravo for testing. After passing QA, then a customer service representative can schedule a date to have the data loaded into your store.

Each of the three spreadsheets will follow the same formatting rules:

Row 1 - Header row as defined by each type defined below.
Row 2 - N - Data rows as defined by each type defined below.
All data defined in a single tab in the Excel fill.

IMPORTANT: Only ACTIVE customer description (i.e., Name, Address, ID types, etc.), ACTIVE inventory (i.e., not sold), and ACTIVE loans/buys (not expired) should be included in the spreadsheets. These are the only types of records that will be imported. The Bravo conversion process will NOT convert the following types of data:

Prior transactions

Customer history (i.e., any prior transaction history or loan/sales history)

Inventory SKU's (quantity items)

Consignments / Memos

Layaways*

Historical ATF gunbook relevant information.

*Active layaways can be added to the file, but they will be converted as regular inventory. Your store personnel will need to manually convert the inventory to layaways in Bravo for the correct amount. When manually converting, your store can use the "System Conversion" tender to enter any payments on them to avoid issues with balancing the till.

Importing Inventory

The Bravo customer will provide an excel spreadsheet for each store that will have its inventory imported. There will be one row in the spread sheet for each inventory item.

Note: Firearm inventory will be shown in the A&D book as acquired from your own store with a note saying "Converted".

The Header row will contain the following values exactly as defined below:

Column	Header Row Value
1	Current Inventory Number
2	Category
3	Description
4	Serial Number
5	Cost
6	Price
7	Retail Price
8	Firearm Type
9	Action
10	Caliber

Each data row will contain the following information in the following order:

Current Inventory Number	Use the exact inventory number from the existing system. No conversion necessary. Maximum of 20 characters.
Category	Must be one of the following values: “Jewelry”, “B-Good”, or “Watch”.
Description	Up to 255 characters can be imported. This field is mandatory. If no value is provided, the record will not be imported.
Serial Number	Maximum of 40 characters.
Cost	Dollar value including a decimal point and the 2 digit cents value. This field is mandatory. If no value is provided, the record will not be imported.
Price	The price the item is being sold for in dollars and cents.
Retail Price	This is a marketing value, not the sale price of the item in dollars and cents.
Firearm Type	For firearms only, such as Revolver, Pistol, Shotgun, Rifle, Receiver, Barrel.
Action	For firearms only, such as Single, Double, Bolt, Break, Pump, Lever, etc.
Caliber	For firearms only, caliber or gauge of the firearm such as 22, 45 ACP, 357 Magnum, 410, etc.

During the import process, an “ItemId” column will be added to the table and populated with unique identifiers for the inventory items. Store identification information will also be associated with the inventory items. The imported inventory items will be identified in the inventory comments as “Converted Inventory”. This will allow a user to quickly identify which items were imported into Bravo and which were added using standard Bravo processes.

Importing Customers

The Bravo customer will provide an excel spreadsheet for each store that will have its customers imported. There will be one row for each customer starting with row 2.

The Header row will contain the following values exactly as defined below:

Column	Header Row Value
1	CustomerNumber
2	FirstName
3	MiddleName
4	LastName
5	Suffix
6	BusinessName
7	MailingAddressType
8	Address
9	AddressLine2
10	City
11	State
12	StateAbbr
13	ZipCode
14	Email
15	PhoneNumber
16	CellPhone
17	WorkPhone
18	DateOfBirth
19	AlertNote
20	Note
21	FirstTimeIn
22	LastModifyBy
23	LastModifyTime
24	Language
25	Race
26	Sex
27	HairColor
28	EyeColor
29	Build
30	Complexion
31	ScarsMarksTattoos
32	Weight
33	Height
34	BirthCity
35	BirthStateContry
36	IDType
37	IdAgency
38	IdNumber
39	IdExpirationDate
40	Id2Type
41	Id2Agency
42	Id2Number
43	Id2ExpirationDate
44	FFLNumber
45	FFLExpirationDate
46	TaxExemptNumber
47	Employer
48	Occupation

Each data row will contain the following information in the following order:

Customer Number	Unique identifier in source, or original, system. This number will be used for importing purposes only but will not be used as the unique customer identifying key in Bravo.
First Name	Bravo will use the first 50 characters of the customer’s first name.
Middle Name	Bravo will use the first 50 characters of the customer’s middle name.
Last Name	Bravo will use the first 50 characters of the customer’s last name.
Suffix	Bravo will accept up to 20 characters for the customer’s suffix.
Business Name	Bravo will use the first 50 characters of the business name.
Mailing Address Type	Bravo will accept up to 6 characters
Address	This will be added to Bravo as the home address. The first 50 characters will be loaded into Bravo.
Address Line 2	The first 30 characters will be loaded into Bravo.
City	The first 30 characters will be loaded into Bravo.
State	The first 30 characters will be loaded into Bravo.
State Abbreviation	3 character abbreviation for the customer’s state.
Zip Code	Bravo will accept up to 20 characters for the zip code.
Email	The first 20 characters will be loaded into Bravo.
Phone Number	The first 20 characters will be loaded into Bravo.
Cell Phone Number	The first 20 characters will be loaded into Bravo.
Work Phone Number	The first 20 characters will be loaded into Bravo.
Date Of Birth	The values must be in the following format:” $%DyyyyMMdd” where “yyyy” is the 4 character year, “MM” is the 2 character month, and “dd” is the 2 character day. Bravo will provide an encryption rule to allow the user to change their format into this Bravo specified format.
Alert Note	The first 2000 characters will be loaded into Bravo.
Note	The first 2000 characters will be loaded into Bravo.
First Time In	This is a date time offset value representing the date and time of the customer’s first time visiting this store. This field is mandatory. If no value is provided, the record will not be imported.
Last Modify By	The user ID of the last employee that registered a transaction for this customer.
Last Modify Time	This is a date time offset value representing the date and time of the customer’s last transaction in this store. This field is mandatory. If no value is provided, the record will not be imported.
Language	If not provided, this field will default to the store’s language as defined by the store configuration value. This field is mandatory. If no value is provided, the record will not be imported.
Race	This field is mandatory. If no value is provided, the record will not be imported. During conversion, this field will be converted using the following table: Description: BLACK Code: RACEB Description: HISPANIC Code: RACEH Description: INDIAN Code: RACEI Description: MULTIRACIAL Code: RACEM Description: ASIAN Code: RACEO Description: WHITE Code: RACEW
Sex	This field is mandatory. If no value is provided, the record will not be imported. During conversion, this field will be converted using the following table: Description: FEMALE Code: SEXF Description: MALE Code: SEXM
Hair Color	This field is mandatory. If no value is provided, the record will not be imported. During conversion, this field will be converted using the following table: Description: AUBURN Code: HRAUB Description: BALD Code: HRBLD Description: BLACK Code: HRBLK Description: BLOND Code: HRBLO Description: BROWN Code: HRBRN Description: DK BROWN Code: HRDBR Description: LT BROWN Code: HRLBR Description: GRAY Code: HRGRY Description: RED Code: HRRED Description: SILVER Code: HRSIL Description: SANDY Code: HRSDY Description: WHITE Code: HRWHI
Eye Color	This field is mandatory. If no value is provided, the record will not be imported. During conversion, this field will be converted using the following table: Description: BLACK Code: EYEBLK Description: BLUE Code: EYEBLU Description: BROWN Code: EYEBRN Description: DICHROMATIC Code: EYEDIC Description: GREEN Code: EYEGRN Description: GRAY Code: EYEGRY Description: HAZEL Code: EYEHAZ Description: PINK Code: EYEPNK
Build	This field is mandatory. If no value is provided, the record will not be imported. During conversion, this field will be converted using the following table: Description: HEAVY Code: BLDHVY Description: LIGHT Code: BLDLT Description: MEDIUM Code: BLDMED
Complexion	This field is mandatory. If no value is provided, the record will not be imported. During conversion, this field will be converted using the following table: Description: DARK Code: CMPDRK Description: LIGHT Code: CMPLT Description: MEDIUM Code: CMPMED
Scars Marks Tattoos	This is a description of any identifying marks on the customer. The first 50 characters will be loaded into Bravo.
Weight	No specified format.
Height	No specified format.
Birth City	Bravo will provide an encryption rule to allow the user to change their format into a Bravo specified format.
Birth State Country	The first 30 characters will be loaded into Bravo.
ID Type	During conversion, this field will be converted using the following table: Description: DRIVER'S LICENSE Code: IDDL Description: MILITARY ID Code: IDMIL Description: OTHER ID Code: IDOTHR Description: PASSPORT Code: IDPASS Description: State ID Code: IDSTID Description: USCIS ID (Green Card) Code: IDUSCS
ID Agency	The first 50 characters will be loaded into Bravo.
ID Number	Bravo will provide an encryption rule to allow the user to change their format into a Bravo specified format.
ID Expiration Date	This field can be specified in any valid date format.
ID 2 Type	During conversion, this field will be converted using the table defined in the ID Type description.
ID 2 Agency	The first 50 characters will be loaded into Bravo.
ID 2 Number	Bravo will provide an encryption rule to allow the user to change their format into a Bravo specified format.
ID 2 Expiration Date	This field can be specified in any valid date format.
FFL Number	This specifies the Federal Firearms License number
FFL Expiration Date	The expiration date of the customer’s FFL in any valid date format.
Tax Exempt Number	The first 50 characters will be loaded into Bravo.
Employer	The first 50 characters will be loaded into Bravo.
Occupation	The first 50 characters will be loaded into Bravo.

Importing Loans

The Bravo customer will provide an excel spreadsheet for each store that will have its loans imported. There will be one row for each loan starting with row 2.

The regulatory set to use for all imported loans must be specified. Regulatory sets can be defined using the Bravo configuration function. See the Store Configuration Guide for details on how to setup regulatory sets.

The Header row will contain the following values exactly as defined below:

Column	Header Row Value	Header Row Description
1	Custom Number	This value must match the customer number defined in the customer Excel file that secured this loan.
2	Loan/Buy Indicator	“L” for Loan or “B” for Buy. All other values are invalid.
3	Current Loan/Buy Number	The first 20 characters will be loaded into Bravo. This field is required and must contain a value. If no value is provided, the record will not be imported.
4	Loan Item Number	This value will be combined with the Loan Number to create the Bravo inventory and reference numbers.
5	Ticket Item Number	This is the line item number on the ticket (i.e. item 1, item 2, etc). This field is mandatory. If no value is provided, the record will not be imported.
6	Original Pawn Time	This is a date time offset value that defines the date and time of the original pawn ticket creation for this loan. This field is mandatory. If no value is provided, the record will not be imported.
7	Current Maturity Date	This is a date field in any valid date format. This field is mandatory. If no value is provided, the record will not be imported.
8	Notice Sent Date	If a notice was sent this is the date it was sent in any valid date format.
9	Pull Date	This value can be specified in any valid date format. If not provided, Bravo will calculate this based on current maturity date.
10	Category	Must be one of the following values: “Jewelry”, “B-Good”, or “Watch”.
11	Description	The first 255 characters will be loaded into Bravo in the description field. The first 32 characters will be stored in the short description field. This field is mandatory. If no value is provided, the record will not be imported.
12	Serial Number	The first 40 characters will be loaded into Bravo.
13	Loan Amount	This may be the overall loan amount for the entire loan or the loan amount for each item. This field is mandatory. If no value is provided, the record will not be imported. Note: If the amount specified in the Loan Amount field represents the entire loan (as opposed to the current line item), the Bravo personnel will need to be notified so the amount can be split between the items before loading the values in the Bravo database.
14	Total Amount Paid	This is expressed as a dollar amount.
15	Total Number of days the loan has been extended	This field can be mathematically determined if the data is not available. Note: Firearm loans will be shown in the A&D book as acquired from the loan customer with a note saying "Converted". The acquisition date will be the conversion date.
16	Firearm Type	For firearms only, such as Revolver, Pistol, Shotgun, Rifle, Receiver, Barrell.
17	Action	For firearms only, such as Single, Double, Bolt, Break, Pump, Lever, etc.
18	Caliber	For firearms only, caliber or guage of the firearm such as 22, 45 ACP, 357 Magnum, 410, etc.

In some states (e.g. Georgia) where the interest rate changes over time, firearm loans may need to be manually modified in order to properly credit them for loan extensions. The store personnel would need to write the loan with the proper maturity date using the backdate procedure. After processing the firearm loans, the store would provide Bravo personnel with a list of the loans, number of extension days and total extension payments. The Bravo staff would then back the Pawn Time up by the number of days and create a Pawn Line Item record for the ticket to reflect the days and payment.

Import Data into Bravo

Learn how to import data into Bravo using supported spreadsheet templates, including steps for submitting files to Support for bulk uploads of SKUs, customers, or inventory.

Importing Inventory

Importing Customers

Importing Loans