Parseur logo Shopify logo

Extract data from Shopify orders in real time

shopify integration

You can start selling products right from the beginning and Shopify has you covered with everything that you need (built-in tools, marketing campaigns, payment, and shipping).

We all know how the COVID 19 crisis has changed the way businesses are done. It became important for shops to have an online presence so that the business can keep running. Online selling and home deliveries became the new “normal”.

Shopify’s Revenue Nearly Doubles as Covid-19 Pushes Shopping Online” - The Wall Street Journal

Using Shopify as an online shop is a great way to grow your business and earn revenue. However, choosing what products to sell, reaching out to suppliers, updating your store, keeping track of paid orders and among other things are time-consuming. As an online retailer, you have to take care of everything.

What if you could automate your e-commerce and save countless hours?

Integrating your Shopify account with Parseur will only scale up your business!

Parseur is a powerful mail parser tool that automates data extraction from emails and attachments such as PDFs or Excel. The parsed data can be downloaded, sent to Google Spreadsheets or to any other application of your choice using Zapier, Integromat. and MS Flow.

Rest assured that Parseur is a no-code tool just like Shopify. You don’t need to be tech-savvy or hire a technical person to use Parseur.

Popular ways of Parseur and Shopify integration:

  • Add new Shopify orders to a Google Sheets spreadsheet
  • Add new Shopify customers to a Mailchimp list for your email marketing
  • Send real time order notifications from Shopify to Slack
  • Book new sales to your accounting software

In this article, we'll demonstrate how to extract data from shopify purchase orders as an example. Other use cases follow a similar pattern.

Step 1: Create your free Parseur mailbox

Parseur is totally and forever free for a limited number of emails sent per month, with all features enabled. Click on the link below to get started.

Create my Parseur account
Having a powerful email parsing tool can help you automate your business processes, saving you countless hours of work.

Once your account is created, enter a name for your mailbox to create it.

name the parseur mailbox

Name your mailbox

Select Custom emails (default) or Custom emails and attachments if you need to extract data from documents attached to emails (for example, sales orders generated on your Shopify store or purchase orders for your vendors).

Parseur is a visual template tool that has a built-in library of templates that will automatically process the data extraction, depending on which industry you are in.

select the mailbox type

Select custom emails (default)

Step 2: Forward Shopify orders to your mailbox

Let’s take the case where you use the purchase order tool from Shopify to generate a purchase order for one of your vendors.

Once you receive the PO in your mailbox, you need to extract specific data from it and insert it in Google sheets so that your team can have access to those details as well.

Go to your personal mail inbox and forward one of your orders to your Parseur mailbox.

Note: for best results, we recommend you forward your emails from your original email client (Gmail, Yahoo, etc.) and not from your phone or desktop email client (Apple Mail, Outlook, etc).

sample of shopify email

Example of a Shopify email received in Parseur mailbox

Shopify purchase order received in mailbox

Purchase order received

Step 3: Create a template to extract Shopify order data

You do not need to create parsing rules for the data extraction process. Highlight the data that you need and create data fields for them.

Create template for shopify

Highlight the data

Click on “create template” once done. The parsed results will appear like this:

parsed results from data extraction

Parsed results

Step 4: Export the parsed order data to your favorite application

To Google sheets

Like we mentioned above, you can send the extracted data to Google sheets.

Click on “export” on the left-hand side of your mailbox and click on “Google sheets

All you have to do is click on “new spreadsheet” and copy the formula there. Those formulas will automatically send the data to the Google spreadsheet.

Since there are tables and rows in our template, we will use the second formula.

export pdf to google sheets

Click on export in your Parseur mailbox and select Google Sheets

parsed data sent to Google sheets

Extracted data sent to Google sheets

And, you will see that the data has appeared automatically which will be refreshed every hour and so.

Using Zapier

With the integration of Zapier, you can send out the data to any application of your choice (a CRM tool, project management tool). Zapier makes it easy to connect applications together without relying on developers.

Zapier integration

Export to Zapier

As an online store builder, Shopify provides you with all the tools to create an online business with your products. However, it can get quite hectic once you have many orders coming in.

An integration with Parseur will always help to automate the workflow.

Parseur logo What is Parseur?

Parseur is a powerful email parser software to automatically extract text from emails, attachments and documents and automate your workflow. See Parseur features.

Shopify logo What is Shopify?

Shopify is an e-commerce platform that enables anyone to set up an online store, without any coding knowledge. More about Shopify.

Zapier logo What is Zapier?

Zapier is a cloud automation tool that connects apps together. You can connect two or more apps to automate repetitive tasks without coding or relying on developers to build the integration.