Specific prices priority over catalog rules - a logic approach #33440
Replies: 25 comments 1 reply
-
Hi @freeman78ita, Yes, When we use specific prices, the catalog price rule is ignored( lower or higher than the specific price). Thanks! |
Beta Was this translation helpful? Give feedback.
-
Yes. Catalog price rules should be on top of the priority , then will be useful for merchants. Case
|
Beta Was this translation helpful? Give feedback.
-
@matks do you think we could add a new option in the catalog price rule page ? Do you think it could it be done with this issue #10548 ? |
Beta Was this translation helpful? Give feedback.
-
That would be great! |
Beta Was this translation helpful? Give feedback.
-
Hi @colinegin, Any news about the fix of this issue? because @PrestaShark said
Thanks! |
Beta Was this translation helpful? Give feedback.
-
As mentioned above : "Example CATALOG RULES doesn't work OVER product SPECIFIC PRICE! ;( THANKS! |
Beta Was this translation helpful? Give feedback.
-
so @freeman78ita , @khouloudbelguith it is very bad, |
Beta Was this translation helpful? Give feedback.
-
Nothing......it's a very basic thing. Now for example under covid we would love to set up let's say a category "t-shirt" with 30% off that override specific prices and we can't set it. |
Beta Was this translation helpful? Give feedback.
-
There is a paid module, but my country is not supporting Paypal. So i am waiting.. it is so important to the " Disable/enable specific prices for selected groups. |
Beta Was this translation helpful? Give feedback.
-
which module? I think this should be not managed by a plugin but as a native feature. |
Beta Was this translation helpful? Give feedback.
-
hi, any news on the fixing? |
Beta Was this translation helpful? Give feedback.
-
Guys.... its over two years and nothing was happend here #16295 Catalog price priority shoud be over (on top) of specific prices of single products because they are not usable right now. Example |
Beta Was this translation helpful? Give feedback.
-
Hi @PrestaShark I have read a very accurate answer 2 days ago on Twitter: https://twitter.com/adamwathan/status/1381275398646927362 "One of the most stressful parts of product development (especially open source) is when people are frustrated you haven’t made the improvement they want and automatically attribute it to complacency or ignoring the community instead of just being completely buried in work to do. If something important takes two years to get worked on, it’s usually because there are two years worth of other fires to put out and work that’s necessary for pure survival. Things taking a long time is more stressful for me than it is for you, I promise. We’re on the same side." It's Adam Wathan, founder of Tailwind, another popular opensource project, who said that. Unfortunately it's exactly the same for us. We're buried in work to do. This is why things take years. If you really need something to go forward on the project and we cannot do it because we have so much work to do, the best is to invest into having it done. You can try doing it on your own. The most important thing is to share that fix with everyone by submitting a Pull Request -- that's what the open source spirit is all about. |
Beta Was this translation helpful? Give feedback.
-
Temporary solution - works for me (PS 1.7.6):
BEFORE AFTER
Now CATALOG RULES are applied before the SPECIFIC PRICES |
Beta Was this translation helpful? Give feedback.
-
I believe this only works if you want the latest rule to apply, not the largest available discount... From the thread here (PS 1.6) : https://www.prestashop.com/forums/topic/438626-set-priority-on-product-discount/ It appears that this should be the solution but I am not sure if it works for 1.7 or what needs changed to make it work? This would be the override (for 1.6): = `from`) AND (`to` = \'0000-00-00 00:00:00\' OR \'' . $now . '\' <= `to`) ) AND id_cart IN (0, ' . (int)$id_cart . ') '; if ($real_quantity != 0 && !Configuration::get('PS_QTY_DISCOUNT_ON_COMBINATION')) { $query .= ' AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,' . (int)$quantity . ' ,' . (int)$real_quantity . ')'; } else { $qty_to_use = $id_cart ? (int)$quantity : (int)$real_quantity; $query .= 'AND `from_quantity` <= ' . max(1, $qty_to_use); } /* order by reduction_type and reduction */ $query .= ' ORDER BY `reduction_type` DESC, `reduction` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC'; SpecificPrice::$_specificPriceCache[$key] = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow($query); } return SpecificPrice::$_specificPriceCache[$key]; } } |
Beta Was this translation helpful? Give feedback.
-
This bug/feature was driving us insane. We couldn't workout why it was ignoring our products custom pricing and using the default price when applying the discount from Catalog Price Rules. We didn't realise that the rules worked like that, as it is not mentioned in the documentation. We spent a few hours trying to locate the cause of the issue, but our limited knowledge of PrestaShop's internals was hindering our efforts. Would it be a good idea to add a note to the documentation explaining that Catalog Price Rules work on the default product price only? This might help to reduce confusion for new users in the future. |
Beta Was this translation helpful? Give feedback.
-
Hello everyone. Following our new approach to feature requests, I converted this Issue to the GitHub Discussion so that the community can discuss the best possible ways to handle this problem and maybe, I hope, organize together to work towards fixing it in the core. If you are motivated to do so, we will be happy to help. |
Beta Was this translation helpful? Give feedback.
-
Hello, |
Beta Was this translation helpful? Give feedback.
-
Abandoned presta as dev
Il mer 8 mag 2024, 21:45 RedTyper ***@***.***> ha scritto:
… Hello,
Do you have a solution but the opposite? The price catalog rule will not
be active when the product has a specific price?
—
Reply to this email directly, view it on GitHub
<#33440 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ADFMLO3WJT6STI56MWMKOH3ZBJ6ERAVCNFSM6AAAAAA6U6QVROVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TGNJZGU3DO>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
Maybe someone has an idea how to solve this? |
Beta Was this translation helpful? Give feedback.
-
Nope. switched to Shopify and never looked back
Il mer 8 mag 2024, 22:11 RedTyper ***@***.***> ha scritto:
… Maybe someone has an idea how to solve this?
—
Reply to this email directly, view it on GitHub
<#33440 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ADFMLO3TSHTEWZ56JPSIH3DZBKBGPAVCNFSM6AAAAAA6U6QVROVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TGNJZHAYDC>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
Funny to chose to pay thousands monthly instead of hiring a dev to solve this trivial change, I say this because last time I checked, if I'm not wrong, rules and specific prices (B2B) were only available on Shopify Plus. LOL, the price is 2300/month now, if someone pays me that monthly I can add all type of discounts customers want. I just added discounts per quantity per customer, so merchant can assign quantities on customer profile and customer can buy 1 and get price of 100, also discounts per totals on cart, not only for products or variations and also solved few issues with taxes for less than that, wow, I really feel scammed. Now I see that working with PHP on Opencart, WooCommerce and PrestaShop was a huge mistake, will learn Ruby now. I leave a link to hire a dev and pay him 2300/m and then see the results: https://www.prestashop-project.org/support/ |
Beta Was this translation helpful? Give feedback.
-
You can use plugins and pay far less. As usual it all depends on use cases
and needs. Eventually switching to woo would be even a possible solution.
I'm done with presta, all the best of luck with it.
Il gio 9 mag 2024, 09:27 Chillcode ***@***.***> ha scritto:
… Funny to chose to pay thousands monthly instead of hiring a dev to solve
this trivial change, I say this because last time I checked, if I'm not
wrong, rules and specific prices (B2B) were only available on Shopify Plus.
LOL, the price is 2300/month now, if someone pays me that monthly I can
add all type of discounts customers want.
I just added discounts per quantity per customer, so merchant can assign
quantities on customer profile and customer can buy 1 and get price of 100,
also discounts per totals on cart, not only for products or variations and
also solved few issues with taxes for less than that, wow, I really feel
scammed.
Now I see that working with PHP on Opencart, WooCommerce and PrestaShop
was a huge mistake, will learn Ruby now.
—
Reply to this email directly, view it on GitHub
<#33440 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ADFMLO7OVTK4YQMQJXFIJITZBMQNHAVCNFSM6AAAAAA6U6QVROVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TGNRUHA2TC>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
Just said that because I do really find Shopify useless for me, but I understand people mad that PS is a bit of DIY, but IMO has everything others don't. Have a nice day! |
Beta Was this translation helpful? Give feedback.
-
Is your feature request related to a problem?
Yes, on P.s. 1.7.5
When setting up a catalog rule if the product has already a specific price it gets ignored.
This maybe right if the catalog rule is lower than the actual product specific price, but it's not if the discount can be higher
Describe the solution you'd like
We used this workaround in 1.6 and i think it made sense:
https://www.prestashop.com/forums/topic/438626-set-priority-on-product-discount/
Describe alternatives you've considered
Hard to say, as if there is for example a black friday, the catalog price rules are best but this way as most of the items can already have a small discount, they will be ignored.
Beta Was this translation helpful? Give feedback.
All reactions