Prepare the source
- Define a source-to-target field mapping.
- Normalize encoding, dates, decimal values, currency codes, and identifiers.
- Deduplicate natural keys such as SKU or external reference.
- Validate category, language, tax, and inventory references.
- Separate create, update, and deactivate operations.
Run safely
- Back up the target database.
- Test a small sample in staging.
- Validate row counts and rejected records.
- Run production imports in batches sized for available database capacity.
- Make reruns idempotent using stable external keys.
- Reconcile imported records and totals.
