CertifierOS Asset Bulk Upload Tool / Mass Site and Product Entry

The CertifierOS Asset Bulk Upload Tool allows certification bodies to efficiently register multiple producer sites and products via an Excel template that links products to sites using temporary IDs, requires specific data entries such as producer GGN and certification body ID, supports up to 1000 rows per upload, and includes validation and error correction steps before final import to the system .

Key capabilities

• Create (register) multiple new Producer Sites (production site, PHUs, Multisite/Scope Information Site…) in a single upload.
  Note: for the time being central PHUs have to be created manually. This functionality will be added in a future update.
• Create (register) multiple new Products on Producer´s Sites at the same time.

Registration of Assets

Producer´s Assets (Sites and Products) can be created for every registered Producer/PG in CertifierOS by using the producer´s/PGs GGN as the reference.

Note: The Producer/PG itself must be created before starting to use the Asset Bulk Upload Tool.

End-to-end process flow:

1. Open the Products/Sites/PHU Browser overview​ and click on the arrow next to “Add Product/SitePHU”. The dropdown contains the bulk import option

• Do not click on the “Add Product/SitePHU” button if you need the bulk upload.​
• Use the arrow/dropdown to expose additional actions.​

The system will open “Import Product Data” page where you will find the “Download Template” button.

2. Download “Product Upload Template”

Note: Although the Excel file is named “Product Upload Template”, it is used for both product and site uploads.

The system will download the template. This template must be used to register/create Sites and Products

How to fill in Site and Product data in the Excel sheet for each row:

Column “A”: Temp ID

Column “A” is mandatory and predefined by the system. Do not edit or use it. This row contains the “Temporary Asset ID,” which the system uses internally to link products to their corresponding sites (see Row “J” Parent ID (Site/PHU)). After the upload is completed, the temporary ID is replaced by the CertifierOS Asset ID.

Column “B”: Product/Site/PHU Title EN* - Mandatory

Asset Name must be filled for every row.​ Please follow the wiki guidelines How to name sites, PHUs, products and audits - GLOBALG.A.P. Wiki Site

Columns “C, D, E, F and G”: Additional Product/Site/PHU Title language options

DO NOT USE!!! These columns have no function for the time being.

Column “H”: Asset “Type”

In this column corresponding Asset Type “Site” or “Product” needs to be selected in a dropdown menu

Column “I”: Site/PHU Category ID

Information in this column provided in a dropdown menu will only be filled when creating “Sites”.         

“Products” DO NOT HAVE A “CATEGORY”!!!

Column “J”: Parent ID (Site/PHU)

This column is important. It uses the “Temporary ID” from Column “A” of the site being created to link each product to its parent site.

How it works:

• Enter the site information in the top row and list the related products in the rows below. This layout is optional, but it improves visibility by grouping each site with its products. You may also leave one blank row between site-product groups for easier reading. Blank rows do not cause errors and will be skipped during upload.

• To create the link, copy the site’s “Temp ID” from Column “A” into Column “J” for each related product.

Column “K”: Product Type (External ID)

Column K contains the Product Type code used by the Asset Bulk Upload Tool. The available codes are listed in a separate sheet within the Excel template.

Use only Product codes provided in the Excel template under column “A” - ExternalID

Column “L”: Producer ID (external GGN)

Column L contains the producer’s GGN, which determines which producer the assets (sites and products) are assigned to. In this example, GGN 6291041007903 belongs to “Wiki Producer,” which currently has no registered assets.

Note: Assets can be created for multiple Producers/PGs in one upload file. In this case the Producer/PG GGN will be added to each Asset´s column "L" to be linked to that particular Producer/PG. See screenshot below:

Columns “M, N, O, P and Q”: Asset Address

Note: Use these columns only for Site addresses. (Geocoordinates will also become available in a future update). Products do not contain address fields; therefore, please leave these columns blank for product rows!!!

Enter required information for Site address. Important: All “Site” address columns must be filled in!!!

Column “R”: Country (Address)

Enter ISO alpha-2 County code

Column “S”: Certification Body ID

Certification Body ID must be correct and consistent. It represents CB´s Name in CertifierOS not the CB Number registered with CB-AT!!!. Your CB's "Organization ID" can be found in CertifierOS under "Organizations":

Column “T”: Tags

Here CB can tag Sites and Products using their own tagging system.

VERY IMPORTANT: Do not rename, delete, or move template columns.​

The completed upload file should match the format shown in the example provided in this wiki.

Required steps for data registration:

• Use the latest downloaded template, to ensure you are working with the most up-to-date version.​

• Validate Asset Name spelling.​
• Confirm the correct Parent ID (Site/PHU). (It represents the Temp ID in Column A of the Site)
• Check Producer GGN before upload.​
• Confirm the correct Certification Body ID. (It represents CB´s Name in CertifierOS not the GG CB Number!!!)
• Create one asset per row.

Data Import limitations:

• Maximum 1000 rows per import.​
• Split larger files into separate uploads.​
• Warnings should be reviewed before import.​
• Errors must be corrected before records can be created.​
• Avoid duplicate Producer records.

3. Upload Excel File

Drag and drop the upload sheet into the dedicated upload area on the Upload page or browse your files to select it.

• Check that the correct Excel file is attached.​
• If the wrong file is selected, remove it before continuing.​
• Click Continue to move to the review step.

6. Review Preview

The system validates the Excel data and displays the import preview.

• Check Ready for Import, Warning and Error counters.​
• Review Asset Name, Address for the Sites, ”Temp ID” of the Site, Certification Body ID, ISO Country code and other important columns.​
• If errors appear, hover above the warning sign to see what caused the error. Correct the data in Excel file and upload it again.

After clicking Start Import, confirm the number of items to be imported.

• Verify the item count before confirming.​
• Click Confirm only when the preview is correct.​

After confirmation, the records are created in the Producer master data, and all asset “Temp IDs” are replaced with the CertifierOS Asset ID.

Common issues and quick fixes

• Template upload fails

Download a fresh template and avoid changing column headers or workbook structure.

• Rows show errors

Correct mandatory fields, invalid values or missing Certification Body ID, then re-upload.

• More than 1000 rows

Split into multiple Excel files and import them separately.