Introduction
This article guides you through how to bulk edit the derived attributes of product uids such as weight, height, width, and length.
Steps to Bulk Edit Derived Attributes
1. Navigate to Product UIDs
Go to Product Models
Select a product model
Select the Product UID tab
2. Select Products to Edit
Choose the products you wish to edit.
Single Selection: Check the box next to a single product.
Multiple Selection: Check the boxes next to multiple products.
Select All: Click the checkbox in the table header.
3. Enter Bulk Edit Mode
Click on the Edit button to enter the bulk edit mode.
4. Edit Values Directly
In the bulk edit interface, you'll see a spreadsheet-like view.
Click on the cells corresponding to the attributes you want to change (e.g., weight, height, width, length).
Enter the new values directly into the cells. The changed cells will get a green background.
Note:If a cell has an fx symbol next to it, its value is based on a formula. You can view the formula by hovering over the fx symbol (but can’t edit). To modify the formula, go to the product model and edit the derived attribute itself.
Cells without the fx symbol mean that the value is manually entered.
5. Customize Columns (Optional)
To focus on specific attributes:
Click on the Columns button.
Select or deselect the attributes you want to display.
Click Save to apply your changes.
6. Save Your Changes
After making the desired edits, click the Save button to apply the changes to all selected products.
Frequently Asked Questions (FAQ)
1. How do I edit the formula for a derived attribute?
To edit the formula for a derived attribute, select Parts & Attributes tab of the product model page and then select the derived attribute you want to edit.
2. Can I undo changes made in bulk edit mode?
Yes, if you haven't saved your changes yet, you can cancel or exit the bulk edit mode to discard unsaved changes. I
3. Is there a limit to the number of products I can edit at once?
Generally, there is no strict limit to the number of products you can edit simultaneously.
4. How can I add or remove attributes displayed in the bulk edit interface?
You can customize the columns by clicking on the Columns button within the bulk edit mode. From there, you can select or deselect attributes to display based on your editing needs.
5. Are changes made in bulk edit mode applied immediately?
Changes are applied to the products only after you click the Save button. Until then, your edits are in a draft state and won't affect the live product data.
6. Can I save my customized column settings for future sessions?
This is currently not supported.
7. What if I only want to edit one specific attribute, like weight, for all products?
You can streamline your view by customizing the columns to display only the Weight attribute. Click on Columns, deselect all attributes except Weight, and then proceed to edit.
8. How do I know if a value is manually inputted or based on a formula?
In the bulk edit interface, attributes with an fx symbol next to them are derived and calculated using formulas. Attributes without the fx symbol are manually inputted and can be edited directly.