Glossary

What is a catalog import? E-commerce definition

June 4, 2026

The catalog import (product import) is the input of product data into a store from an external source: CSV file, ERP, PIM, dropshipping supplier, or other platform. It creates or updates titles, prices, stocks, images, and variants in the product catalog. On Shopify, it is the reverse operation of the catalog export.

Summary

Definition of the catalog import

Importing a catalog means populating or updating a store's product repository without manual page-by-page entry.

Common import sources:

The concept is best understood by distinguishing several elements: CSV / Excel: supplier file or internal spreadsheet; ERP / PIM: Odoo, Akeneo, Sage (ERP integration); Migration: export from WooCommerce, PrestaShop, Magento to Shopify; Dropshipping: AliExpress, CJDropshipping apps (dropshipping); API: custom script via Shopify API; Marketplace: retrieving Amazon/Etsy listings (depending on the tool).

Import modes:

The concept is best understood by distinguishing several elements: Creation: new products missing from the catalog; Update: modifying prices, stock, titles on existing products (matching handle or SKU); Scheduled Sync: automatic daily or real-time import.

Useful distinctions:

The concept is best understood by distinguishing several elements: Catalog import vs catalog export: import = entry; export = exit; Catalog import vs product feed: the feed mainly feeds Google/Meta from Shopify; importing feeds Shopify from the outside; Manual CSV import vs API connector: occasional vs continuous flow; Catalog import vs single product addition: importing processes hundreds or thousands of SKUs at once; Import vs inventory management: a stock import updates quantities; a complete catalog import includes content, prices, and media.

Why catalog import is important in e-commerce

Manually entering 500 references is slow, prone to errors, and incompatible with frequent price/stock updates.

Its benefits can be seen at several levels: Time saving: shop or season launch in just a few hours; Data consistency: one master source (ERP, supplier) feeds Shopify; Multi-channel: same catalog on web and marketplaces; Up-to-date stock: sync quantities, limiting overselling; Migration: change platform without recreating everything; Dropshipping: massive import of third-party catalogs; SEO and ads: complete product sheets (titles, images) right from go-live.

A poorly prepared import can overwrite carefully crafted descriptions, create duplicates, or result in incorrect prices: hence the importance of backing up exports before a massive import.

Prepare and check a product import

Classic Shopify CSV import steps:

The workflow can be read as follows: first Export a backup of the current catalog (export); then Download the Shopify CSV model or map supplier columns; then Clean the data: unique SKUs, URL handles, decimal prices, valid image URLs; after that Test on 5 to 10 rows before full import; finally Import into Products > Import; then Check: random product pages, stock, collections, GMC feed.

Key Shopify CSV columns (one row per variant): Handle, Title, Body (HTML), Vendor, Type, Tags, Option1 Name/Value, Variant SKU, Variant Price, Variant Inventory Qty, Image Src.

In practice, food wholesaler provides a weekly Excel (120 SKUs, price and stock). The team maps the columns to the Shopify format, keeps the existing Handle for updating, imports on Monday morning. Variants missing from the file remain in draft. After import, verification of three product pages and the Shopify error report. Images remain hosted on the Shopify CDN (URLs already imported during initial setup).

Recurring imports: automate via app (Matrixify, Excelify) or ERP middleware rather than daily manual CSV.

Import catalog to Shopify

Shopify offers native CSV import in Products > Import (Shopify Help Center).

In Shopify, this translates in particular to: Product CSV Import: creation or update by Handle; CSV Template: downloadable from the Import screen; Images: public URLs in the Image Src column (Shopify retrieves them); Variants: multiple rows with the same Handle, options Option1/2/3; Collections: via column or post-import assignment; Apps: Matrixify, Excelify, Importify (bulk imports, scheduling); Admin API: ProductCreate, bulk operations for large volumes; Migration apps: Cart2Cart, LitExtension from other CMS.

Dropshipping case: dedicated apps import the supplier catalog with price/stock synchronization (AliExpress import guide).

Checklist before bulk import:

The workflow can be read as follows: first Backup complete CSV export; then Document matching rules (Handle vs SKU); next Validate UTF-8 encoding and CSV separator; after that Test import then visual storefront check; finally Verify sales channels published after import.

Points to note before a bulk import

Points of vigilance include in particular: Single source of truth: ERP or Shopify, not two diverging masters; Unique SKUs: mandatory for reliable sync; Export before import: rollback possible; Batch import: 500 lines tested before 5000; Stable handles: do not change existing product URLs without redirection; Clean images: accessible HTTPS URLs, no fragile hotlinking; Automate if importing more than once a week.

To watch out for:

Points of vigilance include in particular: Re-importing exported CSV without understanding the columns (overwriting); Inconsistent Handle or SKU duplicates; Prices with a comma instead of a decimal point; Broken HTML descriptions (un-escaped quotes); Stock imported at zero across the entire catalog; Forgetting to publish products (draft status); Dropshipping import without reworking titles and images (poor SEO).

In brief

Key takeaways: Catalog import = product data entry into the store (CSV, API, ERP, dropshipping); Creation, update, or scheduled sync via Handle/SKU; Distinct from catalog export and outgoing marketing feed; Shopify: Native CSV import, Matrixify apps, API, migration; Backup, batch testing, unique SKUs, documented source of truth.

Related terms, FAQ, and useful resources

Associated terms

FAQ

Catalog import and product feed: same thing?

No. Catalog import populates Shopify from the outside. A product feed typically exports from Shopify to Google, Meta, or a marketplace.

How to update prices in bulk on Shopify?

Export the CSV, modify the Variant Price column, then re-import while keeping the same Handles. Or use an app / the API to sync with an ERP.

Does the CSV import overwrite existing products?

If the Handle matches an existing product, Shopify updates the fields present in the file. Missing columns may retain their values or be emptied depending on the mapping: always test on a sample.

Can we import images via CSV?

Yes, via the Image Src column using public HTTPS URLs. Shopify downloads the images onto its CDN. Multiple images = multiple rows with the same Handle or additional Image Src columns depending on the format.

Going further

Sources: Shopify Help Center (Import and export), Shopify Help Center (CSV format).

Enzo

13 May 2026

Convert over 2,000 customers on average per month with Qstomy.

The world’s 1st Shopify AI dedicated to customer conversion

Empowering 200+ e-commerce merchants

Subscribe to the newsletter and get a personalized e-book!

No-code solution, no technical knowledge required. AI trained on your e-shop and non-intrusive.

*Unsubscribe at any time. We do not send spam.