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.
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.
Please take into account that if you upload GGN more than once, they will be bookmarked multiple times.
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.
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.
Article Name (SKU): 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.
Artile Nr (SKU Nr): 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.
Delivered amounts in unit: 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.
Delivered amounts in weight: 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 30 characters and is voluntary.
Distribution Center: 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 30 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 30 characters and is voluntary.
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.
Additional Information 1: 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 20 characters and is voluntary.
Additional Information 2: 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 128 characters and is voluntary.
Include members: You can include the members of the producer group by entering 0 = No / 1 = Yes
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.
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.
