WordPress.org

Ready to get started?Download WordPress

Forums

WP eCommerce
[resolved] adding uk counties (7 posts)

  1. chemboy
    Member
    Posted 1 year ago #

    I notice this plugin has default 'State' fields for the USA and Canada, but how can I add UK counties, so when users select United Kingdom a list appears to select from?

    http://wordpress.org/extend/plugins/wp-e-commerce/

  2. Lee Willis
    Member
    Plugin Author

    Posted 1 year ago #

    The easiest way is probably to install this plugin temporarily - it comes with a "Region manager" that will let you set them up.

    http://wordpress.org/extend/plugins/wp-e-commerce-weightregion-shipping/

  3. chemboy
    Member
    Posted 1 year ago #

    thanks lee, i'll give it a go

  4. chemboy
    Member
    Posted 1 year ago #

    i have a further question, re creating a csv file of uk counties to import into the 'region manager'

    is there a way to import a csv file of counties into either the region manager or the database? it would save a lot of hand-inputting, or is that the only way?

    also, how do i determine the country id for the UK? in the database, the USA is 136 and Canada is 100

    many thanks

  5. Lee Willis
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    There's no out-of-the-box tool for uploading them that I know of. It is a straightforward table insert though so there may be some way of doing it.

    The country code for UK will be against the entry in the wp_wpsc_currency_list table.

  6. chemboy
    Member
    Posted 1 year ago #

    okay, good to know, i'll get on with it...

    thanks for your help

  7. chemboy
    Member
    Posted 1 year ago #

    hi again

    i managed to import a csv file into the tax regions database table, by replacing the wp_wpsc_region_tax table. saved a lot of hand-coding. if anyone has access to their db, then you can find my csv file by following the link below

    it lists previous usa and canada entries, with uk and ireland added

    works a treat, well done Lee :)

    link to csv file: http://thechemistryset.co.uk/wp_wpsc_region_tax.csv.zip

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic