We operate www.chamonixskipasses.com, a WooCommerce-based e-commerce site selling ski lift passes. Currently, when customers purchase passes, our team must manually log in to our supplier’s B2B portal, enter the order details, generate the QR code tickets, and email them to the customer.
This process is time-consuming and prone to human error.
We want to fully automate this workflow.
Since the supplier does not offer an API, the solution must use browser automation / RPA (Robotic Process Automation) to replicate our manual steps reliably.
⸻
Objectives
• Automatically detect a paid WooCommerce order.
• Use a “robot” to log in to the B2B portal and create the order exactly as per the customer’s details (pass type, dates, names, date of birth, etc.).
• Download the resulting voucher(s) or QR code(s).
• Attach/store the QR codes in the WooCommerce order.
• Send a branded customer email containing their QR code(s) and instructions.
• Provide error handling, logging, and the ability to retry failed orders.
• Build a small admin interface so we can view order status and re-trigger fulfilment if needed.
⸻
Key Requirements
• Experience in RPA / browser automation using tools such as Playwright, Puppeteer, Selenium, Robocorp, or UiPath.
• Strong understanding of WooCommerce hooks/webhooks and PHP or Node.js/Python integration.
• Ability to securely handle and store login credentials (use of secure vaults/secrets managers).
• Ability to parse and handle downloadable files (PDF, PNG) from the B2B portal.
• Experience with automated email delivery (e.g., AWS SES, SendGrid, or via WooCommerce).
• Build error handling, logging, and reporting (Slack/email alerts for failures).
• GDPR-aware handling of customer data.
⸻
Deliverables
1. Automated Workflow that:
• Triggers when WooCommerce order status is “Processing” (paid).
• Logs in to the B2B portal and completes order.
• Downloads voucher(s)/QR code(s) and links them to the Woo order.
• Sends branded confirmation email with voucher(s) attached or linked.
2. Admin/Support Dashboard (simple web UI or WooCommerce backend extension) to:
• See recent orders and fulfilment status.
• Retry failed fulfilments.
• Update pass type → B2B mapping without code changes.
3. Documentation:
• Setup instructions.
• How to maintain/update the automation if the B2B portal changes.
• Troubleshooting guide.
4. Testing & Training:
• Test with real and sandbox orders.
• Train our team on how to use the system.
⸻
Project Scope & Timeline
• Phase 1 (MVP): Automate a single pass type, single order, success path only.
(Target: 2–3 weeks from start date)
• Phase 2 (Full): Handle all pass types, bulk orders, error handling, retries, admin dashboard.
(Target: 4–6 weeks total from start date)
⸻
Skills & Technologies (preferred)
• RPA Tools: Playwright, Puppeteer, Selenium, Robocorp, UiPath
• Languages: Python or Node.js (preferred), PHP for WooCommerce integration
• WooCommerce Development: Hooks, webhooks, order meta handling
• Email Services: AWS SES, SendGrid, or Mailgun
• Hosting: AWS, Google Cloud, or similar for running automation bots
• Version Control: Git
⸻
Budget
• Fixed price preferred for MVP + agreed hourly or fixed fee for Phase 2.
• Please include:
• Examples of similar automation you’ve built.
• Estimated timeline and cost for MVP and full build.
• Any ongoing maintenance costs.
⸻
To Apply
When responding, please include:
1. Your relevant experience in RPA without an API.
2. Examples of browser automation projects you’ve delivered.
3. Your preferred tech stack for this project and why.
4. A brief outline of how you would approach the problem.
Corporate Human Capital Metrics Deck Category: Business Analysis, Corporate Identity, Data Visualization, Excel, Google Slides, Infographics, Powerpoint, Research Writing Budget: $200 - $250 SGD
Recreational Lake Permit Plan Category: 3D Modelling, 3D Rendering, AutoCAD, Building Architecture, Civil Engineering, Environmental Engineering, Landscape Design, SketchUp Budget: $250 - $750 USD
1 Minute Fundraising Video Creation Category: After Effects, Animation, Script Writing, Video Ads, Video Editing, Video Post Editing, Video Production, Visual Effects Budget: $10 - $20 CAD
