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
Searching GGNs: cycle, status, certfied process
In the GLOBALG.A.P. Database you have three search options (#1 - #3), which you can use for more search results. This is the Expert Search.
- Search 1: Search GGN or certificate number
- Search 2: Search by name
- Search 3: Search producers of a product in one country
Depending on the number of GGNs found you will see one GGN with the data tree containing certificate information, more GGNs in order to be able to select any of them by opening the data tree with the plus sign.
A cycle means the one year certificate that is issued for a single producer or a producer group, i. e. one cycle means one calendar year. A current cycle means a current valid certificate, a next cycle a next valid certificate.
It is possible to audit and certify the products before a current certificate runs out, so a producer can have both a current and a next certificate already.
Crucial is the information what is displayed for Certified process. Yes states that the products result from a certified process, No that the production process on the farm was not yet certified.
In the database search there are different status options - in combination with the information of certified process as listed below.
The product status accepted can appear combined with certfied process Yes or No as shown above.
Accepted with Yes means that you see a product of a producer group member, who supplies a group with a certified production process. This combination is used distinctively for such producer group members (option 2).
Accepted with No means that the products has been registered by the Certification Body, the client was "accepted" - however the production process not yet certified. In this case products cannot be marketed as GLOBALG.A.P. certified, there is no paper certificate - if yes, it cannot be confirmed as valid.
First the certificate information in the GLOBALG.A.P. Database has to be updated and the paper certificate can be issued only afterwards.
The product status certified is set upon product certification and triggers the one year certificate cycle. The new certificate cycle is linked with a GLOBALG.A.P. certificate number per product, which is generated by the database.
The certified status shows always that products result from a certified process, so you will see Yes for single producers (option 1) and producer groups (option 2 - or also option 1).
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.
The GRASP status and the checklist results are only for users visible, who have a database access and have signed the relevant documents (Terms & Conditions, Data privacy).
Both the database access and the access to the GRASP results have to be requested. Please, contact the customer support. The Terms of References are also publicly available in the Annex II of the GRASP General Regulations.
The status open non-conformance can be set, when a producer or producer group does not comply with the GLOBALG.A.P. Control Points and Compliance Criterias in an initial certification process.
A producer or producer group can ask for a voluntary suspension of a product, if it is not compliant with certain GLOBALG.A.P. requirements.
A suspension of the product certificate is issued, when a producer or producer group does not present evidence of corrective actions that close out a non-conformance after a Warning has been issued.
This status appears if a product neither has been registered nor certified for a cycle. In search this appears in the case if a product was not included in a current valid certificate, but in a next one that has already been updated in the database.
Visibility of producer and product data: data release
The data access rules of GLOBALG.A.P. allow to choose between the options, whether to hide the company name and address or to show to the public. This way searching producer and producer groups publicly, names and addresses are visible only, if the producer/producer group has granted access rights to these data.
Database users who search the GGNs with a database login (user name & password) belong to the access group "Market participants", they will be able to see the name and address of the certificate holder by default. The certificate holder are the single producer and the producer groups (cooperatives). The names and addresses of the producer group members are hidden by default.
There is another option newly implemented in the database: Growers can also show their product data. Product data currently cover the quantities: hectar for crops, tons for livestock, broodstock, seedlings and tons quantity for aquaculture. By default these quantities are not visible for any of the users.
Ask for data release
Minimum producer and product data are shown according to the data access rules as described above. More information can be released only if the producer/producer group allows to do so. For this the regular way is that the retailer/supplier asks the grower (or the importer/exporter with contact to the grower) for data release (defining which data), so the producer/group can advise its certification body (trustee of masterdata) to change the database settings. Or the producer can ask the customer support for its own database access and complete the changes.
In order to ease this process, a Data release form was created in four languages: English, German, Italian, Spanish. The first three pages have to be filled in by the retailer/supplier (company name, data required) and then forwarded to the producer/producer group. Please, ask the customer support for this form.
The key idea of bookmarking producers is to avoid the recurrent search for single producer GGNs or the upload of upload sheets with a large number of GGNs in order to gain certificate information. With the bookmarking function you can create a personal bookmarking pool of producers. This pool we call List where the GGNs are uploaded only once, but certificate information can be obtained permanently.
This enables a company to trace the deliveries of different suppliers, to group products of one supplier or deliveries from one country. It is up to the user how the deliveries will be differentiated, segregated and finally listed (e. g. List of Avocados Mexico, List of Tomatoes, List of supplier/retailer x etc.).
There can be several lists that are filled with GGNs by uploading them with an Excel sheet. The bookmarking lists can be extended with more producer GGNs the same way. Please, see the chapter Filling lists below.
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
You can bookmark GGNs – then you will see the producer with all the certified products in a Tree view.
Additionally you can bookmark GGNs with the product using a product ID, you can include delivery information such as time of arrival – then you will see the GGNs with the bookmarked products and will be able to filter and download the list in the List view.
For the terms Tree view and List view, please, see the chapter List selection below.
The new bookmarking concept allows that a list can have one editor and one follower. This means that the editor company creates the list and makes it available for the follower company. The editor can view the list, add GGNs and delete GGNs from the list. The follower views the list, too. Both the editor and the follower can edit the list name and the description that can be added – however these changes will be visible only for the company who edits data. Finally if either the editor or the follower do not wish to view the list anymore they can unsubscribe from the specific list.
The bookmarking functionality is available in different packages. The packages differ only in the amount of producers 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.
If you wish to test the bookmarking function before purchasing a package, you can also choose to access it for a free trial period of two weeks. Please contact the customer support.
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 other users. You can add, update lists, and unsubscribe from lists you are follower of.
Add a list
The first step towards bookmarking GGNs is always to have or add a list that will be filled with GGNs later on.
Adding a list means: you set up who shall be the editor and the follower of a list, what shall be the name of the list. Initially the company that is logged in is set by default as Editor and as Follower (Fruitlogistica2011).
If editor and follower are the same, both the company Fruitlogistica2011, 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”, enter the O-Key of that organisation. The O-Key has to be provided by the other company you would like to give access to a list. Finally you 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 be able to only see a list you have added initially. After having created a list for a follower company, this company will receive an e-mail notification.
Has the list been created successfully, it appears in List Management:
Update a list
Update a list means that the name and the description of a list that was saved initially can be changed at any time. These changes become visible only for the company who completes them. The editor does not see what the follower has changed and also the follower will not see the changes done by the editor.
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 to manage a list anymore, you can unsubscribe from that list. If editor and follower are different:
- the editor unsubscribes it cannot update the list anymore, but the follower still can access it
- the follower unsubscribes it cannot access the list anymore, but the editor still can update it
If editor and follower are the same and this company unsubscribes, neither can the list be accessed nor updated. In order to unsubscribe, please, select the symbol for wastepaper bin.
If editor and follower are different companies and the follower unsubscribes from the list, the editor will see the name of the follower company crossed out. If the editor has unsubscribed, the list will not be visible anymore. In case of unsubscription the user(s) with the role Bookmarking responsible of the other company get an e-mail notification about it.
Has the Bookmarking Responsible first chosen or added a list in the List Management, this list can be filled with GGNs and other entries by uploading an .xls-file, the Bookmarking template provided by GLOBALG.A.P. This template contains one obligatory and various voluntary columns.
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.
- GGN: The column with the heading GGN (numbers with 13 digits) always have to be completed. This is the only obligatory entry. If you wish to attach specific e.g. delivery information on product level please use the other (voluntary) columns.
- 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. This entry is voluntary and should be a date.
- article: Can be filled in as required. You can use this entry to describe your delivery in more detail. This entry may be a string of up to 50 characters and is voluntary.
- variety: Can be filled in as required. You can use this entry to describe your products in more detail. This entry may be a string of up to 50 characters and is voluntary.
- site name: Can be filled in as required and might be of use in keeping track of individual sites. This entry may be a string of up to 50 characters and is voluntary.
- delivery order no: Can be filled in as required. This entry may be a string of up to 30 characters and is voluntary.
- advice note no: Can be filled in as required. This entry may be a string of up to 30 characters and is voluntary.
- delivery date: Can be filled in as required. This entry allows you to mark the delivery date. This entry accepts dates and is voluntary.
- SSCC (Serial Shipping Container Code): Can be filled in as required. Through this column you may be able to better organize your batches/deliveries. 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 the item’s GTIN. This entry may be a string of up to 20 characters and is voluntary.
- supplier name: Can be filled in as required.By using this column you can easily link the delivered products to their suppliers. This entry may be a string of up to 128 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 will help you organize and sort your own deliveries as per your necessity. The information that you enter into these columns is not accessible to anyone but your company and GLOBALG.A.P.
If you need more columns than displayed here, please, contact the GLOBALG.A.P. customer support and we will add them to the bookmarking function.
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.
Please, click on “Browse” or “Durchsuchen” in order to select the Excel file with the GGNs you need to see in the list (here the “List for Supermarket 1”), select the list and upload the file. You will get an immediate confirmation after the upload:
Finally the user will get an upload report via e-mail and a link to a file with successfully uploaded GGNs and/or errors. In this file the GGNs and the product IDs are validated and errors are shown, too. If there is an error, those GGNs and products will not be bookmarked. Whether a product is certified or not, this can be checked in List selection.
The follower´s view
As soon as a list was created by an editor company, here Fruitlogistica2011 for the follower company Supermarket 1, this company can see that list and view the entries.
Here Supermarket 1 can see an “Initial List” that is created automatically by the system, can be updated and filled by the company. The list 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
In the Bookmarking tab you will find all your GLOBALG.A.P Bookmarking lists.
The List selection allows you to select one ore more lists in order to view and filter them. If you have used the bookmarking functions before, all your bookmarked producers will be merged into the Initial list.
If you select more than one GLOBALG.A.P. Bookmarking List these lists will be displayed as one merged list.
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 View Selection you can also choose to display only explicitly bookmarked products. If you choose No in the tree view, all products of a GGN will be shown.
Download of bookmarked producers and deliveries
Have you selected the list view for checking all your deliveries, this list can be downloaded.
By clicking on “Download all deliveries” please, open the .csv-file. This .csv-file is a text file, this means that the different information are not shown in separate columns, this .csv-file has to be converted into an Excel file with information separated into several columns. For this please, select the column A that contains all the information, go on the “Data”/“Daten” tab to “Text to Columns”/“Text in Spalten”:
Select 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”:
Your text will now appear in several columns, depending on the number of delimiters in the original list. Should the GGNs be displayed in an incorrect format, this has to be changed, too, by clicking right with the mouse and selecting “Format Cells”/“Zellen formatieren”:
Finally having selected the dialog “Number”/“Zahl” and 0 for “Decimal places”/“Dezimalstellen”, you will see the GGNs in the correct format.
Now you are able to filter the colums as you need and use all information.
If you now save your file as an “Excel workbook/Excel Arbeitsmappe” the information will stay in separate colums.
For any further help and questions, please, feel free to contact the customer support.