Skip to main content

Menu Price file Import

Introduction​

This will import menu price file to Cloud SQL for PostgreSQL

Fields​

Column PositionDescriptionDatatypeValidationMax lengthMandatoryExample
AVINStringAlphaNumeric17Y1HGCM82633A004352
BMenu DescriptionStringSpecial Characters Allowed255YBrake Service
CLabour time (Hours)NumberUp to 2 decimal places5Y1.50
DPart Number 1StringAlphaNumeric15YPN01
EPart Quantity 1NumberUp to 2 decimal places5Y12.00
FPart Description 1StringSpecial Characters Allowed50YPart Desc 1
GPart Number 2StringAlphaNumeric15YPN02
HPart Quantity 2NumberUp to 2 decimal places5Y12.00
IPart Description 2StringSpecial Characters Allowed50YPart Desc 2
JPart Number 3StringAlphaNumeric15YPN03
KPart Quantity 3NumberUp to 2 decimal places5Y12.00
LPart Description 3StringSpecial Characters Allowed50YPart Desc 3
MPart Number 4StringAlphaNumeric15YPN04
NPart Quantity 4NumberUp to 2 decimal places5Y12.00
OPart Description 4StringSpecial Characters Allowed50YPart Desc 4
PPart Number 5StringAlphaNumeric15YPN05
QPart Quantity 5NumberUp to 2 decimal places5Y12.00
RPart Description 5StringSpecial Characters Allowed50YPart Desc 5
SPart Number 6StringAlphaNumeric15YPN06
TPart Quantity 6NumberUp to 2 decimal places5Y12.00
UPart Description 6StringSpecial Characters Allowed50YPart Desc 6
VPart Number 7StringAlphaNumeric15YPN07
WPart Quantity 7NumberUp to 2 decimal places5Y12.00
XPart Description 7StringSpecial Characters Allowed50YPart Desc 7
YPart Number 8StringAlphaNumeric15YPN08
ZPart Quantity 8NumberUp to 2 decimal places5Y12.00
AAPart Description 8StringSpecial Characters Allowed50YPart Desc 8
ABPart Number 9StringAlphaNumeric15YPN09
ACPart Quantity 9NumberUp to 2 decimal places5Y12.00
ADPart Description 9StringSpecial Characters Allowed50YPart Desc 9
AEPart Number 10StringAlphaNumeric15YPN10
AFPart Quantity 10NumberUp to 2 decimal places5Y12.00
AGPart Description 10StringSpecial Characters Allowed50YPart Desc 10
AHPart Number 11StringAlphaNumeric15YPN11
AIPart Quantity 11NumberUp to 2 decimal places5Y12.00
AJPart Description 11StringSpecial Characters Allowed50YPart Desc 11
AKPart Number 12StringAlphaNumeric15YPN12
ALPart Quantity 12NumberUp to 2 decimal places5Y12.00
AMPart Description 12StringSpecial Characters Allowed50YPart Desc 12
ANPart Number 13StringAlphaNumeric15YPN13
AOPart Quantity 13NumberUp to 2 decimal places5Y12.00
APPart Description 13StringSpecial Characters Allowed50YPart Desc 13
AQPart Number 14StringAlphaNumeric15YPN14
ARPart Quantity 14NumberUp to 2 decimal places5Y12.00
ASPart Description 14StringSpecial Characters Allowed50YPart Desc 14
ATPart Number 15StringAlphaNumeric15YPN15
AUPart Quantity 15NumberUp to 2 decimal places5Y12.00
AVPart Description 15StringSpecial Characters Allowed50YPart Desc 15
AWPart Number 16StringAlphaNumeric15YPN16
AXPart Quantity 16NumberUp to 2 decimal places5Y12.00
AYPart Description 16StringSpecial Characters Allowed50YPart Desc 16
AZPart Number 17StringAlphaNumeric15YPN17
BAPart Quantity 17NumberUp to 2 decimal places5Y12.00
BBPart Description 17StringSpecial Characters Allowed50YPart Desc 17
BCPart Number 18StringAlphaNumeric15YPN18
BDPart Quantity 18NumberUp to 3 decimal places6Y125.00
BEPart Description 18StringSpecial Characters Allowed50YPart Desc 18
BFPart Number 19StringAlphaNumeric15YPN19
BGPart Quantity 19NumberUp to 3 decimal places6Y125.00
BHPart Description 19StringSpecial Characters Allowed50YPart Desc 19
BIPart Number 20StringAlphaNumeric15YPN20
BJPart Quantity 20NumberUp to 3 decimal places6Y125.00
BKPart Description 20StringSpecial Characters Allowed50YPart Desc 20
BLPart Number 21StringAlphaNumeric15YPN21
BMPart Quantity 21NumberUp to 3 decimal places6Y125.00
BNPart Description 21StringSpecial Characters Allowed50YPart Desc 21
BOPart Number 22StringAlphaNumeric15YPN22
BPPart Quantity 22NumberUp to 3 decimal places6Y125.00
BQPart Description 22StringSpecial Characters Allowed50YPart Desc 22
BRPart Number 23StringAlphaNumeric15YPN23
BSPart Quantity 23NumberUp to 3 decimal places6Y125.00
BTPart Description 23StringSpecial Characters Allowed50YPart Desc 23
BUPart Number 24StringAlphaNumeric15YPN24
BVPart Quantity 24NumberUp to 3 decimal places6Y125.00
BWPart Description 24StringSpecial Characters Allowed50YPart Desc 24
BXPart Number 25StringAlphaNumeric15YPN25
BYPart Quantity 25NumberUp to 3 decimal places6Y125.00
BZPart Description 25StringSpecial Characters Allowed50YPart Desc 25
CAGeneric Part 1StringSpecial Characters Allowed50YCoolant
CBGeneric Part Quantity 1NumberUp to 2 decimal places5Y12.00
CCGeneric Part 2StringSpecial Characters Allowed50YOil
CDGeneric Part Quantity 2NumberUp to 4 decimal places7Y1234.50
CEGeneric Part 3StringSpecial Characters Allowed50YGrease
CFGeneric Part Quantity 3NumberUp to 4 decimal places7Y1234.50
CGLex Band 1 LA1NumberUp to 6 decimal places9Y123456.89
CHLex Band 1 LA2NumberUp to 6 decimal places9Y123456.89
CILex Band 1 LA3NumberUp to 6 decimal places9Y123456.89
CJLex Band 2 LA1NumberUp to 6 decimal places9Y123456.89
CKLex Band 2 LA2NumberUp to 6 decimal places9Y123456.89
CLLex Band 2 LA3NumberUp to 6 decimal places9Y123456.89
CMLex Band 3 LA1NumberUp to 6 decimal places9Y123456.89
CNLex Band 3 LA2NumberUp to 6 decimal places9Y123456.89
COLex Band 3 LA3NumberUp to 6 decimal places9Y123456.89
CPLex Band 5 (M25) LA1NumberUp to 6 decimal places9Y987654.32
CQLex Band 5 (M25) LA2NumberUp to 6 decimal places9Y987654.32
CRLex Band 5 (M25) LA3NumberUp to 6 decimal places9Y98.765432
CSService4Fleet Band 1NumberUp to 6 decimal places9Y112233.44
CTService4Fleet Band 2NumberUp to 6 decimal places9Y112233.44
CUService4Fleet Band 3NumberUp to 6 decimal places9Y112233.44
CVService4Fleet Band 5 (M25)NumberUp to 6 decimal places9Y112233.44
CWService4Fleet Platinum (ARVAL) Band 1NumberUp to 6 decimal places9Y778899.00
CXService4Fleet Platinum (ARVAL) Band 2NumberUp to 6 decimal places9Y778899.00
CYService4Fleet Platinum (ARVAL) Band 3NumberUp to 6 decimal places9Y778899.00
CZService4Fleet Platinum (ARVAL) Band 5 (M25)NumberUp to 6 decimal places9Y778899.00

Importing a file​

Preparation​

  1. Check the deployed job's bucket and importFilesDropPath. A common configuration is bucket fnp-imports with prefix oec; these are separate settings.
  2. The current importer expects di_vx_fleet_price_export_<ddMMyyyy>.csv, using the processing date. For example, a run on 18 September 2026 expects di_vx_fleet_price_export_18092026.csv. Upload that basename to the configured prefix. It no longer selects menu_price.csv in the bucket-loading path.

See FNP providers and data for the current importer behaviour and source references.

Validation​

Through Cloud Scheduler

  1. Go to Cloud Scheduler
  2. Run OEC_menu_price_validation job (job name could be different on other env)

Local

  1. In fnp-import-manager, inspect the validate:oec-menu-price npm script before running it. The checked-in script specifies an example local file and a limited row range.
  2. Set the intended local file path (-f), start line (-s) and line count (-l) for the validation run. Local file selection is separate from the date-based bucket filename. Review validation output before persistence.

Importing​

Through Cloud Scheduler

  1. Go to Cloud Scheduler
  2. Run OEC_menu_price_import job (job name could be different on other env)

Local

Use npm run import:oec-menu-price with the intended file and row range. The checked-in script includes a sample path and a one-row limit; do not treat it as a complete production batch without checking the arguments. Persistence upserts on vin and idJob.

Testing​

  1. Data is written to oec_menu_price in the PostgreSQL database selected by the import service's Cloud SQL configuration. Verify this is the same environment/database used by the callable service.
  2. Check persisted batch counts and row errors, then query a known VIN. An import does not automatically refresh an existing enquiry's saved descriptions; use Debugging missing FNP pricing for that investigation.

Troubleshooting Memory Issues​

⚠️ Memory Error Handling:

If you encounter a memory error like Memory limit of 512 MiB exceeded with 515 MiB used, follow these steps:

  1. Increase the memory allocation for the import service (above 512MB)
  2. Re-run the import job
  3. Revert the memory back to default (512MB) after successful import
Status: Accepted
Category: Protected
Authored By: Jeyakumar arunagiri on oct 5, 2025
Revisions