Product Search, Inactivation/Deletion Enhancement - PCR #219
The Product Search, Inactivation/Deletion Enhancement provides product manufacturers the ability to search AGIIS for products by primary category, variety/hybrid or product ID to perform a mass deactivation or deletion. Based on the input criteria, a list of products is displayed for review. This list allows users to remove one or more products from consideration prior to performing a mass deactivation or deletion. The following images outline the steps to utilize this new functionality. In this example we are performing a mass deletion.
From the Company View page, click ”Update Information“.
The Company Update page below is displayed. Click on, "Mass Deactivation/Delete".
The Mass Deactivation/Delete Page below is displayed. This page allows you to review a product subset based on your input criteria and allows you to remove one or more products from consideration prior to performing the mass deletion.
You must choose to either Deactivate or Delete using the "Operation" radio buttons. Deleting a product will take it out of AGIIS altogether, while deactivating a product will keep the product in AGIIS, but in an "Inactive" status.
Choose either "Last Verified" or "Last Modified" to delete products last verified or last modified prior to the date entered.
Choose to see all products or those under a primary category by clicking one of the Primary Category radio buttons.
A product identifier can be entered into the Product Identifier field to review products under a specific product ID. Likewise, a Variety/Hybrid can be entered to mass deactivate or delete products matching the variety/hybrid entered. In this example, we are leaving these fields blank.
Once all information is entered, click on the "Search" button.
The page below shows all of the products that matched the input criteria. Notice there are several products highlighted in yellow. These products are in another subscriber's product subset and can't be deleted until the subscriber removes these products from their subset. When performing a Deactivation, this rule does not apply.
Clicking on the hyperlink in the "Subscriber Subsets" column will display a page similar to the one below. The subscriber(s), along with the email address of their company contact, and the Product GTIN is displayed. This information is provided so that you can contact the subscriber and request they remove the product from their subset.
To remove one or more products from being deleted, check the appropriate box the "Remove" column and click on the, "Remove Selected Items from Results" button. It is not necessary to remove those products highlighted in yellow as they are exempted from being deleted.
Once the product grid contains only those products you wish to delete, click on the "Delete" button. In this example, there are two remaining products eligible for deletion.
Finally, a confirmation page displays providing the number of products deleted.
CSV EBID/GLN Entity Subset Extract Creation Enhancement - PCR #220
The CSV EBID/GLN Entity Subset Extract Creation enhancement provides AGIIS subscribers the ability to generate a full entity subset extract in a CSV file format. Other format options are XML and fixed length text.
To schedule an EBID or GLN subset extract in the new CSV file format, hover over the "Files" menu in AGIIS and click on, "Schedule Extracts". The following page appears. Click on the, "Request Entity Subset Extract" button.
On the following page, choose either EBID or GLN Subset from the Subset Type drop down menu. Choose, "CSV" from the Extract Format drop down menu. Click, "Submit". You will be notified via email once the extract is complete.
Below is a link to the CSV Entity subset extract file layout.
CSV Entity Subset Extract File Layout
A complete set of release notes for both enhancements will be sent out on Monday, April 22, 2019. If you have any questions, please contact Member Services at Member.Services@AgGateway.org, or call (866) 251-8618.
GLN Bulk Process Name Standardization Enhancement
The GLN Bulk Process Name Standardization Enhancement, takes the name standardization enhancement that was implemented on the website and web services in September 2017, and later to the 2017 annual de-duplication maintenance, and applies it to the GLN bulk process.
The name standardization functionality will provide more robust name standardization when trying to determine a match in the bulk process. This functionality will improve name matching for abbreviations, support individual name vs business name matching scenario’s and provide flexibility to assist in decreasing false positive matching.
Below are two examples of improvement in decreasing false positive matching. Prior to the enhancement, AGIIS likely would have matched the two entities together based on the similarity in the name and having identical addresses. Since the enhancement, AGIIS recognizes their differences and will not match the two together.
John Doe, 123 Main St, Anytown, USA and John Doe Farms, 123 Main St, Anytown, USA
Jane Doe, 828 Sycamore, Anytown, USA and Jane & John Doe, 828 Sycamore, Anytown USA
The second enhancement, AGIIS Sponsorship Recognition Banner, displays the company logos of those subscribers that have historically provided significant financial support above the published AGIIS subscription rates. With these companies’ permission, they are being recognized by having their company logo scroll across the AGIIS login and home pages. Companies that have authorized the use of their logo are BASF, Bayer, Dow Agrosciences, Dupont/Pioneer, FMC Corporation, Syngenta, Tessenderlo
Kerley, and Valent. The image below provides an example of this.
GTIN Logic Modification Enhancement
On Saturday, May 12, 2018, AGIIS was enhanced to accommodate a variable length, GS1 company prefix
in the formulation of the 14‐digit Global Trade Item Number (GTIN). The GTIN uniquely identifies a
product in AGIIS at its lowest saleable unit. A GS1 Company Prefix is a unique identification number that
GS1 issues companies using bar coding and product code identification, such as the GTIN. The 14‐digit
GTIN utilized in AGIIS is created by combining four components, a Package Level Indicator, GS1
Company Prefix, Package Size ID and Check Digit.
Historically, company prefixes were assigned by GS1 that were 7‐digits in length. This meant that the
Package Size ID was always 5 digits in length, as both the Package Level Indicator and Check Digit, are
Now, GS1 is assigning company prefixes that vary in length. As AGIIS was originally programmed to
require a 7‐digit Company Prefix and 5‐digit Package Size ID, updates were made to accommodate a GS1
Company Prefix between 1 and 11‐digits. The Package Size ID may now contain between 1 and 11
numeric digits but, the combination of the GS1 Company Prefix and the Package Size ID must equal 12‐
New requirements for the construction of the 14‐digit GTIN is provided below.
Updates have been made to the AGIIS Product file layouts Product 3‐Level (CSV) and GTIN Level 1 (CSV)
to reflect these changes. These file formats, along with the XML product update document, can be
found in the Product section in AGIIS under the Links menu. If you have any questions about this
enhancement, please contact Member Services at Member.Services@AgGateway.org, or call us at (866)
Verification Date Enhancement
AGIIS was enhanced on Saturday, January 20, 2018 allowing the AGIIS Directory Administrator to update the "Last Verification Date" on an entity even if the requested update is declined.
Before, if a subscriber requested Member Services verification (phone or web verification) on updated entity demographics, and the update was declined after performing verification, the "Last Verification Date" did not update. With this enhancement, the "Last Verification Date" will update regardless if the demographic update is accepted or declined.
In the example below, phone verification was requested on an update to the mailing address. In the side by side comparison of the history, you can see that no update to the entity demographics were made, yet the "Last Verified" field was changed from "None" to "Member Services Level: Tier 2- Phone/Email + Web Verification on 01/22/2018." Member Services verification determined that the existing address on the entity was correct. The update was declined, but because a phone verification was performed confirming the address, the "Last Verified" field is updated with the date and type of verification performed.
If you want to access the 2017 AGIIS Enhancements page, click here.