Glossary
/
catalog-import
E-commerce catalog import: CSV definition Shopify ERP migration, vs product feed export, dropshipping API and key product data points.
Updated on
June 4, 2026
The catalog import (import products) is the product data entry into a store from an external source: CSV file, ERP, PIM, dropshipping supplier, or another 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 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 apps, CJDropshipping (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 not present in the catalog; Update: modifying price, stock, title 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; the import feeds Shopify from the outside; Manual CSV import vs API connector: occasional vs continuous flow; Catalog import vs adding individual products: import processes hundreds or thousands of SKUs at once; Import vs inventory management: a stock import updates quantities; a full catalog import includes content, prices, and media.
Why catalog import is important in e-commerce
Manually entering 500 references is slow, error-prone, and incompatible with frequent price/stock updates.
Its effects can be seen at several levels: Time saving: store or season launch in a few hours; Data consistency: a master source (ERP, supplier) feeds Shopify; Multichannel: same catalog on web and marketplaces; Up-to-date stock: quantity sync, limits overselling; Migration: platform change without recreating everything; Dropshipping: massive import of third-party catalogs; SEO and ads: complete listings (titles, images) from the go-live.
An ill-prepared import can overwrite carefully crafted descriptions, create duplicates, or result in incorrect prices: hence the importance of a backup export before any 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 template or map supplier columns; next 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 Control: random product pages, inventory, 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 file (120 SKUs, prices 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, they check three product pages and the Shopify error report. Images remain hosted on the Shopify CDN (URLs already imported during the 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 into: 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 sync (AliExpress import guide).
Checklist before bulk import:
The workflow can be read as follows: first complete CSV export backup; then document matching rule (Handle vs SKU); then validate UTF-8 encoding and CSV separator; after that test
Points of attention before a bulk import
Points of vigilance include in particular: Single source of truth: ERP or Shopify, not two divergent 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 (overwrite); Inconsistent Handle or SKU duplicates; Prices with a comma instead of a decimal point; Broken HTML descriptions (unescaped quotes); Imported stock at zero across the entire catalog; Forgetting to publish products (draft status); Dropshipping import without reworking titles and images (poor SEO).
In brief
To remember: Catalog import = product data entry into the store (CSV, API, ERP, dropshipping); Creation, update, or scheduled sync by Handle/SKU; Distinct from catalog export and outgoing marketing feed; Shopify: Native CSV import, Matrixify apps, API, migration; Backup, batch test, unique SKUs, documented source of truth.
Associated terms, FAQ, and useful resources
Associated terms
Catalog export: inverse outbound flow.
Product catalog: repository populated by the import.
Product variant: one CSV line per variant.
Inventory management: quantities updated upon import.
ERP: frequent source of import.
FAQ
Catalog import and product feed: same thing?
No. The catalog import populates Shopify from the outside. The product feed generally exports Shopify to Google, Meta, or a marketplace.
How to bulk update prices on Shopify?
Export the CSV, modify the Variant Price column, re-import while keeping the same Handles. Or use an app / the API to sync with your ERP.
Does 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 cleared depending on the mapping: always test on a sample.
Can you import images via CSV?
Yes, via the Image Src column with public HTTPS URLs. Shopify downloads the images to its CDN. Multiple images = multiple lines 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
June 4, 2026
