Skip to content

Latest commit

 

History

History
8 lines (7 loc) · 997 Bytes

README.md

File metadata and controls

8 lines (7 loc) · 997 Bytes

store-upc-loader

Consumes Gap Inc. Product Catalog API response and populates a MySQL database with the mapping of (Store) UPC values and online SKUs.

In order to run successfully on a given server with Python 3.6 installed...

  • The MySQL Python Connector must be present (e.g. pip3 install mysql-connector==2.1.4) - see https://dev.mysql.com/doc/connector-python/en/connector-python-installation.html
  • A 'config.py' file must be created in the same location as the 'load-upc-data.py' script containing the MySQL connection information and a valid Product Catalog API key (see 'EMPTY-config.py' as an example template); if you do not have an API key, contact [email protected]
  • The MySQL instance running on the target server must be configured to accept traffic from the machine executing the script
  • If necessary, Update MySQL table in SQL statement to ensure INSERTS are committed to the right destination (and ensure table is configured with expected columns & definitions)