GS1 GPC

A tool for importing GS1 Global Product Classification (GPC) data into SQL databases.

Key Features

• Import GPC Data: Import GS1 GPC XML data into SQLite or PostgreSQL databases

• Download Latest Data: Download the latest GPC data directly from GS1 API using the gpcc library

• Automatic Fallback: Use the newest cached version if download is not available

• SQL Export: Export database tables to SQL file for backup or migration

• Database Portability: Support for both SQLite and PostgreSQL

• Command-line Interface: Easy-to-use CLI with Click

Installation

Install from source:

git clone https://github.com/mcgarrah/gs1_gpc_python.git
cd gs1_gpc_python
pip install -r requirements.txt
pip install -e .

Quick Example

# Import GPC data
gpc import-gpc --download

# Export to SQL
gpc export-sql --db-file ./data/instances/gpc_data_xml.sqlite3

Contents

User Guide

• Installation
  • Requirements
  • Installing from PyPI
  • Installing from Source
  • PostgreSQL Support
  • Development Installation
• Quickstart
  • Basic Usage
  • Python API Usage
  • Basic Example
• Command Line Interface
  • Commands
  • Examples
• Database Schema
  • Core Hierarchy Tables
  • Attribute Tables
  • Junction Tables
  • Example Queries
• Advanced Usage
  • PostgreSQL Support
  • Custom XML Files
  • Logging
  • Programmatic Usage
  • Using Models and Callbacks
  • Food Segment Example

API Reference

• Database Module
  • DatabaseConnection
  • setup_database()
  • insert_segment()
  • insert_family()
  • insert_class()
  • insert_brick()
  • insert_attribute_type()
  • insert_attribute_value()
• Parser Module
  • GPCParser
  • process_gpc_xml()
• Models Module
  • GPCModels
• Callbacks Module
  • GPCProcessedCallback
• Downloader Module
  • GPCDownloader
  • find_latest_xml_file()
  • download_latest_gpc_xml()
• Exporter Module
  • GPCExporter
  • dump_database_to_sql()

Development

• Contributing
• Testing
• Releasing

Indices and tables

• Index

• Module Index

• Search Page