Running into issues when using the StoreRocket sync tool can happen. There could be many reasons why the sync tool doesn't work. As we use Google Sheets API for the interaction between StoreRocket and your spreadsheet, everything should be in order or Google Sheets API won't understand what our tool wants.
Here you will find a list of the most common causes why the sync tool is not working as expected.
Incorrect Column Names
You cannot change the default columns that were created by the sync tool. Please make sure the column names weren't changed and they are not unnamed.
Make sure you don't have multiple columns with the same name.
Unnamed Columns With Values
Make sure you don't have some values in the cells below a column that doesn't have a name.
Not Enough Rows
You need to have more rows than the total number of locations. For safety, keep 1000 empty rows after your last used row.
When pasting from another spreadsheet or Excel file, some cells might be merged. This will break the sync tool. Use Edit -> Paste Special -> Values Only when pasting to avoid merged columns. If you have merged columns, you need to unmerge them.
The Sheet Is Not The First
The sheet that was created by the sync tool must be the first one in the sheet order. You can give it the name that you want.
If you are still experiencing issues with the StoreRocket sync tool, it may be best to contact us so we can take a closer look.