Administering Imports and Commodity Code Manager

The following is an example of the CommodityCode.csv file format:

UTF8

Domain,UniqueName,Name,ParentUniqueName

unspsc,41101504,Homogenizers,41101504

unspsc,41101807,Electron diffraction apparatus,411018

unspsc,41103019,Plasma storage freezers,411030

unspsc,41102916,Microtomes,411029

unspsc,41103704,Biological baths,411037

• Note that the Domain is all unspsc, which is the parameter value.

  (This would be custom in Jenny's import file.)

• The UniqueName is the system's unique ID or name, with the Name being the display name.
• ParentUniqueName references the UniqueName of the commodity code above it within the hierarchy.

On the dashboard, choose Manage, and then Core Administration.

Choose Site Manager, then choose Data Import/Export.

Find the task Export Commodity Codes, and choose Export.

Choose the adapter source and choose OK.

The following options are available to choose as the adapter source:

• All - Exports all the commodity codes in the site.
• AribaManaged - Commodity codes manually imported within Site Manager
• External - The object and all its data fields are maintained in an external system, such as an ERP system or a set of CSV files. Objects with this adapter source can be overwritten or deleted when data is imported from the external system.

On the dashboard, choose Manage, and then Administration.

Choose Site Manager, then choose Data Import/Export.

Search for the Import Commodity Codes task, and choose Import.

Choose Load or Create, and enter the location of your CommodityCode.csv file, and then choose Run to import your data.

On the dashboard, choose Manage, and then Administration.

Select Commodity Code Manager, and then choose Commodity Codes.

Perform one of the following actions:

• To edit a commodity code, search for the value by entering the commodity code ID or Name, and when located, choose Edit.
  • The name, parent, mapping entries and enablement can be edited.
  • The domain and ID cannot be edited.
• To create a new mapping, choose Create New.

Upon selecting Create New, Administrators will be required to input the Domain, ID and Name.

Parent is optional, and the Commodity Code Map Entries tab is where mappings can be assigned.

From the dashboard, choose Manage﹥Administration.

Select Commodity Code Manager, and then choose Commodity Code Maps.

Perform one of the following actions:

• To edit a mapping, search for the mapping by entering the commodity code in the Value From or Value To field, and choose Edit.
• To create a new mapping, choose Create New.

Choose values for the domain and value fields, and choose Save.

To import ERP commodity mappings:

1. Create a commodity code mapping file (CommodityCodeMap.csv) that contains only the commodity code mappings you want to add.
2. Choose Manage﹥Administration.
3. Choose Site Manager, and then choose Data Import/Export.
4. On the Import tab, search for the Import Commodity Code Mappings task and click Import.
5. Choose Load or Create, and enter the location of your CommodityCodeMappings.csv file, and then choose Run to import your data.

"Now that my new value has been created and the row removed from our master data file, I can go in and deactivate the old value.

Luckily, I do not need to run a deactivate import since I only have one. I will go ahead and deactivate this one in Commodity Code Manager, instead."

On the dashboard, choose Manage﹥Administration.

Select Commodity Code Manager, and then choose Commodity Codes.

Search for the commodity code by entering the ID or Name. When located in the search results, check it's box and select Edit.

Change the Enabled value to No and then Save.