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
6
votes
6answers
12k 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 ...
0
votes
1answer
2k views

Magento 2 - Get product qty and special price from product collection

I am able to get a product collection by using the ProductRepositoryInterface: \Magento\Catalog\Api\ProductRepositoryInterface Then loop through products by doing: $list = $this->...
2
votes
1answer
979 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).
1
vote
1answer
5k views

Magento 2 programatically get special price product collection

How can i programatically get special price product collection?
1
vote
0answers
102 views

Cart price issue for some products

We have a magento multistore website and we are facing an issue with the pricing in Cart. Products on magento are pushed from ERP system. The products pricing is website specific. I will explain the ...
0
votes
0answers
718 views

Magento 2: Cart Subtotal shows Original Price in place of Special Price

I have an online multistore website. In this website, we are facing an issue in which subtotal on the cart is not displaying special price for some products. In place, it shows the actual price with ...
4
votes
3answers
2k 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.
0
votes
0answers
322 views

Set special price as percentage

Is it possible to modify Magento 1.9.0.1 so that special price could be set as percentage from the original price? In other words we could set special price to be for example 80% of the original price....
1
vote
0answers
327 views

Bug or Feature? regular_price vs final_price in Magento2

I am having some weird issue in multi-store with different store currency but same base currency. For example: $_product->getPriceInfo()->getPrice('regular_price')->getValue() gives the ...
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 ...
5
votes
2answers
850 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.
0
votes
0answers
401 views

Magento 1.9 Where is original price saved in order tables?

If a customer bought a product with special price (catalog price rule), the special price will be saved in sales_flat_order_item table. I wonder if the original price is also saved in this table? If ...
0
votes
1answer
1k views

Magento 1.9 Get price from catalog price rule to a SKU programmatically

In Magento, we can use $product->getSpecialPrice() to get the discount price which is set under product view. Is there a way to get the discount price for a SKU from Catalog Price Rule ...
1
vote
1answer
958 views

How to Apply the Coupon Code only to the products that are "Not on Sale" - [Without Special Price]?

My conditions are working fine when i check out with single product which is not having the special price, The same condition is working fine with the products has special price. So the problem is ...
0
votes
1answer
528 views

Sorting Product Collections in Magento 2

I want to make a top offers block where special offer products with the highest percentage discount are shown. I have my special offer products showing and just wondering if something like below is ...
0
votes
1answer
1k views

Magento 2 : How to get getTireprice ,getSpecialprice and getfinalprice?

I am working in Magento 2. I need to get getTireprice ,getSpecialprice and getfinalprice? Anyone please provide same code for this.
0
votes
1answer
646 views

Get Special Price products collections programmatically

I have created some products in magento admin panel by giving Special Price. So how can I get only the Special Price Products collection programmatically in Observer.php? I have created custom ...
0
votes
0answers
433 views

Magento 2 : In Wishlist Special Price Not Showing for Simple Products

In wishlist, Special price is showing for configurable products but not for simple products..
0
votes
1answer
312 views

How do I combine two product collections into one observer?

Can this be added to an observer like in my code in: How to set products in stock after import ? I currently have a module I created that will check the sites prices. It is currently just a page ...
0
votes
1answer
133 views

Remove sale prices on items in store

I am in the process of migrating from an older Magento 1.7 to a Magento 2.1.5 webshop. On the new one, after a very tricky database migration I have a weird occurrence of some products being on sale, ...
2
votes
2answers
4k 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
8k 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); ...
1
vote
0answers
212 views

Cannot re-save product programmatically on 2.1.6

I have a simple script which updates product's special price: /** @var \Magento\Catalog\Api\ProductRepositoryInterface $repository */ $repository = $this->getObjectManager()->create('\Magento\...
0
votes
0answers
141 views

How to fix backend date always showing 2020?

I've looked far and wide for an answer to this problem and could not find one. Perhaps you can help. The Problem: In the Magento Admin Backend Panel, I am trying to set the Special Price Date so that ...
3
votes
0answers
435 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 ...
0
votes
1answer
109 views

Show suggested price in product view

I have the code below for the wholesale customers (they see msrp) I want to show below this: Suggested price: (special price) for your customers <?php echo $this->getChildHtml('...
1
vote
2answers
1k views

If a product has a special price add a new category

I'm trying to create a cron job that checks if a product has a special price and if it does it adds it to the sale category as well as the one it is currently in. $category_id = 9; $_product = Mage::...
1
vote
1answer
23 views

What am I doing wrong on this conditional?

I've put together a blurb to show logged out customers what they can pay if they create an account and log in. Some of our products don't have a lower price so I want to omit the blurb for products ...
0
votes
1answer
683 views

i want to write custom sql query to select low and high price in magento2?

I want to write a custom sql query to find final price,min-price,max_price,special_price but i dont know in which file i suppose to write this code and execute? can anyone tell me where we can write ...
0
votes
1answer
245 views

Magento : How to select products by multiple attributes?

Trying to get products where special_price is set and special_from_date is less than todays date and special_to_date is more than todays date, so: $currentTime = Mage::getSingleton('core/date')->...
0
votes
0answers
525 views

Special price product in product collection magento2

How do I get products with special price rule (for logged in customer group as well as overall) in product collection?
0
votes
1answer
346 views

Special price products custom page magento2

How can I show products with special price (or discounted products) in a separate page in Magento 2 ? Thanks.!
2
votes
0answers
107 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 ...
0
votes
0answers
308 views

Magento 1.9.3.1 getSpecialPrice

I have set different user groups on my store. If you are regular account or logged out you see regular prices. For special clients there are special prices set (user group prices, not special price). ...
1
vote
0answers
219 views

Special Price not changing in magento

1.I m adding a configurable product in magento ,with some price and after adding sale tag over it for a particular duration it still shows up after the end of the date. Price is showing different on ...
1
vote
1answer
869 views

Magento 2.0 REST/SOAP API - how to retrieve Special Price

I need to be able to retrieve the Special Price of a product. I can successfully retrieve products singly or as a list, but can only see a price property on the product object. I also cannot see ...
5
votes
2answers
6k 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. ...
0
votes
2answers
3k views

List all products with special price

I need to create a page which lists all special products (with active special price). How can I do this?
7
votes
3answers
4k 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 ...
8
votes
2answers
3k 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 ...
0
votes
1answer
942 views

Show also fixed price for bundle product when special price is set

Currently when we set a special price for bundle product it shows the special price as configured price. We use bundles as package products so we hide all options and selections and bundles have only ...
1
vote
0answers
65 views

Can I add a special price on my standard tier pricing?

I have set a promotional action in the magento admin by adding a special price on product level. The products have also a tierpricing system. I would like to also add a special price on the tierprice ...
0
votes
1answer
272 views

how to get actual price of a product in magento?

How to add actual price in order email template? I am using this code $_actualPrice = $_product->getPrice();
0
votes
1answer
168 views

Datepicker not working while creating special price

Whenever I am trying to create a special price for a product and try to select the from and to dates for the same the date is not getting selected at all, I have to enter it manually every time. How ...
3
votes
1answer
793 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 ...
0
votes
1answer
678 views

Add class in price.phtml if product got special price

I want to add some class to the <p class="old-price">, when the product got a special price. NOTE: I only want to add this, if the product got a special price, not a catalog price rule. How ...
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 ...
1
vote
2answers
440 views

Issue when SpecialPriceFromDate is equal with SpecialPriceToDate

This is my scenario: I will set up a special price for current day only and I would like to mention in Frontend a text message when the offer is available. By default when you select a date in ...
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 ...
1
vote
2answers
335 views

Adding Time to SpecialToDate

Magento's SpecialToDate does not include a time stamp so any deal runs until midnight. What I would like to do is to be able to set the time as well as the date. I was thinking of changing the ...