Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › changing countries etc in shipping

changing countries etc in shipping

Thread began 12/05/2011 4:28 pm by studio366170 | Last modified 12/07/2011 2:49 pm by Jason Byrnes | 1427 views | 5 replies |

12/05/2011 4:28 pm | #1 studio366170

changing countries etc in shipping

Another question. I really hope some responses are coming soon as I am on a deadline....

How do I change the available countries for shipping, as the client only wishes to ship to some countries.

Thank you
Simone

12/06/2011 9:35 am | #2 Jason ByrnesWebAssist

the countries are stored in the ps4_countries table of the power store database in power Store 4.5, to remove countries from the shipping select list, remove them from the ps4_countries table.

12/06/2011 7:51 pm | #3 studio366170

Can you tell me where I find the tables... thank you.

12/07/2011 7:13 am | #4 Jason ByrnesWebAssist

the tables are in the power store database.

you need to use a GUI Tool such as PHPMyAdmin to access the database on your hosts server.

Most hosts offer a cpanel for maintaining your site, this cpanel will usually include PHPMyAdmin for accessing the database on your site.

12/07/2011 2:37 pm | #5 studio366170

Okay, never having accessed the database before (other than to create it) can you please post here step by step instructions so I don't destroy it! Thanks so much.

12/07/2011 2:49 pm | #6 Jason ByrnesWebAssist

use phpmyadmin to access the database.

in the ps4_countries table, delete the records for the countries that you don't want to have listed in the shipping list.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.