Deleting attributes and predefined values from the attribute dictionary

You can delete attributes and attribute predefined values from the attribute dictionary if conditions change. For example, if the manufacturer no longer makes a product in various sizes and the product is now available only in one size fits all.

Before you begin

Ensure that the attribute or attribute value you want to delete is not assigned to any catalog entries. If the attribute is assigned to a catalog entry, you must delete the attribute or its value from the catalog entry before you can delete the attribute from the attribute dictionary. To delete a predefined value for an attribute, you must delete the value from the attribute dictionary. If the attribute is assigned to a catalog entry, you cannot delete the value.

Feature Pack 6 or later When you delete an attribute, any attribute folder that contains a reference to that attribute will have its reference deleted from the folder.

You cannot delete inherited attributes.

Procedure

Use one of the following methods to delete attributes from the attribute dictionary:

Option Description

Delete predefined values

Option	Description
Delete predefined values	Remove any association between the value and SKUs. If the value is associated with a SKU, you must remove the association before you delete the value. To remove the association, you must delete the SKU. For more information about deleting the SKU, see deleting SKUs. From the explorer view in the Catalogs tool, click Attribute Dictionary. From the list of available attributes, right-click the attribute that contains the predefined value to be deleted; click Open. In the Attribute Values Information section, right-click the predefined value to delete; click Delete. The number of listed values is determined by your page size preference setting. Click Save; then click Close.
Delete attributes	Ensure that the attribute dictionary attribute that you want to delete is not assigned to any catalog entries. If the attribute is assigned to a catalog entry, you must delete the attribute from the catalog entry before you delete the attribute from the attribute dictionary. You cannot delete inherited attributes. Open the Catalogs tool.. From the explorer view filter, select Attribute Dictionary. From the explorer view, click the attribute dictionary to display all of the attributes that are contained within the attribute dictionary. These attributes display in the Attribute Dictionary-Attributes list view. In the list view, right-click the attribute that you want to delete; then click Delete. Note: You cannot delete an attribute that is used in a marketing activity. Before you can delete the attribute, you must first remove the relationship in the activity.
Delete attributes by using catalog upload	You can delete attributes by using catalog upload even if these attributes are assigned to a catalog entry. Attributes must be local to the store that you load the file to. Since multiple value descriptive attributes are supported, when you are deleting descriptive values for an attribute, you must explicitly delete the value. You can no longer replace the values by loading the attribute with new values. If you load a new value for an attribute, the value is included with the existing value. For example, if you have an attribute that is called platform with a value Windows and you want to replace that value with the value Linux, you must first delete the existing Windows value. If you upload the attribute with the Linux value without first deleting the existing value, your attribute now has two available values, Windows and Linux. Note: If you delete a defining attribute from a catalog entry, any SKUs that were defined by that attribute continue to exist and use the deleted attribute. If you want a SKU to stop using an attribute, you must either delete the SKU, or assign a new attribute as the defining attribute of the SKU. Create a CSV file with the following content: `AttributeDictionaryAttributeAndAllowedValues, Identifier,Delete DefAttr1,1` Where `DefAttr1` is the identifier of the attribute to delete. You can also create an XML file that contains the following content to upload for deleting attributes: `<?xml version="1.0" encoding="UTF-8"?> <LoadItems loadItemName="AttributeDictionaryAttributeAndAllowedValues"> <LoadItem Sequence="1.0" Delete="1"> <Identifier>DefAttr1</Identifier> </LoadItem> </LoadItems>` Open the Catalogs tool. From the list beside the Create new toolbar button, select Catalog Upload to open the properties view. In the Manage Catalog Upload tab, browse for the CSV file you created in step 1. For more information about uploading catalog data from your file into the database, see Uploading catalog data. Click Save; then click Close.

Remove any association between the value and SKUs. If the value is associated with a SKU, you must remove the association before you delete the value. To remove the association, you must delete the SKU. For more information about deleting the SKU, see deleting SKUs.
From the explorer view in the Catalogs tool, click Attribute Dictionary.
From the list of available attributes, right-click the attribute that contains the predefined value to be deleted; click Open.
In the Attribute Values Information section, right-click the predefined value to delete; click Delete. The number of listed values is determined by your page size preference setting.
Click Save; then click Close.

Delete attributes

Ensure that the attribute dictionary attribute that you want to delete is not assigned to any catalog entries. If the attribute is assigned to a catalog entry, you must delete the attribute from the catalog entry before you delete the attribute from the attribute dictionary. You cannot delete inherited attributes.

Open the Catalogs tool..
From the explorer view filter, select Attribute Dictionary.
From the explorer view, click the attribute dictionary to display all of the attributes that are contained within the attribute dictionary. These attributes display in the Attribute Dictionary-Attributes list view.
In the list view, right-click the attribute that you want to delete; then click Delete.

Note: You cannot delete an attribute that is used in a marketing activity. Before you can delete the attribute, you must first remove the relationship in the activity.

Delete attributes by using catalog upload

You can delete attributes by using catalog upload even if these attributes are assigned to a catalog entry. Attributes must be local to the store that you load the file to.

Feature Pack 5 or later Since multiple value descriptive attributes are supported, when you are deleting descriptive values for an attribute, you must explicitly delete the value. You can no longer replace the values by loading the attribute with new values. If you load a new value for an attribute, the value is included with the existing value. For example, if you have an attribute that is called platform with a value Windows and you want to replace that value with the value Linux, you must first delete the existing Windows value. If you upload the attribute with the Linux value without first deleting the existing value, your attribute now has two available values, Windows and Linux.

Note: If you delete a defining attribute from a catalog entry, any SKUs that were defined by that attribute continue to exist and use the deleted attribute. If you want a SKU to stop using an attribute, you must either delete the SKU, or assign a new attribute as the defining attribute of the SKU.

Create a CSV file with the following content:

AttributeDictionaryAttributeAndAllowedValues,
Identifier,Delete
DefAttr1,1

Where DefAttr1 is the identifier of the attribute to delete.

You can also create an XML file that contains the following content to upload for deleting attributes:

<?xml version="1.0" encoding="UTF-8"?>
<LoadItems loadItemName="AttributeDictionaryAttributeAndAllowedValues">
	  <LoadItem Sequence="1.0" Delete="1">
		  <Identifier>DefAttr1</Identifier>
	  </LoadItem>
</LoadItems>

Open the Catalogs tool.
From the list beside the Create new toolbar button, select Catalog Upload to open the properties view.
In the Manage Catalog Upload tab, browse for the CSV file you created in step 1. For more information about uploading catalog data from your file into the database, see Uploading catalog data.
Click Save; then click Close.