FTP Export (CSV)

Dealer Studio allows inventory exports to third-party platforms via FTP or SFTP (preferred). This is achieved by transmitting CSV files containing vehicle inventory data.

To set up an inventory CSV export, please provide the following connection details:

Setting	Description
FTP Server Address	The hostname or IP address of the FTP/SFTP server.
Port	Standard 21 for FTP or 2222 for SFTP.
Username	The username used for authentication.
Password	The password used for authentication.

Standard CSV Columns

The table below lists the standard columns included in the exported CSV file:

#	Column Name	Description
1	Stock No
2	Make
3	Model
4	Series
5	Badge
6	Year
7	VIN
8	Price	The price to be advertised for the car (if car has both dap & egc price, we will select the preferred option based on dealer preference)
9	Odometer
10	Body
11	NVIC	Only supplied if partner holds glasses license
12	Body Colour
13	Trim Colour
14	Features
15	Transmission
16	Capacity
17	Cylinders
18	Doors
19	Engine No
20	Engine Type
21	Rego No
22	Comments
23	Yard Location
24	New/Used
25	Redbook Code	Only supplied if partner holds Redbook license
26	AirCon
27	EGC Price	Excluding government charges price
28	DAP Price	Drive Away Price
29	EngineSize
30	FuelType
31	StockType
32	RegoExpiry	dd/mm/yyyy
33	Drive
34	RegoState
35	Compliance	dd/mm/yyyy
36	GCM
37	GVM
38	Tare
39	SleepingCapacity
40	Toilet
41	Shower
42	Fridge
43	Stereo
44	Axle
45	WheelBase
46	Brakes
47	Coupling
48	Differential
49	SerialNumber
50	Suspension
51	Length
52	Hours
53	SeatBelt
54	DVD
55	CaravanCategory
56	IsDemo
57	Photos	Pipe delimited list of photo URLs

Excluding columns from export

You can optionally exclude specific columns from the exported CSV. When configuring the feed, use Columns to exclude from export and enter the exact CSV header names you want omitted (e.g. Comments, Price). Names must match the column headers in the generated file exactly; any name that does not match an existing column is ignored. The exported file will contain all columns except those you list.