Skip to main content

Is it possible to change the order number?

More
15 years 8 months ago #4775 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

Please Log in or Create an account to join the conversation.

More
15 years 8 months ago #4776 by nicolas
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.

Please Log in or Create an account to join the conversation.

More
15 years 8 months ago #4777 by bg46250
HOLY CRAP THAT WAS FAST!!! (caps intended)

Thank you! Why can't every product have support like this?

Please Log in or Create an account to join the conversation.

More
15 years 8 months ago #4781 by bg46250
AWESOME! Worked like a charm! Thanks again!

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #24612 by adoewa
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

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #24622 by nicolas
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.

More
15 years 1 month ago #24864 by adoewa
Nicolas....

What do you mean with truncate?

Koen

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #24870 by nicolas
I mean to run the truncate table query. Here is a video tutorial on that:
www.youtube.com/watch?v=ZC0PcJKTXTY

Please Log in or Create an account to join the conversation.

More
9 years 2 months ago #273804 by alin
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.

More
9 years 2 months ago #273869 by nicolas
Hi,

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
Powered by Kunena Forum