Order Numbers

  • Posts: 44
  • Thank you received: 0
10 years 7 months ago #150211

-- url of the page with the problem -- : test.crossfitshorts.com/
-- HikaShop version -- :HikaShop Essential 2.2.3, Joomla!™ Online Shop System
-- Joomla version -- : 3.3
-- PHP version -- :5.4.26
-- Browser(s) name and version -- : all

Hello Everyone,

I'm trying to figure out how to set up my order numbers to start somewhere in the 1,000's. Currently my order #'s are something like M4 or F5. How do I change this so they are numeric only and start at 1,002?

Thank you,
Todd

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
10 years 7 months ago #150227

Hi,

If you want them to be numeric, you can change the "order number format" option of the configuration.
If you want them to start at a certain number you can do like that:
www.hikashop.com/forum/4-how-to/7820-spe...at.html?lang=en#7825

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

  • Posts: 44
  • Thank you received: 0
10 years 7 months ago #150380

Nicolas,

Thank you. Where do I go to view the different options for the setting. I only see
{automatic_code}

What do I use for numeric and/or what are the other options?

Is there a tutorial for this topic?

Thanks,
Todd

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
10 years 7 months ago #150386

Hi,

If you click on the "help" button at the top of the screen, you will see the help relative to the current page and yo will see a section explaining what you can do with that option.
Simply, you want to use the tag {order_id}

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

  • Posts: 44
  • Thank you received: 0
10 years 3 months ago #168241

I've got the order id set to numbers, but I'd like to start at a specific number (2200). Can you please direct me on 'how-to' set the order number to 2200 so that it increases by 1 after ever order?

Thank you,
Todd

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

  • Posts: 13201
  • Thank you received: 2322
10 years 3 months ago #168284

Hi,

You can use such code in phpMyAdmin:

ALTER TABLE #_hikashop_order AUTO_INCREMENT=2200;

Just replace "#_" by your database prefix.

The following user(s) said Thank You: benrud

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

  • Posts: 44
  • Thank you received: 0
10 years 3 months ago #168356

issue resolved

thank you

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

  • Posts: 101
  • Thank you received: 9
10 years 3 months ago #168517

Isn't it possible to make it more user friendly and implement a button in the backend that does execute the above code?

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 3 months ago #168518

Hi,

I just add your request in our TODO list.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: lousyfool, benrud

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

Time to create page: 0.076 seconds
Powered by Kunena Forum