Moving from Shopmonkey
Save your customer list out as a file — an Excel file is fine — and the columns are matched when you bring it here.
You keep Shopmonkey. Treadstock stores tires and nothing else — it is not a shop management system. Your customer list comes over once, as a file you save out yourself, and then you carry on running the shop where you run it now.
Getting the file out of Shopmonkey
The first one is the only one worth hunting for.
- Find the customer export or reportEvery shop system can write its customer list out to a file — it is how shops move to a new accountant, a new phone system or a new owner. Look for an export, a download, or a customers report with a save or download button on it. If you cannot find it, your system’s support line will know the name of it, and asking for “a customer and vehicle export as a spreadsheet” gets you the right thing.
- An Excel file is fineWhat comes down is often an Excel file rather than a .csv, and that is what the import screen expects to see. You do not have to save it again as something else first.
- Open the file once before you send itOne row per customer, with the headings across the top. If a name, a phone number or a car is missing from the file, it will be missing here too — the export is the limit, not us. Opening it in Excel and saving it again is fine.
We do not say which menu it is under, because we do not run Shopmonkey and a guessed menu name sends you hunting for something that is not there. What we can tell you is what to ask for.
The columns matched for you
These are the headings our screen recognises from the Shopmonkey files it has read.
- First Name and Last Name
- Phone (or Phone Number, or Mobile)
- Year, Make and Model
- License Plate
- VIN
- Note
It is a head start, not a rule. Every match is shown on screen with a real value out of your own file beside it, so a wrong guess is obvious, and you can change any of it before one customer is written. A column your file does not have is simply left alone.
What to check once it has run
- The count. The screen says how many customers it added and how many it filled in. If that is far off what you expected, the export was partial — run it again asking for all customers.
- One customer you know well. Open them and check the phone number and the car. If a column went to the wrong place it is obvious on the first person you look at.
- Nobody is in twice. Somebody already here gets their blanks filled in and any missing car added, rather than a second copy. Running the same file twice changes nothing the second time.
- Your tires are the other job. A customer list does not say what is on your rack. Walk the racks logging what is where, or paste a list you already keep.
Questions about moving from Shopmonkey
Does this connect to Shopmonkey?
No. You save a file out of your own system and bring the file here, the same way you would open it in Excel. There is nothing to authorise and nobody to ask.
My file came down as an Excel file. Is that a problem?
No. The import screen reads .csv, .xlsx or .xlsm. The only one it cannot read is the old .xls from before 2007.
Will it make a second copy of customers I already have?
No. Somebody already in your shop gets their blank fields filled in and any car the file knows about added. Nothing already there is written over.
On a different system?
The four with their columns matched are a head start, not the whole list.
The import screen reads .csv, .xlsx or .xlsm out of anything that writes one, and if your system has no export at all there is a template on that screen to fill in.