Switch the primary source of an existing sync

Change which report supplies your sync’s rows, review the columns, and reload the sheet.

The primary source is the report that defines which rows your sync imports. Adding fields from another report only adds columns to those rows.

Before you switch

Changing the primary source clears the existing synced data and reloads the sheet with a new structure when you save. If your workbook already contains manual notes or custom column values, preserve them before continuing.

Preserve custom values before switching

The safest approach is to keep the original tab while preparing a replacement. Do not assume manual values will stay attached to the same products after the rows are reloaded.

  1. Save a backup of the current spreadsheet before making further changes.
  2. Create the replacement sync in a separate tab with the new primary source and the same account and marketplace. Choose Create new Sync at the warning in the steps below to keep the original report. Review the compatible columns you need.
  3. Allow the new tab to finish loading and check that the expected products appear.
  4. Transfer manual values by matching each row’s identifiers, not its position. For product reports with SKUs, match SKU plus account and marketplace. ASIN alone is not enough when one ASIN has several SKUs.
  5. Check unmatched or duplicate identifiers and a few known products. Paste the matched results as values if the custom fields should remain manually editable. Keep the original tab and backup until the transfer is verified.

Change the primary source

  1. Open the spreadsheet and select Hopted → Spreadsheet syncs. Find the sync for the intended tab and choose Menu → Edit to open its overview.
  2. Select Edit beside Your selected fields. In the field picker, find the This will be a … sheet label at the top of the source list.
Hopted field picker showing the current primary-source label and the two-arrow Change primary source button
Find the current primary source above the source list. The two-arrow button opens the source menu.
  1. Select the two-arrow button beside that label (Change primary source) and choose the new source. All Listings provides broader coverage than Active Listings; for virtual multipacks missing from that report, check Listing Details. See virtual multipacks and source coverage.
Primary-source menu with All Listings below Active Listings
Choose the source that includes the products you need in the selected accounts and marketplaces.
  1. Read the Caution warning. Choose Continue anyway to update this sync, or Create new Sync to keep the original report.
Caution dialog explaining the sheet reload, with Create new Sync and Continue anyway buttons
Continue anyway changes the existing sync. Create new Sync lets you keep the original report.
  1. Check the new primary-source label and configure any source parameters. Hopted removes incompatible fields, so review the remaining columns and add the fields you need.
  2. Review the import filters and schedule, then continue to the sync overview. Check the complete configuration and select Confirm changes.

Check the updated report

  1. Open the destination tab and allow the reload to finish.
  2. Check a few known SKUs or ASINs against the selected accounts, marketplaces and filters.

If products are still missing, see Why am I not seeing my full product catalog?.