WP BUGS

By default provides regions such for example, WP eCommerce Canada and the US.   In the example below, we're adding the eight state and territory regions for Australia to WPEC plugin.   By logging into our web hosting, All database queries and updates were performed cPanel and using phpMyAdmin application to access the database. The first step is to make backup of the website database..   The changes below include manual updates to WPEC database tables so we need to ensure there's path if something goes wrong. Find the two digit region codes for the country to be updated..   We could not find on the internet any for Australia so we used the 6 digit codes we found eg AUS-NS for New South Wales and just dropped 'AUS- part..   Using phpMyAdmin to look in the wp wpsc currency list shows that the ID for Australia is 137. Add the states and territories to the database..   The table structure is - id counter country id the number allocated to each country WPEC name the state name code two digit region code tax defaults to 0.   Here's the sql that was generated by phpMyAdmin to add Australian states and territories to the table..   In WPEC back end we moved the country field up above the state field and saved the change. Set the tax regions for the updated country..   We just needed to save the Tax rate as 10% for 'All Markets in WPEC backend ..   Read more