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/
wannaplay2009
Member
Posted 2 months ago #
Thanks for sharing with everyone?
Could you?
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
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.
...