Import Vehicle Stock

Top  Previous  Next

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 :-

 

clip0619

 

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.