+ Start a Discussion
Blake Carrera 4Blake Carrera 4 

Update an Order with the Correct Products via DataLoader

We have an integration with NetSuite via Jitterbit. An implementation partner created something inside of Salesforce that is multiplying the number of order products on an order. I have a data backup file that includes CSV information on orders and order products. What I'm trying to do is use DataLoader to update these orders, but I'm not sure how to proceed. Would I use Update on the Order Product object? I'm not sure if that would delete the extra items or not. 

Does anyone have any advice on how to do this?
AnudeepAnudeep (Salesforce Developers) 
Hi Blake, 

Follow the below steps for adding Order Products to existing Orders in Salesforce.

Use Data Loader and select Insert to create new or Upsert to create new and update existing Order Products.

1. Check the box for 'Show all Salesforce objects'

2. Select "Order Product (OrderItem)"

3. Choose the CSV you created and Next.

4. Hit next again (For Upsert, map the Id column from the CSV as the default Matching Field for Data Loader Step 2a).

5. Create a Mapping, Auto-Match Fields to Columns, click OK, and click Next.

6.  Click the Browse... button to select the directory where the success and error files should be saved, then click "Finish".

7. When a pop appears asking you to proceed, click Yes.

See Import Order Products with Data Loader for step by step instructions