This will import only dealers stock, not full free stock

Log in to Amazon Web Services (AWS)

Imported data can be checked here

Link to PROD logs:

https://eu-north-1.console.aws.amazon.com/cloudwatch/home?region=eu-north-1#logsV2:logs-insights$3FqueryDetail$3D~(end~0~start~-86400~timeType~'RELATIVE~tz~'LOCAL~unit~'seconds~editorString~'fields*20*40timestamp*2c*20*40message*0a*7c*20sort*20*40timestamp*20asc*0a*7c*20limit*2010000*0a*7c*20filter*20*40message*20like*20*2f*2f~queryId~'518aae5d-6e08-4fb3-805f-3eb89b105ebe~source~(~'*2faws*2flambda*2fmicroservice-bassadone-import-prod-cron)~lang~'CWLI)

Link to DEV (test) logs:

https://eu-north-1.console.aws.amazon.com/cloudwatch/home?region=eu-north-1#logsV2:logs-insights$3FqueryDetail$3D~(end~0~start~-3600~timeType~'RELATIVE~tz~'LOCAL~unit~'seconds~editorString~'fields*20*40timestamp*2c*20*40message*0a*7c*20sort*20*40timestamp*20asc*0a*7c*20limit*2010000*0a*7c*20filter*20*40message*20like*20*2f*2f~queryId~'518aae5d-6e08-4fb3-805f-3eb89b105ebe~source~(~'*2faws*2flambda*2fmicroservice-bassadone-import-dev-cron)~lang~'CWLI)

Filter by text - VIN/dealer etc filter @message like /text/ |fields @timestamp, @message

VehicleLogisticStateNo	OrderState	On creation	On update	SF status

VehicleLogisticStateNo	OrderState	On creation	On update	SF status
null		+	+	keep the existing status
5 10	vehicle-initial- Factory vehicle-waiting- Factory	+	+	Pre-ordered
15	vehicle-ordered- Factory	+	+	Ordered
20	vehicle-confirmed- Factory	+	+	Production plan
25	in production- Factory	+	+	Production
30	vehicle-ready- Factory	+	+	Ready for retail
40	vehicle-transfer- Factory	+	+	In transit
45	vehicle-free-storage- Hanko	+	+	Harbour arrived
60	vehicle-equipped- Hanko	+	+	Harbour parts fitted
62	waiting for transport - Hanko	+	+	Transport requested
70	vehicle-sale-account- Dealer	+	+	Arrived branch

If for example status 25 - Production is applied then previous statuses 15 and 20 will be automatically applied well.

Statuses, which are not defined, for example 55 should should apply at least previous status 45 - Harbour arrived

50 and 55 = 45 - Harbour arrived

35 = 30 - Ready for retail

66 = 62 - Transport requested

Fields list

Default strategy of filling individual fields, depending on whether vehicle is being created or updated during import.

Salesfront	Bassadone API	On creation	On update	Notes

Salesfront	Bassadone API	On creation	On update	Notes
Order number	OrderNumber	+
Order date	OrderCreated	+	-
Status	VehicleLogisticStateNo/ OrderState	+	+	Used to evaluate workflow state
Model	ModelSeries + Model	+	+	Vehicle local name from PDM based on EIC
End Item code	ModelFactoryCode	+	+
ETA	EstArrivalToFinland	+	+
VIN	VIN	+	+
Dealership	OrderingDealerCode	+	+	Dealership code is matched to ones in Locations
Color code	OrderColor	+	+	Exterior color
Interior code	OrderDecor	+	+	Interior color
Production date	VehicleLogisticStateNo - 25	+	+	Status changed to 25 and if bigger then first import date

In first place pipe import should check VIN-code existence and then order number. Order number can change and it will be updated if needed.

For dealer stock cars initial reservation order number will start with 9 and if this order is confirmed then it will be changed to 5. Vehicles which order number starts with 9 will always have VIN-code and order number 5 will never change to 9. Vehicles whose order number starts with 5 can only get an additional VIN-code.

Vehicles which order number starts with 9 will be ignored!

Dealership will be assigned depending on External ID, otherwise vehicles will be added to HQ.

API user bassadone-import should have Dealership access.

Ordering dealer	Ordering dealer number
Autlit UAB	15802
AUTOSPIRIT TARTU OÜ	15490
City Motors AS	15506
Eurostauto OÜ	15501
Eurostauto Pärnu	15500
FAKTO AUTOCENTRAS UAB	15840
Norde SIA	15645
Raitas UAB	15891
SIA SKANDI MOTORS	15032
TEHAUTO LATGALE	15641
UAB IVUANA	15820
UAB TechRuna	15892
Wiru Auto OÜ	15228
Auto Bassadone OÜ, Laagri	15400

If vehicle is updated in factory system, then it should be rebuilt in the Salesfront!

Customer name and salesman name are available in API, but will be not filled in Salesfront

https://modera.atlassian.net/browse/CLS-11748

payload example if Importer stock

{
        "Make": "Nissan",
        "ModelSerie": "Qashqai",
        "Model": "MHEV 158 Xtronic 2WD N-Connecta",
        "FactoryCode": "TDZALEWJ12UGB-H3EQ",
        "ModelYear": "20231",
        "ModelGeneration": "N-Connecta",
        "ModelBodyType": "",
        "ModelDriveType": "FWD",
        "ModelDrivingForce": "BE",
        "ModelDrivingForceAlternative": "",
        "DrivingForceOption": "MHEV",
        "ModelTransmission": "A",
        "DecorCode": "G",
        "ColorCode": "XDF",
        "Co2CombinedWLTP": "143.000000",
        "VehicleAccs": "",
        "Serial": "SJNTAAJ12U1466268",
        "LicenseNumber": ""
    },
    {
        "Make": "Nissan",
        "ModelSerie": "Qashqai",
        "Model": "e-POWER 2WD N-Connecta",
        "FactoryCode": "TDNALE9J12HGB-ANEE",
        "ModelYear": "20231",
        "ModelGeneration": "N-Connecta",
        "ModelBodyType": "",
        "ModelDriveType": "FWD",
        "ModelDrivingForce": "BE",
        "ModelDrivingForceAlternative": "EL",
        "DrivingForceOption": "HEV",
        "ModelTransmission": "A",
        "DecorCode": "G",
        "ColorCode": "Z11",
        "Co2CombinedWLTP": "117.000000",
        "VehicleAccs": "",
        "Serial": "SJNTBAJ12U1467192",
        "LicenseNumber": ""
    }

payload example if Dealer stock

 {
            "OrderCreated": "2024-10-21T11:40:42.000Z",
            "OrderDay": "2024-10-21T00:00:00.000Z",
            "EstArrivalToFinland": "2024-11-06T00:00:00.000Z",
            "ArrivalToFinland": "2024-11-06T15:02:59.000Z",
            "Make": "Nissan",
            "ModelSeries": "X-trail",
            "Model": "e-4ORCE Tekna 5ST MY24",
            "LicenseNumber": "",
            "VIN": "JN1T33TB2U0025946",
            "OrderState": "importerorder-invoiced",
            "VehicleLogisticStateNo": "70",
            "OrderNumber": 516444,
            "OrderType": "1",
            "OrderSalesType": "8",
            "OrderingDealerCode": "15506",
            "OrderingDealerCountry": "EE",
            "OrderingDealerName": "City Motors AS",
            "OrderingSalesmanName": "Hanna Pruulsen\t",
            "OrderingSalesmanEmail": "hanna.pruulsen@citymotors.ee",
            "DeliveryDealerCode": "15506",
            "DeliveryDealerName": "City Motors AS",
            "EndCustomerName": "City Motors AS",
            "EndCustomerCompany": "",
            "EndCustomerAddress": "",
            "EndCustomerCity": "",
            "EndCustomerZipCode": "",
            "EndCustomerTel": "",
            "EndCustomerEmail": "",
            "EstimatedCustomerDeliveryDay": null,
            "DrivingForce": "BE",
            "EnginePowerRPM": null,
            "OwnWeight": 1936,
            "EnginePowerKW": null,
            "ConsignmentLimitSwapDate": null,
            "RowInputTime": "2025-01-17T14:22:45.647Z",
            "ModelFactoryCode": "TDNNLG9T33TGA-FSAB",
            "OrderColor": "NBL",
            "OrderDecor": "C"
        },
        {
            "OrderCreated": "2024-10-21T12:04:05.000Z",
            "OrderDay": "2024-10-21T00:00:00.000Z",
            "EstArrivalToFinland": "2024-09-06T00:00:00.000Z",
            "ArrivalToFinland": "2024-09-09T16:44:50.000Z",
            "Make": "Nissan",
            "ModelSeries": "Qashqai",
            "Model": "e-POWER 2WD N-Connecta MY24",
            "LicenseNumber": "",
            "VIN": "SJNTBAJ12U2060871",
            "OrderState": "importerorder-invoiced",
            "VehicleLogisticStateNo": "70",
            "OrderNumber": 516450,
            "OrderType": "1",
            "OrderSalesType": "8",
            "OrderingDealerCode": "15506",
            "OrderingDealerCountry": "EE",
            "OrderingDealerName": "City Motors AS",
            "OrderingSalesmanName": "Hanna Pruulsen\t",
            "OrderingSalesmanEmail": "hanna.pruulsen@citymotors.ee",
            "DeliveryDealerCode": "15506",
            "DeliveryDealerName": "City Motors AS",
            "EndCustomerName": "City Motors AS",
            "EndCustomerCompany": "",
            "EndCustomerAddress": "",
            "EndCustomerCity": "",
            "EndCustomerZipCode": "",
            "EndCustomerTel": "",
            "EndCustomerEmail": "",
            "EstimatedCustomerDeliveryDay": null,
            "DrivingForce": "BE",
            "EnginePowerRPM": null,
            "OwnWeight": 1681,
            "EnginePowerKW": 140,
            "ConsignmentLimitSwapDate": null,
            "RowInputTime": "2025-01-17T14:22:45.647Z",
            "ModelFactoryCode": "TDNALE9J12HGA-A---",
            "OrderColor": "GAT",
            "OrderDecor": "G"
        }]

Pilot was City Motors - live 01.12.2014

Need to be discussed:

ignore bookings - vehicles which order number starts with “9”?

User Guides

Nissan Bassadone dealer stock API

Fields list

payload example if Importer stock

payload example if Dealer stock

Related content