What Is The Extension Of Default Magento Template Files?

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 lot are new to the import procedure - starting time by reading FireBear Studio Magento two import guide.

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

List of Magento 2 sample import files

/Improved Import : Consign - Sample Files

B2B Improver entities

b2b_companies.csv .xml .xlsx .ods - companies are a Magento 2 Commerce B2B entity. In this file you will discover all company attribues and volition be able to import companies with the B2B Improver to Improved Import and Consign extension.
b2b_shared_catalogs.csv .xml .xlsx .ods - shared catalogs are product catalogs available for companies and dissimilar customer groups. The catalog format is pretty elementary. If you are importing NEW shared catalogs and the assigned client group doesn't exist - it will be created automatically. Requires B2B Add-on to Improved Import and Consign extension.
b2b_requisition_lists.csv .xml .xlsx .ods - requisition lists permit customers to order products on a recurring basis in the most user-friendly mode. Requisition lists tin can only be managed past 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 volition notice minimum set of attributes required to import products to the client'southward carts. Quotes are a office of the negotiable quote - a B2B entity - they share a single import entity with them. Requires B2B Addition to Improved Import and Consign 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 ii 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 full general Magento 2 entities

attributes.csv .xml .xlsx - a file with production attributes and aspect sets and groups. With its help y'all can create new attributes and aspect sets.
advanced_pricing.csv .xml .xlsx .json - a native Magento ii file limerick 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 avant-garde pricing for existing Magento 2 products.
cart_price_rules.csv .xml .ods .xlsx .json - a sample file for importing cart toll rules to Magento two with Improved Import and Export extension. If the file y'all volition discover 3 toll rules with different sample coupon codes, discountss and other attributes.
categories.csv .xml .xlsx .json - a sample file for importing Categories to Magento ii with Improved Import and Export extension. There are three sample categories you can quickly identify. Each category comes with different settings to show y'all possible aspect 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 Consign extension. Useful when migrating from an former store. Two sample CMS blocks help you understand how to import different settings and attributes and which values Magento ii accepts.
cms_pages.csv .xml .xlsx .json - a sample file with CMS blocks that can be imported to Magento 2 with Improved Import and Consign extension. Useful when migrating from an old store. Two sample CMS pages help yous understand how to import unlike settings and attributes and which values Magento 2 accepts.
customer_addresses.csv .xml .json - a native Magento two file composition for importing customer addresses. Starting time of three customer import files with the same sample customers for clarity. In this file you tin 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. 2d customer file. Here you can become idea how to import both, customer data and addresses with different attribute values for every client.
customers_main.csv .xml .xlsx .json - a native Magento 2 file composition for importing customers. Third customer file. It helps you lot go the thought 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 advantage betoken rest updates. The file is but viable for Magento 2 Cloud and Commerce versions.
fixed_product_tax.csv .xml .json - a native Magento 2 file for importing products. The main departure is the Magento 2 Fixed Product Tax attribute that allows you to add revenue enhancement per product for different countries. In this file you lot can see which fixed product tax values tin be imported.
orders.csv .xml - a sample file with guild import to Magento 2. We constantly meliorate guild import and export making information technology simple and available for manual edits. This version of the order import file features defended rows for products in the gild.
products_all_types.csv .xml .xlsx .json - a sample file which lists ALL product types for Magento 2 import. In this file you lot tin can find products of every possible type: configuable, package, grouped, downloadable etc. You tin can acquire 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 dissever files. With this file you lot go 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 lot can find bundle products and learn what attributes and values are required to import bundle products. The file tin can be imported with default Magento two import.
products_configurable_improved.csv .xml .xlsx .json - a sample file for importing Magento 2 configurable products in a new, straightforward, fashion. Only for Improved Import extension. In this file we use custom aspect column 'group' where we listing parent production dependency for uncomplicated products. Using Improved Import extension you only need to specify this 'group' attribute, and the extension volition 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 detect default Magento 2 table limerick for importing configurable products using attributes configurable_variations and additional_attributes.
products_grouped.csv .xml .xlsx .json - a sample file with Magento 2 grouped production import. Hither you tin can observe grouped products and learn what attributes and values are required to import grouped products. The file can exist imporeted with default Magento 2 import.
products_downloadable.csv .xml .xlsx - a sample file with Magento 2 downloadable product import. Hither you will larn 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 ii taxes. But bachelor in CSV equally default Magento 2 import process is used. In this file you will learn table limerick for importing taxes applied to different stores and store views. To import taxes keep 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 production stock and price. Use with Improved Import. In this file we share an instance of how you tin speedily compose a file for updating stock and price. You only need to specify product SKU, Price and Qty attributes. This style if your supplier provides you with the updates, yous tin can apply them chop-chop.
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 two. Make sure you lot are not using the aforementioned 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 whatsoever URL redirects for client search queries.
product_position_in_category.csv - this file features 'products' entity with custom 'categories_position' attribute which allows to import product position within of a category.
page_hierarchy.csv .xml .ods .xlsx - this file features 'page hierarchy' entity which will permit you import your CMS pages card linking.
url_rewrite.csv .xml .ods .xlsx - this file features 'url rewrites' entity which will permit you import your Magento two URL rewrites, redirects, and other url linking.
review.csv .xml .ods .xlsx - this file features 'product reviews' entity which will let yous import your Magento 2 production reviews, rating, and client thoughs of your products.
gift_card.csv .xml .ods .xlsx - this file features 'products' entity, specifically gift card products, which volition let you import your Magento 2 Commerce gift cards. Note, that you demand to use 'Products' entity for import and consign, every bit 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)

Improved Import and Export extension for Magento two

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 demand to map attributes and categories
If you lot crave order, category, cart price rule, product aspect and sets import
If you require Balance or Lather API connection to your CRM, ERP and other systems

What is the extension

Improved Import and Export is a Magento two extension - meaning all the management process takes identify in the ambassador panel. You lot are not tied to the tertiary political party applications and don't have to run anything in the background.
The extension is open code - meaning that you can make necessary lawmaking adjustments and even improve existing functionality the manner you like.
Customization endpoints - FireBear team have composed a dedicated customization module for Improved Import and Export extension yous can use to enhance the extension'due south functionality.
Json file back up - a single signal of the Rest and Soap API integration with any software you are using for customer or sales management. Attempt integrating your CRM, ERP or POS systems to the extension.

Magento 2 Ultimate Import & Consign 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 information technology into the import job and schedule it to run automatically.

Read more about Magento ii Google Sheet Import

Nosotros have too equanimous a Master Google Canvas table for Magento two where gathered all possible import entities. Every attribute comes with a clarification and samples. Feel free adding it to your Google Drive and using for your store.

Google Sheet Principal Table for Magento 2 Import

Magento 2 Improved Import and Consign Roadmap

Import and consign events and chore queue and restrictions - build flexible weather for running import and consign jobs afterwards whatever Magento two update, queue jobs, automatically block jobs that depend on any system upshot or process. For case: order placed, new product or customer created, attribute modified.
Magento 2 product prototype processing settings and configuration - crop and calibration, adjust size and files name, convert to different format, compression and operation optimization.
Email, WhatsApp, Telegram and other notification possibilities for jobs - send condition and debug data most import and consign processes.
Import diff system – a smart algorithm for comparing the electric current state of Magento 2 and data in the specified import source. Relieve 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 packet managing director.
Simplified and improved import of parcel and grouped products – import and create on the fly complex products past the fields of the child products.
Full support of Magento 2 Multiple Source Inventory extension and its workflow.
Full support and compatibility with Magento ii B2B and Omnichannel.
Toll and currency formatting.
Get raw SQL query of import & consign job to run and adapt 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.
Total circumvolve Magento ii integration and synchronization of products and orders with top drib-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 plan