External IDs are mandatory values in terms of Commerce Category imports. It serves as a unique ID key for the record. This can be user defined for a manually generated CSV import file. It can also be the unique key for the record when the data originated as an export from another system. This ID is used to establish the relationship between the CSV files for subcategories and items.
1. Create the saved search for Commerce Categories
a. Navigate to Lists > Search > Saved Searches > New
b. Click Commerce Category
c. Under Criteria tab > Standard Sub-tab:Filter:Select Inactive and Select No and Click SetFilter: Select External ID (Text) and Select Is empty and Click Set
d. Navigate to Result tab > Columns Sub-tabField: Select Internal IDField: Select External ID