Questions tagged [special-price]

For questions about the Special Price function where a product has a temporary promotion resulting in a lower price for the customer than normal.

Filter by
Sorted by
Tagged with
9
votes
1answer
6k views

Magento 2 : How to get Final price & Original price of all types of product

How can I get Original price and Final price of given below types product? Simple product Configurable product Bundle product Group product For simple product I can get price easily using below code....
7
votes
3answers
3k views

M2 Enterprise: How to add Special Price for product from date to date programmatically?

I want to add a Special Price for a product from date to date programmatically by code but don't know how. I can set in admin but I want to use code to save multiple products. I use Enterprise ...
7
votes
2answers
2k views

magento2 - how to create Scheduled Changes (Magento_CatalogStaging module) of product programmatically?

I want to set "Special Price" for product from date to date programmatically by code but don't know how, i use Magento 2 EE. I can set in admin use then but I want use code to set programmatically. ...
6
votes
2answers
7k views

Use final price in addFieldToFilter

I am using this code to filter products by min and max price updated code $collection = Mage::getResourceModel('catalog/product_collection') ->addAttributeToSelect('*') ...
5
votes
3answers
7k views

Magento 2 - get special price of product by product id or sku

I need to get the special price of a product by product Id or Sku. Let's say I have an existing product with Id '21' and Sku 'test-21'. This information is provided in my custom block class, how can ...
5
votes
2answers
160 views

Error showing special prices when changing store view - Magento 2.3.1

I have 2 store views, one for normal customers (product prices including tax) and one for wholesale customers (product prices excluding tax). See images for reference. Normal Store View (product ...
5
votes
2answers
667 views

How to remove special price if qty is low?

How to remove special price if qty is low. Instead of setting from and to date from advanced pricing, I need to remove special price based on if qty is lower.
4
votes
2answers
3k views

Magento 2 - Unset Special Price programmatically

I have an import script which imports configs and the variants. There is set the special price if some is set in my import XML document. If no special price is set, i try to remove the special price. ...
4
votes
3answers
1k views

magento select all the products which have special price

I want to select all the products SKU which have special price through mysql query.
4
votes
3answers
460 views

Should my product types be changed from configurable so that child discounts can be applied?

Issue: I need child products to have a special price that does not inherit from the parent product. Details: Currently I am using configurable products to list product options. We need to run a ...
4
votes
1answer
526 views

Magento2: Tier price higher than regular price

I figured out that if you set a tier price higher than the regular price, it will show the regular price anyway. Seems this is the "normal" funcionality, always show the lower price if it's possible. ...
4
votes
1answer
248 views

How to get final price of a product by rest API?

I mean the final price that Magento calculated and inserted in catalog_product_index_price table. It may have applied special price/catalog price rule/tier price, which price is displayed to customer ...
4
votes
1answer
906 views

Magento 2.1 update special price dates programmatically

I have a problem updating the special price dates of a simple product. I've tried 2 versions of code, but without results. In both cases the special price will be update, but no affect to the start ...
4
votes
0answers
2k views

Special prices not showing in product pages

hope you can help me. Using 2.1.7 CE. Site is ready to go live except one frustrating issue I can’t work out. I have just moved to production mode and turned caches on. Since then: Special prices ...
3
votes
1answer
8k views

Magento 2 display old price AND special price in category list

In my old 1.7.0.2 version, I have in a category product list : "special_price" instead of "regular_price" like : 200$ instead of 350$ As I understand Magento2 change the way of setting special_price ...
3
votes
1answer
5k views

How to check if product in cart is on sale (has a special price)?

I'm trying to add an icon to all products with special price in a cart and I've to check if products are on sale. Anyone got any idea how to do it? It was simple to do in list and product cart but now ...
3
votes
2answers
13k views

Reindexing option not available in magento 2.0 [duplicate]

I applied some product catalog rules and deleted them but site still shows the discount. I also clicked on apply filter but nothing happened. Prior to 2.0, I was able to do it from the admin panel. ...
3
votes
1answer
3k views

Special Price With Configurable And Simple Products

I am adding a configurable product with some associated products. In that configurable product I am entering both special price and old price. In that configurable product i have 4 associated product....
3
votes
1answer
10k views

How to add special price for customer group in admin

In magento products, admin have option to add customer group price. I also want to add customer group special price. There is already special price option in the products but it is for all customer ...
3
votes
1answer
749 views

Problem with Special Price Date in Magento2

I am running Magento 2. The other day I tried for the first time to set a special price, but when I try to set a date I get an error. After trying some dates I noticed a pattern. When I pick a date ...
3
votes
1answer
545 views

How can you set the customer group pricing for specific logged in ids as 50 percent discount for all products in magento2?

How can we enable the customer group pricing for a specific set of the customers and even reflect that price while adding items to cart as well from Magento storefront screen?
3
votes
3answers
5k views

Product with special price should not applied for a discount in shopping cart using promotion rule

I have made one promotion rule for shopping cart. If product has price $7.99 from specific category, will get fixed amount of discount $5. This promotion rule is not working well when some products ...
3
votes
2answers
1k views

Sort by price is not working as expected in magento 2.2.7 product listing page

when I sort by price product order in Asc or dec. In product listing shows like, First product price is 40, second product price is 50 and the third product price is 40. If I opened and save those 50 ...
3
votes
1answer
684 views

Magento2 Override Price Logic

We have a custom extension that adds fields for multiple vendors. How can we override Magento Price logic to make calculations for price and special price according to that fields. I have seen the ...
3
votes
1answer
243 views

Magento2 catalogrule promotions, ability to choose price or special_price?

By default catalogrule promotions are applied to price field. Changing this was one classic request in most Magento 1 projects we have managed One approach could be to apply catalogrule promotions to ...
3
votes
0answers
406 views

Magento2 price filter with special price for configurable product

For Configurable product how can we get price filter with special price in magento2? Now its filtering with original price. if i have a product with retail price:20 and special price:10, price filter ...
3
votes
1answer
2k views

Special Price with Configurable Products in Magento 2

We have been converted some Configurable products from Downloadable products. But have an issue in there, we can't be set Special Price(link open the modal set Advancing Pricing is hidden) and very ...
2
votes
2answers
2k views

Magento2: Attribute News to date, News from date , special from date and special to date doesn't show in admin

I've store in Magento ver. 2.1.4 Enterprise. I am trying to add News to date and special date for products. I can't see it in admin. I've checked and attribute is available but its doesn't show in ...
2
votes
1answer
3k views

In the Magento Difference between Price, Group Price, Special Price, Tier Price, Display Actual Price and Manufacturer's Suggested Retail Price

In the Magento backend product creation section, In the price tab showing different types of price below. 1. Price, 2. Group Price, 3. Special Price, 4. Tier Price, 5. Display Actual Price 6. ...
2
votes
1answer
569 views

Programatically get special price products that are active by checking the end date?

How can I programmatically get products that has an active special price? (by checking the end date).
2
votes
1answer
7k views

Get product FINAL price without loading entire product

I can get product attributes efficiently without loading the entire product by using: Mage::getResourceModel('catalog/product')->getAttributeRawValue($productId, 'attribute_code', $storeId); ...
2
votes
3answers
1k views

Least selling special price should display on configurable product view page

please visit this configurable product link you can see : MRP : Rs. 9.00, below that Rs. 0.00 by default Backend values : Price : 0 , special price : 0 in same link, above you can see "color" ...
2
votes
2answers
2k views

Special Price From Date and To Date

I'd like to directly query sku, special price, special price from date, special price to date from database. We are offering special sale every week with different items. Sale items are supposed to ...
2
votes
2answers
723 views

Catalog Price Rules mess when using multiple conditions

I'm trying to set up some discounts on manufacturers products, but I need to be able to apply different discounts on some categories. Example: If manufacturer: ford, discount is 25% If manufacturer: ...
2
votes
2answers
857 views

Discount is not applying properly

please visit configurable product please search for "color" using CTRL + F , than you can see "choose an option" MRP : 100 , Special price : 50, Discount : 50 % OFF = > Fine please change choose ...
2
votes
1answer
393 views

How can I update special prices in magento via API?

I try this scrpit to update special prices. The update is slowly. Is it possible to update any item in one request? In this issue I make request for every item. SOAP V2 $proxy = new SoapClient('http:...
2
votes
2answers
900 views

Obtain final price(s) of item(s) after promotion rules applied?

How can I obtain the actual final cost of items? Let's say a customer's out-of-pocket payment for an order is $1000 and tax is $100 and shipping is $50 So subtracting, all his items AFTER ...
2
votes
1answer
314 views

PHP to show sale badge not working correctly

I am trying to display a sale badge over the image of products with a special price on the catalog and product pages. I have used the following PHP: <?php // sale badge ?> <?php $...
2
votes
1answer
2k views

Catalog Price Rules applied to special_price

Currently magento is using the special price if its lower than the applied catalog price rule. => If the catalog price rule makes the product cheaper than the special price, then the catalog price ...
2
votes
1answer
99 views

Display sale badge on PLP

I am trying to display a 'Sale' badge on product category pages if the products have a special price. Though the isn't rendering anything. <?php if (_$product->getPriceInfo()->getPrice('...
2
votes
1answer
403 views

editing “special price” from frontend is saving in “Price” field in Backend

we are having marketplace [multi vendor] site. so in each seller or vendor account we are displaying name, sku, price .... etc. so that sellers/vendors can edit the product information and save . so ...
2
votes
1answer
1k views

Special price and discount on invoice

In some EU countries, all discounts, including special prices, must be mentioned in invoice. But Magento doesn't display speciall price anywhere in orders. If speciall price is applied, it will ...
2
votes
0answers
23 views

get price in shipment email template in magento 2

I need to get customer order product price for Shipment email template in configurable products. I had added magento-sales/templates/email/items/shipment/default.php $priceHelper = $_objectManager-...
2
votes
0answers
17 views

Magento 2 to avoid special price for b2b customer

I have used magento 2.3.1 enterprise edition. I need to restrict the special price for b2b customers ( either to all the b2b customers or specific customer groups). But for B2C customers, I need to ...
2
votes
0answers
112 views

How to display Catalog Price Rule Discount and Special Price Discount along with Cart Price Rule Discount?

I'm using Magento version 2.2.4. Currently on view and edit checkout page, only Cart price rule discount is shown as below How to show Catalog Price Rule and Special Price (added while adding a ...
2
votes
2answers
643 views

How to check final price or special price is valid or expire on magento 1.9

I am trying to add a condition for checked the special price is valid or not for list page but did not able to find.
2
votes
0answers
25 views

Condition rules in Promotion

I wanted to add BOGO (Buy one Get One Free) promotion on my website. I have Successfully added it but it is applied on same product only. Actually my requirement is like if user purchases 2 products ...
2
votes
0answers
98 views

Special Order date picker that validates time frame before add to cart

I am fairly new to magento2 and I am working on developing a date picker that validates if a special order can be placed in time. The time frame would be different for each manufacturer on the site ...
2
votes
1answer
296 views

How to force catalog price rule over default special price

Currently in Magento CEv1.9, Minimum price is considered between default special price(entered from prices form for product) and price after discount applied through catalog price rule. How can we ...
1
vote
3answers
2k views

Magento Product Collection less then the Original price

How to get Special price less or not <?php $categoryIds = array(469);//category id $todayDate = date('m/d/y'); $tomorrow = mktime(0, 0, 0, date('m'), date('d'), date('y')); $...