Zapier Case Studies Automating eCommerce Transactions: A Case Study of Blue is the Land

Edit This Case Study Record

	Automating eCommerce Transactions: A Case Study of Blue is the Land Zapier

Automating eCommerce Transactions: A Case Study of Blue is the Land

Zapier

Technology Category	Application Infrastructure & Middleware - Database Management & Storage Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries	Cities & Municipalities Equipment & Machinery
Applicable Functions	Procurement Sales & Marketing
Use Cases	Last Mile Delivery
Challenge	Blue is the Land, an eCommerce business founded by Derek Howles, faced a significant challenge in managing its sales records across multiple channels. The company, which sells neighborhood maps, operates on various platforms such as Shopify, Etsy, and Fancy. While these multiple sales channels increased revenue, they also complicated recordkeeping as transaction information was scattered across different systems. It was crucial for the company to ensure that orders and customer information were consistently funneled through the fulfillment pipeline. The challenge was to create a centralized database that could consolidate each transaction from every channel in a convenient and efficient manner. Read More
About Customer	Blue is the Land is an eCommerce business that sells neighborhood maps. The company was officially launched in late-2013 by founder and designer Derek Howles, who has a deep fascination with cities and their neighborhoods. The company operates across multiple sales channels, including Shopify, Etsy, and Fancy. Blue is the Land has a diverse range of 30 different neighborhood maps and continues to expand its product line. The company is committed to ensuring a consistent and efficient fulfillment pipeline for its orders and customer information across all its sales platforms. Read More
Solution	To address the challenge, Derek built a database in Google Sheets, consolidating each transaction from every sales channel in one convenient spreadsheet. He used Zapier, an app automation tool, to pull this information from ShipStation, an eCommerce order management platform where Blue is the Land's orders were imported for shipping and fulfillment. With a simple Zap, a bridge between two or more apps, Derek connected ShipStation's data to recordkeeping in Google Sheets, creating a database that populates itself. Additionally, Derek also used Zapier to build email lists in MailChimp from his customer data in ShipStation. He added an extra step to this particular Zap, using Filter by Zapier to find specific customers, enabling Blue is the Land to send customized, targeted emails for particular groups. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Database Management & Storage

Infrastructure as a Service (IaaS) - Cloud Databases

Applicable Industries

Cities & Municipalities

Equipment & Machinery

Applicable Functions

Procurement

Sales & Marketing

Use Cases

Last Mile Delivery

Challenge

Blue is the Land, an eCommerce business founded by Derek Howles, faced a significant challenge in managing its sales records across multiple channels. The company, which sells neighborhood maps, operates on various platforms such as Shopify, Etsy, and Fancy. While these multiple sales channels increased revenue, they also complicated recordkeeping as transaction information was scattered across different systems. It was crucial for the company to ensure that orders and customer information were consistently funneled through the fulfillment pipeline. The challenge was to create a centralized database that could consolidate each transaction from every channel in a convenient and efficient manner.

About Customer

Blue is the Land is an eCommerce business that sells neighborhood maps. The company was officially launched in late-2013 by founder and designer Derek Howles, who has a deep fascination with cities and their neighborhoods. The company operates across multiple sales channels, including Shopify, Etsy, and Fancy. Blue is the Land has a diverse range of 30 different neighborhood maps and continues to expand its product line. The company is committed to ensuring a consistent and efficient fulfillment pipeline for its orders and customer information across all its sales platforms.

Solution

To address the challenge, Derek built a database in Google Sheets, consolidating each transaction from every sales channel in one convenient spreadsheet. He used Zapier, an app automation tool, to pull this information from ShipStation, an eCommerce order management platform where Blue is the Land's orders were imported for shipping and fulfillment. With a simple Zap, a bridge between two or more apps, Derek connected ShipStation's data to recordkeeping in Google Sheets, creating a database that populates itself. Additionally, Derek also used Zapier to build email lists in MailChimp from his customer data in ShipStation. He added an extra step to this particular Zap, using Filter by Zapier to find specific customers, enabling Blue is the Land to send customized, targeted emails for particular groups.

Impact #1	The implementation of Zapier and Google Sheets significantly streamlined Blue is the Land's operations. The automated database not only consolidated transaction information from multiple sales channels but also populated itself, reducing manual work and potential errors. The automation of building email lists from customer data in ShipStation allowed for more efficient and targeted marketing efforts. The Filter by Zapier feature enabled the company to identify specific customer groups and send customized emails, enhancing customer engagement and loyalty. Overall, the solution allowed Derek to save time and money, enabling him to focus more on his passion for geography, art, and design, and less on administrative tasks.

Impact #1

The implementation of Zapier and Google Sheets significantly streamlined Blue is the Land's operations. The automated database not only consolidated transaction information from multiple sales channels but also populated itself, reducing manual work and potential errors. The automation of building email lists from customer data in ShipStation allowed for more efficient and targeted marketing efforts. The Filter by Zapier feature enabled the company to identify specific customer groups and send customized emails, enhancing customer engagement and loyalty. Overall, the solution allowed Derek to save time and money, enabling him to focus more on his passion for geography, art, and design, and less on administrative tasks.

Benefit #1	Consolidated transaction information from multiple sales channels into one database
Benefit #2	Automated the process of building email lists from customer data
Benefit #3	Enabled targeted email marketing by identifying specific customer groups

Benefit #1

Consolidated transaction information from multiple sales channels into one database

Benefit #2

Automated the process of building email lists from customer data

Benefit #3

Enabled targeted email marketing by identifying specific customer groups

Download PDF Version

Overview

Automating eCommerce Transactions: A Case Study of Blue is the Land

Operational Impact

Quantitative Benefit