Forums

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

  1. wannaplay2009
    Member
    Posted 2 months 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 months ago #

    i solved this myself :)

  3. nmac
    Member
    Posted 2 months ago #

    Thanks for sharing with everyone?
    Could you?

  4. jamescollins
    Member
    Posted 1 month 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 6 days ago #

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

    ...

Reply

You must log in to post.

About this Topic