Data quality for data recipients

• Almost all tables and visuals in the report can be exported. To do so, click on the table or chart and use the three dots at the top. Please note that exports are always limited to 150,000 rows! 
• The filter options allow you to refine your selection. Use CTRL to combine multiple values. You can minimise the filter panel again using the ‘Hide filter panel’ button. 
   

Via the ‘My Reports’ tab, you have access to 2 separate reports: the ‘Validation Report’ for the completeness of product sheets and the ‘Audit Report’ for their accuracy. 

Read more about the two-step framework here

This report gives you an overview of completeness, assessed against the validation rules of the current Benelux data model. The completeness of items has a direct impact on the visibility of product sheets in My Product Manager.
In this section, you see an overview of:

• the overall data quality score of all data providers (1)
• the companies with the most products (2)
• the most common errors/warnings (3)
• the timestamp of the latest version of the report (4) 
   

The dashboard is dynamic. When you click on a specific supplier in the ‘Information Provider’ list (2), you automatically see an overview of the validation rules (Validation Failures) that apply to this supplier at the bottom (3). Conversely, when you select a validation rule, the list of data providers will show all suppliers whose data contains this error.
The data quality report distinguishes between warnings and errors.

• Products with errors are not visible to you as a data recipient. These product sheets must therefore be corrected or completed by the data provider.
• Products with warnings, which are not blocking, are visible in your product overview. However, the product information does not comply with the sector agreements defined in the data model and the corresponding validation rules. 

In addition to the general dashboard, the report also contains two levels of detail:
Would you like to see the status of all products for each supplier? Click ‘Supplier details’ in the general overview.

You will then be taken to the following overview, where you can use the filter at the top right to search for the GLN or name of your data provider and find all their products and their status in the table. You can also search for a specific GTIN.

Under ‘Validation Failures’ at the bottom, you see an overview of the warnings and errors for the filtered products. You can also select the row for a specific GTIN in the table, after which only the errors and warnings, if any, for the selected product will be highlighted in the overview.

Would you like to go into even more detail? The ‘Full Details’ button gives you a detailed overview of all errors and warnings per GTIN. You can filter by supplier or product, as well as by incomplete items or specific error messages.

The audit report provides you with the information you need about the accuracy of the product sheets published to you, after GS1 has carried out a content audit. A score is only calculated for GTINs that have participated in the audit.

Use the ‘Product Details’ button to switch to a second table where the data is displayed at GTIN level. Scroll to the right to see all columns.

Would you like to start using these reports as a data recipient? Here is a possible step-by-step approach you can follow.

1. Determine which supplier and/or items you want to check for data quality. In My Product Manager, the GLN (supplier) and GTIN (items) are the unique identification keys, so make sure you have them to hand! 
2. Start in the ‘Validation Report’ and filter by GLN/GTIN.
   1. You can’t see the supplier and/or items? There may be several reasons:
      1. Your supplier does not have a valid My Product Manager Share connection. On this page, you find an up-to-date list of all registered My Product Manager Share users. Always check whether your supplier is active on this list. If not, you can ask them to activate their connection.
      2. Your supplier has not yet created or published the product. Ask your supplier to check whether the item exists in My Product Manager and whether it has been published publicly or to your GLN with a ‘valid’ status.
      3. The publication is not visible due to a difference in settings. For example, if you choose to receive only items using the FMCG data model and your supplier publishes according to the DIY data model, you may not see the product sheet. Contact support@gs1belu.org to determine the appropriate solution.
   2. You can see the products? Then check their status.
      1. GTINs with an ‘ACTIVE’ status have been validly published in accordance with the relevant data model. No further action is required.
      2. GTINs with an ‘INCOMPLETE’ status are incomplete and are not visible to you in ‘My Products’. To resolve this, the supplier must make the necessary changes and publish the data again. Via ‘Full Details’, you can check which errors are blocking the product sheet.
3. For all items that are valid in the ‘Validation Report’, you can carry out an additional check in the ‘Audit Report’. Here as well, filter by GLN and/or GTIN.
   1. You can’t see the item? It probably did not meet all the conditions to be included in the scope of the audit. You can find the conditions here.
   2. You can see the item? Then you can check its status:
      1. If the status is ‘New’ and there is no score, the GTIN still needs to be audited. Ask your supplier to initiate the audit.
      2. Is the score below 100%? This means that the data in My Product Manager does not match the information on the label. Ask your supplier to make the necessary changes and request a new audit.
      3. Is the score 100%? The data is fully correct and no further action is required.
          

Wil je als data-afnemer aan de slag gaan met deze rapporten? Dan is hier een mogelijk stappenplan dat je kan volgen.

1. Bepaal voor welke leverancier en/of artikelen je de datakwaliteit wil controleren. In My Product Manager zijn het GLN (leverancier) en GTIN (artikelen) de unieke identificatiesleutels, houd die dus bij de hand!
2. Start in het Validation Report en filter op het GLN/GTIN
   1. Zie je de leverancier en/of artikelen niet? Dan zijn er verschillende oorzaken:
      1. Je leverancier heeft geen geldige My Product Manager Share-aansluiting. Op deze pagina, vind je een up-to-date lijst terug van alle geregistreerde My Product Manager Share-gebruikers. Ga dus altijd even na of jouw leverancier hierop actief is. Indien dit niet het geval is, kan je hem de vraag stellen om deze te activeren.
      2. Je leverancier heeft het product nog niet gecreëerd of gepubliceerd. Vraag aan je leverancier om na te gaan of het artikel bestaat in My Product Manager en of het publiek of naar jouw GLN is gepubliceerd met een status ‘geldig’.
      3. De publicatie is niet zichtbaar door een verschil in instellingen. Als je bijvoorbeeld zelf kiest om enkel items met het FMCG datamodel te ontvangen en je leverancier publiceert volgens het DIY-datamodel zie je de fiche mogelijk niet. Contacteer support@gs1belu.org om te bekijken wat de juiste oplossing is.
   2. Zie je de producten wél? Ga dan na wat de status is.
      1. GTIN’s met een ‘ACTIVE’ status zijn geldig gepubliceerd volgens het bijhorende datamodel. Hierop is geen verdere actie nodig.
      2. GTIN’s met een ‘INCOMPLETE’ status zijn onvolledig en voor jou niet zichtbaar in ‘Mijn Producten’. Om dit op te lossen moet de leverancier de nodige aanpassingen maken en opnieuw publiceren. Via ‘Full Details’ kan je nagaan welke errors de fiche precies blokkeren.
3. Voor alle artikelen die geldig zijn in het Validation Report kan je een extra controle doen in het Audit Report. Filter ook hier op het GLN en/of GTIN.
   1. Zie je het artikel niet? Dan voldeed het waarschijnlijk niet aan alle voorwaarden om in scope te komen. Je vindt de voorwaarden hier.
   2. Zie je het artikel wél? Dan kan je nagaan wat de status is:
      1. Bij een status ‘New’ en ontbrekende score moet het GTIN nog geauditeerd worden. Vraag aan je leverancier om de audit op te starten.
      2. Zie je een score lager dan 100%? Dan komt de data in My Product Manager niet overeen met de data op het etiket. Vraag aan je leverancier om de nodige aanpassingen te maken en een nieuwe audit aan te vragen.
      3. Is de score 100%? Dan is de data helemaal in orde en hoef je niets meer te doen.