Mar 23, 2021 | 11 minutes
How to Auto Send Shopify Orders to Dropshipping Suppliers [Guide]
Learn how to automate one of the most time-consuming dropshipping processes there are: Sending Shopify orders to manufacturers for fulfillment.

In recent times, the convenience of Shopify dropshipping has attracted many sellers in the ecommerce industry.Â
The appeal of this retail variety is easy to come by for the attentive observer, and can be explained in a few strong reasons:
Well-oiled supply chains
Abundance of quality fulfillment services
Massive adoption of online shopping
Ease of building a digital store
In other words, markets are ripe for sellers who excel in the two key areas of dropshipping: finding good products at great prices, and managing processes better than the competition.
Naturally, automation plays a predominant role in the latter.Â
By automating processes related to operations, marketing, and sales, dropshippers lay the foundation for more efficient operations and better margins.Â
But where to begin?Â
There are multiple tasks and processes that fit the âdropshipping automationâ bill, and itâs easy to get confused.Â
With that in mind, we are here to show you how to automate one of the most time-consuming processes Shopify dropshippers deal with: Sending Shopify orders to manufacturers for fulfillment. Â
Itâs a dropshippersâ job to receive orders and notify the supplier/manufacturer to fulfill them, and automating the process can make a huge impact on earnings.Â
In this tutorial, we will show you how to automate your flow of orders from the very beginning. But first, letâs take a look at some important considerations.Â
Shopify sellers and suppliers: A special relationship
Itâs an understatement to say that reliable, professional suppliers are crucial for dropshippers.Â
After the careful and somewhat tedious process of choosing a supplier, collaboration between parties begins.Â
If you already have a Shopify store, you probably came across the problem of having to manually send orders to your supplier. This usually requires using email or some other form of communication.Â
Itâs an inefficient, but also counterproductive workflow. The more orders you get, the longer it will take you to funnel them to your manufacturer.Â
Moreover, Shopify doesn't provide a native solution to this problem, and thatâs why we are here today. Â
In the following use case, we will show you how to use Make to:
Automatically store new Shopify orders in a database
Let your suppliers view new orders in the database (and consequently, fulfill them)
Send a confirmation email to the customer once an order is fulfilled
To fully automate the entire process, we will rely on three tools: Airtable, Make, and email.
Note: You will need an Make account to create this integration. If you donât have one yet, please register for free.
Note 2: You will see the word âscenarioâ thrown around a lot. This is a synonym to âautomated workflowâ, and our setup will require two of them. For more information about basic Make terms, please refer to this page.Â
Shopify order to manufacturer, automated: A step-by-step guide
As we mentioned earlier, we will be using Airtable as our database. Here, we will store the orders for the suppliers to fulfill. Once thatâs done, an automatic notification will be sent to the customer.Â
To accomplish this, we will use two Make scenarios that will do the following:
Scenario 1: Instantly receives new orders from Shopify and adds them to an Airtable base. This scenario will use two Make modules:
Shopify > New Event (instant)
Airtable > Create a recordÂ
Scenario 2: Checks if the order status has been changed to âShippedâ in the Airtable base. Then, it automatically changes the order status in Shopify, and sends the confirmation email to the customer. This scenario will use the following Make modules:
Airtable > Watch records
Shopify > Create a fulfillment
Email > Send an email
Now, letâs begin by creating the first Make scenario.
Scenario 1: Connecting Shopify to Airtable
To begin, please click the âCreate a new scenarioâ button on the top right corner of your Make dashboard.
On the next screen, type âShopifyâ, select the app, and click âContinueâ on the top right corner.
You will be redirected to the scenario builder, where you will create the Shopify - Airtable integration.
The first thing youâll see is a blank module on your screen. Select the pre-loaded Shopify app and select the âNew eventsâ module.Â
This module will instantly receive orders when they are created on Shopify.
 Â
1. Configuring the âNew Eventâ Shopify module
For Make to instantly receive the orders, you first need to create a webhook. To do that, click the âAddâ button in the module.
The âAdd a hookâ box will appear on your screen. Here you have to give your webhook a name (if you want), and then click the âAddâ button.
After you do this, a second box labeled âCreate a connectionâ will appear.Â
This is where you can give your connection a name; you will also have to copy and paste your Shopify subdomain, and click âContinueâ.
Next, you will need to click on the âEventâ dropdown, and select the âorders/paidâ option from the list. Once you do this, click âSaveâ.
After you do this, Make will automatically attach the webhook to Shopify.
To finish the configuration of this module, we will have to test the webhook. When it comes to webhooks, Make needs to learn the data structure before adding other apps to the scenario. To do this, please follow these steps:
Hit the âRun onceâ button on the bottom left of your scenario
Go over to Shopify, create an order and mark it as paid
Go back to your Make scenario. If you see the number â1â above the module, then the webhook is working properly
2. Configuring the âCreate a recordâ Airtable module
Now that the Shopify module has been configured, itâs time to add the âCreate a recordâ Airtable module to the scenario.Â
On the left side of the Shopify module, youâll notice a plus sign. Click on it to bring up the search box, type âAirtableâ, and click on the Airtable app.
You will see a list of Airtable modules; here, select the âCreate a recordâ module. We will use this module to automatically add new Shopify orders to an Airtable base.
Once in the module configuration box, start by clicking the âAddâ button to connect your Airtable account to Make.Â
Bear in mind, you will be required to enter your Airtable API token. To obtain it, all you have to do is follow these simple steps.
Assuming that you have created an Airtable base beforehand, you now need to choose the base and the table that you want to add the orders to.
Now comes the important part: mapping the data elements coming from the Shopify module into the Airtable module.Â
Before learning how to do this, letâs take a quick look at the field layout in the Airtable table.
Please note that your table may contain different fields according to your requirements. Make sure that the fields below are included, as they are standard for the process:
First name
Last name
Email
Product
Variant
Status (Use the Single Select field type and add Pending and Shipped options.)
Shipping address
Created time
Last modified time
Order ID
Order number
If you want to use the same base used in this tutorial, you can copy it here.
Back in the Airtable module, you will see your Airtable columns as fields.Â
Here, you will have to map (drag and drop) the data elements from the Shopify module to the corresponding fields in the module.Â
Eg. Data customer: first_name to the First name field, Data customer: last_name to the Last name field.
This sounds more complicated than it actually is - please refer to the image below to visualize how to do it.
When you get to the âStatusâ field, enter the word âPendingâ, as this should be the initial status of orders that have been placed but not yet shipped.
Then, you will have to complete the âShipping addressâ box with the corresponding data element, as shown below.
Once you do this, click âOkâ at the bottom of the module, and then hit the âSaveâ button at the bottom of the scenario.
3. Testing the scenario
Now that the scenario has been configured, itâs important to ensure it works the exact way you want it to.
Like you did previously, hit the âRun onceâ button and create an order in Shopify. This is what the execution should look like:
To activate this scenario, please set the switch below the âRun onceâ button to âonâ.
Scenario 2: Updating order status on Shopify, sending email notifications
The first scenario is running, which means that new Shopify orders will be automatically sent to the Airtable base.Â
After you provide your supplier with access to that base, it will see the orders as soon they arrive, and start the fulfillment process.
Here, we will need a second Make scenario to go the full circle. This second scenario will:
Change the order status in Shopify to âFulfilledâ after your supplier changes the status to âShippedâ on the Airtable base
Send an email notification to the corresponding customer, telling that the order has been shippedÂ
This is how it's done.
1. Creating a new scenario
You need to create a new scenario, which you can do directly from the scenario builder.Â
In the first scenario you are watching Shopify for new orders, in the second scenario you will be watching Airtable for order status changes.Â
So, after you create a new scenario on Make, please select the Airtable app on the scenario builder, and search for the âWatch recordsâ module.Â
Since you already added your Airtable connection, it should already be selected for you in the module.
After you do this, select the Airtable base and the table that contains the orders.Â
In the âTriggerâ field, select the âlast modified timeâ option.Â
When the status is changed in a record, the last modified time will be updated, telling Make to pick up this record and trigger the automation.
Next, choose a field that will be used as a label for the record.Â
In the âLimitâ field, enter the maximum number of records you want Make to retrieve during one scenario run.
2. Connecting the Shopify appÂ
This module will change the order status on Shopify to âFulfilledâ automatically, so you donât have to.Â
In the scenario builder, add a new module, select the Shopify app and pick the âCreate a fulfillmentâ module.
Inside the module, select your Shopify account, which was added earlier in the flow. Then, simply map the âOrder IDâ data element from the Airtable module to the âOrder IDâ field, and select the location.
Scroll down to the âShipment statusâ field and select the âconfirmedâ option. After that, click âOKâ.
3. Configuring the filter: A simple way to manipulate data on MakeÂ
What happens if the supplier accidentally changes the status to âshippedâ and then changes it back to âpendingâ?Â
The âlast modified timeâ field in the table will still be updated. Therefore, when the scenario executes, the order status will be incorrectly changed to âFulfilledâ in Shopify.Â
So how do you prevent this from happening? Simple: use a filter.Â
Exclusive to Make, filters are used to only allow data meeting specific criteria to pass through.
In this case, the filterâs criteria will be the following: the status of a record must be âshippedâ. Thus, only the records labeled as such will pass through to the Shopify module and update the fulfillment status of the order.Â
To set up the filter you have to click on the link between the two modules:
Then, configure the filter as follows:
Give it a name
Map the âStatusâ element to the top field (under âConditionâ)
Select the âEquals to (case insensitive)â text operator
Type in the word âShippedâ in the bottom field(exactly as is, including a capital S)
And thatâs it. Now that the filter has been set up, letâs finish setting up the scenario.Â
4. Configuring the Email app
The final part of the scenario uses email to send shipping notifications to your customers.Â
To configure it, add a new module, search for the Email app and select the âSend an emailâ module.
When you add your account, you have the option of choosing between two connection types:
Google restricted
Others (SMTP)
If you are using Gmail, please read the additional information under âConnection nameâ.
Moving on, the customerâs email address is contained in the âEmailâ field on the table.Â
In the âToâ field, click the pencil icon and map the âEmailâ element from Airtable.
When it comes to the subject and content of the email, you can customize it the way you want.Â
Below is an example of a basic layout and the important elements to map in the subject and body.
5. Testing the scenario
Testing this second scenario is slightly different than the first one.Â
Since we are not using a webhook, you will need to:
Change the status of an order in AirtableÂ
Hit the âRun onceâ button in the scenarioÂ
If done correctly, the execution will look like this:
6. Scheduling the scenario
To set up scenario scheduling, switch the scenario on and the schedule box will pop up.Â
You can always access this menu by clicking the clock icon on the trigger module as well.
In the âRun scenarioâ field, simply choose the interval that best suits your business needs and click âOkâ.
Scheduling will determine how often the scenario will run - that is, update order status on Shopify, and send the corresponding email notifications to customers.Â
And that, friends, is all.Â
ConclusionÂ
Shopify dropshippers want their business to run smoothly, but also to be sustainable in the long term. That is why Shopify dropshipping automation matters.Â
These two automated scenarios will help you achieve that, and focus on the less automatable parts of your business: getting better suppliers, and lower prices.
To conclude, thereâs the peace of mind factor. Knowing that your customers will get what they purchased without requiring your intervention is dropshipping at its finest. Â
Happy automating!

Wayne Govender
Solutions Architect at Make who loves all things tech with a focus on workflow automation. Also enjoys fitness and spending too much time on YouTube.