CertifierOS Producer Bulk Upload Tool / Mass Producer Entry

The Producer Bulk Upload Tool is a new CertifierOS feature that enables CBs to register and upload new producer information using a dedicated Excel data sheet available in the system.

Key capabilities

• Create (register) multiple new individual producers in a single upload.
• Create (register) multiple new Producer Group members at the same time.

Automatic registration of PG Members

Producer group members can be assigned automatically to their producer group by using the producer group’s GGN as the reference in the Producer Hierarchy under Parent GGN.

Note: The PG itself must be created manually to receive its GGN to use it in the Bulk Upload Tool as a parent

End-to-end process flow:

1. Open the Producer overview​ and click on the arrow next to Add Producer. The dropdown contains the bulk import option

• Do not click only the main button if you need the bulk upload.​
• Use the arrow/dropdown to expose additional actions.​

2. Select Upload BusinessPartners

• This is the correct path for producer bulk creation.​
• It opens the import screen for Excel files.

On the Import Producer Data screen, download the official template first, then upload the completed Excel file.

• Blue arrow: download the official Excel template.​
• Red arrow area: upload or drag-and-drop the completed file.​

3. Download Template

The system will download the Producer upload template. This template must be used to register the Producers' information.

• Producer Name must be filled for every row.​

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

See here an example of a test CB Organization ID

• Producer Hierarchy should be filled when parent/child relationships are required​

• Contact and address columns should be completed where available.​ Use ISO country code for the Column "Country"

• Do not rename, delete, or move template columns.​

• Use a second import file if more than 1000 rows are required.

4. Fill in Producer data in the Excel sheet

Required steps for the data registration:

• Use the latest downloaded template.​
• Validate Producer Name spelling.​
• Check Producer Group GGN before upload.​
• Confirm the correct Certification Body ID. (It represents CB´s Name in COC not the GG CB Number!!!)
• Keep one Producer 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.

5. 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 Producer Name, Certification Body ID and other important columns.​
• If errors appear, fix the Excel file and upload 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, records are created in the Producer master data.

7. Start Import​

8. Confirm​

Common issues and quick fixes

• Duplicate Producer detected

Search the Producer Browser first. Use existing records instead of creating duplicates.

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

Summary:

Producer bulk upload should follow one controlled path:​

Producer overview page → Add Producer → Upload Business Partners → Download Template → Fill in Excel → Upload File → Review → Start Import → Confirm

​Key rule: validate the Excel data before confirming the import.