You can further edit the items through the list of items by clicking an item from the list.
Pic. 3.1 Item selection
Pic. 3.2 Item detail
As with creating a new item, you must pay attention to the mandatory fields marked with an asterisk (*). 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.3 Save, Send and Update buttons
To finish the editing of an item, click Save data for later or Send data to Globus.
1.1. Bulk editing of items
If you need to edit more than one or a few items from each category, you can edit them in bulk.
Press the “Products” link located on the top left main page to get to the list of supplier categories you have access to. Click on the category whose articles you want to bulk edit (e.g. on Household, Decorations or Drugstore).
Pic. 3.4 Selection of category for bulk edit
The items you have assigned to the category are displayed. For each item, there is a check box for selecting items (1.).
Check this box for all items you want to edit in bulk, and then click on "Export smartsheet" (2.).
Pic. 3.5 Selection of items for bulk edit
Next, you will see a window for exporting smartsheet – do not change anything here, just click Confirm.
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.