How frequently can I sync data from Shopify to Excel?

Flatly allows you to set custom sync frequencies ranging from every 10 minutes to once daily, depending on your Flatly pricing plan.

Does Flatly modify my Shopify data during the sync?

No. Flatly provides a strict one-way sync. It extracts your historical and dynamic data from Shopify and securely loads it into Excel without altering your original source data.

Do I need to write code to connect Shopify to Excel?

No code is required. Flatly is a turnkey, no-code integration platform designed for non-technical users to securely connect their data sources and destinations in minutes.

Commerce Destination

Sync Shopify to Excel

Automatically sync your Shopify data into Excel with Flatly's no-code, triggerless, turnkey integration service.

Historical & Dynamic Data

One-way Sync

For Non-technical Users

Connect Shopify to Excel Which Shopify API does Flatly use?

Source: Shopify

Shopify is a complete commerce platform that lets you start, grow, and manage a business.

Auth: OAuth

Available datasets

ApplicationCharges-All
ApplicationCredits-All
Blogs
Blogs+Articles Combo
Carrier Services
Custom Collections
Customers-All
Customers-Last X days Date-ranged
Customers+Metafields Combo
Customers+Metafields-Last X days Combo Date-ranged
InventoryLocations
Marketing Events
Metafields
Orders-All
Orders-Last X days Date-ranged
Orders-All+Metafields Combo
Orders-Last X days+Metafields Combo Date-ranged
Orders+Fulfillments-All Combo
Orders+Fulfillments-Last X days Combo Date-ranged
Orders+Refunds-All Combo
Orders+Refunds-Last X days Combo Date-ranged
Orders+Transactions-All Combo
Orders+Transactions-Last X days Combo Date-ranged
Pages-OnlineStore
PaymentsBalance
PaymentsPayouts-All
PaymentsPayouts-Last X days Date-ranged
PaymentsPayouts-Last X days+Transactions Combo Date-ranged
Policies-OnlineStore
PriceRules
PriceRules+Discounts Combo
Products-All
Products+Variants Combo
Products+Metafields Combo
Recurring Application Charges
Redirects

Destination: Excel

Desktop clients like OneDrive or Dropbox can sync flat files directly to the desktop.

Auth: OAuth

How it works

1
Connect Shopify

Authenticate Shopify (OAuth) and Excel (OAuth) in the Flatly dashboard. You only have to do this once.
2
Choose your datasets

Pick which Shopify datasets to sync and set your sync frequency. The frequencies available to you depend on your Flatly plan.
3
Data lands in Excel

Flatly uploads your Shopify data to Excel automatically and refreshes it based on your sync frequency.

Shopify

What are Metafields and Metaobjects?

Some of the Shopify data sets Flatly offers include metafields and metaobjects automatically blended in with each parent data set (example: Orders-Last X Days+MetaFields). Since these metas can contain nested data, Flatly outputs these data sets in a left-joined format. The parent to each meta has its fields repeated in each row, whereas each meta is unique to each row. The labels from each meta are presented as column headings, to make the data intelligible for human users.

A non-left-joined option (high column count) is available as well. First, experiment with the existing Flatly Shopify data sets and check if your business intelligence platform can properly relate repeated parents to unique metas without any additional setup. Reach out to Flatly Support for more details.

FAQ: Shopify to Excel

How frequently can I sync data from Shopify to Excel?: Flatly allows you to set custom sync frequencies ranging from every 10 minutes to once daily, depending on your Flatly pricing plan.
Does Flatly modify my Shopify data during the sync?: No. Flatly provides a strict one-way sync. It extracts your historical and dynamic data from Shopify and securely loads it into Excel without altering your original source data.
Do I need to write code to connect Shopify to Excel?: No code is required. Flatly is a turnkey, no-code integration platform designed for non-technical users to securely connect their data sources and destinations in minutes.

“The interface is unbelievable. Flatly is so easy to use. After years of struggling with Zapier this is life changing.”

Melissa Cable

Project Manager, Aeolidia

Full data refresh

Maintain up-to-date flat files when any nested or bundled data changes in your source app.

Connection Management

Manage multiple tenants, with connection health monitoring.

Bulk Job Management

Control multiple jobs at the same time, with live progress monitoring.

Merged datasets

Export left-joined combo objects like deals+products.

Write options

Refresh one flat file or create a stack of timestamped versions.

Filterability

Include only the columns or views essential for your reporting.

Notifications

Get alerts about your syncs via email, webhooks or Slack notifications.

Logging

Access up to one thousand log entries for your sync operations.

Custom Field Enrichment

Get useful values in your data instead of identifiers or definitions.

Metadata Attachment

See file statistics alongside your flat files to keep track of their origins.

Dark UI Mode

Reduce eye strain and save energy by using our built in dark mode.

Programmatic Jobs

Queue jobs by making API calls or agent requests.

Time Stamp Enrichment

Get human-readable dates and times from UNIX timestamps.

High frequency

10-minute refresh cycles mean your data store is near real-time.

High capacity

Reliably flatten billions of cells to CSV files without hiccups.

Advanced Security

Two-factor authentication and Destination Lock controls.

Stripe-powered Billing

Reliable payments provider with automatic, familiar invoicing and 1% of Sales to Stripe Climate.

Mobile access

Manage your sync operations from your phone if you are traveling.

Connect Shopify to Excel

Get started today with a 14-day free trial. No credit card required. Both human and AI support are available.

Get started Learn more