Price rule for a specific country

[Jimmythebib]

Hi I have price rules set up and working for various currencies to set the price per currency rather than have an exchange mechanism doing it and creating messy unattractive prices. It also allows balancing shipping costs within the product price as we offer free shipping to all locations.Price rules are great!

 

 I did it like this: In Back Office Catalogue > Product > Prices tab > Specific Prices

 

Example:

 

All combinations Dollar All countries All groups All customers $21,00 -- From 2015-06-01 00:00:00
To 2025-07-01 00:00:00

 

Priority Management

 

Shop > Currency > Country > Group

 

Example of price rule that is not working as I need (Base price €16);

 

All combinations Euro Ireland All groups All customers €14,00 -- From 2015-06-01 00:00:00
To 2025-07-01 00:00:00

 

I need to set a specific price for one currency (the Euro) and country but it keeps being applied to all prices in that currency. I realise the user will need to be logged in to see the price difference for their country. but all Euro prices are affected for that product when you switch currency not just for that country. Only people from the specific country should have the different price applied.

 

I have two questions.

 

1. Have I configured things wrong?

 

2. Will the price change in the shopping cart if people from that country only log-in during the checkout process and not at the time of adding to their basket?

 

Hope I'm clear enough for someone to help?

 

 

Jimmy

 

 

[irrelevant]

Do you have a separate rule for Euros All Countries?

 

The priority management section states "Sometimes one customer can fit into multiple price rules. Priorities allow you to define which rule applies to the customer." - try swapping the order about so Country is ahead of Currency. 

[Jimmythebib]

Do you have a separate rule for Euros All Countries?

 

The priority management section states "Sometimes one customer can fit into multiple price rules. Priorities allow you to define which rule applies to the customer." - try swapping the order about so Country is ahead of Currency. 

 

Hi thanks for your help.

 

Yes I have a separate rule for all Euros

 

I swapped the priority (below) and there has been a change but the opposite to which you might expect. Now the rule is being applied to all countries (except Ireland)

 

Shop > Country > Currency > Group

 

Jimmy

[irrelevant]

Hmm....

 

Looking at the code, I can see where the "score" for the priority is calculated, but it places this at a lower level in the ordering than the id of the price rule -

$query .= ' ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC';

This is only a guess, I hasten to add, but you could try swapping those over, i.e. change it to

$query .= ' ORDER BY `id_product_attribute` DESC, `from_quantity` DESC,  `score` DESC, `id_specific_price_rule` ASC';

This is ~line 235 of classes/SpecificPrice.php   Make a backup first.  And put the priority back where it was before.  And if it works, report this as a bug on forge! :-D

Edited June 25, 2015 by irrelevant (see edit history)

[Jimmythebib]

Hi irrelevant I tried another combination which appears to have worked but I'm still testing.

 

-- All combinations Euro Ireland Customer All customers -- - €2,00 (Tax incl.)

 

Default priorities set: Shop > Currency > Country > Group

 

Shows full price logged out when logged in and shipping to Irish address the price reduced by 2 currency units as it should. Ship to any other address including Euro countries reverts to normal price.

 

Think I will mark as solved?

 

 

Jimmy