The short answer
Catalog migration is a data project before it is a storefront project. Clean product identifiers, variants, categories, images, and descriptions before importing them. A smaller test migration helps reveal problems while the current store remains available.
Create a field map
Identify which system owns each field: SKU, product name, price, inventory, attributes, and product URL. Do not assume two platforms use the same meaning for a similar column. Record required fields and transformation rules. A consistent product identifier gives the team a way to reconcile old and new records.
Separate cleanup from import
Remove accidental duplicates and resolve contradictory product information in an approved source file. Keep discontinued products and unpublished drafts distinct from active listings. Preserve a copy of the original export so changes can be traced. Editing values manually in several systems creates uncertainty about which version is authoritative.
Rehearse with variety
Test simple products, multiple variants, missing images, unusual characters, and items with special shipping rules. Compare totals and inspect individual records. A file importing successfully does not prove the catalog is correct. Staff should review descriptions and prices, while the implementation team checks mappings and image references.
Control the cutover
Decide when product edits pause, how late changes will be captured, and who authorizes release. Reconcile the final import with the approved source and verify important product URLs. Keep the rollback material accessible until the store is stable. The exact sequence depends on the selected platforms and the amount of live activity.
When to take the next step
Prepare the catalog before the visual store redesign reaches final approval. Product structure affects filters, variant selection, and navigation. If staff disagree about naming or categories, resolve those definitions in the source data. A design cannot consistently present a catalog whose underlying records have incompatible rules.
- MerchandiserApproves data
- DeveloperMaps fields
- StaffInspect test import
- OwnerApproves cutover
Adapt these responsibilities to your team and project scope.
Before you start
- Choose one authoritative catalog file.
- Test representative variants and image paths.
- Capture changes made after the first export.
Questions clients ask
Is a successful CSV import enough?
No. Validate prices, variants, images, categories, and customer-facing pages after import.
Should duplicate products be deleted automatically?
Only under agreed rules. Similar names can represent different products or variants, so uncertain matches need review.
A worked scenario
Consider a boutique moving a large legacy catalog. The useful outcome is to transfer products with consistent structure. This is a planning example, not a reported client result. The team needs a decision that can be checked against real work, rather than a feature list that looks complete during a presentation. The starting question is whether the proposed approach changes that particular task in a way the people doing it can recognize.
In this situation, duplicated variants appearing under slightly different product names is the failure to guard against. Ask the responsible person to demonstrate an ordinary case and one difficult case using current records or safe test data. Record what they expect to happen, what actually happens, and where they need another person to intervene. Those observations establish the scope for this example; they do not justify an assumed improvement percentage or a guaranteed business result.
Decision checkpoints
| Checkpoint | Practical action | Evidence to retain |
|---|---|---|
| Prepare | Clean identifiers, categories, variants, and image references. | The approved scope, relevant source records, and unresolved questions. |
| Verify | Import a representative sample and inspect rejected rows. | The test case, expected result, observed result, and correction needed. |
| Operate | Compare product and variant counts after the full migration. | The responsible owner, completion record, and next review trigger. |
Use these checkpoints to transfer products with consistent structure; they are a sequence of decisions, not a promise of a particular schedule. A completed document or screen is not enough if the underlying action still fails. Keep unresolved items visible and describe which ones prevent progression. The evidence can be a small test record, an approved mapping, or a reviewed example. It should be understandable to someone who was not present when the work happened.
Measure the useful result
A useful check for this topic is validated migrated variants divided by intended variants. The numerator is validated migrated variants; the denominator is intended variants. Define the sampling window, exclusions, and source of each count before interpreting the result. If only selected examples can be reviewed, describe them as a sample. Do not present a small reviewed group as a complete picture of the business, and do not assign a target simply because a round number looks persuasive.
The measure helps reveal whether the team can transfer products with consistent structure, but it does not explain every cause of success or failure. Inspect the underlying cases alongside the summary. If the count changes after import a representative sample and inspect rejected rows, check whether the operating result changed or the counting method changed. Retain enough context to explain the difference. When records are incomplete, state the limitation and use a direct task review instead of manufacturing a precise-looking estimate.
Step 1: Prepare the evidence
The first practical move is to clean identifiers, categories, variants, and image references. Start with the smallest set of examples that covers the important variation in this scenario. Include an ordinary case, a case with missing information, and a case that requires intervention. Describe the intended result before reviewing the current behavior. This keeps the preparation focused on the outcome: transfer products with consistent structure.
For a boutique moving a large legacy catalog, the person responsible for the source information should take part in preparation. Ask that person to confirm which information is authoritative and which points still need a decision. Record those uncertainties beside the scope instead of hiding them in a general assumption. Preparation is complete when another team member can follow the agreed example and explain what evidence would allow the work to continue.
Step 2: Test the difficult case
The next move is to import a representative sample and inspect rejected rows. Compare expected behavior with observed behavior in the same test, rather than comparing two descriptions written at different times. Pay particular attention to duplicated variants appearing under slightly different product names. A demonstration that works only for its author does not establish that the intended user can complete the task. Let the reviewer attempt the work with the instructions they would normally receive.
For this check, retain the input, the relevant condition, and the final disposition. A screenshot can illustrate the state, but the record also needs to explain what the team expected and why the result matters. If source identifiers cannot distinguish sellable combinations, hold the decision open and send it to someone with the authority to resolve it. Retest the changed case after correction; an agreement to fix something is different from evidence that the correction works.
Step 3: Assign operating ownership
The operating move is to compare product and variant counts after the full migration. A successful initial test should lead to a repeatable responsibility, not a permanent dependency on the person who built the solution. Name the person who reviews the result, the person who can change the rule, and the person who responds when the task fails. In this scenario, each responsibility contributes to the same outcome: transfer products with consistent structure.
Give the operator a short record of what healthy work looks like and what requires intervention. Include the warning case of duplicated variants appearing under slightly different product names, together with the relevant records and support route. The procedure should be usable during normal work, not only during a formal review meeting. Check that an authorized backup person can follow it before treating the approach as ready for broader use.

