Most sync problems come from the layout of the sheet. Go through this list, then click Sync FROM Sheets again on the Google Sheets Sync page.
Check your sheet
Your locations are on the first tab. Only the first tab syncs. You can rename it and add other tabs after it.
Row 1 holds the column names, and there's only one header row. Don't add titles above it.
No column was renamed or deleted. StoreRocket finds columns by name. A missing StoreRocket ID column stops the sync, and a missing Filters, Type or hours column clears that detail from every location.
No two columns have the same name, and no values sit under a column without a name.
No merged cells. When you paste from another file, use Edit > Paste special > Values only.
No formulas or IMPORTRANGE. The sync replaces formulas with plain values. Paste values instead.
You're editing the linked sheet, not a copy. A copy made with File > Make a copy, or a downloaded file, doesn't sync. Click Open Sheets on the Google Sheets Sync page to open the right one.
The page says Sync in progress for a long time
Most syncs finish within a minute, and almost all within 3 minutes. Refresh the page. If it still says Sync in progress after 30 minutes, message us on live chat.
Don't unlink the sheet to stop a sync. Unlinking disconnects your sheet, and a new sheet starts from your current StoreRocket locations, so changes you haven't synced stay behind in the old sheet.
The sync finished, but my locator didn't change
With daily auto-sync, changes made after 4:00 AM Eastern Time wait until the next morning. Click Sync FROM Sheets to apply them now.
A location with
0in Visible is hidden from your locator.If Lat and Lng are still empty after the sync, the address couldn't be found, and StoreRocket set Visible to
0. Fix the address or type the coordinates, set Visible back to1, then sync.Changing an address doesn't move the pin by itself. Clear Full Address, Lat and Lng in that row, then sync again.
My changes in the dashboard keep disappearing? Daily auto-sync replaces them with the sheet's values every morning. Make the change in the sheet instead.
More help
The complete guide to the Google Sheets Sync Tool explains every column, the delete option, daily auto-sync and every error message.
Still stuck? Message us on live chat and tell us what you changed in the sheet and what you expected to see.