Geekozi

The Challenge

This was not a typical ecommerce website.

At launch, the store included more than 8,000 products. Each product had nine variations and up to sixty-six images. Manual product creation was not realistic at this scale. The system needed to support bulk product management, structured content generation, controlled image ordering, and long-term reusability.

In addition, performance had to remain stable despite thousands of high-resolution images and variation-based galleries.

The project required a systems-first approach rather than a traditional “build and upload” workflow.

Architecture & Performance Planning

Before development began, performance and scalability were planned as part of the foundation.

The website was deployed on a cloud-based hosting environment to support high product volume. Product images were separated from the main server and handled through object storage to reduce load and improve performance. This ensured that the site could scale without significant degradation, even with thousands of media files attached to products.

The structure was designed to support automation from day one, meaning future updates would not require rebuilding the system.

Structured Data & Content System

To manage the scale of the catalog, I designed a structured data system using Google Sheets as the central control layer. This sheet was not used only for content generation — it became the operational backbone of the store.

All categories were structured and organized within the sheet, including more than 280 category entries. Products were assigned to categories inside the spreadsheet, allowing bulk organization before anything was uploaded to WooCommerce.

Each product entry contained multiple title variations, detailed descriptions, and five FAQ entries. Because the data was structured at the spreadsheet level, it could be reused anytime the client needed to update products or add new ones.

This approach eliminated the need to manually edit products inside WordPress and created a repeatable, scalable workflow.

Automation with n8n

To connect the structured spreadsheet system with WooCommerce, I built custom automation workflows using n8n.

These automations handled product creation, updates, category assignments, and content mapping. Instead of pushing all products at once in a risky bulk import, the system processed entries row by row to maintain accuracy and control. When spreadsheet API limits were reached, additional API-based handling ensured stability.

The result was a fully automated pipeline between structured data and the live WooCommerce store, significantly reducing the possibility of human error during large-scale operations.

Image Handling & Variation Logic

One of the most technically demanding aspects of the project was image handling.

Each variation required its own set of images, and the display order mattered for presentation. The WooCommerce extension used for additional images required image IDs rather than filenames, which introduced complexity when working at scale.

To solve this, I created a system inside Google Sheets that mapped image placement and order per variation. Using Google Apps Script, I retrieved image IDs, organized them in the required sequence, and prepared structured ID sets for each product variation. This logic was then integrated into the automation workflow so that images appeared in the correct order automatically.

This ensured consistency across thousands of products while keeping the process scalable and maintainable.

Photoshop Mockup Automation

Because the store required thousands of product visuals, I also helped develop a Photoshop-based mockup automation system. A custom script was created to generate bulk mockups from base designs, allowing the team to produce large volumes of product images efficiently and consistently.

This reduced manual design work and supported the scale requirements of the project.

Programmatic SEO Implementation

SEO was implemented as a structured system rather than a manual task performed after upload.

Each product was configured with structured metadata, including automatically generated image alt text, meta titles, meta descriptions, and Open Graph data. Internal linking between products and categories was planned at the structural level. URLs and taxonomy were designed to support search engine clarity.

As a result, products launched with complete SEO configuration already in place, without requiring manual optimization for each individual listing.

Launch & Stability

Because this was a live production ecommerce platform, deployment was handled carefully. Automation was tested incrementally to ensure there were no broken variations, incorrect image orders, or checkout issues.

The full catalog was generated and launched through automation rather than manual entry. Stability and data integrity were prioritized throughout the process.

Outcome

The final result was a large-scale WooCommerce platform that could reliably handle thousands of products, structured content, complex variations, and high image volume while remaining maintainable for future growth.

The systems built for this project allowed product updates and additions to be handled through structured data rather than manual edits, significantly improving operational efficiency.

Role Conclusion

My involvement concluded after the successful launch of the platform. I later stepped away from the agency to focus on building my own creative and technical practice.