- Posts: 3
- Thank you received: 0
Is it possible to change the order number?
15 years 8 months ago #4775
by bg46250
Is it possible to change the order number? was created by bg46250
I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use!
However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase.
Thanks in advance,
Bryan
However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase.
Thanks in advance,
Bryan
Please Log in or Create an account to join the conversation.
15 years 8 months ago #4776
by nicolas
Replied by nicolas on topic Re: Is it possible to change the order number?
Hi,
You can increment the order id following that post:
www.hikashop.com/en/support/forum/4-how-...mer-order-.html#2144
If you want to change the order number format, you can use the option "order number format" in the configuration. You can read more about that option in the documentation: www.hikashop.com/support/documentation/5...hop-config.html#main
This option is only available in the commercial versions of hikashop.
You can increment the order id following that post:
www.hikashop.com/en/support/forum/4-how-...mer-order-.html#2144
If you want to change the order number format, you can use the option "order number format" in the configuration. You can read more about that option in the documentation: www.hikashop.com/support/documentation/5...hop-config.html#main
This option is only available in the commercial versions of hikashop.
Please Log in or Create an account to join the conversation.
15 years 8 months ago #4777
by bg46250
Replied by bg46250 on topic Re: Is it possible to change the order number?
HOLY CRAP THAT WAS FAST!!! (caps intended)
Thank you! Why can't every product have support like this?
Thank you! Why can't every product have support like this?
Please Log in or Create an account to join the conversation.
15 years 8 months ago #4781
by bg46250
Replied by bg46250 on topic Re: Is it possible to change the order number?
AWESOME! Worked like a charm! Thanks again!
Please Log in or Create an account to join the conversation.
15 years 1 month ago #24612
by adoewa
Replied by adoewa on topic Re: Is it possible to change the order number?
Nicolas,
How can i reset this autonumber.
For testing i created some orders, but now the site is online and we want to start from 001.
Koen
How can i reset this autonumber.
For testing i created some orders, but now the site is online and we want to start from 001.
Koen
Please Log in or Create an account to join the conversation.
15 years 1 month ago #24622
by nicolas
Replied by nicolas on topic Re: Is it possible to change the order number?
You need to go in phpmyadmin and edit the tables hikashop_order and hikashop_order_product and truncate the tables. That will reset the auto increment to 1 and remove all your orders.
The following user(s) said Thank You: raeiken
Please Log in or Create an account to join the conversation.
15 years 1 month ago #24864
by adoewa
Replied by adoewa on topic Re: Is it possible to change the order number?
Nicolas....
What do you mean with truncate?
Koen
What do you mean with truncate?
Koen
Please Log in or Create an account to join the conversation.
15 years 1 month ago #24870
by nicolas
Replied by nicolas on topic Re: Is it possible to change the order number?
I mean to run the truncate table query. Here is a video tutorial on that:
www.youtube.com/watch?v=ZC0PcJKTXTY
www.youtube.com/watch?v=ZC0PcJKTXTY
Please Log in or Create an account to join the conversation.
9 years 2 months ago #273804
by alin
Sorry for my English, it's not my native language.
Replied by alin on topic Re: Is it possible to change the order number?
Hello! Tell me please do I need to clean hikashop_history table too?
Sorry for my English, it's not my native language.
Please Log in or Create an account to join the conversation.
9 years 2 months ago #273869
by nicolas
Replied by nicolas on topic Re: Is it possible to change the order number?
Hi,
If you truncate the hikashop_order and hikashop_order_product tables, then yes, you also want to truncate hikashop_history table.
If you truncate the hikashop_order and hikashop_order_product tables, then yes, you also want to truncate hikashop_history table.
The following user(s) said Thank You: alin
Please Log in or Create an account to join the conversation.
Time to create page: 0.200 seconds