Is it possible to change the order number?

  • Posts: 3
  • Thank you received: 0
13 years 3 months ago #4775

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.

  • Posts: 81509
  • Thank you received: 13065
  • MODERATOR
13 years 3 months ago #4776

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.

  • Posts: 3
  • Thank you received: 0
13 years 3 months ago #4777

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.

  • Posts: 3
  • Thank you received: 0
13 years 3 months ago #4781

AWESOME! Worked like a charm! Thanks again!

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

  • Posts: 35
  • Thank you received: 0
12 years 7 months ago #24612

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.

  • Posts: 81509
  • Thank you received: 13065
  • MODERATOR
12 years 7 months ago #24622

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.

  • Posts: 35
  • Thank you received: 0
12 years 7 months ago #24864

Nicolas....

What do you mean with truncate?

Koen

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

  • Posts: 81509
  • Thank you received: 13065
  • MODERATOR
12 years 7 months ago #24870

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.

  • Posts: 117
  • Thank you received: 6
6 years 9 months ago #273804

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.

  • Posts: 81509
  • Thank you received: 13065
  • MODERATOR
6 years 9 months ago #273869

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