Set-up Invoice to #1

Hi guys,



How can i set up invoice to start again from number #1. ?

I can do it with orders, shipment but not for invoice.



Thanks

You will need to access your database directly, usually accessed via a control panel such as phpMyAdmin.



Please make a full backup of your database before editing anything.



View cscart_shipments table. Ensure the table is empty (ie. shipment_id of '1' is not already assigned).



Go to Operations tab.



Edit 'AUTO_INCREMENT' value to '1'



Done

[quote name='StellarBytes' timestamp='1338461970' post='137744']

You will need to access your database directly, usually accessed via a control panel such as phpMyAdmin.



Please make a full backup of your database before editing anything.



View cscart_shipments table. Ensure the table is empty (ie. shipment_id of '1' is not already assigned).



Go to Operations tab.



Edit 'AUTO_INCREMENT' value to '1'



Done

[/quote]



Thank you StellarBytes, works fine.

Have tried this in 2.2.3. nothing happened. Invoice number is still the same like before change. How to proceed?

[quote name='dozo' timestamp='1358541399' post='153137']

Have tried this in 2.2.3. nothing happened. Invoice number is still the same like before change. How to proceed?

[/quote]



Hi. What I was trying to achieve was to setup Invoice number back to number 1.



Make sure that u set up:

Admin / Settings / General / Initial order ID value - 1



Then go to phpadmin panel:

find table “cscart_shipments” and click on it



On top find “SQL” and paste into textarea this

ALTER TABLE cscart_shipments AUTO_INCREMENT =1

and press enter



It works also for 3.0.4, u can repeat it as many times u want

Need to delete all orders in dB too.

[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]Hi guys, i hav ethe ORDER ID, but need to give a field for the user to manage their own ID because the tribute company need the report of invoices done.[/size][/font][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]The think is the order generate a Order ID #1 and # to reporte company of tribute is #100002.

How i can manage other consecutive?[/size][/font][/color]