Before you can import your spreadsheet, each location must have a unique shop code. Having a unique shop code for every location in your account ensures that changes are accurately applied to each location when you import a new spreadsheet.
Add shop codes
In the Business Profile, you can add or change store codes at any time. With the Business Profile Manager, you can bulk upload using a spreadsheet to new store codes for new locations. Learn how to bulk upload using spreadsheets.
To add or change missing store codes:
- Go to your Business Profile. Learn how to find your profile.
- Select the three-dot menu
Business Profile settings
- To add or change your store codes, next to 'Store code', select the pencil
.
- In the window that appears, enter the store code.
- Select Save.
Business Profile settings Bear in mind
- Any unique identifier can be a shop code. A shop code can be anything from the name of a place to a random number, as long as it stays the same to refer to that location.
- Include your brand name in your shop code to avoid confusion between spreadsheets (for separate business or personal accounts). For example, if Google had 100 locations, they might be named 'GOOG1', 'GOOG2', 'GOOG3', etc. Learn more about formatting shop codes.
In your bulk upload spreadsheet
To change a shop code, use the Business Profile Manager.
Adding shop codes with a bulk spreadsheet upload only works when you’re adding a new location. If you add or change a shop code to an existing location, it will create a duplicate location.
- Download your locations to a spreadsheet.
- Enter shop codes in the spreadsheet. Don't change the address of any locations.
- Upload the spreadsheet with the new shop codes.
If you maintain an offline spreadsheet, make sure that it also uses the new shop codes.
