Guide

Correct synced products with a spreadsheet

What to do when the products upload says it is locked: correct fields on a channel-owned catalogue without disconnecting anything.

You do not have to disconnect a channel

When a sales channel syncs your products, a spreadsheet can still correct them. Upload the file on Settings → Import Data under Products, the same way you always would. The card says Matches your synced catalogue and names the channel that owns it.

What changes is what the file is allowed to do:

  • It matches; it never creates. Rows are matched on SKU. A SKU that is not already in your catalogue is reported back to you instead of being created, because the channel owns which products exist. That refusal is the duplicate protection — it is why the upload used to be refused whole.
  • Each value is decided field by field. A corrected category does not overwrite a price. Every value goes through your field precedence rules: where the spreadsheet wins, it applies; where the channel wins, the value waits in Import conflicts for your decision.
  • Your correction sticks. A value you set from a file on a synced catalogue is treated as your own decision, so the next sync from the channel does not quietly undo it. If the channel sends something different afterwards, that arrives in Import conflicts for you to look at.

Check before you commit

The preview step reports, before anything is written: how many rows will apply, how many will be held for review, and how many are rejected with the reason. Read those three numbers. If the rejected count is higher than you expect, it is usually a SKU column matched to the wrong column, or SKUs that only exist in the spreadsheet.

Which imports still wait for you to disconnect

Stock levels and sales history do not work this way and still lock while a channel syncs them. There is no "field" to correct in a quantity or an order: a second source writing the same stock movement double-counts it, and a second source writing the same order duplicates it. Correct stock with a count (see Counting and adjusting inventory), not with a file.

Afterwards

See Review import history and resolve conflicts in bulk for the run's receipt and for settling everything the import held.

Try the plan on your own stock.

Start a trial with your own sales and stock, or look around the live demo first.