Product field not populated when importing Work Order Line Items

Issue

You imported Work Order Line Item records and you observe from Salesforce UI, in the Work Order Line Item list inside the Work Order record that the Product was not populated (Product is not shown by default but you can add it editing the Work Order layout).

Cause

Work Order Line Item object doesn't work in the same way when using Salesforce API v37 (the version that dataloader.io supports) and how it works in latest versions (v52 by the time this article is written).

In v52 You don't map the Product2Id. The field is read only and is populated with a save hook based off the PricebookEntryId field while in v37 the field is not automatically populated.

Solution

When working with dataloader.io (currently supports Salesforce API v37) you need to populate the Product2Id field manually. The Product2Id needs to be included in the input CSV file and map it when setting your task.