A lot of Shopify stores rely on supplier data for replenishment. Once a week, or even daily, a Google Sheet link or Excel file lands in your inbox, and you use it to update inventory levels and incoming arrivals — a familiar operational pattern.
But the moment you try to sync that sheet to Shopify, you almost always hit a wall. Column names are slightly off, units differ, blank cells contain a stray '-', a product name has a sudden line break — every supplier's sheet is packed with the company's own history and habits. This article is about how to live with that reality.
Common supplier-sheet problems
First, let's list the typical issues you encounter. You'll likely recognize them from your own store.
- Column names drift between languages or styles (e.g., 'Item #,' 'SKU,' 'Product Code' all mixed in)
- The inventory column contains dashes or spaces and can't be parsed as a number
- Product names have trailing spaces or embedded line breaks
- Pack-size units differ (each vs. case vs. loose)
- The sheet splits into weekly tabs like '2026-W10,' forcing you to chase the latest tab every time
- Rows suddenly appear labeled 'discontinued' or 'renewed'
Each issue seems minor, but it can turn fatal when you sync to Shopify. A single dash in the quantity column can halt the sync at that row. Asking the supplier to 'change your format to match our system' isn't always realistic given the relationship.
Column-name drift and unit mismatches
Of all the problems, column-name drift and unit mismatches are the ones you'll hit most often. Each supplier has their own reasons, so the only realistic option is for you to adapt.
Build a column-mapping table
We recommend keeping a simple mapping table on hand. List the correspondences: 'Supplier A's Item # is our SKU,' 'Supplier B's Stock Qty is our Inventory (units).' When a new supplier joins, you just add a row. Manage the mapping table itself in Google Sheets so it's easy to hand off to whoever comes next.
Document your unit-conversion rules
Unit mismatches are trickier. The supplier may track stock in '1 case = 24 bottles' while you sell single bottles — this kind of mismatch is routine. The fix is to hard-code the conversion rule as a formula in the sheet: 'supplier sheet stock × 24 = our stock.' Doing the math in your head is a recipe for incidents. With the rule written in the sheet, anyone gets the same answer.
The idea of inserting an intermediate sheet
Reading this far, you may feel that connecting a supplier sheet directly to Shopify is unworkable. You're right. The practical solution is to insert another sheet between the supplier sheet and Shopify. We call it an intermediate sheet, or a normalization sheet.
The role of the intermediate sheet is simple. Pull data from the supplier sheet via IMPORTRANGE, then clean up column names, convert units, and strip junk data — producing 'clean data fit to send to Shopify.' The sync app only needs to look at the intermediate sheet, so you're no longer at the mercy of changes on the supplier's side.
Another benefit of the intermediate sheet is that it creates a buffer where a human can review data before it reaches Shopify. Before syncing, you can eyeball the sheet and catch obviously abnormal numbers (negative stock, or 100x the usual). With direct sync, by the time you notice, the store has already been overwritten.
Pushing back without damaging the relationship
Technical tricks like the intermediate sheet can absorb a lot. But the human side also needs to be handled. How you communicate errors or inconsistencies in supplier sheets directly affects the long-term health of the business.
A common misstep is to fire back, 'This column is blank again!' Yes, your work has stalled, but the supplier's contact is also busy and is helping you within their own constraints. Blaming them unilaterally creates friction. Instead, frame it calmly with row numbers and specifics: 'Could you double-check this week's file? Row XX has a blank stock quantity.'
A more fundamental fix is to agree upfront with each supplier on the minimum set of columns and on which fields must never be blank. Once that agreement exists, it becomes easy to point out 'this part doesn't follow our rule' later on. The first few exchanges might be tense, but six months later both sides feel less stress.
Getting along with supplier sheets is never perfect overnight. But inserting an intermediate sheet, maintaining a mapping table, and refining how you communicate — stack these three steadily and the operation gets measurably easier. Don't try to eliminate the quirks completely; design a system that gracefully absorbs them.