Synthesized version of a real client's script for automating image uploads on Home Depot Vendor Portal
- Batch Processing: Uploads images for thousands of products automatically.
- Smart Resume: If interrupted. Run the script again, and it picks up exactly where it left off.
- Error Tracking: Generates a detailed Excel report of any failed uploads.
- Create a
password.txtfile in the root directory containing your portal password (optional, for auto-login). You can login manually once the login prompt appears on the ChromeDriver instance, and the script will continue as normal.
- Python 3.10+
- Google Chrome installed
- Install dependencies:
pip install -r requirements.txt
- Prepare your Excel file: Must contain columns
* ID(OMSID) andUPC. - Prepare your Images: Place images in a folder, named as
<UPC>.jpg. - Run the script:
python main.py path/to/products.xlsx path/to/input_images_folder/--debug: Show detailed logs.-r [N]: Resume from checkpoint (rewind N items, default 1).
# Example: Resume processing
python main.py products.xlsx ./images -r