If your item list is already published in a request and you need to make edits or add new columns, you can do so by using an Excel file. Follow these steps:
1. Download the Existing Item List
- Open the Items tab of the request.
- Click the ‘Download Item List’ button to download the published list of products.
2. Important: Use the System-Generated File
- It’s crucial to use the file you downloaded from the system! This file contains an essential column labeled "Original ID" that assigns a unique ID number to each product.
- Do not delete or modify the "Original ID" column. This ID ensures that any updates you make are applied to the correct products when you upload the file back into the system.
Note: If you upload a file that was not downloaded from the system, the system will not recognize the information and will treat it as new products. This will result duplicates being created.
3. Edit the Excel File
-
Open the downloaded file and make the necessary changes:
-
Update existing information in the columns.
-
Add additional columns if needed (you can also add columns directly on the platform before downloading the file).
-
-
Once you’ve made the necessary edits, save the file.
4. Upload the Updated Item List
- Return to the Items tab and click the ‘Upload Item List’ button.
- Select the file with your updated information.
- If you've added new columns in the Excel file, the system will prompt you to configure how these columns should be displayed. Choose the appropriate fields for the new columns and click ‘Upload’.
5. System Updates
- After uploading the file, the system will update the information within a few seconds.
By following these steps, you can easily manage product details and make necessary adjustments without creating duplicates or losing critical information.