Guest Posted October 26, 2005 Share Posted October 26, 2005 how can you remove many (almost all) countries at once? My client only wants ONE country in the list. How can you remove or disable all the others? Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted October 26, 2005 Share Posted October 26, 2005 This site is very very handy - www.mysql.com Firstly backup your database!! I am sooo not going to be held responsible if something goes wrong Then use phpMyAdmin to lookup the country in [prefix]CubeCart_iso_countries. After you have located the country, put the id into the following SQL statement and run it with phpMyAdmin. Replace [prefix] with the database table prefix of the store (if it has one). DELETE FROM [prefix]CubeCart_iso_countries WHERE id <> XXX Quote Link to comment Share on other sites More sharing options...
Guest Posted October 27, 2005 Share Posted October 27, 2005 so, I take it from your response, the answer is: There is no way to do it from the admin pages. Quote Link to comment Share on other sites More sharing options...
convict Posted October 27, 2005 Share Posted October 27, 2005 use phpMyAdmin! Quote Link to comment Share on other sites More sharing options...
Guest Posted October 27, 2005 Share Posted October 27, 2005 I am fully aware of how to use mysql and can delete data manually, what I was hoping was a simple to use admin function, maybe the ability to multi-select items to delete? Quote Link to comment Share on other sites More sharing options...
convict Posted October 27, 2005 Share Posted October 27, 2005 Back to your first question - did you mean drop down box (combo box) Language or countries list for currrencies and shipment stored into database? If countries list which one your client wants? Quote Link to comment Share on other sites More sharing options...
Guest vrakas Posted October 27, 2005 Share Posted October 27, 2005 so, I take it from your response, the answer is: There is no way to do it from the admin pages. Yes there is no way to mass delete them as you requested :unsure: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.