Amazon Inventory Helper

Description

Currently Amazon seller manages inventory in google sheets. Python orders parser is implemented and launched from Excel. Program parses all new loaded orders and outputs excel helper file to reduce inventory from the items sold.

Project is heavily based on previous work.

Project Caveats:

• Not uploading source files, or databases due to sensitivity of personal information;
• No Excel side (VBA) implementation is uploaded;

Features

• Filters out orders already processed before (present in database)
• Logs, backups database;
• Automatic database self-flushing of records as defined by ORDERS_ARCHIVE_DAYS in orders_db.py;
• Creates a helper file to aid inventory management;
• Helper file is updated with items details from new orders on subsequent loads.

Output File Sample

Example of output helper excel file:

Requirements

Python 3.7+

pip install requirements.txt

Compile executable

Within "Helper Files" directory:

pyinstaller -w -F -i Python.ico amazon_inventory_main.py

which will output amazon_inventory_main.exe in dist folder.