This article explains how ZDHC Approved MRSL Certifiers can use the Bulk Assign Certificates functionality in ChemCheck.
01/ Introduction
The Bulk Assign Certificates functionality allows ZDHC Approved MRSL Certifiers to manage certificate assignments for multiple products using a CSV file.
Instead of updating each product individually, you can download a pre-populated assignment template, update the relevant rows, and upload the completed file to ChemCheck for validation and submission.
You can use the bulk assignment functionality to:
- Add ZDHC MRSL certificates to multiple products.
- Remove existing ZDHC MRSL certificates.
02/ Prerequisites
Before starting, make sure that:
- You have access to ChemCheck as an MRSL Certifier.
- The relevant products are available under the Product Approvals section.
- You have the information required for the certificate assignments you want to add or remove.
03/ Steps
- Log in to the ZDHC Gateway. From the main dashboard, open ChemCheck.
Select Product Approvals.
Click Bulk Assign Certificates in the top-right corner of the Product Approvals page.
You will be taken to the Bulk Assign Certificates view. There, click on the Download Assignment Template (CSV) button. The template will be downloaded to your computer.
Follow the CSV Template Instructions available in the information section. You can expand the Assignment Template Columns dropdown to see the details of the information required for each column.
Once completed, upload the file following the formatting instructions. Then, click on Continue.
On the Review Assignments page, review the proposed actions and check for errors. If you need corrections, update your CSV file and upload the corrected version before proceeding.
Once the submission is confirmed, you will see the Submission Complete screen with a summary of your submission. You can then go back to your product list, or upload a new file (this will redirect you to the Bulk Assign Certificates page).
04/ How products are matched during bulk assignment
When you upload a CSV file, ChemCheck matches each row to an existing product in the ZDHC Gateway using the following information:
- Product ID: ChemCheck first matches products using their Product ID.
- Product name: If no Product ID is provided, ChemCheck can match products by name, provided the name is unique.
- Chemical formulator name: ChemCheck also considers the formulator name to improve matching accuracy.
Tip: Include the Product ID whenever possible to help ensure the correct product is identified.
05/ Reviewing your assignments
During the Review Assignments step, you can check the matched products and certification information before completing the bulk assignment. The system automatically skips empty rows in the CSV file, and the displayed row numbers correspond to your original upload file. This makes it easier to identify and review individual entries.
Tip: Review the matched products carefully before confirming your assignments.