Declare variables

Create temp tables

Create indexes

Data Ingestion and Normalization

Parse JSON and insert to temp

Normalize ExtractionDate

Generate SourceTypeID

Normalize part and company names

Normalize packaging

Normalize module/aggregator

Log normalization steps

Validate parts (external service)

Update part and company mapping

Set Not Valid Part Number status

Validate seller mapping

Set Not Mapped Seller Name status

Set Not Mapped Company Name status

Log validation steps

Apply business rules (delete/update)

Handle currency/aggregator constraints

Update Sku from PartNumber if needed

Set LeadTime to NULL for certain sellers

Insert partial aggregators

Mark duplicates

Flag fake/invalid stock

Set statusID from status

Log cleaning steps

Main Processing

Insert LifeCycle records

Insert NotMapped parts

Update NotMapped parts

Delete modules with recent check

Insert Wrong_Data records

Track LastCheckDate

Insert TE Customer Parts

Insert MainParts_Additional

Insert/Update Extra Features

Insert new MainParts

Update MainParts_Not_Match

Update MainParts

Insert MainParts_History

Update Elastic Flags

Log processing steps

Update batch/job status

Return success result

Log finalization

Catch errors

Update batch/job status to error

Log error

End with error