Yep, although you might wanna make sure and wait for another person to confirm my answer as I am not confident. Better yet, why don't you contact the iPage guys because they can give you an answer better...
Thanks 1quicksi. I did perform the search. Found that the answer was quite vague for us new people. Would anyone have a pretty explicit way to change the order/invoice numbers?.
Thank you in advance -..
I assume you have access to phpMyAdmin to modify the database or you have some other method via the command line (mysqladmin) etc..
First - back up your database unless you feel real confident and lucky..
Second - Pick an existing order or a test order that you will use to "change" the order number on so that the next order on your system will be one more than that. Lets assume the order number you'll use is order #22..
Third - Now we will change order number 22 to say 2001..
In phpmyadmin just click on table orders. Then click on SQL to bring up an entry screen that you'll use to enter the following SQL code. You can copy and paste it into the window if you wish..
Then hit the "go" button to run the query/update. The next order number that osC will generate is #2002..
You should be good to go now..
Hi Tom -.
I appreciate your help. I am not aware of any php program. I use my ftp to download the particular files. I am assuming that I am supposed to be in the Admin-orders.php file. Then from there I use notepad to edit the file..
If so, I have copied what is currently there: Could you please help me further?.
$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased, comments from "TABLE_ORDERS" where orders_id = '"tep_db_input($oID)"'");..
You won't be using any of the osC php files or modifying any of them..
You need to gain direct access to your MySql database. Normally this is accomplished via phpMyAdmin. It is a free program. You can get it at the following site..
Your host provider may already have this available for you. If not ask him what you can use to update your mysql tables..
This post has been edited by.
: 29 December 2003, 23:17..
Thank you so much for your help. I went to that iPage website looks very unfamiliar to me. I am wondering if you might have any other easier resources. Sorry to be a thorn in your side...
PhpMyAdmin is the best way to work with your database. The only other option I know of is to use command line operatives through MySQL directly which I do not recommend for any one not very familiar with MySQL...
I did such a change... after that, my order is gone in the admin tool... If I change the order no back to what it was originally, then the order is visible again!.
Does anybody have a clue why this is happening?..
There are other tables that also contain the order_id so changing just the orders table to set your next order_id to a larger value will probably cause the select clause in SQL to fail to join other tables like products etc..
Use the following method to set your order_id to a new and higher value. Back your DB up first..
In phpmyadmin (SQL Tab) run the following command:.
Alter table orders auto_increment=insert_new_orderid_here.
Change the "insert_new_orderid_here" to whatever you want the next order to be (i.e 20000)..
This post has been edited by.
: 28 October 2004, 17:21..
Ok, that is the solution for getting the desired OrderID for the next order. But what if I want to change an OrderID for an order already registered? Is it possible?..
If you want to change an order's order_id number AND have all of the associated good things work within osCommerce for that order, then you'll need to change ALL of the tables that reference that order with an appropriate SQL update command or use phpmyadmin on each of the tables. I'll let you do the research on that..
The solution here was to set osCommerce up with a higher order number than comes with the default installation..
I don't know of any contribution that provides the functionality you are looking for..
Ok, then I know at least! Thanks for you answer!..