Free · No sign-up · Exact 96-Column Shopify CSV
Shopify Product Extractor — Extract Product Data for Shopify CSV
Extract product details from compatible online storefronts and generate clean, Shopify-ready CSV files without manual copy-pasting. Paste single product links, a category collection, or an entire store homepage to capture titles, HTML descriptions, prices, compare-at sale discounts, SKUs, variants, and image galleries.
Extract products
Works with Shopify, WooCommerce (WordPress), Salesforce Commerce Cloud stores (Khaadi, Sapphire), Kamalia-type custom feeds, and sites with standard Schema.org product data.
Tip: For an entire category, tick the collection box. For an entire store, tick whole-store mode and paste only the homepage — the engine queries public data endpoints first, then sitemaps and category pagination (up to 100 products).
Results
Editing Price here sets that price for all variants of the product. Remove a row with ✕ if you don't want it in the CSV.
| Image | Title | Vendor | Price | Source | Details |
|---|
- 96Shopify CSV columns, exactly matched
- 5+Platform families supported
- 100Products per collection or store
- FreeNo account, no watermark, no catch
How to use the extractor
A streamlined four-step workflow from public storefront to your Shopify admin — with zero spreadsheet formula headaches.
Input Store Links
Paste individual product links, check collection mode for a category URL, or check whole-store mode with a shop homepage. Configure optional pricing markup or custom tags.
Automated Extraction
Click Extract Products. The engine detects the source platform, traverses pagination, resolves variant matrices, and compiles hosted image URLs into an interactive review table.
Review & Edit
Inspect titles, vendors, prices, and photo counts. Edit prices or titles inline, remove unwanted rows with ✕, and click Download Shopify CSV to receive shopify-products.csv.
Import into Shopify
In Shopify Admin, go to Products → Import, select your CSV, and click Upload and continue. Because the file follows Shopify’s 96-column format, no mapping is needed.
Supported sources & compatibility matrix
The extractor detects source architecture dynamically from response headers, API endpoints, and page DOM structure. Where public data feeds exist, it queries structured endpoints directly; otherwise, it falls back to parsing Schema.org JSON-LD and HTML tag models.
Important distinction: This tool extracts publicly accessible storefront data (titles, descriptions, customer-facing prices, options, and photos). It does not access private backend databases, customer accounts, order histories, or password-protected supplier intranets.
Shopify Storefronts
Directly reads public Shopify storefront endpoints (/products.json and product detail pages). Extracts comprehensive product entities including variants, SKUs, option names, compare-at prices, and high-resolution image galleries.
variants + SKUs compare-at prices collections whole store
WooCommerce / WordPress
Queries the public WooCommerce Store API (/wp-json/wc/store/v1/) or parses frontend Schema.org JSON-LD. Transfers variable products across multi-row handles, preserving attributes (sizes, colors), regular prices, and sale prices.
Store API categories attribute variants sale pricing
Salesforce Commerce Cloud (SFCC)
Extracts public Demandware storefronts (such as Khaadi and Sapphire). Follows collection pagination (sz= and start=), opens each product detail page, and resolves variation dropdowns via dwvar_ attributes.
Khaadi & Sapphire dwvar_ attributes auto pagination
Custom Data Feeds (Laravel / Vue)
For custom storefronts (such as Kamalia Khaddar) that load inventory via client-side feeds, the engine reads backend catalog feeds discovered in page scripts and sitemaps, extracting original "was" prices and SKUs.
data feed parser Kamalia sitemap categories
Universal Schema.org & JSON-LD
Any website publishing standard Schema.org Product JSON-LD, Microdata, or OpenGraph tags can be extracted—including strikethrough sale prices, image carousels, and manufacturer metadata.
JSON-LD OpenGraph Microdata universal fallback
Native 96-Column Shopify CSV
Outputs strictly in Shopify's native export format. Matches all 96 columns, handle grouping logic, variant row expansions, extra image rows, inventory defaults, and target market inclusions without column remapping.
exact 96 columns zero mapping required Shopify-ready
Platform-specific migration use cases
1. WordPress and WooCommerce to Shopify
Migrating from WordPress depends on your store setup. Standard WordPress posts and pages do not contain e-commerce data structures (such as SKUs, inventory counts, or variant options). However, WordPress sites running WooCommerce store complete product structures. The extractor queries the public WooCommerce Store API or frontend JSON-LD markup to compile a clean 96-column Shopify CSV. Variable products (e.g. a shirt in 3 sizes × 2 colors) are grouped under a shared handle across multiple variant rows, ensuring variants arrive as selectable dropdowns rather than separate products. For detailed guidance on taxonomy differences and 301 redirect mapping, read our dedicated WooCommerce to Shopify Catalogue Migration Guide.
2. Salesforce Commerce Cloud (SFCC) to Shopify
Salesforce Commerce Cloud (formerly Demandware) powers high-volume global retailers. In enterprise IT environments, catalogue migrations traditionally require exporting massive XML feeds (catalog.xml and pricebook.xml) from Business Manager and building custom transform scripts. For merchandising teams, marketing agencies, or regional distributors who lack Business Manager access, this extractor provides a direct alternative: it crawls public SFCC storefronts (such as Khaadi or Sapphire), traverses collection pagination parameters, resolves variation matrices (sizes and colors via Demandware dwvar_ parameters), and generates an import-ready Shopify CSV in minutes.
3. Shopify-to-Shopify Store Duplication & Expansion
Merchants expanding into new regional markets (e.g. launching a UK or Canadian expansion store) frequently need to duplicate existing Shopify catalogues. While Shopify permits native CSV exports, third-party supplier storefronts or stores where admin access has lapsed can be extracted directly using our whole-store or collection modes, capturing complete variant trees, compare-at pricing, and hosted image links without manual spreadsheet assembly.
4. Custom & Headless E-Commerce Storefronts
Custom-built storefronts on Laravel, Next.js, Nuxt, or Gatsby often store product data in proprietary formats. If the site publishes standard Schema.org structured data (JSON-LD) or exposes public data feeds (as demonstrated by our Kamalia Khaddar integration), the extractor captures titles, descriptions, prices, and photo galleries, normalizing them into Shopify’s standard schema.
Product information & 96-column CSV output
Shopify’s native import engine expects a specific multi-row spreadsheet structure. A single product with multiple variants or photos occupies several rows in the file, linked together by a unique Handle. Our extractor constructs this structure automatically:
| Shopify CSV Column Group | Specific Columns Populated | How It Maps to Your Storefront |
|---|---|---|
| Product Identity | Handle, Title, Body (HTML), Vendor, Type, Tags, Published | Defines the product title, rich HTML description, manufacturer brand, product classification, and publishing status. Row 1 holds main text; following rows leave Title blank to avoid duplicates. |
| Variant & Pricing | Option1-3 Name & Value, Variant SKU, Variant Price, Variant Compare At Price | Translates sizes, colors, and materials into selectable dropdowns. Preserves regular selling prices and calculates strikethrough compare-at discounts. |
| Inventory & Shipping | Variant Inventory Tracker, Variant Inventory Qty, Variant Inventory Policy, Variant Grams | Populated with configurable defaults (e.g. inventory tracker set to shopify, default quantity 100, weight 1000g) so products are immediately purchasable. |
| Photography & Media | Image Src, Image Position, Image Alt Text | Every product image is added as a dedicated row in display order. Shopify downloads and hosts these photos directly from the source URLs during import. |
| International Markets | Included / Pakistan, Included / United States, Included / UK, etc. | Sets market inclusion flags to TRUE so products appear across all active international storefront markets. |
To understand the mechanics of handle grouping, variant options, and secondary image rows, read our in-depth breakdown: Shopify’s CSV Format, Explained in Plain English.
Importing your CSV into Shopify, step by step
Once you have downloaded shopify-products.csv, follow this tested import routine to avoid inventory errors:
- Sanity-check your CSV: Open the file in Google Sheets or Excel. Confirm that handles in Column A group variants together, prices contain plain numbers without currency symbols, and image links open in a browser.
- The 2-Product Pilot Test: In your Shopify Admin, navigate to Products. Click Import (top right), then Add file. Select a small test file containing just the first two products. Leave "Overwrite any current products that have the same handle" unchecked.
- Review the Import Preview: Shopify displays a preview showing how it mapped option dropdowns, variant counts, and images. Because our file uses Shopify’s exact 96 columns, no column mapping is necessary. Click Import products.
- Inspect Live Theme Preview: Open both test products in your Shopify admin. Confirm titles, formatted descriptions, photos in order, variant pricing, and inventory quantities.
- Import the Full Catalogue: For large imports, set Status to draft in the extractor tool. Upload the full file. Once imported, you can organize products into collections and publish them in bulk.
For an end-to-end walkthrough of operational planning and execution, see our guide: How to Move Products Into Shopify From Another Store, Step by Step.
Common problems and technical troubleshooting
| Observed Issue | Technical Cause | Recommended Solution |
|---|---|---|
| HTTP 403 Forbidden | The source website blocks automated user agents using a WAF (Cloudflare Turnstile, Akamai, or AWS WAF). | Automated scraping is blocked by the target server. Enter those products manually or use an authorized native database export. |
| HTTP 429 Too Many Requests | Rate-limiting triggered by too many requests in a short interval. | Wait 2–5 minutes. Re-run extraction using smaller batches of 10–25 URLs. |
| No Price Found | The source store renders prices strictly via client-side JavaScript or hides them behind a wholesale customer login. | Type the price into the results table before downloading, or edit prices in bulk inside Shopify after import. |
| Images Missing After Import | The source store employs hotlinking protection or deleted the image files before Shopify completed its background download. | Ensure source images are publicly accessible without authentication. If blocked, upload images manually to Shopify Files. |
| Currency Discrepancies | Prices are extracted in the source storefront’s currency. The tool does not perform automatic currency conversion. | Use the Price markup % setting to adjust for exchange rates, or edit prices in the results table before export. |
| Repeating / Look-Alike Titles | Stores selling fabric, apparel, or jewelry often title each variant page identically (e.g. repeating "Winter Khaddi"). | Edit titles in the interactive table before downloading to give each product a distinct, descriptive title with color or style details. |
Legal and ethical use: Only extract products you have the right to sell
This extractor is engineered for legitimate commercial operations: migrating your own e-commerce store, importing authorized supplier catalogues, or rebuilding existing product listings on Shopify. Product descriptions, photographic assets, and brand trademarks belong to their original copyright holders. Always obtain clear permission before reproducing product content, respect source website terms of service, and write original product descriptions to maximize your organic search visibility.
Shopify Product Extractor Guides
Explore our dedicated step-by-step guides for moving your product catalogue from WordPress, WooCommerce, and Salesforce Commerce Cloud into Shopify:
How to Export Products from WordPress to Shopify, Step by Step
Learn how to export products from WordPress to Shopify, from WooCommerce products and images to a clean Shopify-ready CSV you can import.
How to Export Products from Salesforce to Shopify, Step by Step
How to export products from Salesforce to Shopify: what moves cleanly from Commerce Cloud, what needs cleanup, and how to test your import.
WooCommerce to Shopify Migration Free: How to Move Your Catalogue Without Paying for an App
A free WooCommerce to Shopify migration is possible for your catalogue. See what is free, what is not, and how to move products without an app.
Shopify Product Extractor Guide: Step by Step
A complete operational walkthrough of every tool setting, single-product mode, collection crawling, whole-store discovery, and Shopify admin import flows.
Shopify’s CSV Format, Explained in Plain English
Understand how handles group variants, why products take multiple rows, what the 96 columns do, and how to avoid import-breaking spreadsheet mistakes.
How to Move Products Into Shopify From Another Store, Step by Step
The structured 6-step roadmap: planning, extracting, spreadsheet auditing, running 2-product pilot tests, and executing error-free full imports.
How to Export Products to Shopify from WordPress, WooCommerce and Other Platforms
A comprehensive architectural guide covering native exports, storefront extraction, WooCommerce variable product mapping, Salesforce Commerce Cloud integrations, and CSV validation.
WooCommerce to Shopify: Migrating a Catalogue Without Retyping It
Learn what transfers cleanly from WooCommerce, how variable products map onto Shopify handles, and how to handle categories and 301 redirects.
Frequently asked questions
What is the Shopify Product Extractor and what does it do?
The Shopify Product Extractor is a free web tool that extracts publicly accessible product data from compatible online storefronts—including Shopify, WooCommerce (WordPress), Salesforce Commerce Cloud (Demandware), and custom e-commerce stores—and formats it into an exact 96-column CSV file matching Shopify’s native product import specification.
Can I export products from WordPress and WooCommerce to Shopify?
Yes. For WooCommerce stores, the tool queries the public WooCommerce Store API (/wp-json/wc/store/v1/products) or parses frontend Schema.org JSON-LD to extract titles, descriptions, prices, sale prices, variants (sizes/colors), SKUs, and image URLs into a pre-formatted Shopify CSV without requiring WordPress admin credentials. Note that standard WordPress sites without WooCommerce lack dedicated product entities.
Can I export products from Salesforce Commerce Cloud (Demandware) to Shopify?
Yes. The tool features a dedicated Salesforce Commerce Cloud (SFCC) engine that parses public storefronts (such as Khaadi or Sapphire), traverses collection pagination, extracts variation dropdowns (via dwvar_ attributes), and compiles full image galleries into Shopify-compatible CSV format. It operates on public storefront pages and does not connect to backend Business Manager XML feeds.
What exact information is included in the generated Shopify CSV?
The generated CSV matches Shopify’s exact 96-column export format: Handle, Title, Body (HTML), Vendor, Type, Tags, Published, Option1-3 Name & Value, Variant SKU, Variant Grams, Variant Inventory Tracker, Variant Inventory Qty, Variant Inventory Policy, Variant Price, Variant Compare At Price, Image Src, Image Position, Image Alt Text, and multi-market inclusion columns.
Do you store or track the products I extract?
No. The URLs you submit are fetched on demand to construct your CSV directly within your browser session. We store no product databases, keep no copies of your catalogues, and require no account registration.
How do I import the extracted CSV into Shopify?
In your Shopify Admin, navigate to Products → Import. Upload the shopify-products.csv file downloaded from this tool. Because the file follows Shopify’s native column structure, there is no manual column mapping required. We recommend testing with 1–2 products first and importing large catalogues in Draft status.
Why did an extraction fail with HTTP 403 or HTTP 429?
An HTTP 403 error means the source website employs an aggressive bot firewall (such as Cloudflare Turnstile or Akamai) that blocks automated scrapers. An HTTP 429 error indicates rate-limiting from too many rapid requests; pause for a few minutes and re-run with fewer URLs.
Will product variants, options, and compare-at sale prices transfer accurately?
Yes. Variable products are formatted across multiple rows linked by a shared Handle. Strikethrough sale prices are mapped to the Variant Compare At Price column, ensuring discounts display correctly in your Shopify theme.
Have more questions about migration mechanics or grade calculators? Consult our general FAQ page or read our step-by-step extractor guide.