Deleted attributes
Find, group, and safely delete attribute values that no longer exist in the source system but remain in PIM.
The Attributes deleted at source screen lists product attribute values that no longer exist in the source system (ERP or Excel) but still remain in PIM. For example, if an attribute value of a product is removed in ERP, the old value remains on the product in PIM. The catalog team uses this screen to find these obsolete values, review them, and delete them from PIM if necessary.
The report is recalculated daily in the background; this screen does not initiate the calculation but only shows the result of the last calculation. Deletion is irreversible and marks the products of the deleted values to be resent to channels.
Accessing the screen
- Follow the path PIM & Catalog › Operations › Deleted attributes in the left menu. The page title is Attributes deleted at source.
If you do not see it in the menu, your account does not have permission for this screen. Viewing the list is not sufficient to delete; deletion requires a separate permission. Without it, selection boxes and delete buttons are not visible.
Screen sections
- Title and company selection: To the right of the title is the Company dropdown. When the page opens, the first company in the list is selected automatically. The report always shows data for the selected company.
- Summary cards: General numbers of the selected company's report (explained below).
- Grouped view: If there is at least one record in the report, a collapsible section appears below the summary cards. It groups and counts records by attribute, list, option code, or value. This section is hidden if there are no records.
- Filter card: The Search box, Attribute, and PIM value fields are always visible; Option code and SKU fields are open by default. Below are the Clear, Detailed filters, and Filter buttons.
- List card: Per page selection, result count ("… records"), Delete all matching the filter button if you have delete permission, refresh icon, and Columns menu; below is the table and pagination.
- A note below the list: "One row is one attribute record: deleting it removes that value from all variants of the product."
Summary cards
| Card | Meaning |
|---|---|
| Attribute records | Number of deletable records. Each row in the list is one record. |
| Variant rows | Spread of records across variants: since one record can appear in multiple variants, this number is usually larger. |
| Affected variants | Number of variants carrying these values. Below the card, the source integration used for the report is shown as "Source: …". |
| Last calculated | When the report was last calculated. If unknown (no records in report), it shows No records in the report. Below the card, it reminds that the report is recalculated daily and this screen does not initiate calculation. |
Summary cards are not affected by filters; they always summarize the entire report for the selected company. The number of records matching the filter is shown in the result count on the list card.
Filtering and searching
| Field | Purpose | Tip |
|---|---|---|
| Search | Searches within option code, SKU, attribute name, or value. | For quick search from a single box. Use the fields below to filter by specific fields. |
| Attribute | Shows only records belonging to selected attributes. Defaults to All attributes when empty. | You can select multiple attributes. The count of records for each attribute is shown in parentheses; you can search within the dropdown. |
| PIM value | Filters records by the value in PIM. | |
| Option code | Shows records for specific option codes. | You can enter multiple codes (see below). |
| SKU | Shows records touched by specific variant SKUs. | You can enter multiple SKUs. |
| Attribute list | Shows records belonging only to selected attribute lists. Defaults to All lists when empty. | Added via Detailed filters menu. List name and record count are shown in options. |
- Filters are applied by clicking the Filter button or pressing Enter in a field. If there are unapplied changes, the Filter button is highlighted. Clear empties all filters and the search box and refreshes the list immediately (selected company remains).
- You can enter multiple values in Option code and SKU fields separated by commas. The Enter multiple values button next to the field opens a Multiple values box: paste one value per line, the count of entered values is shown below, and click Apply to transfer to the field. Pasting multiline text directly into the field also automatically joins lines with commas.
- You can toggle Option code, SKU, and Attribute list fields on/off from the Detailed filters menu. Your choice is saved in your browser. Turning off a field clears its value; press Filter to update the list.
- Changing Company resets all filters and search because attribute and list options depend on the company.
- Company, filters, sorting, and pagination are preserved in the URL; you can share a filtered view link with a colleague.
Grouped view
Click the Grouped view heading to expand this section. It is used to answer "which attribute accumulates the most?" before cleaning many records.
- Select the breakdown from the Group by dropdown: By attribute, By list, By option code, or By value.
- The table has columns Group (group name), Promotion capture (number of attribute records in that group), and Variant (number of affected variants). It shows 10 groups per page; below are total group count ("… groups") and pagination.
- Groups are counted according to applied filters. Changing filter or grouping resets the group table to the first page.
- Clicking a group name (Filter by this group) filters the list by that group immediately without pressing Filter. For example, clicking an attribute in By attribute grouping sets the Attribute filter to that attribute.
- Groups without a name appear as (empty) and are not clickable.
List
Each row in the list is one attribute record: a PIM value for an attribute of a product. The same record may appear in multiple variants; these variants are listed in the SKU column.
| Column | Meaning |
|---|---|
| Record no | Number of the attribute record. Hidden by default; can be enabled from Columns menu. |
| Option code | Option code of the product the record belongs to. Clicking the code opens the Products list filtered by this option code; you can check the product's value there. |
| SKU | SKU of the first variant touched by the record. If there are other variants, a "+N" badge appears; hovering over it shows a list of SKUs (up to 50). |
| Variant | Number of variants touched by the record. |
| Attribute list | List to which the attribute belongs. |
| Attribute | Name of the attribute. This column cannot be hidden. |
| PIM value | Value remaining in PIM without a source counterpart. |
| Calculated | Date and time the record was calculated in the report. |
- Click column headers (except Record no) to sort ascending/descending. Sorting applies to all results, not just the visible page.
- Default page size is 10; you can select 10, 25, or 100 from Per page.
- Cells without a value show "—".
- If you have delete permission, selection boxes appear at the start of rows; the header box (Select rows on this page) selects all rows on the visible page. Clicking a row does not open a detail page.
- If the list fails to load, an error "Something went wrong" and a Retry button appear instead of the table.
Actions
Deleting selected records
Used to delete records you review one by one in the list.
- Check the selection boxes of the rows you want to delete. A bar appears above the table showing "… records selected." Click Clear selection on the bar to deselect.
- Click the Delete selected button on the bar.
- The Delete attribute records box opens. It first shows "Verifying records to delete…" and checks if the selected records still exist in the report.
- Read the warning showing how many attribute records will be deleted, how many variant rows they affect, and that deletion is irreversible. If some selected records have disappeared from the report meanwhile, it notes they will be skipped.
- Click the "Delete … records" button. To cancel, click Cancel; your selection remains.
If deletion succeeds, a "Selected attribute records deleted" notification appears, selection is cleared, and summary cards, groups, and list refresh together. The box cannot be closed during deletion; the Cancel button is disabled.
Selection resets if you change page or filter; you can only select rows visible on the current page. To delete many records, use the method below.
Deleting all records matching the filter
Used to clean all obsolete values of an attribute or list at once.
- Set filters and click Filter. Deletion uses the applied filter; changes not applied by clicking Filter are ignored. If no filter is applied, the operation covers all records in the selected company's report.
- Check the result count and rows in the list card.
- Click the Delete all matching the filter button.
- In the Delete attribute records box, verify the number of records and variant rows to be deleted, then confirm with "Delete … records."
If deletion succeeds, a "… attribute records deleted" notification appears and the screen refreshes.
Up to 5,000 records can be deleted at once. If more records match the filter, the box indicates this and the delete button is disabled. Narrow the filter (e.g., select an attribute in the Attribute field) and perform the operation in parts.
Deletion rules
- No record is deleted without confirmation; the box always shows the count beforehand.
- If no records remain to delete, the box shows "None of the selected records are still in the report." or "No records match the applied filter." and disables the delete button.
- If the report changes while the box is open (e.g., someone else deleted the same records), deletion is rejected, an error notification appears, and the box updates with the new count. Check and confirm again.
- If some records are deleted and some cannot be, a "… records deleted, … records could not be deleted" message appears and the screen refreshes.
- Deleted values are permanently removed from PIM and the related products are marked as changed to be resent to channels. The operation is irreversible.
- Delete buttons appear only if you have delete permission and there is at least one record in the report.
Refreshing the list and adjusting columns
- The refresh icon (Retry) in the list card reloads the current page with updated data. It does not refresh summary cards or groups, nor does it recalculate the report. The report is updated in daily calculations.
- You can hide or show columns except Attribute from the Columns menu; your choice is saved in your browser.
Common situations
- The list says "No deleted attributes." No attribute value without a source counterpart exists for the selected company, or no record matches the filter. Clear filters with Clear and check the report calculation time in the Last calculated card.
- "Source integration not defined" warning appears. The selected company has no ERP, Excel, or source integration; no source to compare, so no report can be generated. Make sure you selected the correct company; you can see company integrations in the Companies screen under company details.
- Company box is disabled and says "No PIM company defined in this setup." No PIM company exists in the setup; the report cannot be shown.
- "Report service not configured" message appears. The report is not yet enabled in this setup. Retrying does not help; notify your administrator.
- Selection boxes or delete buttons are not visible. Without product write permission, you can only view the list. If you have permission but they are not visible, there are no records in the report.
- Delete button in the box remains disabled. The button waits during verification. If still disabled after verification, no records remain to delete or the number exceeds 5,000; narrow the filter accordingly.
- Summary cards show "Something went wrong." The report summary failed to load. Click the Retry button next to it; if the problem persists, notify your administrator.
Related screens
- Products — product list opened by clicking option code; check product attribute values here.
- Attributes — attribute definitions and values.
- Companies — companies and source integrations.
- Operations — import and export operation logs.
- Comparison report — product comparison across channels.