E-commerce catalog CSV mapper

What is an Ecommerce Catalog Mapper?

Seamless WooCommerce to Shopify Catalog CSV Transformation

Migrating product catalogs from WooCommerce (WordPress) to Shopify is one of the most tedious tasks in e-commerce replatforming. WooCommerce export CSVs use custom column headers (such as post_title, regular_price, sale_price) that cause Shopify's import wizard to reject the file or corrupt variant pricing.

DevDeskApp maps, formats, and transforms WooCommerce export CSVs into official Shopify 24-column import CSVs in seconds, entirely client-side in your browser.

Automatic Field Transformations

  • URL Handle Generation: Automatically converts product titles into SEO-friendly lowercase slugs (e.g., Men's Cotton Oversized T-Shirt! becomes men-s-cotton-oversized-t-shirt).
  • Smart Pricing & Compare-at Logic: If a product has an active Sale price greater than zero, the Shopify Variant Price is set to the discounted sale price, while Variant Compare At Price is set to the higher regular price (creating the crossed-out discount badge).
  • Weight Conversion (Kg to Grams): WooCommerce stores product weights in kilograms, while Shopify catalog imports expect grams. Our engine automatically calculates Math.round(weight_kg * 1000).
  • Image Extraction: Extracts the hero primary image URL from comma-separated WooCommerce image galleries for immediate CDN import.
  • Inventory & Publishing Status: Maps WooCommerce In stock? === '1' to Shopify active status, or draft for out-of-stock items.

Practical Transformation Example

Sample transformation comparison:

WooCommerce Input:
Title: Premium Wireless Noise-Cancelling Headphones
Regular price: 4999 | Sale price: 2999 | Weight (kg): 0.25 | In stock?: 1

Shopify Output:
Handle: premium-wireless-noise-cancelling-headphones
Title: Premium Wireless Noise-Cancelling Headphones
Variant Price: 2999 | Variant Compare At Price: 4999
Variant Grams: 250 | Status: active

Related Tools & Migration Guides

Frequently Asked Questions: WooCommerce to Shopify CSV Catalog Migration

Why does Shopify reject standard WooCommerce CSV exports?

Shopify requires exact column header names (such as "Handle", "Title", "Variant Price", "Variant Grams"). WooCommerce exports use different database keys (such as "post_title", "regular_price", "Weight (kg)"), which Shopify fails to recognize without manual mapping.

How does the tool handle sale prices and discounts?

If a product has a valid Sale Price, that discounted value becomes Shopify's "Variant Price", and the original Regular Price is moved into "Variant Compare At Price". This automatically generates the strike-through discount price on your Shopify product page.

Are product image URLs preserved during the conversion?

Yes. The first image URL from your WooCommerce image gallery is mapped to Shopify's "Image Src" column, allowing Shopify to download and host the media files upon CSV import.

Is there a limit on how many products I can convert at once?

No. Using fast client-side PapaParse stream processing, catalogs containing 5,000 to 20,000 products convert in less than 3 seconds directly on your device.

Can I customize the column mappings for custom CSV formats?

Yes. The tool features an interactive column mapping interface where you can map any non-standard source column to Shopify's standard schema.

Does my catalog CSV get uploaded to your servers?

No. The entire conversion is executed locally in your browser using JavaScript. Your product catalog, pricing, and vendor details remain 100% private.

You May Also Need