Magento 2 Advanced Pricing

[Eugene Aubry]

AdobeCommerce and Magento Open Source support various pricing options that you can use for promotions, or to meet the minimum advertised pricing requirements of the manufacturer. Changes to product pricing can be made on schedule, or by price rule that is applied at the product level or in the shopping cart.

The Advanced Pricing settings define the conditions required for special pricing that is available for a specific customer group or shared catalog. Advanced pricing can be applied to simple, virtual, downloadable, and bundle products. To apply discounted pricing to other product types, use a catalog price rule. For more information, see Price Scope.

(Available with Adobe Commerce B2B only) If you are using shared catalogs, advanced pricing data is synchronized with both product pages and shared catalogs. For example, if you update a tier price quantity, the system updates the value in the shared catalog and on the product page. Any custom pricing that is indicated in the shared catalog has priority over customer group pricing. Also refer to Set shared catalog pricing and structure in the Adobe Commerce B2B Guide.

To offer a discounted price during a specified time period or scheduled campaign, enter the special price. When a special price is available, the retail price is crossed out and the special price appears below in large, bold text.

Today, we are going to talk about the Magento 2 advanced pricing import. In this guide, we explain for types of advanced pricing in Magento 2: Special Price, Group Price, Tier Price, and MAP. You will find out how to get a sample Magento 2 advanced pricing CSV. Next, we describe attributes associated with advanced pricing in Magento 2. After that, you will learn how to import advanced pricing to Magento 2. We will explore two different use cases. Firstly, we will teach you how to import tier prices to Magento 2 as a separate entity via the default Magento 2 import. Next, you will master the Magento 2 advanced pricing import as a part of a product import procedure based on the Improved Import & Export extension.

Unfortunately, the default Magento 2 import tools only let you import products and advanced prices separately. It means that you need to upload one file with product data except for four types of advanced pricing provided via different spreadsheets. You must admit that it is not very convenient, especially when you move the entire catalog. To address this issue, we describe another procedure, involving the Improved Import and Export extension. With this tool, you can import both products and their advanced prices in a single file.

Every import procedure requires preparations, and advanced pricing is not an exception. You need to get a properly formatted CSV table before importing advanced pricing to Magento 2. You can get the import table with properly set up separators and sample data in the following ways:

We recommend you use Google Sheets. This sample table comes with a description of Magento 2 Advanced Pricing attributes and clues on which values are required in every column. Read more about Google Sheet Master Table.

Remember, you can use your own import table formatting and map the field separator and text delimiter later during the import process. Meaning that if you are working with the custom table provided by your supplier you can still get it to work.

In most cases, advanced pricing in Magento 2 is associated with tier prices. Since tier prices are applied per product, you need to specify the product SKU for reference and then advanced pricing attributes.

If you want to use the same sample table, make sure you have imported or created products with the same SKUs. Otherwise, the import will fail as it only allows adding tier prices to existing products.

In the screenshot, you can see that in rows 2 and 3, we import two tier prices for the same product with SKU:TST-Conf-Simp-S-Gray. In rows 4 and 5, tier prices are available for the product with SKU:TST-Conf-Simp-S-Green. Take it into account, if you want to import multiple tiers for a single Magento 2 product.

To import tier prices to Magento 2 along with products, you need a new import table. Compose it from standard product attributes with the tier_prices attribute. You can get a sample Product+Advanced Pricing import table at the Master Google Sheet. In the table, you will find a set of simple products with tier prices and descriptions per attribute.

First and foremost, it allows you to schedule the import jobs to run automatically. Second, it supports more import sources including Google Sheets, meaning that you can work together with your colleagues or supplier on a single sheet, then paste it and schedule automatic updates. Other notable features include:

Did you know that mastering advanced pricing can make your Magento 2 store highly profitable? Advanced Pricing provides powerful tools for optimizing prices, promotions, and customer segmentation.This guide will walk you through the step-by-step setup. It will also show how features like Grouped Pricing, Special Pricing, Tiered Pricing, MAP, and MSRP can boost sales and profitability.

Magento 2 advanced pricing offers retailers precise control over pricing. It also allows them to manage promotions to boost sales, profits, and customer interaction. It features dynamic pricing rules and tailored discounts for business objectives and customer segments. It leverages factors like customer attributes, purchase history, and order details.

Grouped Pricing allows retailers to divide their customer base into segments and adjust prices. This segmentation allows retailers to tailor pricing for different customer types. It helps in meeting their specific needs and preferences.

Retailers can differentiate between wholesale customers, who often buy in bulk, and retail customers, who buy smaller quantities. This allows them to provide wholesale customers with greater discounts, incentivizing larger orders.

Retailers can segment customers based on factors like wholesale compared to retail or VIP versus regular members. They can also consider specific demographics such as students, teachers, or military personnel. This approach enables retailers to design pricing strategies tailored to each segment's unique characteristics.

Special Pricing in Magento enables consumers to offer discounted prices for products. This feature allows them to run various promotional campaigns and sales events to attract customers and increase sales volume.

Seasonal promotions like summer sales or Black Friday events are common uses of special pricing. Retailers also use special pricing to clear excess inventory and make space for new products. It is used to promote specific product lines, boosting their visibility and sales. Limited-time offers are another strategy employed to create a sense of urgency and encourage immediate purchases.

Tiered Pricing in Magento allows retailers to offer quantity discounts based on the quantity of products purchased. It boosts the average order size by incentivizing customers to buy more units per order.

Tiered pricing allows retailers to maintain strong profit margins. The lowest tier ideally remains above cost and maintains a baseline margin. Meanwhile, higher quantity tiers can afford to offer steeper discounts.

MAP policies in Magento are important for brands selling through third-party retailers to uphold a premium market position. Without MAP, retailers could advertise products at low prices, eroding brand equity and undercutting competitors.

Select Group Price or similar for Grouped Pricing. You can add multiple customer group prices. Each group can have its own discounted rate for specific customer segments such as wholesalers, retailers, or VIP members.

You can hide the price for specific products in Magento 2. This involves configuring the settings so that the price is not displayed. This feature can be useful for products with pricing restrictions or negotiation-based sales.

In this blog, we will discuss Advanced Pricing in Magento2. Advanced Pricing offers customers better prices that encourage consumers to spend more, drive traffic, and clear old stock. Based on sales, quantity, or customer groups, Magento 2 comes with four types of advanced pricing.

To apply the special price to a product, you need to set a lower price for the product within a specific date range on the product edit page. When the sale is over, the discount price will automatically be replaced with the regular price on the product detail page.

Group price is a part of tier price, and we set it up in the same way. The difference is, you offer customers a tier price based on the quantity of a product ordered. Meanwhile, group prices are based on the customer group. For group prices, the value in the Quantity field is always 1.

Merchants can set up group prices for their products, which allows them to offer different prices for different customer groups. For example, a merchant might offer a product for $10 for regular customers, but for a VIP customer group, the price drops to $8.

I have a site build where I need to set the product price to be higher than the base price when the customer group logs in. I am trying to do it using the advanced pricing tier but Magento 2 ignores prices that are higher than the base price.

I am currently trying to get the calculated price (advanced pricing) for each customer group via the API.I started with checking out the context and also found an endpoint for modifying the context. But you can't modify the customer group there.Is there a way to calculate the advanced pricing for each customer group via the API?

The one you are referencing is the Storefront API. Which means you are querying (browsing) as if you were a customer or a guest. So when you are querying a single product, it is as if you are going to the desktop site as a guest, and asking the price of the product. Guests do have a default customer group assigned to them too. Therefore, the calculatedPrice & calculatedPrices[] will reflect all the prices that are available to this guest.

3a8082e126