/magento2-import-export-sample-files

Default Magento 2 CE import / export CSV files & sample files for Firebear Improved Import / Export extension

Primary LanguageXSLTGNU General Public License v3.0GPL-3.0

Magento2 import / export sample files

In this repository we have gathered all sample files for Magento 2 import and export procedures. Every file has been tested with the different Magento 2 versions and latest release of Improved Import and Export extension.

If you are new to the import process - start by reading FireBear Studio Magento 2 import guide.

The latest release of Magento 2 Improved Import and Export extension added support of B2B Add-On. The add-on allows to import and export all Magento 2 B2B entities: companies, shared catalogs, requisition lists and quotes and negotiable quotes. All B2B sample files can be found here with b2b prefix.

List of Magento 2 sample import files

/Improved Import : Export - Sample Files

B2B Add-on entities

  • b2b_companies.csv .xml .xlsx .ods - companies are a Magento 2 Commerce B2B entity. In this file you will find all company attribues and will be able to import companies with the B2B Add-On to Improved Import and Export extension.
  • b2b_shared_catalogs.csv .xml .xlsx .ods - shared catalogs are product catalogs available for companies and different customer groups. The catalog format is pretty simple. If you are importing NEW shared catalogs and the assigned customer group doesn't exist - it will be created automatically. Requires B2B Add-On to Improved Import and Export extension.
  • b2b_requisition_lists.csv .xml .xlsx .ods - requisition lists allow customers to order products on a recurring basis in the most convenient way. Requisition lists can only be managed by customers or via import. Requires B2B Add-On to Improved Import and Export extension.
  • b2b_quotes.csv .xml .xlsx - quotes are basically abandoned carts of the customers. In this sample file you will find minimum set of attributes required to import products to the customer's carts. Quotes are a part of the negotiable quote - a B2B entity - they share a single import entity with them. Requires B2B Add-On to Improved Import and Export extension.
  • b2b_negotiable_quotes.csv .xml .xlsx - negotiable quotes are company requests for a discounted price per cart. Negotiable quotes contain 'quote' entity - products in the cart - and require additional attribute to be loaded to make sure the negotiable quotes are properly displayed in the backend. Requires B2B Add-On to Improved Import and Export extension.

MSI Add-on entities

  • msi_stock_source.csv .xml. .xlsx .ods - a sample file with the stock sources (warehouses), allows creating/addin new warehouses to the Magento 2 store and updatig existing warehouses.
  • msi_source_qty.csv .xml .xlsx .ods - product quantity per stock source (warehouse), allows updating product quantity per warehouse. Products are referenced by SKU and warehouses by source_code attributes.

Improved Import and Export extension general Magento 2 entities

  • attributes.csv .xml .xlsx - a file with product attributes and attribute sets and groups. With its help you can create new attributes and attribute sets.
  • advanced_pricing.csv .xml .xlsx .json - a native Magento 2 file composition for importing tier prices. Comes with only product SKUs and tier price attributes: tier_price_website, tier_price_customer_group, tier_price_qty, tier_price, tier_price_value_type. These composition is enough to update advanced pricing for existing Magento 2 products.
  • cart_price_rules.csv .xml .ods .xlsx .json - a sample file for importing cart price rules to Magento 2 with Improved Import and Export extension. If the file you will find three price rules with different sample coupon codes, discountss and other attributes.
  • categories.csv .xml .xlsx .json - a sample file for importing Categories to Magento 2 with Improved Import and Export extension. There are three sample categories you can quickly identify. Each category comes with different settings to show you possible attribute values.
  • cms_blocks.csv .xml .xlsx .ods - a sample file with CMS static blocks that can be imported to Magento 2 with Improved Import and Export extension. Useful when migrating from an old store. Two sample CMS blocks help you understand how to import different settings and attributes and which values Magento 2 accepts.
  • cms_pages.csv .xml .xlsx .json - a sample file with CMS blocks that can be imported to Magento 2 with Improved Import and Export extension. Useful when migrating from an old store. Two sample CMS pages help you understand how to import different settings and attributes and which values Magento 2 accepts.
  • customer_addresses.csv .xml .json - a native Magento 2 file composition for importing customer addresses. First of three customer import files with the same sample customers for clarity. In this file you can find sample data on which address values can be accepted by Magento 2.
  • customers_and_addresses.csv .xml .xlsx .json - a native Magento 2 file composition for importing customers and addresses. Second customer file. Here you can get idea how to import both, customer data and addresses with different attribute values for every customer.
  • customers_main.csv .xml .xlsx .json - a native Magento 2 file composition for importing customers. Third customer file. It helps you get the idea of main customer attributes, how to fill them and what is the file composition accepted by Magento 2.
  • customer_finance.csv .xml .xlsx - a Magento 2 Cloud and Commerce file with store credit and reward point balance updates. The file is only viable for Magento 2 Cloud and Commerce versions.
  • fixed_product_tax.csv .xml .json - a native Magento 2 file for importing products. The main difference is the Magento 2 Fixed Product Tax attribute that allows you to add tax per product for different countries. In this file you can see which fixed product tax values can be imported.
  • orders.csv .xml - a sample file with order import to Magento 2. We constantly improve order import and export making it simple and available for manual edits. This version of the order import file features dedicated rows for products in the order.
  • products_all_types.csv .xml .xlsx .json - a sample file which lists ALL product types for Magento 2 import. In this file you can find products of every possible type: configuable, bundle, grouped, downloadable etc. You can learn which attributes are required to import every product type and what values are expected in these attributes.
  • products_and_advanced_pricing.csv .xml .json - a sample file which allows to import products along with tier prices using Improved Import and Export Magento 2 extension. Default Magento 2 import only allows to import tier prices and products in separate files. With this file you get a sample of new attribute tier_priceS only available for Improved Import. Use this file with entity 'Products' to import tier prices.
  • products_bundle.csv .xml .xlsx .json - a sample file with Magento 2 bundle product import. Here you can find bundle products and learn what attributes and values are required to import bundle products. The file can be imported with default Magento 2 import.
  • products_configurable_improved.csv .xml .xlsx .json - a sample file for importing Magento 2 configurable products in a new, straightforward, way. Only for Improved Import extension. In this file we use custom attribute column 'group' where we list parent product dependency for simple products. Using Improved Import extension you only need to specify this 'group' attribute, and the extension will assign simple products automatically.
  • products_configurable_native.csv .xml .xlsx .json - a native Magento 2 file for importing configurable products. In this file you can find default Magento 2 table composition for importing configurable products using attributes configurable_variations and additional_attributes.
  • products_grouped.csv .xml .xlsx .json - a sample file with Magento 2 grouped product import. Here you can find grouped products and learn what attributes and values are required to import grouped products. The file can be imporeted with default Magento 2 import.
  • products_downloadable.csv .xml .xlsx - a sample file with Magento 2 downloadable product import. Here you will learn how to compose and add downloadable links and define which files are sold with downloadable product.
  • tax_rates.csv - a sample file for importing Magento 2 taxes. Only available in CSV as default Magento 2 import process is used. In this file you will learn table composition for importing taxes applied to different stores and store views. To import taxes proceed to System > Import and Export Tax Rates in your Magento 2 admin panel.
  • update_price_stock.csv .xml .json - a sample file for updating Magento 2 product stock and price. Use with Improved Import. In this file we share an example of how you can quickly compose a file for updating stock and price. You only need to specify product SKU, Price and Qty attributes. This way if your supplier provides you with the updates, you can apply them quickly.
  • products_multiple_store_view.csv - a sample file for importing products per store views. Can be used with Improved Import and native Magento 2 import.
  • products_swatches_import.csv - allows importing color swatches for products. The swatches can be imported with color HEX code or using the URL to the swatch image.
  • search_synonyms.csv .xml .ods .xlsx - allows importing search synonyms for Magento 2. Make sure you are not using the same word for different synonym groups to avoid errors.
  • search_terms.csv .xml .ods .xlsx - allows importing search terms for Magento 2. The search terms defines any URL redirects for customer search queries.
  • product_position_in_category.csv - this file features 'products' entity with custom 'categories_position' attribute which allows to import product position inside of a category.
  • page_hierarchy.csv .xml .ods .xlsx - this file features 'page hierarchy' entity which will let you import your CMS pages menu linking.
  • url_rewrite.csv .xml .ods .xlsx - this file features 'url rewrites' entity which will let you import your Magento 2 URL rewrites, redirects, and other url linking.
  • review.csv .xml .ods .xlsx - this file features 'product reviews' entity which will let you import your Magento 2 product reviews, rating, and customer thoughs of your products.
  • gift_card.csv .xml .ods .xlsx - this file features 'products' entity, specifically gift card products, which will let you import your Magento 2 Commerce gift cards. Note, that you need to use 'Products' entity for import and export, as gift cards count as additional product type.

Up to date default Magento 2 Open Source (CE) & Commerce (EE, Cloud) import / export CSV files & sample files for Firebear Improved Import / Export extension (CSV, XML, Json)

  • If you are looking for the way to automate import and export procedures
  • If you want to import from XML, CSV, Json, XLSX, ODS files
  • If you need to map attributes and categories
  • If you require order, category, cart price rule, product attribute and sets import
  • If you require Rest or Soap API connection to your CRM, ERP and other systems

What is the extension

  • Improved Import and Export is a Magento 2 extension - meaning all the management process takes place in the administrator panel. You are not tied to the third party applications and don't have to run anything in the background.
  • The extension is open code - meaning that you can make necessary code adjustments and even improve existing functionality the way you like.
  • Customization endpoints - FireBear team have composed a dedicated customization module for Improved Import and Export extension you can use to enhance the extension's functionality.
  • Json file support - a single point of the Rest and Soap API integration with any software you are using for customer or sales management. Try integrating your CRM, ERP or POS systems to the extension.

Magento 2 Ultimate Import & Export guide

Magento 2 Google Sheets import

Improved Import and Export extension for Magento 2 allows importing CSV files directly from the Google Sheets. You can edit the file with your colleagues or supplier, paste it into the import job and schedule it to run automatically.

Read more about Magento 2 Google Sheet Import

We have also composed a Master Google Sheet table for Magento 2 where gathered all possible import entities. Every attribute comes with a description and samples. Feel free adding it to your Google Drive and using for your store.

Google Sheet Master Table for Magento 2 Import

Magento 2 Improved Import and Export Roadmap

  • Import and export events and job queue and restrictions - build flexible conditions for running import and export jobs after any Magento 2 update, queue jobs, automatically block jobs that depend on any system event or process. For example: order placed, new product or customer created, attribute modified.
  • Magento 2 product image processing settings and configuration - crop and scale, adjust size and files name, convert to different format, compression and performance optimization.
  • Email, WhatsApp, Telegram and other notification possibilities for jobs - send status and debug information about import and export processes.
  • Import diff system – a smart algorithm for comparing the current state of Magento 2 and data in the specified import source. Save time and resources by updating only relevant data.
  • Imports job filtering - flexible rules and conditions for updating and importing specific data from any source.
  • FireBear Composer repository - for extension installation and upgrade with Composer package manager.
  • Simplified and improved import of bundle and grouped products – import and create on the fly complex products by the fields of the child products.
  • Full support of Magento 2 Multiple Source Inventory extension and its workflow.
  • Full support and compatibility with Magento 2 B2B and Omnichannel.
  • Price and currency formatting.
  • Get raw SQL query of import & export job to run and adjust directly to Mageto 2 MySQL server.
  • Dry Run (Test import) - preview and test imported data without actual import. Useful for debugging and catching issues before import.
  • Full circle Magento 2 integration and synchronization of products and orders with top drop-shipping providers (Doba, Dropship Direct, Wholesale2b, Aliexpress, Taobao, Alibaba etc. more details at Ultimate List Of Drop Shipping Platforms And Integrations).

Partner with Firebear and fire up your business

Get special discounts, participate in adjusting the development roadmap and more. Firebear Studio is looking forward to partner with development agencies and anyone interested in cooperating with the most popular Magento blog on web.

Read more about Firebear partner program