> For the complete documentation index, see [llms.txt](https://magecomp.gitbook.io/shopify/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://magecomp.gitbook.io/shopify/apps/impex-collection-import-export/magento-import.md). # Magento Import The Magento Import feature allows merchants to import Magento 2 product export files directly into Shopify collections and products. ### How to Import Magento Products #### Step 1: Add Product Image Base URL Enter the Magento product image base URL in the **Product Images** field. Example: The app combines this URL with the relative image paths from the Magento export file to import product images correctly into Shopify. Example: * CSV Image Path: /b/a/bag.pn * Base URL: Final Imported Image URL:
#### Step 2: Upload Magento Export File Click **Add Magento CSV or XLSX** and upload your Magento 2 export file. Supported file formats: * CSV * XLSX Maximum file size: * 50 MB
#### Step 3: Start Import After uploading the file, click the **Start Import** button to begin importing products and collections into Shopify.
### Supported Import Features #### Import Simple & Configurable Products The app imports Magento simple and configurable products directly into Shopify. Example: * Magento configurable product: * T-Shirt * Sizes: S, M, L * Colors: Black, White Result: * Shopify product with variants is created automatically. #### Create or Update Products by SKU Products are matched using SKU to avoid duplicate product creation. Example: * Existing Shopify SKU: TSHIRT-BLACK-M Result: * Product is updated instead of creating a duplicate. #### Convert Magento Categories into Shopify Collections Magento category paths are converted into Shopify collections automatically. Example: Men/Tops/Hoodies Result: * Shopify collections: * Men * Tops * Hoodies #### Import Product Images Automatically Product images are imported using the Magento image paths and base image URL. Example: * Magento image path: /w/a/watch.jpg Result: * Product image is imported automatically into Shopify. #### Convert Special Price into Compare-at Price Magento special prices are mapped into Shopify compare-at prices. Example: * Original Price: $100 * Special Price: $80 Result: * Shopify displays: * Sale Price: $80 * Compare-at Price: $100 #### Skip Unsupported Product Types Automatically Grouped and bundled products are skipped automatically during import. Example: * Magento bundle product: * Camera + Lens Kit Result: * The product is skipped from import automatically. ### Expected CSV Columns The **Expected CSV Columns** section displays the Magento product export fields supported by the importer. These columns are used to map Magento product data correctly into Shopify products and collections. #### Supported Columns | Column | Description | Example | | ------------------------- | ---------------------------- | ------------------------------- | | `sku` | Unique product identifier | `TSHIRT-BLACK-M` | | `name` | Product title | `Premium Cotton T-Shirt` | | `url_key` | Product URL handle | `premium-cotton-tshirt` | | `description` | Product description | `Soft cotton oversized t-shirt` | | `price` | Product price | `49.99` | | `special_price` | Sale price | `39.99` | | `product_type` | Magento product type | `simple` / `configurable` | | `configurable_variations` | Product variant combinations | `size=M,color=Black` | | `categories` | Magento category path | `Men/T-Shirts/Oversized` | | `product_online` | Product status | `1` = Active | #### Additional Supported Fields The importer also supports additional Magento fields, such as: * configurable\_variation\_labels * meta\_title * meta\_description * barcode * inventory fields These fields help import SEO data, product identifiers, and stock information into Shopify more accurately. ### Related Tools ## Collection Import The Collection Import feature allows merchants to create new collections or update existing collections in Shopify using a CSV or Excel (.xlsx) file exported from the app. ### How It Works #### Step 1: Upload Import File Upload a supported CSV or Excel (.xlsx) file containing collection and product assignment data. Supported file formats: * CSV * XLSX Maximum file size: * 50 MB Large files are uploaded and processed automatically in smaller parts for better performance. #### Step 2: Run Import in Background Enable the **Run import in the background** option to continue working while the import is processed on the server. The import progress can be tracked: * Directly on the import page * From the Reports page #### Step 3: Import Collections Once the file is uploaded, the app creates or updates Shopify collections and assigns products based on the import data. ### Example Use Cases #### Create New Collections Example: Summer Collection, Winter Sale, New Arrivals Result: * New Shopify collections are created automatically. #### Assign Products to Collections Example: Product SKU: TSHIRT-BLACK, Collection: Men/T-Shirts Result: * The product is assigned to the specified Shopify collection automatically. #### Update Existing Collections Example: Collection: Shoes Result: * Existing collection details and product assignments are updated without creating duplicates.
## Reports The Reports section displays the history and status of all import jobs processed for the store. The app tracks: * Shopify imports * Magento imports * WooCommerce imports ### Job Status Overview #### Total Jobs Displays the total number of import jobs created for the store. #### Success Shows completed import jobs. #### Failed / Partial Displays imports that failed or were partially completed due to errors. #### In Progress Shows currently running import jobs. ### Import History All completed and running import jobs appear in the reports section, along with: * Job status * Import type * Processing timestamps This helps merchants monitor import activity and identify any processing issues easily.
## Export Collections The Export Collections feature allows merchants to export Shopify collections along with product and variant data into a CSV file for backup, migration, reporting, or catalog management purposes. ### How It Works #### Step 1: Select Collections Choose one or multiple collections from the collections list. Example: * Ties * Jeans Pants You can also use: * **Select all collections** to export all available collections at once. #### Step 2: Configure CSV Columns Choose which collection, product, and variant fields should be included in the export file. The app allows merchants to export: * Collection details * Product information * Variant data * Metafields * SEO data * Inventory information #### Step 3: Export CSV Click **Export CSV** to download the selected collection data. The exported file can be used for: * Backup purposes * Store migration * Catalog management * Bulk editing * Re-importing collections ## Collection Export Fields ### Collection Columns | Field | Description | Example | | --------------------- | ------------------------------- | ------------------------ | | Collection Type | Shopify collection type | Manual | | Title | Collection name | Summer Collection | | Handle | Collection URL handle | summer-collection | | Sort Order | Product sorting method | Best Selling | | Description (HTML) | Collection description | `

Summer products

` | | Rule Set (JSON) | Automated collection conditions | Product tag rules | | Collection Metafields | Custom collection data | SEO fields | ## Product Export Fields Enable **Include product columns** to export product data for each collection. ### Example Product Fields | Field | Example | | -------------- | ---------------------------- | | Product Title | Premium Denim Jeans | | Product Vendor | MageFashion | | Product Type | Jeans | | Product Tags | denim, blue, casual | | Product Price | 79.99 | | Product Status | Active | | Product SEO | SEO title & meta description | | Product Images | JSON image URLs | #### Example Use Case If a collection contains: Jeans Pants Result: * All products assigned to the collection are exported automatically. ## Variant Export Fields Enable **Include variant columns** to export product variant details. ### Supported Variant Fields | Field | Example | | ------------------ | ------------------ | | Variant SKU | JEANS-BLUE-M | | Variant Price | 79.99 | | Compare at Price | 99.99 | | Inventory Quantity | 50 | | Barcode | 123456789 | | Weight | 500g | | Variant Options | Size=M, Color=Blue | #### Example Use Case If a product has variants: * Size: S, M, L * Color: Blue, Black Result: * Each variant is exported in separate rows with inventory and pricing information. ## Plan Usage The Plan Usage section displays the remaining export limits available in the current subscription plan. Example: 1 collection exports left, 5 product exports left ## Export Tips * Select one or multiple collections before exporting. * Enable product rows to include product catalog data. * Enable variant columns to include SKU, pricing, and inventory information. * Metafield columns are exported automatically when metafield definitions exist in the Shopify store.