Reset invoice numbers

Hi,

I made a lot of test and of course, invoice number in now reaching 44.

My website will be online tomorrow and I would like to reset invoice number to start again with number 1.

How can I do this ?

Thank you in advance

Nobody knows ??

The support on this forum is excellent, but there aren't any SLAs for replies.

I haven't got the system in front on me, but when I looked at the database a while ago, most of the IDs are mySQL auto increment attributes.

I'm guessing this is where the order number comes from. You need to be absolutely sure that you have cleared down all your test orders and then reset the auto increment value directly in mysql against the correct table and attribute. There will be loads on google for how to do this with mySQL depending on how you access your DB.

But I've never done this with HikaShop so attempt at your own risk and see if it does what you want. A backup first would be a good idea

Hello,

This email address is being protected from spambots. You need JavaScript enabled to view it. is right, you should clean your "hikashop_order" table with a "TRUNCATE TABLE" and delete all your test orders in your hikashop's backend.

Watch out with TRUNCATE TABLE if you replicate your database.

Probably fixed now, but mySQL couple of years back used to get into a right mess with the replication.

I prefer..
ALTER TABLE <table name> AUTO_INCREMENT = 1;

And as ALTER TABLE is DDL, you will prob have to do same to the replication DB.

If you don't replicate, then no worries.

Merci, ça marche

tony@10uk.net wrote: I prefer..
ALTER TABLE <table name> AUTO_INCREMENT = 1;