CSV Import Update to Add Items to a Transaction Item Option Field Record

This article aims to supply values in the Items field of an Item Option field record (under Setup > Customization > Transaction Item Options). It can be done by performing an Item import instead of a Transaction Item Option import which is not possible.

Here are the steps:

1.  Create a CSV file. See sample below. Item Options should be separated by "|".

Internal ID	Item Option
10001	Color|Size|Material
10002	Size|Material

2.  Import the file. Go to Setup > Import/Export > Import CSV Records. In the Import Assistant: 

   a. Scan & Upload CSV File, set the following: 

       - Import Type: Item
       - Record Type: Inventory
       - CSV File(s): select file created earlier
       - Click Next

   b. Import Options 

       - Data Handling: Add or Update
       - Click Next

   c. Field Mapping:

		Internal ID		Internal ID
		Item Option		Item Options

   d. Run