Difference between revisions of "Retailers & Suppliers"

From GLOBALG.A.P. Wiki
Jump to navigation Jump to search
Line 61: Line 61:
 
In the database search there are status options and information describing the production process.  
 
In the database search there are status options and information describing the production process.  
  
'''Accepted''' [[File:accepted.jpg]]
+
*'''Accepted''' [[File:accepted.jpg]]
  
  
 
----
 
----
  
'''Certified''' [[File:certified.jpg]]
+
*'''Certified''' [[File: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 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.
Line 75: Line 75:
 
----
 
----
  
'''Assessed''' [[File:assessed.jpg]]   
+
*'''Assessed''' [[File: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''.
 
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''.
Line 83: Line 83:
 
----
 
----
  
'''Open non-conformance''' [[File:onc.jpg]]  
+
*'''Open non-conformance''' [[File: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.
 
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.
Line 89: Line 89:
 
----
 
----
  
'''Self-declared suspension''' [[File:sds.jpg]]
+
*'''Self-declared suspension''' [[File: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.
 
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.
Line 95: Line 95:
 
----
 
----
  
'''Suspended''' [[File:sus.jpg]]   
+
*'''Suspended''' [[File: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.
 
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.

Revision as of 15:04, 6 August 2012

Introduction

The key idea of bookmarking producers is to avoid the recurrent search for single producer GGN or the upload of laboriously prepared upload sheets with a large number of GGNs in order to gain certificate information.

With the bookmarking function you will be able to upload an Excel sheet with a list of producer GGNs just once, with the result that the producers will be added to your personal bookmarking pool. This producer pool is stored and can be extended by uploading additional producers. Within your personal bookmarking pool you are able to see and filter your producers and check the latest certification information.

You will be able to:

  • Obtain certification information immediately from your list
  • Monitor all your GLOBALG.A.P. registered producers,
  • Avoid repeating certification information requests online.

Additional functionality of the bookmarking tool is a list with product or batch/delivery information supplemented to the certificate information of a producer.

By uploading the producer GGN and product combined with voluntary company or supply chain specific data (e.g. article name or variety, GTIN, traceability codes such as SSCC, delivery date) a list is initially generated and henceforth extended. This list comprises the data attached that can be filtered and downloaded.

  • Attach individual data to each product of Bookmarked producers
  • Manage deliveries attached with certificate information data in your supply chain by downloading your deliveries.

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, the customer support has created a Data release form 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 customer support for this form.

Searching GGNs: cycle, status, certfied process

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 status options and information describing the production process.

  • Accepted Accepted.jpg



  • 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



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


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


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.


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.