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]