[{"_1":2,"_34":-5,"_35":-5},"loaderData",{"_3":4},"routes/tutorials",{"_5":6},"tutorials",[7],{"_8":9,"_10":11,"_12":13,"_14":15,"_16":17,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":31,"_32":33},"slug","ecommix-faq","title","Frequently Asked Questions","excerpt","Answers to the most common questions about setting up eCommix, exporting Shopify data to Google Sheets, and importing changes back.","metaDescription","Frequently asked questions about eCommix - Google Sheets Sync. Find answers on setup, exports, real-time sync, imports, errors, and more.","category","tutorial","htmlContent","

Frequently Asked Questions

\n\n

Everything you need to know about setting up eCommix, exporting Shopify data to Google Sheets, and importing changes back safely.

\n\n

Setup

\n\n

Why do I see \"User did not grant permissions to Google App\"?

This means you did not select all required checkboxes when linking your Google Account. During the authorization flow, make sure every permission checkbox is checked. If the error persists, disconnect and reconnect your Google Account from the eCommix settings screen and go through the consent screen again.

\n\n

Exports

\n\n

I can't find a field, or it's not formatted as I want

First, check the Custom Attributes and Metafields sections inside the export builder — many values from third-party apps or Shopify's extended data model live there.

If the field you need isn't available anywhere, reach out to us at contact@ecommix.io. We prioritise feature requests from real users and, if the addition is feasible, we usually ship it within a day or two.

\n\n

Will any content I add next to the exported records be removed?

No. Only the rows that contain exported data are cleared and rewritten on each refresh. Any content you place outside that range stays intact.

If you want to reference the exported data from another sheet or file without risking overwrites, use IMPORTRANGE:

=IMPORTRANGE(\"https://docs.google.com/spreadsheets/d/your-spreadsheet-id\", \"Data!A:Z\")

Replace the URL with the one from your eCommix spreadsheet. The reference updates automatically every time the Data sheet refreshes. When pulling data into a different file for the first time, Google Sheets will show a pop-up asking you to allow access — click Allow access to connect the two files.

\n\n

Can I export custom options from third-party apps like Infinite Options, Globo, and similar?

Yes. Custom options created by third-party apps are stored as order properties and are available in your Order datasets. Look for the Custom Attributes (Line Item) and Custom Attributes (Order) columns — each custom property will appear there as its own entry.

\n\n

Is the data exported in real time?

Some datasets support real-time export. See Export Shopify Orders to Google Sheets in Real Time for the full list and setup instructions.

For datasets that don't support real-time export, you can still keep your spreadsheet fresh by scheduling automatic refreshes hourly, daily, or weekly.

\n\n

Can I change column headers?

Headers can't be customised directly inside an export, but you can work around this easily. Reference the exported data in a separate sheet using ARRAYFORMULA or IMPORTRANGE, add your preferred headers in row 1 of that sheet, and pull the data in from row 2 onward. The data stays synced and the column labels are entirely yours.

\n\n

I'm only able to see orders from the last 30 days

The Free Plan limits order history to the last 30 days. To pull orders from any point in the past, upgrade to a paid plan. See the pricing page for plan details.

\n\n

Errors with Exports

\n\n

My export fails or returns an error

On the Free Plan, exports may not complete if the combination of filters and data volume exceeds the plan's limits. Upgrading to a paid plan gives you higher row limits and more reliable exports.

On a Paid Plan, if your spreadsheet contains many complex formulas, Google Sheets may throttle the export and return Error 503 – Service Unavailable. The cleanest fix is to export the data into a dedicated spreadsheet with no heavy formulas, then reference it in your working file using IMPORTRANGE:

=IMPORTRANGE(\"https://docs.google.com/spreadsheets/d/your-spreadsheet-id\", \"Data!A:Z\")

References update automatically each time the source sheet refreshes.

\n\n

How do I export refunded items?

Order Line Items expose two quantity fields:

Quantity (Line Item) — all units originally ordered, including any that were later refunded or removed.
Current Quantity (Line Item) — units that remain after refunds and removals.

To calculate refunded units, add a helper column with this formula:

= Quantity (Line Item) – Current Quantity (Line Item)

Place the helper column outside the exported range so eCommix doesn't overwrite it on refresh — see \"Will any content I add next to the exported records be removed?\" above for guidance.

\n\n

Exports in Real Time

\n\n

Is it possible to show only the latest order status in real time, instead of displaying each update as a new row?

Yes, you can do this entirely with Google Sheets formulas in two steps:

Add a column at the end of the Data sheet — call it Latest? — that returns TRUE only for the most recent event row of each order ID.
Create a separate sheet (e.g. Report) that uses FILTER or QUERY to show only rows where Latest? is TRUE.

The report will then display each order exactly once, always reflecting its current status.

\n\n

Imports

\n\n

I can't find a field, or it's not formatted as I want

If a field you need isn't available in the import builder, write to us at contact@ecommix.io. We actively add fields based on user feedback and ship feasible requests quickly.

\n\n

Seeing #ERROR! in your formulas?

eCommix sheets are created with the United States locale because several internal formulas require it. If you write your own formulas, use US-locale syntax:

United States: =SUM(A1,A2,A3) — arguments separated by commas
Spain / other locales: =SUM(A1;A2;A3) — arguments separated by semicolons

Only the United States locale is supported at this time.

\n\n

My import is failing

Keep these rules in mind to avoid import errors:

Only columns to the right of the column separator are editable — do not modify columns on the left.
If individual rows fail, the reason will appear in the STATUS_MESSAGE column so you can identify and fix incorrect values.

\n\n\n

Use eCommix - Google Sheets Sync to sync your Shopify store with Google Sheets — exports, real-time updates, and two-way imports in one app.

Learn more on ecommix.io

Install eCommix - Google Sheets Sync on Shopify

\n","publishedAt","2025-07-03","readingTimeMinutes",5,"faqItems",[],"urlPath","/tutorials/ecommix-faq","url","https://ecommix.io/tutorials/ecommix-faq","ogImagePath","/og/ecommix-faq.png","ogImageUrl","https://ecommix.io/og/ecommix-faq.png","actionData","errors"]

Shopify Tutorials

Frequently Asked Questions

Ready to manage your Shopify store with Google Sheets?