Orders7 min read

How Do I Send Each Shopify Order to My Supplier Automatically?

Email each supplier only its own items from every new Shopify order, in the file layout it asks for, and get tracking numbers back from a Google Sheet.

In this guide
  1. Why is this still done by hand in so many shops?
  2. What can Shopify do on its own?
  3. How do I email each supplier only its own items?
  4. How do I send the file layout my supplier asks for?
  5. How do I get tracking numbers back from my supplier?
  6. What should I check before the first order goes out?
  7. FAQ
  8. Try Columna: Order Export & Sheets

To send each Shopify order to your supplier automatically, match the supplier to the products it ships by the product’s vendor, then have an app email that supplier a file with only its items whenever an order is paid. The file layout comes from a saved template, so it can have the columns your supplier asks for. For tracking, give the supplier a Google Sheet it can type tracking numbers into, and have those numbers fulfill the orders in Shopify.

This guide shows how to set that up with Columna: Order Export & Sheets, what Shopify’s own tools cover, and what to check before the first order goes out.

Why is this still done by hand in so many shops?

Dropshipping and multi-vendor shops that work with suppliers outside an app network keep asking the same thing in the Shopify Community: how do I get each order to the supplier, manufacturer or partner without forwarding it myself? The usual answer is “email it” or “export a CSV”, which is the manual job they wanted to stop doing.

Three things make it harder than it looks:

  • One order, several suppliers. A customer buys a mug from one supplier and a print from another. Each supplier should see only its own line, not the whole order and not the other supplier’s prices.
  • Each supplier wants its own layout. One asks for SKU, quantity and ship-to address; another wants the product title and a size column.
  • Tracking has to come back. Once the supplier ships, the tracking number must get onto the order in Shopify so the customer can follow it.

What can Shopify do on its own?

Shopify Flow can react to new orders and has a Send internal email action that sends an email from your store’s sender address to one or more addresses. You can list order details in the body with Liquid. That is a fair start for one supplier and a few orders a day.

Where it stops, for this job:

Need Flow with Send internal email An app that emails suppliers
Only the supplier’s own items from a mixed order You write the Liquid conditions yourself Picked by the product’s vendor
A spreadsheet file in the supplier’s layout Shopify’s page for the action mentions no attachments; data sits in the email body An Excel file built from a template
Several suppliers One branch or workflow per supplier One supplier entry each
Tracking numbers back into Shopify Not covered by the email action From a synced Google Sheet (Columna Pro)

If one supplier and an email body are enough for you, Flow is the simpler choice. For several suppliers who want a file, read on.

How do I email each supplier only its own items?

In Columna this is the Suppliers page, part of the Pro plan. The app picks a supplier’s items by the product’s vendor in Shopify, so first make sure every product has the right vendor set.

  1. In the app, open Settings and pick Suppliers.
  2. Click Add supplier and enter a Supplier name, such as “Coffee roaster”. It appears in the email subject and the file name.
  3. Under Vendors, tick the vendors this supplier ships. Names match regardless of upper or lower case.
  4. Under Supplier email addresses, add the address the supplier reads orders at (up to 3).
  5. Under Send orders, choose When the order is paid (recommended) or As soon as the order is placed. The second also sends orders that are not paid yet, such as cash on delivery or bank transfer.
  6. In Template, keep the Supplier order sheet preset or pick a template of your own.
  7. Optional: tick Tag orders after they are sent so each emailed order gets a tag (the default is sent-to-supplier).
  8. Click Save.

A few minutes after an order is paid (or placed), the supplier gets an email with an Excel (.xlsx) file holding only the items from its vendors and the shipping address. Several new orders can arrive in one email. Each order is sent once; Resend in Sent orders sends it again, and Send now sends the orders the supplier has not received yet without waiting.

Only orders placed after you saved the supplier are sent, so earlier open orders still need to go out the way you sent them before. A shop can have up to 20 suppliers, each with up to 20 vendors. The full steps are in the help guide How do I email each supplier only its own order items?.

How do I send the file layout my supplier asks for?

The template decides the columns. The Supplier order sheet preset is one row per line item, with each item’s vendor and the ship-to address, and leaves out prices and the customer’s email. It ends with two empty columns, Tracking number and Carrier, that the supplier can fill in on the same file (Columna does not read that file back; for tracking that comes back on its own, use the Google Sheet below).

If your supplier wants something else:

  1. Open Templates, find Supplier order sheet and click Customize.
  2. Add the columns the supplier asked for, such as SKU, Variant, Quantity or a line-item property like an engraving text, each in its own column.
  3. Rename the headers to the supplier’s words and drag them into the supplier’s order.
  4. Save the template and pick it in that supplier’s Template field.

Each supplier can use a different template. The sender name and reply-to address of these emails are set under Settings > Email sender, so a supplier’s reply reaches your orders inbox.

How do I get tracking numbers back from my supplier?

With Pro, tracking numbers typed into a synced Google Sheet fulfill the orders in Shopify.

  1. Set up a Google Sheets sync of new orders, with a template of one row per order or one row per line item.
  2. In the sync’s settings, tick Write tracking back to Shopify, allow fulfillment access when the app asks, and decide whether Shopify should email customers when an order ships.
  3. On the next sync the sheet gets Tracking number, Tracking company and Tracking URL columns, plus a Tracking result column.
  4. Share the sheet with the supplier. They type the number in the order’s row and leave the two sync key columns alone.

The app reads the sheet at least once an hour. In a sheet with one row per line item, each row fulfills only its own item, and a sync filtered to one supplier’s items fulfills only those items, so each supplier can fill in its own rows. Tracking result then says, for example, “Fulfilled in Shopify”. This works for orders that ship from your own locations; orders that another app or a fulfillment service ships are left to that app. Details are in How do I write tracking numbers from Google Sheets back to Shopify?.

What should I check before the first order goes out?

  1. Vendor names. An order is skipped for a supplier when the product’s vendor does not match one of that supplier’s vendors. Fix spellings on the products in Shopify admin.
  2. Personal data. Send the supplier only the columns it needs to ship. The Supplier order sheet preset already leaves out prices and the customer’s email.
  3. Payment timing. Keep When the order is paid unless you take cash on delivery or bank transfer and the supplier should start before payment.
  4. A test order. Place one order for each supplier’s product and check the Sent orders list and the supplier’s inbox before you rely on it.

To check what each supplier sold you at month end, a vendor filter on an export gives you the lines to compare with their invoice; see sales per vendor from Shopify orders. For a full order file on a schedule instead, see Shopify scheduled order export.

FAQ

Can Shopify email my supplier when an order is placed?

Shopify Flow’s Send internal email action can send order details to an address you enter, in the body of the email. It does not split a mixed order by supplier for you, and Shopify’s page for the action mentions no file attachments.

Will my supplier see my prices or my customer’s email?

Not with Columna’s Supplier order sheet preset, which leaves both out. If you build your own template, you choose every column the supplier gets.

Are orders placed before I set up the supplier sent too?

No. Only orders placed after you saved the supplier are emailed. Send earlier orders the way you did before.

Can the supplier add tracking numbers without access to my Shopify admin?

Yes, with Columna Pro: they type the number into the shared Google Sheet, and the app fulfills the order in Shopify with that tracking number.

Do I need Pro for this?

Emailing suppliers and writing tracking back from Google Sheets are Pro features. On Free you can still export orders to CSV or Excel with a vendor filter and send the file yourself. Plans are on the Columna app page.

Try Columna: Order Export & Sheets

Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX with line-item properties such as engraving, gift messages and upload links, for shops that hand orders to production, fulfilment or accounting. If your supplier is the one who makes or ships the order, set it up once and let each new order reach them. Install Columna: Order Export & Sheets on the Shopify App Store.