...
After creating the products, you must further export them to fill in the data or download data from the product databases (unless you want to fill them out manually one at a time). Export is done on the home page in the PRODUCTS section, click Export more products here.
Pic. 4.7 Export more products
...
Next, you will see a window for exporting the smartsheet – do not change anything here, just click Confirm.
Pic. 4.9 Confirmation window
...
Pic. 4.10 Export of items
Open the file and for later validation click "Enable Editing" and subsequently "Enable Content" in the macro file.
Pic. 4.11 Enable Editing
Depending on the security level of your system, you may receive the following message instead of the "Enable Content" notification:
Pic. 4.13 Microsoft has blocked macros
In this case, the macro file needs to be unblocked in File Explorer, where you right-click on the file, select Properties, and check Unblock on the General tab.
Pic. 4.14 Unblocking a file
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.
After filling in the data, click Validate Sheet - see the Validation of the Smartsheet file for more.
If validation went well, then save the file and upload it back to the portal, see Import a completed Smartsheet file for more.
4.2.2. Validation of the Smartsheet file
It is advisable to validate the file before uploading it back to the supplier portal to prevent possible errors, e.g. when entering an invalid EAN, missing some of the mandatory fields, etc.
Please note that modifications to Smartsheet can be made at any time, but you must be logged into the Supplier Portal to validate it.
If you are logged in, click Validate Sheet in the top left. The Smartsheet Content Check window will appear and you can confirm with OK.
Pic. 4.15 Validate Smartsheet Contents
In the browser window, you will see the information message "Smartsheet has been authenticated for user XYZ. You can close this window" and an automatic login window for validation
will appear in the excel spreadsheet, where you can press Login.
Pic. 4.16 Login
The results of the check will be displayed.
Pic. 4.17 Validation result
If the validation is completed with errors, select the red highlighted cell - it always contains details of the error in a note (unfilled mandatory data, etc.).
If the validation passes without error, or the errors are corrected after validation, then save the file in the normal way and then upload (import) it back into
the portal on the home page in the Products > Smartsheet Import.
4.2.3. Import a completed Smartsheet template
On the home screen in the PRODUCTS panel, click "Smartsheet Import"
Pic. 4.18 SmartSheet import 1
Next, click on "Import Smartsheet".
You can also see other/previously uploaded files on this page.
Pic. 4.19 SmartSheet import 2
Select the file you want to import.
Pic. 4.20 SmartSheet import - File selection
During the import, another data check is performed, which may reveal errors other than the validation in the smartsheet. After the import, you need to check that the process was successful.
Click on the round icon "Recent background processes" in the upper right menu.
Pic. 4.21 SmartSheet import - Recent background processes
Look at the last process that took place (it is always the first from the top).