...
Pic. 3.6 How to edit multiple items - confirmation
At this point, an Excel table (smartsheet) is generated with the items you selected. If you have already edited these items in the product database, those edits will be inserted into the generated excel table so you don’t need to fill in the changes again.
The smartsheet must now be downloaded from the application by clicking on the file name.
Pic. 3.7 Bulk editing of items - download a generated file
If Excel asks you to enable content when you open the file, confirm the message for the file to function properly.
Pic. 3.12 Smartsheet table
Fill in all the blue fields – they are always mandatory. Other data are optional, but the more data you fill in, the better. At the same time, check that the data added from the product database is correct.
Validate the table after the check. Note that Smartsheet editing can be done at any time, but you need to be logged into the Supplier portal to Validate it.
If you are logged in, click on Validate sheet at the top left. You will see the Validate Smartsheet Content window, which you confirm OK.
Pic. 3.13 Validate Smartsheet Content window
The information message "Smartsheet has been authenticated for user XYZ" will open in the browser window. You can close this window" and an automatic login window for validation will appear in the excel table, where press Login.
The results of the check shall be displayed.
If the validation is completed with errors, some cells are colored red. The cell with the ID contains information about the number of errors for the given item (or row) in the note, the other colored cells have details about the error in the given cell (blank mandatory data, etc.) in the note.
After correcting the errors, it is recommended to validate the table again to make sure that something is not left out.
If the validation is done without errors, then save the file in the normal way and then upload (import) it back to the portal on the homepage in the widget Products > Import filled Smartsheet.