How We Saved This E-Commerce Site Close to 1,000 Hours Per Year

October 28, 2024
Share this post
Subscribe to newsletter
By subscribing you agree to with our Privacy Policy.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

During the pandemic, people were scrambling for interesting activities to do while being cooped up in quarantine. One such activity that a lot of people turned to was paint by numbers. One website, Just Paint by Number, saw their revenue grow over 1,100% during the pandemic. While a good problem to have, it's still a problem to handle such astronomical growth if you're not prepared for it. We helped turn this business into a valuable passive income stream for it's owner through a combination of building a custom no code automation application and outsourcing. Here's how we did it:

Just Paint by Number

For those that aren't familiar, paint by numbers is an activity where you get a canvas with a numbered outlined shapes printed on it. Each number in the shapes corresponds to a different color of paint. You paint the different shapes, and voila, you have a painted masterpiece! No special skills required. For Just Paint by Number, about 80% of their orders were custom kits. In other words, customers would upload photos that they wanted to have converted into a paint by number kit when they checked out on the e-commerce website (a WooCommerce site in this case). The business would then have to download the photo, send it to their supplier who was located in China. The supplier would then create a proof which the business would send to the customer. Once the customer approved, the business would have to notify the supplier so they could produce and ship the kit. When we timed this process, it took about 5 minutes per order which doesn't sound like a lot. However, over 10,000 orders, this process was taking the business over 750 hours per year. We were able to cut this process down to ZERO.

1. Automated Admin Dashboard

We first, using the no code platforms, Zapier and Bubble.io, we built a custom admin dashboard for the Just Paint by Number team could use. This dashboard automatically imported new order data as well as the image the customer uploaded.

Just Paint by Number No Code Dashboard

2. Created a Supplier Dashboard

We then created a very similar supplier dashboard where they could see most of the information that was provided on the admin dashboard. From their, their team could directly upload the proof that they created into the dashboard.

3. Automated Customer Notification

As soon as the supplier uploaded the proofs, we would send e-mail and SMS notification to the customer (although we delayed SMS notification until after 9:00 AM to ensure that we did not piss off any customers). They would get a unique link to this proof approval page:

Just Paint by Number Proof Approval

If the customer is informed that if they do not approve within 72 hours, the proof will automatically be approved. They receive reminders before this 72 hours via e-mail and SMS. After 72 hours, the proof is automatically marked as approved. The vendor can see this on their dashboard, and they send the kit to production once they see it is approved.

4. Automated Social Media Posting

If the customer approves the proof, they are given the option to give us permission to share the proof on our social media pages. If they say yes, the proofs are AUTOMATICALLY shared to the business' Facebook, Twitter, Pinterest, and Instagram accounts. Many customers will often share this proof once it is posted. Their Pinterest account gets hundreds of thousands of impressions per month from almost exclusively automatically generated content.

5. Customers LOVE the Process

It is really important to note that not only through this automation did we save this business hundreds of hours, we also improved the customer experience as well. See below for a customer testimonial on the process.

Just Paint by Number Customer Testimonial

Your business can benefit from custom applications just as Just Paint by Number did. Because we're building time-saving no code tools and because we offer financing, we can deliver these applications at a cost that is extremely affordable cost. if you're interested in seeing how your business can benefit, book a free consultation using the link below where we can understand your current workflows and business processes and identify bottlenecks that can be freed up through a custom no code application to automate your most time consuming tasks!

Stay Updated with Drive Phase Consulting

Sign up for our newsletter to receive updates, insights, and industry news.

By clicking Sign Up you're confirming that you agree with our Terms and Conditions.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Blog

Featured Blog Posts

Read some of our latest blog posts

How Seagate's Lyve Team Saved $2.3 Million and Accelerated Development by Switching from Full Code to Bubble.io

In the world of enterprise technology, innovation often hinges on balancing speed, cost, and functionality. Seagate's Lyve team recently demonstrated the transformative potential of no-code solutions by switching from a traditional full-code development process to Bubble.io. This decision resulted in staggering savings—$2.3 million annually by eliminating outsourced coding contracts—and significantly reduced project timelines from 15 months to just 3–4 months.

View Post

Why Wireframes are Essential for Custom App Development Success

Discover why wireframes are essential for successful custom app development, improving communication, saving time, and enhancing user experience.

View Post

Unlocking the Power of No-Code: Can It Really Meet Your Needs or Are There Hidden Limitations?

Explore the benefits and limitations of no-code platforms to determine if they can truly meet your development needs.

View Post

Debunking the Myths: Why Vendor Lock-in in No-Code Platforms is Overstated

Explore the reality behind vendor lock-in risks in no-code platforms and discover how businesses can navigate these concerns effectively.

View Post

Validating Your Startup Idea: Why You Should Do It Quickly and Cheaply

Validating your startup idea is crucial to ensure you're solving a problem that people will pay to solve. As a founder, it's important to validate your idea quickly and cheaply before fully developing a product. You can start by offering your solution as a consulting service or using existing tools to create a minimum viable version. The most important step in validation is not just asking people if they would buy but actually getting them to pay. This shows genuine interest and proves your idea addresses a real, painful problem. By validating early, you save time, money, and increase your chances of building a successful product.

View Post

HIPAA Compliant App Development Using No Code

No code development represents a transformative shift in how applications are built. This approach is particularly significant given the healthcare industry's strict regulations, such as HIPAA (Health Insurance Portability and Accountability Act), which governs the privacy and security of medical information. The issue has historically been that many no code platforms are not HIPAA compliant. However, two of the new paltforms, WeWeb and Xano, are actually HIPAA compliant which opens up the benefits of no code to more health care organizations.

View Post

The Importance of Valuing Time for Small Business Owners

Small business owners often face a unique challenge of valuing their own time. Juggling numerous responsibilities, they can easily fall into the trap of undervaluing their hours, leading to burnout, procrastination, and stunted business growth. This struggle is often rooted in the complexity of roles they play – from sales to marketing to operations – which often leaves little time for strategic thinking and planning.

View Post

Our Lead No-Code Consultant Becomes One of the First 100 Certified Bubble Developers

We are excited to announce that our very own Lead No-Code Consultant, Xan Hong, has achieved a significant milestone by becoming one of the first 100 Certified Bubble Developers through Bubble.io. This accomplishment not only underscores Xan's commitment to staying at the forefront of technological innovation but also reinforces Drive Phase Consulting's dedication to providing top-tier, cutting-edge solutions to our clients as a Bubble Consultant.

View Post

How We Saved This E-Commerce Site Close to 1,000 Hours Per Year

During the pandemic, people were scrambling for interesting activities to do while being cooped up in quarantine. One such activity that a lot of people turned to was paint by numbers. One website, Just Paint by Number, saw their revenue grow over 1,100% during the pandemic. While a good problem to have, it's still a problem to handle such astronomical growth if you're not prepared for it. We helped turn this business into a valuable passive income stream for it's owner through a combination of building a custom no code automation application and outsourcing.

View Post