Importing your price book

Getting Started

When you first begin using FireMate 451, you have the option to use the supplied default price book (in which case you can skip this guide and get right to building your first estimate!), or you can import your own price book to use as the default for your company.

Whichever option you choose, all future estimates will be built using that price book.

NOTE: It is recommended that you do not build any estimates prior to importing a new price book. If you have existing estimates, you must first delete them before beginning the import process.

 

Preparing Your Price Book

The first step in importing your price book is to format your existing price book into a CSV (comma separated value) spreadsheet according to the specifications below, so that you may import it using our automated importing tool.

The CSV structure guidelines are as follows:

  1. All individual items (non-assemblies) must appear at the top of your CSV.
  2. All assemblies that may be included in other assemblies must also appear at the top of your CSV, below the individual (non-assembly) items.
  3. All assemblies that include other assemblies must appear at the end of your CSV.

These are the columns that are required in your CSV:

Column Header Description Format Example
name long name alpha-numeric 1" LINE HANGER ASSEMBLY TBC
shortname short code  alpha-numeric AHLB1
jobphase default phase  integer (index of phase) 0
description short description  alpha-numeric  1in Line Hanger Assembly TBC
material cost/value rate #1  integer with two decimals (leave blank if assembly) 0.00
labor cost/value rate #2  integer with two decimals (leave blank if assembly) 0.00
fab cost/value rate #3  integer with two decimals (leave blank if assembly) 0.00
shop cost/value rate #4  integer with two decimals (leave blank if assembly) 0.00 
miscsub cost/value rate #5  integer with two decimals (leave blank if assembly) 0.00 
isassembly assembly: true or false  1 or blank
assemblyitems reference items within the assembly  shortcode|qty separated by commas (blank is non-assembly) HRP1|1,HATRB3E|1,HTBCB3E|1 
assemblycount total unit quantity (multiplier factor)  integer (blank if non-assembly)  100 

Here is a simplified example of a valid CSV import.

 

Importing Your Price Book

After you have prepared your price book according to the specifications above, you can now import it using our automated importing tool.

NOTE: Once you import your price book, it will overwrite the existing price book entirely. If there are any items or assemblies you wish to include in your new price book, you must first add them to your CSV for import.

  1. Point your browser to subdomain.firemate451.com/importitemscsv.php.
  2. Click Choose File and select the CSV file on your computer for import.
  3. Click Upload to begin the import.

While your price book is being imported, our software will scan through it and look for CSV formatting errors, such as an assembly referencing an individual item that does not exist. If it finds any problems, the import will halt and an error message will be displayed indicating what the problem is and where it was found in the file. You must then remedy the issue and attempt to import the file again.

When the file has been imported successfully, you will receive a "success" notification in the browser window. You can then begin building estimates using your new price book.

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk