All cars are identified by Kommisionsnr which acts as a primary key and matches Order Number in Salesfront.

All cars that are missing in import file will be marked as delivered after import.

Status updates

Workflow state	On create	On update	Logic
sold	+	+	If Status contains SÅLD PV TILL ÅF or SÅLD LAGER and Kundnamn and Säljare are not empty
jump_off	+	+	If vehicle state is sold currently but previous condition does not apply anymore
arrived_branch	+	+	If Status contains L ÅF LAGER or SÅLD LAGER and Noteringar doesn't contain 'WH'
harbour_arrived	+	+	If Status contains L ÅF LAGER or SÅLD LAGER and Noteringar contains 'WH' and Hemkomstdag contain a date
delivered		+	If car is not in the file

Field mappings

Salesfront	Kobra	Comment
branch	Avd	Location code is matched with Salesfront location codes. Matching location is set as home dealer for the vehicle.
modelGroup	Modellgrupp
regNumber	Fordonsid	Registration plate number.
customer	Kundnamn	Customer name.
salesman	Säljare	Salesman code looked up from employee catalogue and assigned to vehicle when matching.
price	Ber. förs.pris
kobraNotes	Noteringar	General notes field. When field contains "WH" substring than we replace it.
orderNumber	Kommisionsnr	Used as Primary Key. Never updated.

If one of these fields were updated through UI then import process will not update them.