Printable View
Hi,
I want to change the starting order number to something bigger.
I understand that I go to admin, store manager but where do I add the new number. I placed a bigger number into Older order ID and nothing happend when I placed a fake order and I added a number to the New order ID but again nothing. WHat am I doing wrong? Do I need to add two numbers:dontgetit
Reset Current Order ID
Old Order ID
New Order ID
Hi there
You need to enter both numbers Old ID (being the last order number) and New Id being the new start number which needs to be bigger the the Old ID
Thanks for that :bigups:
Sorted now :smile:
Quote:
Originally Posted by pb4
Ok. I'm reviving this post, because I don't understand how to do this. Where exactly in the admin do I change the order number permanently to a higher number and it goes incrementally forward from there? I can't imagine anyone wanting to reorder from someone who's order number is in single, double or triple digits (1,10 or 100). I'd like to change it to start at about 1000 or more.
I've done some test orders, but still only in the single digit order numbers here.
Any help is greatly appreciated.
Never Mind! I finally figured it out! :D
What was the secret to your success? :smile:
The secret, was that I went back and "RE-read" the info, logged into my admin>store manager followed the destructions...er I mean the instructions. ;-) Worked perfectly. I'm better at the destruction than the instruction. LOLQuote:
Originally Posted by Ajeh
Every now and then ... I have to read the instructions too, or I end in disaster myself ... :cool:
worked like a charm. thx!
Can somebody help? Where are the original instructions on where to edit the starting order number? I don't see any option to edit anything on the order info page. Thanks.
To change the orders_id you would go to the Tools ... Store Manager ... and read the instructions there on how to create an Order and then change that Order's orders_id to a new orders_id ... :smile:
Thanks. original instructions worked for me as well.
I followed your and the instruction on that section and tried 25 times. It still does NOT work. What is going on?? I made an order and got the order ID as 21 and want to start the new ID as 8229 so I put 8228. I then made another order again, the number still the old number +1=22.
Pl. help!!!
the site is : www.ftabonus.com
Thank you very much.
Quote:
Originally Posted by Ajeh
Could you look at the structure of your orders table via phpMyAdmin and list the settings for the orders_id that you see when looking at its structure?
I coulsdnt find order table as you mentioned, so i tried order total, hope that can help, as below:
Order Total Modules
Modules Sort Order Action
COD Fee ot_cod_fee 950
Discount Coupon ot_coupon 280
Group Discount ot_group_pricing 290
Gift Certificates ot_gv 840
Low Order Fee ot_loworderfee 400
Quantity Discount ot_quantity_discount 295
Shipping ot_shipping 200
Sub-Total ot_subtotal 100
Tax ot_tax 300
Total ot_total 999
Thank you very much.
Quote:
Originally Posted by Ajeh
You have a database that holds all of the data tables for your shop that you can see via your Control Panel for your domain with phpMyAdmin ... this is not part of Zen Cart ...
By looking at the structure of your orders table in your database you can see how the orders_id is setup and check to see if, for some reason, it is not setup for the proper settings ...
If you don't know where phpMyAdmin is in your domain's control panel, you should contact your hosting site for some help on how to use phpMyAdmin so that you can check the structure of the orders table in your database ...
Hope below are the things you are talking about, I am really ignorant in this. NEWBEE..
I did a check table:
Table Op Msg_type Msg_text
pansat_zc1.zen_orders_total check status OK
then is this:
zen_orders_total 38 MyISAM 6.3 KiB Creation: Jul 02, 2008 at 11:39 PM
Last update: Oct 05, 2008 at 08:50 PM
Last check: Oct 06, 2008 at 04:42 PM
I hope this helps.
Look foward to hearin gfrom you.
Thanks again.
Quote:
Originally Posted by Ajeh
Not really ...
You need to look at the table structure of the orders table in your database ...
It will list the fields such as:
What you want to see is if your orders_id field is marked as auto_increment or not ...Code:Field Type Collation Attributes Null Default Extra Action
orders_id int(11) No auto_increment
customers_id int(11) No 0
customers_name varchar(64) latin1_swedish_ci No
customers_company varchar(64) latin1_swedish_ci Yes NULL
Would I be able to add letters to the New Order ID?
Not to the database, the orders_id is a numeric field ...
I'm having problems with this, too. There's nothing in my version of Zencart called Admin > Store Manager. Where should I go in version 1.5.1?
Admin -> Tools -> Store Manager
else
http://www.yourwebstite.com/your_adm...re_manager.php
best.
That's exactly what I needed...thanks so much!!