Migrating Product Data into Norce Commerce
Overview
This guide explains how to migrate product data into Norce Commerce. It covers different migration approaches based on catalog size, required preparations, step-by-step instructions, and best practices. The goal is to help you efficiently import your product catalog, regardless of its size or complexity.
Prerequisites
Before starting product migration, ensure you have:
- Set up product settings in Norce Commerce.
- Defined your product content model.
Preparations
Before migrating product data, complete the following preparations:
Assess Catalog Size:
Decide on a migration approach based on the number of products:- Small catalog: Use Excel-based migration.
- Medium catalog: Use a script-based solution.
- Large catalog: Contact Norce for guidance.
Prepare Product Data:
Export product data from your source system. Organize the data into the following categories:- Master data (core product information)
- Product content (descriptions, images, etc.)
- Prices
- Stock levels
Decide on Data Organization:
Plan how to structure and import each data type (master data, content, prices, stock).
Tip: Make key product setting decisions (such as category structure) before importing large data sets. Changes to product settings after import can impact performance.
How-to: Migrate Products
Choose the migration method that matches your catalog size.
Small Catalog Migration
For small catalogs, use Excel imports for each data type:
- Master data and standard price
- Product content
- Additional prices
- Stock levels
Medium and Large Catalog Migration
For larger catalogs, use staged imports:
- Import master data first.
- Verify that products are correctly imported.
- Import prices in a separate step.
- Import stock levels independently.
- Add product content in separate batches.
Best Practice: Always verify each import step before proceeding to the next.
Best Practices
- Verify master data imports before importing prices, stock, or content.
- Use separate imports for different product data types.
- Finalize product settings before importing large data sets.
- Use Norce's synchronization tools to move product catalogs between environments, rather than repeating manual migrations.
Importing Product Images
Product images are imported from public URLs.
See the separate documentation for details on image import requirements and formats.
Important Considerations
- Make all major product setting decisions (such as category trees) before importing large product assortments.
- Changes to product settings after import (especially category structures) can temporarily affect pricing module performance.