...
As with creating a new item, you must pay attention to the mandatory fields marked with an asterisk (*). If all required fields are not filled in, the item cannot be sent to Globus. The number of unfilled mandatory fields is displayed as a small number at the top left of the screen next to the text "Master data". If all required fields are filled in, the number will no longer be displayed.
If you are using a product database (BrandBank, ZAS/Promis, GDSN), you can update the items in the database and then edit them using the "Load data from the product bank" button at the bottom of the screen, i.e. you do not have to fill in the data multiple times for each item.
...
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.
Pic. 3.14 Login
The results of the check shall be displayed.
Pic. 3.14 Validation results
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.