How to change starting point for order numbers?

-- url of the page with the problem -- : ojostore.digitaldemo.net
-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.4.8

Hello there -

I have a client who wants their order numbers to START at 8000. So the first order would be 8000, the second would be 8001 and so forth and so on.

How do I do that?

Best,

Leslie

Hi Leslie,

Maybe this link will help.
Number Formatting
This option is only available in the Commercial Version (Essentials/Business)

Otherwise, if you have the ability to connect to the database table via phpMyAdmin or Navicat (I use Navicat), you can set the auto increment value to 8000 in the table #___hikashop_order on fields order_number and order_invoice_number

Depending on your business rules, they do not have to be the same values.

The formatting is found under table #___hikashop_config on the field order_number_format.
My format is set for SUM-{id size="5"}-{date format="Ymd"} which will result in something like this: SUM-01019-20160511

Hope that helps,

Kelso

We have the Business edition, but while I see the area to define the order numbering format in the configuration,
I can't figure out how to get the order sequence to begin at 8000.

The AutoIncrement field will need changed to 8000.
Here is a screen shot from phpMyAdmin. Do you have direct access to your database?



Kelso

Hi,

See AUTO_INCREMENT setting in your screenshot

Regards,

Yes, Jerome.

That message I sent to Nano as he was the OP.