It is possible to prepare a spreadsheet file of vehicles to add to the system and import in one go. This is useful for example when purchasing a number of used vehicles from auction or from a finance company. They can simply be imported rather than keyed in manually.
The first step is to format the spreadsheet file. The spreadsheet should have column headings in row 1 which contain some or all of the following (the mandatory ones are red):-
Field Name |
Description |
Example |
ModelCode |
This is the internal model code of the vehicle. It is unlikely that this field would ever be used |
1.2.1.1.1.1.1.2 |
RegDate |
The Registration Date of the vehicle |
01/05/13 |
VehicleType |
Car, Commercial - defaults to Car |
Car |
VatStatus |
Margin, Qualifying or Commercial - default is Margin |
Margin |
RegNo |
Registration No of the Vehicle |
AB53ABC |
Colour |
Colour of the vehicle |
Red |
DateDue |
Date due in stock |
21/10/17 |
SupplierAccountNo |
Supplier Account No |
0500 |
BoatName |
Name of the Boat (if the vehicle is a boat) |
|
RetailPrice |
Retail Price of the Vehicle |
5000.00 |
PurchasePrice |
Purchase Price of the Vehicle |
4000.00 |
ChassisNo |
Chassis no of the Vehicle |
VF1A12345667678678877 |
EngineNo |
Engine no of the Vehicle |
67676766 |
PurchasedBy |
Name of the staff member who purchased the vehicle |
Fred Bloggs |
AddToWeb |
Add to Web Site ? Yes/No - defaults to No |
No |
Make |
Make of the Vehicle |
Ford |
Model |
Model of the Vehicle |
Fiesta |
Specification |
Specification of the vehicle |
1.0 Zetec 5 Door |
SourceOfSuppliy |
The source of supply of the vehicle - this can be a supplier or a location as needed |
Auction |
To import the file, on the Vehicle Administration toolkit click on the Import Used Stock Button on the Import/Export Menu Tab :-
This will prompt for the file to import and will then import the file creating stock records for the vehicles in it. Any errors will be reported on screen.