CSV Bulk Order System

The Challenge: TPB Marketplace, a leading Canadian distributor of sustainable products and reusable lighters, was struggling with their wholesale ordering process. Their B2B customers were placing large repeat orders with dozens or even hundreds of products, but the traditional "add to cart" process was time-consuming and frustrating. Store owners needed to click through multiple product pages, manually entering quantities for each SKU — a process that could take 30-45 minutes for a typical bulk order.

The Solution: We developed a custom CSV-based Bulk Order Uploader that revolutionized their ordering workflow. The system allows wholesale customers to download a pre-populated template with all active SKUs, edit quantities in Excel or Google Sheets, and upload everything in seconds. The app validates stock availability in real-time, handles partial fulfillment scenarios, and integrates seamlessly with their existing Shopify checkout and promotional systems (including BOGO offers).

Technical Implementation:

• Custom Shopify app built with Node.js backend

• Real-time inventory validation via Shopify API

• CSV parsing with error handling and validation

• Smart cart management with automatic product addition

• Responsive UI with drag-and-drop file upload

• Stock availability alerts and partial order handling

• Integration with existing discount and promotion logic

The Results:

• 90% reduction in order placement time (from 30+ minutes to under 3 minutes)

• Increased average order value by 28% due to simplified bulk ordering

• Higher customer satisfaction — wholesale clients now prefer their platform over competitors

• Reduced cart abandonment for bulk orders by 65%

• Scalable solution handling orders up to 500 line items

• Winner of CSNC Sustainability Impact Award 2023

Client Testimonial: "The bulk order uploader has been a game-changer for our wholesale business. Our customers love how fast and easy it is now, and we've seen a significant increase in repeat orders. The development process was smooth, and the team understood exactly what we needed."

Delivery Timeline: 21 days from concept to launch