Forums

[resolved] [Plugin: WP e-Commerce] Changing product number (id) (5 posts)

  1. wannaplay2009
    Member
    Posted 2 years ago #

    Is there a way to change the order number of an email.

    It's now showing up like this:

    Billing Details
    Purchase Log Date: 10th Sep 2009
    Purchase Number: 2

    I want to start the purchase number with something like 8500 so it looks better to our customers, anyone know a way to fix that?
    I've searched all over google but couldn't find a solution.

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

  2. wannaplay2009
    Member
    Posted 2 years ago #

    i solved this myself :)

  3. nmac
    Member
    Posted 2 years ago #

    Thanks for sharing with everyone?
    Could you?

  4. James Collins
    Member
    Posted 2 years ago #

    You can do this by adjusting the AUTO_INCREMENT value on the wp_wpsc_purchase_logs MySQL table.

    To do this, you need to run the following MySQL query against your WordPress database (via something like the MySQL command line or phpMyAdmin):

    ALTER TABLE wp_wpsc_purchase_logs AUTO_INCREMENT = 8500

  5. inetwerx
    Member
    Posted 2 years ago #

    Beautiful. wannaplay2009 took the time to tell us he solved the problem, but didn't bother to write the solution.

    ...

Topic Closed

This topic has been closed to new replies.

About this Topic