Different prices for multiple countries

[rosuandreimihai]

Hi all,

 

I need to set up a store in PrestaShop where the prices are different for every delivery country.

Could someone point me to the correct approach of setting such a request?

 

My current ideea is to set up for each country a new shop in MultiStore, but having 107 countries is more the time consuming.. Is there any other solution?

 

Thanks!

[gabdara]

The closest thing you can do now is to set a reduction price for different countries from BO > Price Rules > Catalog Price Rules.

You could hire a developer to adapt or create this functionality for you (set specific product price for different countries).

[rosuandreimihai]

So, you think that creating different stores for every country would not be an option?

[gabdara]

It is definitely an option, but as you said it's more time consuming. It seems inefficient, hard to scale and maintain.

[rosuandreimihai]

Yes, but using the catalog price rule would not take into consideration the delivery address.. So, when a user from Germany will deliver something to Spain, I would like the price paid to be from the catalog from Spain.. So, I guess the only option is to have different catalog prices for every country even if I will spend a lot of time defining the shops..

[El Patron]

https://www.prestashop.com/forums/topic/193843-module-prestashop-geo-pricing-geo-target-specific-prices-by-country/

 

this module extend feature of by country specific price.

 

i.e. back office-->catalog-->products-->edit product-->prices-->add a 'by country' specific price.

 

then you can have specific price by country based on resolved IP address, not worry about non-resolved IP being denied shipping, and not change country (price) when registered country is different than IP resolved country.

 

also this can be somewhat accomplished by a mutlishop that uses ccTLD (country code) type domain names.  The problem is url's have heavy seo based on 'age' so going this route is good in long run but not so much in near term unless you pay adwords to get some seo juice.  There is also more setup/admin going this route.  Happy day, el

[rosuandreimihai]

Thank you for the reply. I am aware of that module, but, if one client form Spain would love to send a product to France wich price would be selected?

[El Patron]

https://www.prestashop.com/forums/topic/193843-module-prestashop-geo-pricing-geo-target-specific-prices-by-country/

 

this module extend feature of by country specific price.

 

i.e. back office-->catalog-->products-->edit product-->prices-->add a 'by country' specific price.

 

then you can have specific price by country based on resolved IP address, not worry about non-resolved IP being denied shipping, and not change country (price) when registered country is different than IP resolved country.

 

also this can be somewhat accomplished by a mutlishop that uses ccTLD (country code) type domain names.  The problem is url's have heavy seo based on 'age' so going this route is good in long run but not so much in near term unless you pay adwords to get some seo juice.  There is also more setup/admin going this route.  Happy day, el

 

 

Thank you for the reply. I am aware of that module, but, if one client form Spain would love to send a product to France wich price would be selected?

 

They would see the price for Spain.  That for us only makes sense.  If we change the visitor country from Spain to France because of delivery address then the price will change, confuse the visitor which is not a good thing to do.

[socket84]

Hi guys,

I've a problem, i need to set a SPECIFIC PRICE of a product, for 200 countries...

Is there any fast and quick solution in Prestashop?

Prestashop gives to me only the option to select countries one by one, but it's really too long procedure. The problem is that prestashop loose the MULTISELECT ability, and is impossible to spend one day to add specific prices for every 200 country...

I've tried also tu use CATALOG PRICE RULES, but the problem is the same, i have to create the rule one by one...

Let me know if somebody have a solution.

Thanks all!

Edited December 21, 2015 by socket84 (see edit history)

[gabdara]

I don't know of a way to do this directly from PrestaShop.

The fastest way that I can think of that doesn't involves code is to use PhpMyAdmin like this:

• from Back Office create a specific price for your product for the first country
• open Countries page to see the ids that you need
• go to PhpMyAdmin, your PrestaShop database, open table ps_specific_price and see the last entry
• on the last entry, click Copy, modify field id_country with the next Country id that you need and click Go
• repeat the copy step until you have entered all 200 countries id

It still requires some manual work, but it will be faster than doing this from Back Office.

If you know a little bit of MySQL, based on the process above you can make an Insert query to include all 200 values at once.

[socket84]

Yeah nice solution! I think that I'll use it. Obiously MYSQL string will be appreciated!

[El Patron]

Make sure to look about for 'mass update specific price' modules.  I bought one back in 1.4 days that allowed nicely mass update of specific prices.  If you 'search' and find anything interesting please post back here.

 

other ideas?  store commander for PrestaShop may be worth taking a look at, also using .csv's rather than relying on native back office to manage 'many' of anything.  lol

[gabdara]

It shouldn't be hard for you to construct the MySQL string. After you do the process I've described once you will see the query that was executed right at the start of the page.

Click [Edit] and it will open a window where you can modify it. It will look similar to this:

INSERT INTO table (col, col, col, ...) VALUES (val, val, ..., id of country 1, ...); 

What you need to do then is to change into the values the next country id, add a comma, copy the values parenthesis again and change to the next country id.

Repeat this until the last country id. It will look something like:

INSERT INTO table (col, col, col, ...) VALUES 
(val, val, ..., id of country 2, ...),
(val, val, ..., id of country 3, ...),
(...),
(val, val, ..., id of country 200, ...);

Hit Go and you're set.

[socket84]

It shouldn't be hard for you to construct the MySQL string. After you do the process I've described once you will see the query that was executed right at the start of the page.

Click [Edit] and it will open a window where you can modify it. It will look similar to this:

INSERT INTO table (col, col, col, ...) VALUES (val, val, ..., id of country 1, ...); 

What you need to do then is to change into the values the next country id, add a comma, copy the values parenthesis again and change to the next country id.

Repeat this until the last country id. It will look something like:

INSERT INTO table (col, col, col, ...) VALUES 
(val, val, ..., id of country 2, ...),
(val, val, ..., id of country 3, ...),
(...),
(val, val, ..., id of country 200, ...);

Hit Go and you're set.

You are the best!

Thanks 4 all! I've did'it in 30min! Thanks a lot!