Book Descriptor

The Problem:
A number of bookshops use some pretty out-dated technology to get their stock imported to WooCommerce. Due to the vendor supplying data in varying formats a number of shops have books / products online with largely missing description data. Some of these shops have over 25,000 products online and need a solution to identify stock with missing data, and then supply data from a csv sheet.

The Solution:
BookDescriptor is a python script with a simple GUI to allow book shops to run an automated daily process to locate missing description and import them from a legally acquired local data source.

https://github.com/OliPassey/BookDescriptor

Installation & Usage

-Clone the repo locally (run on your PC, not the webserver)
-Create API Key & Secret in WooCommerce (do not share these with anyone)
-Add your site URL & API Credentials to config.json
-Install Python3 if not already installed
-pip install woocommerce
-pip install pandas
-pip install tk
-pip install pillow

Usage
-Place a csv output of ISBN, Synopsis in the same folder as gui.py
-python ./gui.py

Example Output:

Searching for latest CSV file…
Found CSV file: TitleDataExport_2023041122 (1).csv
Loaded CSV file: TitleDataExport_2023041122 (1).csv
Total rows loaded in DataFrame: 1000
Searching for products without descriptions…
Connecting to https://xx.co.uk/
Downloading the latest 100 products.
Total products downloaded: 0
0 products require a description.
Process complete.

SKUs with missing synopses, you may want to update these manually:
[]