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