Import Multiple Subsidiaries for Item Records

The user wants to update an Item Record by associating to Multiple Subsidiaries

Solution

A. Edit the CSV file

1. On the CSV file, add a column for Subsidiaries
2. Use the pipe character ( | ) as a field delimiter
   Note: Make sure that there are no extra spaces before and after the field delimiter (Example: ABC Company : First Subsidiary|ABC Company : Second Subsidiary)

B. Perform the CSV Import

1. Navigate to Setup > Import/Export > Import CSV Records
   1. Import type : Select Item
   2. Record type : Select Inventory Item
   3. Character encoding : Select Western (Windows 1252)
   4. CSV Column Delimiter : Select Comma
   5. Select and Upload the CSV file
2. Click Next
   1. Data Handling : Select Update
3. Click Next
   1. Map the columns on the CSV file
   2. Map Subsidiary to Item : Subsidiary
4. Click Next
   1. Provide an Import Map Name
   2. Enter a Description (Optional)
5. Click Save and Run