Bulk editing is available for parts that have unique part numbers in the platform. To bulk edit parts, download the file must be uploaded with the following required information.
- Part Name
- Part Number
- Only unique part numbers are valid
- Part numbers themselves cannot be edited; they are used as an identifier so that Anvyl knows which parts you are attempting to make changes to
To download the pre-filled .csv template, perform the following steps:
- When logged into the platform, click the Parts tab.
- Navigate to the DOWNLOAD menu and export either the parts or parts-suppliers link .csv file
When editing parts, keep in mind that the data you enter on the .csv file will override the existing information that is stored in the parts library. You will be able to add additional MOQs, price points and refresh supplier notes.
Once you have the .csv file with the part numbers for the parts that you wish to update and the appropriate columns that should be changed, perform the following steps to bulk edit these parts:
- When logged into the platform, click the Parts tab.
- Click BULK EDIT
- Click Bulk edit parts or Bulk edit part-supplier links
- You will be asked if the first row contains column headers. Confirm Yes or No.
- Match the appropriate column headers. Click Confirm mapping for each column you wish to update in the platform.
- Click Review and verify if any errors need to be corrected or ignored.
(Note: If you are editing a custom part attribute and receiving an error, please make sure the column header is an exact match to a custom part attribute that has already been added to the Parts library.) - Use the editor to make changes to your parts. Alternatively, if you prefer using Excel, you can make changes to the .csv file and then upload.
(Note: Blank cells will be interpreted as removing information.) - Click Continue.
- Submit when ready. Your bulk edit will be completed once you refresh the page.