Installing a brand-new app on Shopify makes anyone a little nervous. "What if inventory suddenly gets overwritten and something breaks?" "I'm not sure which part of the sheet to fix" — those worries are completely natural. In this article, we'll walk through what to do on day one, from installing Sync Master to running your first successful sync, in order.
Up front: day one is very simple. Prepare the sheet, take a look with the connection test, run the actual sync, and check the logs — just four steps. As long as you go in order, you almost never end up with a serious accident on the first try.
What to do right after installing
When you install Sync Master, you're guided to an initial setup screen. The first thing to do here is connect a Google account. Think of it as granting access to the Google Sheet where your inventory data lives. If your team juggles multiple Google accounts, make sure you pick the one that will own this store's inventory going forward.
Next, check the inventory tracking state on the Shopify side. Unless the "Track quantity" switch is on for the products you want to sync, values pushed from a sheet simply won't be reflected. As we covered in the previous article, this is one of the easiest places to trip up. If you have a lot of products, exporting a CSV to check them in bulk is a reasonable approach.
Preparing your sheet template
Sync Master is designed around keeping your inventory master in a Google Sheet. The structure is simple: one row equals one inventory record — that is, "this SKU, at this location, in this quantity." Deciding up front which columns are required and which are auxiliary will make the rest of your operations much easier.
Required columns
At a minimum, three columns are enough for sync to work: SKU, location, and quantity. Make sure your team agrees on what each one represents.
- SKU: must match the SKU registered in Shopify exactly. Watch for case differences and stray leading/trailing spaces
- Location: must match the location name as registered in the Shopify admin
- Quantity: use whole integers. Blanks or text mixed in can cause sync errors
Recommended columns
These aren't required, but a few extra columns can really help operations. A product name column lets you glance at the sheet and immediately recognize "oh, that's that item" — it's a human-facing note column that doesn't need to be included in sync. Adding columns for last stock-count date, owner, safety stock, and upcoming replenishment lets you make operational decisions from the sheet alone.
The key is to clearly distinguish columns that write back to Shopify from columns meant for human reading. Sync Master's settings let you specify which columns are sync targets, so there's no risk of your human-only note columns accidentally getting written back.
Verifying with the connection test
Once your sheet is ready, it's time to run — but before you do, always run the connection test first. It's one of Sync Master's most important safety features: before any real sync, it previews "what would happen if I ran this right now."
On the connection test screen you can see, row by row, which Shopify product each sheet row maps to and how each location's inventory would change. Warnings like "no matching SKU found" or "location name doesn't match" all surface here. If the preview shows zero errors before you run for real, you can proceed with high confidence.
- Unmatched SKUs: most likely a typo in the sheet, or the product was deleted on the Shopify side
- Location mismatch: suspect half-width vs. full-width characters, or recent location name changes
- Unexpected quantity values: check whether the setting interprets blanks as 0
Running the real sync and reading the logs
Once the connection test comes back clean, it's time for the real run. When you click Sync Master's "Run" button, the values written in your sheet start flowing into Shopify's inventory levels. With many products, it can take anywhere from tens of seconds to a few minutes to finish. Even if you close the screen mid-way, processing continues in the background.
When the run finishes, the log screen displays how many rows succeeded, failed, and were skipped. For any failed rows, the SKU and reason are recorded, so you can fix the sheet and re-run. For successful rows, take a moment to spot-check Shopify's inventory screen to confirm the numbers landed the way you expected.
Once your day-one sync succeeds, the second time will feel much smoother. From then on, you're just repeating the same sheet, the same template, and the same flow — once you're used to it, the whole thing wraps up in a few clicks. After clearing that very first run, sheet sync simply becomes part of your daily routine.
Next time, we'll move on to a topic faced by stores with multiple locations: sheet design. We'll walk through what to keep in mind at the design stage so your operations don't fall apart the moment another location is added.