Starting Order Number
Posted: 16 March 2012 11:24 AM
[ Ignore ]
Is a Really Great Dancer
Total Posts: 87
Joined 2011-09-23
What is the easiest way to make order #‘s start at a custom number 1700 and then increment from there?
Thanks,
Posted: 19 March 2012 08:53 AM
[ Ignore ]
[ # 1 ]
Administrator
Total Posts: 10241
Joined 2008-09-29
1. in orders settings set “Order/Invoice Numbers” to “Create sequential order/invoice numbers”
2. Set the most recent order’s entry’s title to Order #1699
Future orders will increment from there.
Signature
We’re moving away from the forums, though not entirely and not immediately. Lack of support lately is coincidental to that. Unfortunately we’ve had a bad month with it, but we do not forsee that we will have any continued problems with support through our portal going forward, or on forums while we’re still transitioning. We will send out a newsletter and make additional notifications through twitter and other outlets over the coming weeks.
Moving forward; things returning to normal.
Posted: 19 March 2012 09:13 AM
[ Ignore ]
[ # 2 ]
Is a Really Great Dancer
Total Posts: 87
Joined 2011-09-23
I tried that by changing the title and url_title and the next sequential number generated was still incrementing from the previous sequential number. Do I need to change to entry ID and then save back as sequential?
Thanks,
Posted: 20 March 2012 01:56 PM
[ Ignore ]
[ # 3 ]
Administrator
Total Posts: 3541
Joined 2009-05-29
Hey James,
A quick sql query will take care of it:
UPDATE exp_cartthrob_settings SET value = 1700 WHERE ` key ` = 'last_order_number' AND site_id = 1
If you have MSM you’ll have to look up the correct site id.
Posted: 21 March 2012 05:37 AM
[ Ignore ]
[ # 4 ]
Is a Really Great Dancer
Total Posts: 87
Joined 2011-09-23
Posted: 11 May 2012 06:22 AM
[ Ignore ]
[ # 5 ]
Is a Really Great Dancer
Total Posts: 72
Joined 2011-07-18
This seems like a structural flaw, I tried to set the invoice number several times, also by completely removing the suffix in the settings, but it did not change anything. Changing last_order_number did however.
Posted: 14 May 2012 05:06 AM
[ Ignore ]
[ # 6 ]
Administrator
Total Posts: 10241
Joined 2008-09-29
When CT was upgraded, the ability to change the title and update the Order ID that way was removed. I think we’d intended to add a setting for the last order number, but It doesn’t look like it was implemented. I’ll ask Rob if he knows the status.
Signature
We’re moving away from the forums, though not entirely and not immediately. Lack of support lately is coincidental to that. Unfortunately we’ve had a bad month with it, but we do not forsee that we will have any continued problems with support through our portal going forward, or on forums while we’re still transitioning. We will send out a newsletter and make additional notifications through twitter and other outlets over the coming weeks.
Moving forward; things returning to normal.
Posted: 14 May 2012 09:06 AM
[ Ignore ]
[ # 7 ]
Administrator
Total Posts: 3541
Joined 2009-05-29
The advice at the top of this thread no longer applies, the order numbering was changed a while back. Now it uses the hidden last_order_id setting to determine the position of the order numbering.
Posted: 21 May 2012 05:23 AM
[ Ignore ]
[ # 8 ]
Wallflower
Total Posts: 23
Joined 2010-07-19
Where would one find this hidden setting?
Posted: 22 May 2012 04:59 AM
[ Ignore ]
[ # 9 ]
Administrator
Total Posts: 10241
Joined 2008-09-29
config.php. change last_order_number to your order number. Create a new order… then set that back to 0. I don’t’ know if rob has a smoother way of doing that… but I believe that should work.
Signature
We’re moving away from the forums, though not entirely and not immediately. Lack of support lately is coincidental to that. Unfortunately we’ve had a bad month with it, but we do not forsee that we will have any continued problems with support through our portal going forward, or on forums while we’re still transitioning. We will send out a newsletter and make additional notifications through twitter and other outlets over the coming weeks.
Moving forward; things returning to normal.
Wallflower
Total Posts: 23
Joined 2010-07-19
Don’t know if that will work Chris but I (under Rob’s direction) updated the last_order_number field in the ct_settings table. Seems to work OK.
Administrator
Total Posts: 10241
Joined 2008-09-29
Signature
We’re moving away from the forums, though not entirely and not immediately. Lack of support lately is coincidental to that. Unfortunately we’ve had a bad month with it, but we do not forsee that we will have any continued problems with support through our portal going forward, or on forums while we’re still transitioning. We will send out a newsletter and make additional notifications through twitter and other outlets over the coming weeks.
Moving forward; things returning to normal.
Is a Really Great Dancer
Total Posts: 92
Joined 2011-08-01
I’d also like to reset or at least alter the order numbers. I looked for the ct_settings table and poked my head in other tables that sounded promising but couldn’t find the last_order_number field. Where exactly is it?
Thanks and Cheers!
Administrator
Total Posts: 3541
Joined 2009-05-29
The setting is stored in the exp_cartthrob_settings table, where the `key` is equal to last_order_number. To reset, you’d perform this SQL query:
UPDATE exp_cartthrob_settings SET value = 0 WHERE ` key ` = 'last_order_number' ;
I’m going to add a setting to the CP where you can change this, so we can be done with this problem once and for all
Is a Really Great Dancer
Total Posts: 92
Joined 2011-08-01
Ok, I went into the db but a setting in the CP would be sweet nonetheless. Thanks!
