Retailers & suppliers
- 1 Searching GGNs: cycle, status, certfied process
- 2 Visibility of producer and product data: data release
- 3 Bookmarking
- 4 Editor-follower concept
- 5 Bookmarking packages
- 6 First steps: List Management
- 7 Filling lists
- 8 Using the Bookmarking pool: List Selection
- 9 Download of bookmarked producers and deliveries
- 10 Bookmarking XML SOAP interface
Searching GGNs: cycle, status, certfied process
- Search 1: Search GGN or certificate number
- Search 2: Search by name
- Search 3: Search producers of a product in one country
The product status accepted can appear combined with certfied process Yes or No as shown above.
This status is only relevant for the GRASP add-on. For the social practice audit there is no certification, but an assessment. Producer and/or producer groups can be assessed, accordingly the "product" GRASP has the status assessed.
Visibility of producer and product data: data release
Ask for data release
You will be able to:
- Obtain certification information immediately from your list
- Monitor all your GLOBALG.A.P. registered producers
- Avoid recurrent certificate queries online
Another option by using the bookmarking tool is the possibility to add more product or batch/delivery information to the certificate details. Not only the producer GGN and the product is uploaded, but also voluntary company or supply chain specific data (e.g. article name or variety, GTIN, traceability codes such as SSCC, delivery date) related to the specific certificate. The additional information can be accessed, filtered and downloaded via the GLOBALG.A.P. Bookmarking function.
For the terms Tree view and List view, please, see the chapter List selection below.
The new bookmarking concept allows a list to have one editor and one follower. This means that one company creates a list and makes it available for the other company. The company creating the list can decide whether it wants to be its editor or its follower. The editor can view the list as well as manage it by adding and deleting GGNs. The follower is able to view the list content. Both the editor and the follower can edit the list´s name and its description – however these changes will be visible only for the company who edits the data. Finally if either the editor or the follower do not wish to view a list anymore they can unsubscribe from it. The list however will remain usable for the other party.
The bookmarking functionality is available in different packages. The packages differ only in the amount of producers (i. e. GGNs) that you will be able to bookmark:
|Amount of producers that can be bookmarked||Package pricing (annual)|
|up to 50||€ 100|
|50 – 200||€ 200|
|201 – 500||€ 300|
|501 – 1000||€ 400|
|more than 1000||€ 500|
Every bookmarking package also includes the Expert Search tool.
First steps: List Management
The List Management will be only available to users with the database role Bookmarking Responsible. . Here you can manage your company´s own lists or lists you provide to other companies. You can add and update lists as well as unsubscribe from them.
Add a list
Adding a list means: You decide who shall be the editor and the follower of the list and what shall be its name and description. Initially the company that is logged in is set by default as Editor and as Follower (Fruitlogistica2011).
Your company is set by default as editor and as follower. If editor and follower are identical only this company can access and update the list. This can be changed in the drop down menu: If the follower shall be another company, please, select “Other company” and enter the O-Key of that organisation. The O-Key has to be provided by the company you would like to show the content of the list. Click on “Check O-Key” in order to validate the key. Here we entered the O-Key of the company “Supermarket 1”.
Of course you can select your company as a follower and another one as an editor – however then you will only be able to view the content of the list, you cannot edit it. After having created a list with another company as editor or follower, this company will receive an e-mail notification.
After a list has been successfully created, it appears in List Management:
Update a list
You can change the name and/or the description of a list as shown below:
Unsubscribe from a list
If you do not wish to access or manage a list anymore, you can unsubscribe from it. In order to unsubscribe, please, select the wastepaper bin symbol. The result of the unsubscription differs depending on whether the unsubscribing company is the editor, the follower or both. If editor and follower of a list are different and:
- the editor unsubscribes from it, he cannot update the list anymore but the follower is still able to access it.
- the follower unsubscribes from it, he cannot access the list anymore, but the editor is still able to update it.
In case of unsubscription the user(s) with the role Bookmarking responsible of the other company get an e-mail notification about it and the name of the unsubscribing company will be shown as crossed out in the List Management.
If editor and follower are the same and this company unsubscribes, neither can the list be accessed nor updated.
You can download this Bookmarking Excel template here.
Please note the message: All formatting in this document and information beneath this line is only for your information. It will not affect the upload result although it may be marked erroneous. This means that in order to avoid irritations all these lines with examples and explanations should be deleted before uploading the sheet.
Below you will find a brief description of each column.
- product ID: If you wish to attach information to single products of the producer, please enter the corresponding product key (e. g. “2” for apples). These product keys are available in the second sheet of the Excel file provided by GLOBALG.A.P. If you wish to upload more that one product for the same GGN, please use one line for every product key and copy the GGN.
Please, note: if you do not enter any product ID, you will see only the GGN in that line without any certificate data. Bookmarking allows you to attach additional information on product level only if you enter the GGN with the product ID.
- ETA (Estimated Time of Arrival): You can use this column to track the estimated time of arrival of deliveries or communicate it to the follower of the list. This entry is voluntary and should be a date.
- delivery date: Can be filled in as required. This entry allows you to mark and communicate the delivery date. This entry accepts dates and is voluntary.
- SSCC (Serial Shipping Container Code): Can be filled in as required. Using this column you may be able to better organize your batches/deliveries or communicate them to the follower of the list. This entry may be a string of up to 30 characters and is voluntary.
- GTIN (Global Trade Item Number): Can be filled in as required to keep track of or communicate the item’s GTIN. This entry may be a string of up to 20 characters and is voluntary.
As you can see, all columns following the GGN are described as being voluntary. These entries comprise suggestions and requirements by GLOBALG.A.P. stakeholders, which can help you to organize and sort your own deliveries. The information that you enter in these columns is not accessible to anyone but your company, a possible follower of the list and GLOBALG.A.P.
This is how a completed Excel sheet can look like:
You can upload the file with GGNs to one, more or all available lists of the company. This has to be selected before the upload.
The follower´s view
Here Supermarket 1 can see an “Initial List” that is created automatically by the system and can be updated and filled by the company. The list “List for Supermarket 1” that was created by the editor, Fruitlogistica2011 is also visible with the number of GGNs included. For more information can be selected:
In this List Management the follower, company Supermarket 1 can also update the name and the description of any of the lists. These changes are only visible for the follower, not for the editor. The follower can also unsubscribe from the list if it is not relevant anymore.
Using the Bookmarking pool: List Selection
There are two ways how a list can be displayed, as a tree or a list. You can select the preferred view in View selection.
Here you see the tree view:
Below the list view:
In the List view the GGNs are only shown with product certificate information if the product was explicitly bookmarked. GGNs that were bookmarked without products are shown, however without certificate information as this information is linked to products.
If you choose No in the tree view, all products of a GGN will be shown. Otherwise only products of a producer that where explicitly bookmarked by entering the GGN and the product ID in the Bookmarking template are shown.
Download of bookmarked producers and deliveries
Have you selected the List view for checking all your deliveries, you can can download the list.
To do so please click on “Download all deliveries” and open the .csv-file. This .csv-file is a text file, this means that the different information are not shown in separate columns. The .csv-file has to be converted into an Excel file with information in separated columns. For this please open the .csv-file in Excel and select the column A that contains all the information, then go to the “Data”/“Daten” tab and select “Text to Columns”/“Text in Spalten”:
Now the Text Wizard/Textkonvertierungs-Assistant starts, where you need to choose the format of your current data. The .csv-file contains the character | to separate the various fields, so each information that is separated by that character shall be put in a separate column. Please, select “Delimited”/“Getrennt” and click “Next”/“Weiter”. A preview of your selected data appears below.
You are now asked to select the type of character that separates the various fields: This is the delimiter mentioned above. Enter | in the field provided for “Other”/”Andere”, a preview of the data in columns appears below, according to the delimiter selected, then click “Next”/“Weiter”:
Once you have selected the data type for each column, click “Finish”/”Fertig stellen”:
Now choose the tab “Numbers”/ “Zahlen” and select “Number” /”Zahl” as your preferred “Category”/ “Kategorie”. Finally enter 0 for “Decimal places”/“Dezimalstellen” and press “OK”. You will now see the GGNs in the correct format.
Now you are able to filter the colums as you need and use all information.
For any further help and questions, please, feel free to contact the customer support.
Bookmarking XML SOAP interface
please see the link to the article below: