Introduction:

This guide provides detailed, step-by-step instructions on how to complete the AB899 Test Results Import File for bulk uploading test data. Follow the instructions carefully to ensure your data is imported correctly.

Instructions:

Prerequisite: UPC Requirement

Before importing the AB899 Test Results file, you must first add the UPC (Universal Product Code) for the product.

What is UPC?

UPC stands for Universal Product Code.
It is a 12-digit barcode used to identify and track trade items in stores.
The UPC is unique to each product and is used for:
- Inventory management
- Sales tracking
- Identifying products at the point of sale

Important Note: Only one product can be added per test result.

How to Add a UPC

Navigate to the left-hand side menu of the dashboard. and find and click on the "Test Results" tab. This will open a form to add a new product.
Select the "Product Test" dropdown.
Choose the "New Product" option to add a product and enter product details:
- Product Name: Enter the name of the product.
- UPC: Enter the 12-digit Universal Product Code.
- Subcomponents (Optional): If the product has subcomponents, enter their UPCs from the dropdown
After entering the details, click save.

Overview of AB899 Test Results Import File

The AB899 Test Results Import File is designed to streamline the bulk uploading of product test data into the system. This file allows you to input detailed information about each product test, including testing panels, lab details, and specific test results such as heavy metals, pesticides, and plasticizers.

Using this import file ensures that your product data is organized, easily traceable, and compliant with AB899 regulations. This guide provides a step-by-step breakdown of how to accurately fill out each section of the file, as well as prerequisites and tips for a successful import.

1. Testing Panel(s)

What to Enter: In the import sheet, specify the testing panel(s) relevant to the product.

Available Options:

All Testing Panels: Includes all testing categories.
Heavy Metal: For reporting levels of Arsenic, Cadmium, Lead, and Mercury.
Plasticizers: For entering amounts of BPA and BPS.
Pesticides and Glyphosate: To report the presence of pesticides and herbicides.

How to Select:

In the import sheet, enter the name of the testing panel exactly as listed above.
Multiple panels can be selected by separating them with commas (e.g., "Heavy Metal, Plasticizers").
If you enter All Testing Panels, it will automatically include all other categories.
Is it Required? Yes.
Why It’s Important: This ensures the correct columns are populated for the relevant test data in the import file.

2. Testing Lab

What to Enter: The name of the lab where the product was tested.
Is it Required? No.
Why It’s Important: This field is optional but useful for tracking the testing facility.

4. Apply to all Lots

What to Enter: In the import sheet, if the test result applies to all product lots, enter "ALL" in the Lot Number column.

How It Works:

If "ALL" is entered for the lot number, the test result will be displayed alongside all test results that include the "Products Tested" specified in that test result.
If a test result for a specific lot already exists, the system will display that result instead of the "all lot" result.
Is it Required? No, but it simplifies data entry when the same result applies to all lots.
Why It’s Important: This feature ensures consistent test result display across all relevant products without repetitive data entry.

5. Lot Number

What to Enter: The unique identifier for the product lot.
Is it Required? Yes, unless the "Apply to all Lots" checkbox is selected.
Why It’s Important: This links the test result to a specific lot, ensuring traceability.

6. Test ID

What to Enter: A unique identifier for the test. Leave it blank if you want the system to auto-generate it.
Is it Required? No.
Why It’s Important: This helps in tracking and organizing tests.

7. Sample ID

What to Enter: The identifier for the specific sample tested.
Is it Required? No.
Why It’s Important: Useful for tracking individual samples.

8. Order ID

What to Enter: The order ID linked to the test.
Is it Required? No.
Why It’s Important: Helps in traceability if the test is associated with a specific order.

9. Test Date

What to Enter: The date when the test was conducted.
Is it Required? Yes.
Why It’s Important: It provides a timeline of when the test occurred.

10. Expiration Date

What to Enter: The product’s tests expiration date.
Is it Required? No.
Why It’s Important: Optional field for indicating product validity.

Note: If the "Apply to all Lots" checkbox is checked, this field becomes disabled.

11. Product Tested

What to Enter: The name of the product that was tested.
Is it Required? Yes.
Why It’s Important: Links the test result to the specific product.

12. Heavy Metals

For each of the following, enter the amount present in parts per billion (ppb):

Arsenic (ppb) – Not Required
Cadmium (ppb) – Not Required
Lead (ppb) – Not Required
Mercury (ppb) – Not Required
Why It’s Important: Optional field for reporting heavy metal content.

Pesticides and Glyphosate

For each of the following, enter the amount in ppb:

Pesticides (ppb) – Not Required
Glyphosate (ppb) – Not Required
Why It’s Important: Optional field for reporting pesticide and herbicide content.

Plasticizers