Monday, April 8, 2019

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 IDInternal ID
Item OptionItem Options

   d. Run


No comments:

Post a Comment