Get started
Color

Import from your current shop software

Ask your current shop software for your customer, vehicle, repair order, invoice and parts data, then bring it into Pop Dispatch.

For
OwnerAdministrator
Hosting
Any hosting
Devices
Web browser
Business
Repair shop

Checked against Pop Dispatch 0.1.0

Pop Dispatch has an import profile for exports from your current shop software. It reads customers, vehicles, repair orders, open invoices, parts and accounts, and your current shop software is a choice on the Import data page.

The column names in the profile for your current shop software are a best guess. Your current shop software documents no bulk export for shops, so the profile is built from the field names that a conversion page for shop databases lists: customer name, address, phone and email, and vehicle year, make, model, engine, VIN and license. Check the columns step on every file and change any choice from its list.

The Import data screen in the web console for the demo business.
The Import data screen.

Before you start #

  • You need the owner or manager role.
  • The account holder asks client services at your current shop software in writing for exports of customers, vehicles, repair orders, invoices and parts, and asks which file type they send. The Import data page links to the conversion page.
  • The export button usually sits on the screen where you view each kind of record, and each list has its own export. For a report, use the export button in the top right of the report.
  • The conversion page lists no financial data. Print your financial reports before you switch, because they may be the only record of your earlier figures.
  • Pop Dispatch reads CSV and Excel (.xlsx) files. When the export arrives as an older .xls file, open it in Excel or Google Sheets and save it as .xlsx or CSV.

What to ask your current shop software for #

  1. Customers, with name, phone, email and address.
  2. Vehicles, with VIN, plate, year, make, model and the customer they belong to.
  3. Closed repair orders for the years you want to keep as history, with number, date and total.
  4. Open invoices with the balance owed and due date.
  5. Parts, with SKU, description, vendor, bin, cost, price, on hand and reorder level.
  6. Fleet accounts, when you bill fleets, with the customer each one belongs to.

Steps in your current shop software #

  1. Open the lists or reports area and choose the list you want, for example Customers.
  2. Select the Export icon in the top right corner of the page.
  3. Repeat for vehicles, fleets and inventory.
  4. For a report, use the export button in the top right of the report. Payment transactions are often under Settings, then Payments, then Transactions.
  5. When a list has no export option, ask client services for a CSV export of it.

Steps in Pop Dispatch #

  1. Open Settings, then Import data, and choose your current shop software.
  2. Import in this order: customers, vehicles, accounts, parts, repair order history, open invoices. For each one choose the kind of data, choose the file and check the columns.
  3. Import customers first. A first and last name in two columns become one name, and a cell phone is used when there is no home phone.
  4. Import vehicles next. A column holding year, make and model together is split into the three fields. Each vehicle finds its customer by customer number, phone, email or name.
  5. Import repair orders and invoices as Service history. Each keeps its number, date and total, and is tied to the customer and the vehicle when they are on file.
  6. Import any unpaid invoices as Open invoices.
  7. For each file, select Check the file, read the problems with their row numbers, and select Import.
  8. Open the lists in Pop Dispatch and compare a few records with your current shop software.
Technical details
  • A history file with no kind column is read as repair orders for an import from your current shop software.
  • Customer numbers from the old system are saved on each customer, so the vehicle and history files find the same customer later.
  • A VIN with the wrong length or an I, O or Q is listed as a problem and that vehicle is left out. A VIN that fails only the check-digit test is kept and flagged.
  • Parts match on SKU. Put the vendor's name in the vendor column and Pop Dispatch adds that vendor to your vendors when no vendor of that name exists. An import you undo removes the vendors it added.
  • A vendors export has no matching import. Vendors come over with the parts that name them.
  • A repair order row is kept as read-only history with its original number, date and total.
  • Open invoices become open invoices for the balance owed, with no tax added.

If something goes wrong #

  • A vehicle row says no customer is on file. Import the customers first, or tick Add a customer when a row names one that has no record yet and include the customer's name in the file.
  • A column is missing from the mapping. Choose it from the list on the columns step.
  • The file is a PDF. Pop Dispatch reads CSV and Excel (.xlsx) only, so ask for another form.
  • See Fixing import problems for every message.