magepsycho/magento2-regular-special-tier-price-importer-sample-files

Sample CSV Files for Magento 2 Price(Regular, Special & Tier Price) Import / Export Extension

Overview

Magento 2 Regular, Special & Tier Price Importer is the fastest import tool for bulk updating different prices like regular, cost, MSRP/MAP, special, tier & customer group price.

Magento 2 has built-in data transfer for importing products and advanced pricing. But it lacks the functionality of updating all types of prices whether it's regular or advanced pricing in a single go.
Also, the native import has very limited options for pricing.

With this extension, store admin can achieve the simplest & fastest way to import all types of pricing with just a single CSV file (more import sources will be added soon).
And with the export pricing option, store admin can easily prepare the import file.

Key Features

• Provides bulk update for all types of price with just a single CSV file - more import sources will be added soon
• Option to preview the uploaded file which gives the glance view of the file data
• The detailed error message provided during import validation helps to fix the price data faster
• Support for different types of price rounding (whole number to the psychological pricing)
• Price values can be increased(+), decreased(-) by a fixed amount value or percentage
• Price values can also be set as a certain percentage(%) of some reference attribute value
• Ability to import prices via command line interface (CLI)
• Option to export the different prices which makes import file preparation much easier

Sample Files

These samples files are collected here so as to quickly demonstrate the functionality of Magento 2 Regular, Special & Tier Price Importer Extension.

The samples files can be either downloaded from the extension settings(see below screenshots) or from Github repository(files under /samples folder).

Validation

All pricing data must pass validation before it can be imported into the system, to ensure that the values are consistent with the system database.
If validation fails, the extension describes each error. This helps the store owner to quickly find and correct the problem in the CSV file.

This sample file demonstrates the possible validation performed by the extension.

Download Validation Sample File

Import Regular Price & Cost

This sample file shows how to update price & cost

Download Regular Price Sample File

Import Special Price with From & To Dates

This sample file shows how to update special_price, special_from_date & special_to_date

Download Special Price Sample File

Import Tier Price/Customer Group Price

This sample file shows how to update tier_price:*

Download Tier Price Sample File

'Group Price' in Magento 2 is the special case of Tier Price (with tier qty equals to 1).

Import All Prices (Regular, Cost, MSRP/MAP, Tier/Customer Group Price) at Once

This sample file shows how to update all possible prices in Magento 2 at once with just a single CSV file.

Download All Prices Sample File

sku, website_id are two compulsory field for importing any types of pricing in Magento 2.

Price Value Format

This extension supports different formats for pricing.

Format	Description	Applied To
10	Fixed amount value	All Prices
+10	Increase the current value by 10	All Prices
-10	Decrease the current value by 10	All Prices
10%	10% of the reference price value (except tier_price where X% represents the discount)	msrp, special_price, tier_price
+10%	Increase the current value by 10%	All Prices
-10%	Decrease the current value by 10%	All Prices
x	Delete the value from the system	All Prices (except price)