Shopify Product Data Processing & Image URL Automation (Python + Excel + CSV Integration)

Overview
We are looking for an experienced Python / Excel developer familiar with Shopify CSV structure to handle product-data processing and image-URL automation for our store “Tengudou” (天狗堂).
All source data (FTL price list + final Shopify CSV) and Excel templates are ready — your task is to automate and refine the workflow.

Scope of Work
1. Review and optimize the existing Shopify final CSV (already generated).
2. Develop or update the image URL fetching script using our defined Method A (Cookie-based login + HTML scraping).
3. Integrate fetched image URLs into the Shopify CSV automatically.
4. Test CSV compatibility by importing it to Shopify.
5. (Optional) Automate regular price updates using our provided Excel conversion logic.

Requirements
- Strong Python skills (requests, BeautifulSoup, pandas)
- Excel automation (formulas / OpenPyXL preferred)
- Familiarity with Shopify CSV format
- Ability to maintain structure and accuracy across thousands of SKUs
- Secure handling of Cookie-based login sessions

Data Provided
- Final Shopify CSV (v2)
- FTL price list Excel template
- Method A spec (Word)
- Image fetch input template (SKU + product URL)

Deliverables
- Working Python script (fetch_image_urls.py)
- Updated Shopify CSV with Image Src column populated
- Short README explaining how to run the script