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
0
votes
0answers
14 views

Magento 2 import special with scheduled update dates via CSV

Good afternoon everyone, Apologies if this has been asked before but I have a site that I would like to import special price via CSV import but with scheduled update dates. I am aware that the only ...
0
votes
2answers
11 views

catalog_product_entity_decimal table is empty

I need to bring in cost, price and special_price into an existing query. Research brings back catalog_product_entity_decimal has special_price and price. This table is empty. Is there another table ...
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 ...
0
votes
2answers
4k views

Get the special price of the product using query in Magento

I want to create a view of Magento products. The following query will do that: Note: Magento's default records used to create it. SELECT P.entity_id as uid, P.created_at as cdate, # Created to ...
0
votes
2answers
4k views

Special Price From Date and Special Price To Date not visible in backend M2

I am working on Magento Enterprise 2.2.5, I want to set a special price for some products but Special Price From Date and Special Price To Date are not visible. Can someone have an idea how we can add ...
0
votes
1answer
990 views

Magento 2 Show special prices start and end dates

I have added a product with special price, Template is already showing special price with original price strike through over it I want to show special price start and end dates beneath product price, ...
4
votes
1answer
2k 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 ...
0
votes
2answers
104 views

Special Price Not Showing Configurable Product Magento 2.4.2

I have upgraded Magento 2.4.1 to 2.4.2 Special price is showing for a simple product but showing for the configurable product in the category view page. However, on the product details page, I can see ...
0
votes
0answers
12 views

Magento 2 Cloud - Re-Enable Special Price dates

In Magento Community there are two fields special_from_date and special_to_date that let you choose when a special price is applied. In Magento Cloud they have removed this feature and replaced it ...
6
votes
6answers
11k 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
1answer
1k 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 ...
0
votes
1answer
933 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
27 views

Magento 2 Add Time to Special Price Date Start and Special Price Date End

In the calendar special price date start and special price date end, they using format date only like below image : how can I modify this to add time on the calendar, I've checking Magento catalog ...
0
votes
0answers
23 views

Unable to find getPrice method in catalog

Simple issue but can't figure it out alone : Under base vendor/magento/module-catalog/view/base/web/template/product/price/special_price.html There is this part that is used to calculated the product ...
0
votes
1answer
19 views

Product special_price only changes with reindex

I'm trying to set a product special_price using rest api, But the special_price only changes in store front with reindex command. PS: When i use a numeric value, like: 15, 100, etc... it changes ...
2
votes
2answers
1k 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.
0
votes
1answer
74 views

How do I exclude products with discount from coupon codes?

I need put a coupon code. But I don't need the products with any discount (catalog price rule). I want to make discount coupon only for products with normal price. Is this even possible?
0
votes
0answers
32 views

Magento 2 Cannot update specialPrice per website

I'm trying to update specialPrice per website in a Magento 2.3.6 website. The problem is that when i am updating the price using the Product model , the specialPrice is removed from all storeviews ( ...
0
votes
0answers
13 views

Apply promotional rule on customer group price in magento 2

How can I apply promotional rule to customer group price or special price. As default magento apply promotional rule always on base price of product and then after it is using lowest value to use. For ...
0
votes
1answer
34 views

How to set special price as final price in magento 2

I would like to setup the special price as a final price. In the current scenario, what happens, if the price columns is lesser than the special price, the price is taken as selling price. WHY There ...
0
votes
3answers
68 views

Get On sale product collection in magento 2

I want to show all the on sale product on one page. Can any one help me with the code to get the products collection which are on Sale i.e which has special price assigned in magento 2 This is my ...
0
votes
0answers
12 views

Different currency for an price attribute

I have an issue in magento 1.9 about the "special_price" attribute currency in the backoffice. For the packaged product, the currency of this attribute (special_price) is "THB" ...
5
votes
1answer
13k 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 ...
0
votes
0answers
17 views

Configurable products with special price gives discount to wrong options

it was hard to sum on the title, basically what happens is that we set a special price to te lowest price option in a configurable product but it affected the next ones. For example, image we have an ...
0
votes
0answers
27 views

Magento2 staging Update work flow question

Hi I would like to know beside staging_update table, where I can find the related items information? such as I set a schedule special price start date and end date. Where I can find the start date and ...
0
votes
1answer
70 views

Magento 2: How to remove decimal points in special price column in product admin grid

I want to remove decimal points from special price column in product admin grid.
1
vote
1answer
1k views

How can I show the amount saved in magento 2

I am trying to display amount saved on the catalogue page for a magento 2.0.2 website. However I'm not getting the calculation result displayed. I just get an empty space. I am editing the final_price....
0
votes
0answers
56 views

Get configurable product if child product have special price in collection

I tried to get a product collection and filter it by special price attribute. Here is my code: public function getSpecials() { $currentTime = $this->_dateTime->date()->format('Y-m-...
0
votes
2answers
373 views

Special Price Not Applying in Magento2 Cart

I am creating simple products through API call. Product is created finely and showing all attributes finely in admin part but when ever i am seeing product in frontend it is not showing any special ...
1
vote
1answer
91 views

Checking if child products of a configurable product have a special price?

The following code has been added to the list.phtml but is working only for simple products. When they have an special price with a date range, a sale label is attached to the product image on the ...
0
votes
0answers
19 views

Special price VAT inclusive rounding to 4 decimals

I'm having some rounding issues with a Magento 2.3.5 store. Prices in the admin are VAT-exclusive and shown VAT-inclusive on the front-end. Initially I had an issue with Magento's rounding to 2 ...
0
votes
0answers
11 views

special_price round issues

Whenever any decimal gets entered into a products special_price, it will always be rounded when you visit it again in the backend. I've checked the front end and it will display the decimal entered as ...
1
vote
2answers
997 views

Magento 2: How to completely hide price from the store

I want to completely hide the price from the store. Be it in the catalog, product, minicart or cart. I need to do this through a custom module. Any help is appreciated. Thanks!
1
vote
2answers
23 views

Cannot get special price

I have the following problem: I want to get the final price programatically but it always displays 0 I tried with : $product->getSpecialPrice(); $product->getPriceInfo()->getPrice("...
0
votes
2answers
33 views

How to Special price based on attribute?

Is it possible to set special price automatically based on a attribute? I have an attribute called offerprice in which I enter the percentage of discount. So if the product price is $100 and I enter ...
1
vote
2answers
597 views

how to get special price and regular price in phtml file magento2

i have a phtml file where i want to get special and regular price of product im using product model but getting nothing, im using this code: $product_id =$block->getProduct()->getId(); $_product ...
0
votes
1answer
89 views

Magically special_from_date is set whenever product is updated

I got a weird issue i can't see to find the reason behind it. When i update product with a special_price and the special_from_date is NULL (empty) it updates the special_from_date to today.. And i can'...
5
votes
1answer
1k 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. ...
0
votes
1answer
448 views

Magento 2 How to Catalog Price rule apply on product special price

i want to catalog price rule apply on special price product but i see in magento default apply only on product final price but i want to catalog rule apply on product special price how can achieve ...
5
votes
2answers
5k 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
0answers
169 views

Override advanced pricing from product with catalog price rule

I've create a customer group called: "Dealers", the idea is that they have in their account a 10% discount on all the store. The problem i'm facing is that if I set a product, let's say "Product A", ...
0
votes
1answer
64 views

How to get final price for not current customer?

There is a special customer group named A which has it's own special catalog rules and group prices. I am going to display final price of another customer group named B for A users. How can I get ...
0
votes
1answer
206 views

Why preference not working in Magento 2 observer (Custom module)

etc/di.xml <preference for="Custom\Pricerule\Observer\Frontend\Catalog\Catalog\ProductGetFinalPrice" type="Lof\RequestForQuote\Observer\ProductGetFinalPrice2" /> observer/...
0
votes
1answer
38 views

Magento 2: Calculate sale price based on Special Price not Standard Price

I am attempting to do a "sale on sale" promotion for one of my clients. They would like to add a discount on top of items that are already on sale. Example: "take an extra 30% off sale items." Now, I ...
1
vote
3answers
116 views

How to round Magento 2 special prices?

What I am trying to achieve is that, I have SALE on an item I've managed to display the Regular Price and the Special Price But let's say I have a product which has regular price of 319.00 I would ...
2
votes
0answers
257 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-...
0
votes
2answers
474 views

How to remove special price from configurable parent product in magento2

We have migrated Magento 1 to Magento 2 after migration special price of configurable product parent is showing but we can't edit this special price in the backend.
2
votes
0answers
105 views

Magento 2: import special price for configurable products from M1

In Magento 1 the special prices were added to configurable products. In Magento 2 the special prices are set for simple products associated with the main configurable product. Is there an easy way ...
1
vote
0answers
56 views

Special Price Tax

recently i upgraded my Magento2.2.8 to Magento2.3.3 after upgrade i add product in my cart and go to cart page and see summary on cart Page the tax added 10% which is ok but the issue is if i add ...
0
votes
1answer
113 views

Magento 2 function to get a list of products (simple and configurable) with special price on a given date

I have the following function which gives me a list of simple products which are on special at the moment: public function getSpecialProducts($config = []) { /** @var $collection \...

1
2 3 4 5