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
1
vote
1answer
1k views

SQL to update price and special price based on specific store

I have a Magento Enterprise 1.14.2.1 multi-site and what I want is lets say I have two store views setup store "store_US" and "store_AU" I want to run a php file that would get each sku, price and ...
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. ...
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. ...
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('*') ...
1
vote
1answer
90 views

Special price is displaying after refreshing the page in frontend

Special price is displaying after refreshing the page in frontend. Price is working fine, special price is giving problem. We are using following code for editing textfield Price & special price ...
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
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:...
1
vote
1answer
1k views

Magento Discount Filter IN Layered Navigation [closed]

I want To create Magento Discount Filter In Magento. Which Will Be on Base Of Special Product. If Product Price is 400 and special Price is 200. then Discount Will be 50% like this all.. The Filter ...
0
votes
1answer
90 views

disable “Add to Cart” when special price date ended

I am beginner to magento and want to disable "Add to cart" button when special price to date is ended, is there a way to do that? thanks.
0
votes
1answer
560 views

How can I get all products with special price via Magento SOAP V2 API?

I need to get all products that are at a discount. Is there any way to achieve this with SOAP API? Is it possible to compose such a filter?
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
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 ...
1
vote
2answers
47 views

Price of bottle shown as price of one shot

I hope it isn't too bold to ask for help. I sell bottles of liquor and I want to show under price of bottle (item) converted price of one shot. My idea is this If attribute 'show_shot_price' says '...
1
vote
0answers
371 views

Get Bundle Product to display its “base” simple product with Special and Regular Prices

My site sells Bundled Products (Laptops/Desktops). The product is set up as follows: The bundle product's price is dynamic. A simple required product (the laptop itself) that has a price and inventory ...
0
votes
1answer
2k views

Magento - Add special price to product programmatically

I'm looking to extend the special price functionality in Magento and add some custom logic for when special prices should apply to products. What is the most efficient way of doing this? Currently, ...
0
votes
2answers
3k 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 ...
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 ...
1
vote
0answers
273 views

Wrong calculation on Configurable product when Child product price is minus

I have set for a configurable product a base price of 150. One child product with another color is 50 less so I made it -50 at the attributes (associated products) I have discounted the product with ...
1
vote
1answer
668 views

Special price tax applied in catalog but not in product page

I'm migrating Magento 1.7.0.2 to 1.9.1.1 and having following issue. In catalog view products that has special price set are displayed with tax applied. Although, in the product view the same product ...
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 ...
1
vote
1answer
192 views

give special prices only for products uploaded in one month

we uploaded some 1000 products to our site. we uploaded 500 products in 1st month and next 500 products in 2nd month now we want to give special prices for products that we uploaded in 1st month. ...
0
votes
1answer
119 views

display special prices in excel sheet which displaying in site using catalog price rules

we have uploaded about 1000 products in a site. we used "catalog price rules" to give discount for all products, so special prices are displaying in site. we want to get all those special prices in ...
4
votes
3answers
461 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 ...
0
votes
2answers
43 views

Pricing still on

I have some products, that had some discount prices (5% off). Now I deleted all these special prices in the products' dashboard, cleared the cache multiple times and even increased the regular price. ...
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 ...
1
vote
1answer
1k views

special prices are showing only in product list page in one magento site

price.phtml = >http://pastebin.com/T8xhyqp7 we used above code to display price and special price in produt list and product view page. but in one site, this above code is working fine in product ...
0
votes
1answer
464 views

CE 1.9.1 mass product update for Special Price To date

In another question thread I was recommended to do a mass product update by selecting all products and choosing "Change attributes" in order to edit the special from/to date for many products at once. ...
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 ...
1
vote
2answers
748 views

How to remove “special pricing” on Wishlist and Product Page

When I add special pricing for a customer group... I would like it to just show the current price it is at, for example $3.95 in the attached image. I don't want it to show the crossed off "regular ...
2
votes
1answer
315 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 $...
1
vote
1answer
349 views

How to set product special prices to 50% of regular price for a specific category and time span?

Is there a simple way, maybe with the catalog price rules, to set the special price of all products of a specific category to 50% of the regular price and set a start and end date? We have near to ...
0
votes
2answers
898 views

Getting error when trying to update Product Prices index in Magento

I'm getting the following error after attempting to index Product Prices in Magento: Invalid backend model specified: catalog/product_attribute_backend_startdate_specialprice Screenshot here: http://...
0
votes
1answer
2k views

Display both reduced amount and also percentage in cart page

http://www.customy.com/blog/show-product-discount-percent-in-magento/ The amount reduced will be shown in percentage in above link. I need to display percentage of discount along with "HOW MUCH ...
0
votes
2answers
3k views

How do you set the special_price of product in magento via direct SQL query?

I need to mass update special price from a CSV File (which tells me the sku, the special price, to/from date). At the moment I do it using magento models method like this (after parsing the CSV rows) ...
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 ...
0
votes
1answer
1k views

Catalog view incorrectly indicating special pricing on a product

I've sometimes noticed (somewhat rare) behavior whereby a product will show a special price in the catalogue view (i.e when browsing through a category), though when you click onto it no special ...
0
votes
2answers
14k views

special prices are not displayed

Before special prices were displaying on every page. Now special prices are not displaying in the site. I set the product to use other themes. It's not displaying there also, so it is not a theme ...
0
votes
1answer
386 views

Magento Special Price to change grouped.phtml table

I am trying to edit our grouped.phtml table so that when a product has a special price it displays different columns. I have edited my grouped.phtml page to include these columns but can not work out ...