E-commerce Automation Suite

Overview

Automated e-commerce content publishing system that handles Amazon Kindle Direct Publishing book uploads, Redbubble print-on-demand product creation, and Canva design template variations. Reduces manual repetitive tasks through batch processing.

Objectives

• ▸ Automate Amazon KDP book publishing workflow
• ▸ Enable bulk product creation on Redbubble marketplace
• ▸ Generate Canva design variations automatically
• ▸ Support batch processing for multiple products
• ▸ Reduce manual publishing effort significantly

Architecture

Three-module Python automation suite using Selenium WebDriver for browser automation. Each platform has dedicated modules with class-based design (Redbubble) or procedural approaches (KDP). Pandas and OpenPyXL handle spreadsheet-based data processing.

Key Features

• ▸ Amazon KDP automated book publishing from spreadsheet data
• ▸ Redbubble bulk product creation for 20+ product types
• ▸ Canva design variation generation with variable substitution
• ▸ Batch upload processing with status tracking
• ▸ Adult content classification support
• ▸ State persistence in Excel for resume capability

Challenges

• ▸ Platform-specific automation without official APIs
• ▸ Handling dynamic content and CAPTCHA challenges
• ▸ Managing state across interrupted batch operations

Outcomes

• ▸ Significantly reduced manual publishing effort
• ▸ Batch processing enabled for scale operations
• ▸ Resume capability for interrupted operations