WordPress.org

Forums

WP eCommerce
[resolved] Is there a list of 2-digit state numbers that appear in sales log data. (4 posts)

  1. Karalee
    Member
    Posted 2 years ago #

    When I download the sales log data to CSV format, the states appear as 2-digit numbers, not 2-digit postal codes. For example, California is 18 and Ohio is 48. These numbers seem pretty random and I have no idea where they are defined, i.e., no list of them in the docs. Anyone have any idea where there is a list of the numbers for all 50 states? Thanks for your help.

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

  2. Jeffrey Schutzman
    Member
    Posted 2 years ago #

    You can always look at the wp_[your db prefix]_wpsc_region_tax table in the database to decipher the codes. The "id" column is matches the region number you are seeing.

    Exporting this table to csv would give you the lookup table you need to interpret the code.

  3. Justin Sainton
    Member
    Plugin Author

    Posted 2 years ago #

    What version of WP-e-Commerce are you using? This issue should actually be fixed in the latest version. The following commit expounds on this:

    https://github.com/wp-e-commerce/WP-e-Commerce/commit/8de7c2d66c6d6abfbcf55451c7e41c873e7de8cc

  4. Karalee
    Member
    Posted 2 years ago #

    I just installed the 3.8.13 update, and the state info is now displayed correctly in the CSV file. Thanks Jeff and Justin for your replies. The latest release of WP-e-Commerce has made my holidays much happier!

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP eCommerce
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.