Importing from Autowork Online

If your garage is switching from Autowork Online (the garage system from MAM Software / Kerridge, offered branded by Euro Car Parts), this guide walks you through getting your data out and into MechIQ. Every step here is a read-only export -- nothing you do changes your Autowork data.

The two routes

Most migrations use both:

  • Route A -- Self-service export (do this now). Download your own data as CSV from Autowork's reporting screens. No notice period, no cost, and you stay live on Autowork while you test the move. This covers the data most garages need: customers, vehicles, service reminders, invoice history and open balances.
  • Route B -- Full export on leaving (the final cutover). When you formally give notice to leave MAM, they compile your complete dataset to CSV and send it to you. This includes detail the self-service reports leave out (itemised job lines, full account settings). Because it's tied to cancelling, it's the last step.

Run Route A today to pull the bulk of your data and start in MechIQ; trigger Route B as the final switch-over so nothing is missed.

The one rule that matters: always use the download link

On Autowork's reporting screens you'll see a note like "4009 records found. Limit is 300 for actions other than CSV download." The on-screen list is capped, but the "Click here to download the records" link (and the "Export To CSV" button) are uncapped -- they give you the full file. Always take the download; never copy from the on-screen list.

One more quirk: Autowork names most exports the same thing (CrmExport.csv for both customers and vehicles, Sales.csv, Sales Ledger.csv). Rename each file as you download it so you don't lose track -- MechIQ reads the contents to know what each file is, but you'll thank yourself for clear names.


Route A -- the self-service exports

All of these live under the red REPORTS and LEDGERS sections of Autowork's left-hand menu. Log in first (Chrome or Edge work best).

1. Customers

Reports → Customer Relationship Manager → Type: Customer Lists

  1. Set Type to Customer Lists.
  2. Tick Select All Customers.
  3. Leave Exclude on stop customers unticked -- you want everyone, including accounts on hold.
  4. Leave both date ranges blank and set Customer Type = All.
  5. Click Display, then Click here to download the records.

Tip: to skip long-dormant records, set Last Invoice Date → Date From to (say) three years ago before you Display -- only customers invoiced since will be included.

2. Vehicles

Reports → Customer Relationship Manager → Type: Vehicle Lists

  1. On the same screen, switch Type to Vehicle Lists.
  2. Tick Select All Vehicles; leave the Make/Model/Engine/Year filters and dates blank.
  3. Click Display, then Click here to download the records.

This file repeats each owner's details and carries the customer account number (Code) on every row -- that's what re-connects each vehicle to its owner in MechIQ. A vehicle whose Code doesn't match a customer isn't dropped: it comes across on Unassigned vehicles (imported) for you to move to its customer (see Data Import). It also brings registration, make, model, VIN and the MOT / Service / Timing Belt due dates. (Engine, year, colour and mileage aren't in this export, and the import doesn't fill them in from the registration -- those fields arrive empty. Fill them in on the vehicle as each car comes through the workshop, or ask for them in the Route B full export below.)

3. Invoice history (all customers)

Ledgers → Sales / Purchase Report

  1. Set Date From well back -- before the garage joined Autowork (e.g. 01/01/2010). It defaults to today, which is why a narrow range returns almost nothing.
  2. Set Date To to today.
  3. Choose Sales, Invoices & Credits, Paid Status: All, Cust Type: All.
  4. Click Export To CSV.

This is your complete invoice-header history across both cash and account customers. (Sanity-check the row count against roughly years on Autowork x your yearly invoice count.) It carries the invoice number, customer account, date, net, VAT and total -- but not the itemised parts/labour lines (those need the Route B full export, below).

4. Open balances (who owes you)

Ledgers → Sales Ledger → Status: Outstanding → Export To CSV

Set the status to Outstanding (leave dates blank) and export. This gives the unpaid invoices -- balance and due date per account -- so your aged debtors and customer statements are correct in MechIQ from day one. Typically a short list.

5. Suppliers

Autowork has no bulk supplier export, but the list is usually short and often padded with non-parts vendors (milk, sandwiches, insurance). Add your real parts suppliers directly in MechIQ by hand -- it's a quick job and doubles as a clean-up. Alternatively, include suppliers in your Route B request.

What about stock, purchases and inspections?

  • Stock / parts inventory -- only worth migrating if you run managed stock in Autowork (many garages don't). In MechIQ, parts populate as they're used on jobs, and a clean catalogue comes from importing a supplier price list, so a rival system's usage log rarely needs to come across.
  • Purchases / purchase ledger -- if you keep purchasing in your accounting package (e.g. Sage) rather than Autowork, there's nothing to migrate here.
  • Inspections / eVHC -- historical checklists have little forward value and mostly can't be bulk-exported. New vehicle health checks start fresh in MechIQ. If you have valuable open advisories (recommended work not yet done), raise that with us directly.

Route B -- the full export when you leave

When you formally give notice to leave MAM Software, they will export your entire dataset to CSV and send it to you (historically posted on Recorded Special Delivery). This is the safety net that captures anything the self-service reports don't expose.

  • How: put the request in writing to your MAM / Euro Car Parts account manager or support desk as part of your offboarding, and ask specifically for the full CSV data export.
  • When: do this last -- it's tied to cancelling your subscription, so only trigger it once you've validated your Route A data in MechIQ and you're ready to switch.
  • Confirm the specifics (format, media, timescale, any fee) with MAM directly -- offboarding terms change over time.

Why you still want it

The self-service Customer and Vehicle lists are your contact book plus reminders -- but they don't include commercial account settings (customer type, VAT code, payment terms, credit limit, parts/labour discounts, account notes), the itemised parts and labour on past jobs, or vehicle engine/year/colour/mileage. If those matter to you, the full export is where they come from.

What the self-service exports do and don't include

Included in the self-service CSVs Only in the full (Route B) export
Names, addresses, phones, email Customer type (cash / trade)
Marketing-consent flags VAT code, payment terms, credit limit
Registration, make, model, VIN Parts & labour discount rates
MOT, service & timing-belt due dates Account notes, warranty / fleet settings
Invoice headers + open balances Itemised parts & labour on each job
Last-invoiced date (for active-customer filtering) Vehicle engine, year, colour, mileage

Sending your files to MechIQ

Upload your CSV files into MechIQ's data importer -- you can add them all at once and MechIQ sorts the order (customers, then vehicles, then invoices) and maps the columns for you.

  • Keep the files secure. They contain your customers' personal data -- store them on your own machine and share them only through the channel MechIQ gives you.
  • This is your data, moving between your systems. As the business, you're the data controller exporting your own records to your new provider -- a normal, lawful migration.
  • Not sure a file is right? Send just the top row (the column headings) and we'll confirm the mapping before you export the full thing.

Autowork Online is a product of MAM Software / Kerridge Commercial Systems, offered branded by Euro Car Parts; names are used here only to describe the system you're exporting from.