GS1 Retail Data Extended

free

Extended GS1 validation — GTIN check digits, date formats, batch/lot numbers, and net weight fields for retail supply chain.

10 rules 1060 downloads4.4 avg (57)

gs1gtinretailbarcodesupply-chainbatch

4.4(57 ratings)

Test this pack with your data

Download the template, fill in your data, and see quality results instantly.

Test This Pack

Download & Install

Choose your tool — get a ready-to-run file

Run this on your data? Upload your CSV — we'll auto-map the columns, validate, and report the bad rows.Test my data

Or use the CLI

$ npx dqhub install gs1-retail-extended --format soda --table YOUR_TABLE

About this pack

Extended GS1 data quality rules for retail and supply chain. Covers: - GTIN-8, GTIN-13, GTIN-14 with mod-10 check digits - GLN and SSCC format validation - GS1 date format (YYMMDD) - Batch/lot number format - Net weight field validation Based on GS1 General Specifications.

What's included

8format rules

2completeness rules

Checks included (10)

GTIN-8 Check Digit Validation(gtin)

Validates GTIN-8 (Global Trade Item Number) format and mod-10 check digit per GS1 General Specifications. GTIN-8 is used for small retail items where a full barcode will not fit. The value must be exactly 8 digits where the last digit is a valid check digit computed using the GS1 mod-10 algorithm: multiply digits alternately by 3 and 1 (starting from the rightmost data digit), sum the products, and compute check = (10 - sum % 10) % 10.

GTIN-13 (EAN) Check Digit Validation(gtin)

Validates GTIN-13 (EAN-13) format and mod-10 check digit per GS1 General Specifications. GTIN-13 is the standard barcode used worldwide for retail point-of-sale. The value must be exactly 13 digits where the last digit is a valid check digit computed using the GS1 mod-10 algorithm: multiply digits alternately by 1 and 3 (left to right for the first 12 digits), sum the products, and compute check = (10 - sum % 10) % 10.

GTIN-14 Format Validation(gtin)

Validates GTIN-14 format per GS1 General Specifications. GTIN-14 is used to identify trade items at various packaging levels (cases, cartons, pallets). The value must be exactly 14 digits where the first digit is the packaging indicator (1-8 for standard groupings, 9 for variable-measure), and the last digit is a valid GS1 mod-10 check digit.

GLN (Global Location Number) Validation(gln)

Validates Global Location Number (GLN) format per GS1 General Specifications. GLN is a 13-digit identifier used to identify physical locations, legal entities, and functional entities in supply chains. The value must be exactly 13 digits where the last digit is a valid GS1 mod-10 check digit, using the same algorithm as GTIN-13: multiply digits alternately by 1 and 3 (left to right for the first 12 digits), sum the products, and compute check = (10 - sum % 10) % 10.

SSCC (Serial Shipping Container Code) Validation(sscc)

Validates Serial Shipping Container Code (SSCC) format per GS1 General Specifications. SSCC is an 18-digit identifier used to uniquely identify logistics units (pallets, cases, parcels) throughout the supply chain. Structure: 1-digit extension digit (0-9), 7-digit GS1 company prefix, 9-digit serial reference, and 1-digit mod-10 check digit. The check digit uses the standard GS1 algorithm: multiply digits alternately by 3 and 1 (from position 1), sum, check = (10 - sum % 10) % 10.

GS1 Date Format (YYMMDD)(production_date)

Validates that date values conform to the GS1 YYMMDD format used in GS1-128 and DataMatrix barcodes for Application Identifiers such as AI(11) Production Date, AI(13) Packaging Date, AI(15) Best Before Date, and AI(17) Expiration Date. The format is 6 digits: 2-digit year, 2-digit month (01-12), and 2-digit day (00-31, where 00 indicates the last day of the month).

GS1 Batch/Lot Number Format(batch_lot)

Validates that batch/lot number values conform to the GS1 Application Identifier AI(10) specification. A batch or lot number is an alphanumeric string of 1 to 20 characters (uppercase letters and digits only). This identifier is critical for product traceability and recall management across the supply chain.

GS1 Net Weight Field Format(net_weight)

Validates that net weight values conform to the GS1 Application Identifier AI(310n) format. The net weight field is exactly 6 digits representing the weight value with an implied decimal point. The decimal position is indicated by the last digit of the AI (e.g., AI(3102) means 2 decimal places, so 001234 = 12.34 kg). This rule validates the 6-digit numeric format.

Column Not Null

Asserts that a specified column contains no null values. This is the most fundamental completeness check — every row must have a value present in the target column.

Column Completeness Threshold

Asserts that a column meets a minimum completeness threshold, measured as the percentage of non-null values. Useful when some nulls are acceptable but the overall population rate must stay above a defined level (e.g., 95%).