Retailers & suppliers

From GLOBALG.A.P. Wiki
Revision as of 14:53, 8 August 2012 by Ad (talk | contribs)
Jump to navigation Jump to search

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.

Search GGNs.jpg


Cycle

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.

Certified process 3.jpg



Certified process

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.

Certified process 2.jpg Certified process 4.jpg



Status

In the database search there are different status options - in combination with the information of certified process as listed below.


  • Accepted Accepted.jpg

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.


  • Certified Certified.jpg

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).


  • Assessed Assessed.jpg

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.

In case of a producer group the members of the cooperative stay accepted Accepted.jpg.

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).

Sowohl der Datenbankzugang als auch die GRASP-Datenfreigabe müssen beantragt werden. Dafür kontaktieren Sie bitte das customer support. Die Datennutzungsbedingungen können Sie auch dem GRASP Allgemeinen Regelwerk(Anhang II) entnehmen.


  • Open non-conformance Onc.jpg

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.


  • Self-declared suspension Sds.jpg

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.


  • Suspended Sus.jpg

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.


  • Non confirmed Not conf.jpg

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.

Certified process 5.jpg

Visibility of producer and product data: data release

Producer data

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.

Product data

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.

Bookmarking

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.

Bookmarking packages

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. You can add, delete or update lists. In the future it will also be possible to manage lists you shared with others and the lists that other companies shared with you.


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.

BM add a list.jpg



Delete a list

If you would like to delete a list, first you select it, click delete and finally confirm by checking the box again beneath “Are you sure?”:

BM delete a list.jpg



Update a list

Updating a list means to change the name and/or description of this list. Have you selected is, you can amend them and save the changes.

BM update a list.jpg

Filling lists

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 various obligatory and voluntary columns.

BM template.jpg


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. Secretariat and we will add them to the bookmarking function.



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.


BM upload.jpg

Finally the user will get an upload report via e-mail and a link to the file that has been uploaded.


Using the Bookmarking pool: List Selection

In the Bookmarking tab you will find all your GLOBALG.A.P Bookmarking lists.

BM list selection.jpg


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.

BM initial list.jpg



If you select more than one GLOBALG.A.P. Bookmarking List these lists will be displayed as one merged list.

BM merged list.jpg



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.

BM view selection.jpg



Here you see the tree view:

BM tree view.jpg



Below the list view:

BM list view.jpg



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.

BM explicitly.jpg

For any further help and questions, please, feel free to contact the customer support.