Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Set-up Invoice to #1 Rate Topic   - - - - -

 
  • Maky
  • Advanced Member
  • Members
  • Join Date: 16-Nov 11
  • 71 posts

Posted 31 May 2012 - 05:52 AM #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

 
  • StellarBytes
  • Senior Member
  • Members
  • Join Date: 08-Aug 11
  • 1807 posts

Posted 31 May 2012 - 10:59 AM #2

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
Hire StellarBytes for CS-Cart Design & Development Services

 
  • Maky
  • Advanced Member
  • Members
  • Join Date: 16-Nov 11
  • 71 posts

Posted 01 June 2012 - 05:20 AM #3

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


Thank you StellarBytes, works fine.

 
  • dozo
  • Junior Member
  • Members
  • Join Date: 09-Aug 10
  • 10 posts

Posted 18 January 2013 - 08:36 PM #4

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

 
  • Maky
  • Advanced Member
  • Members
  • Join Date: 16-Nov 11
  • 71 posts

Posted 18 January 2013 - 08:58 PM #5

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


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

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11383 posts

Posted 18 January 2013 - 11:28 PM #6

Need to delete all orders in dB too.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • nick2474
  • Newbie
  • Members
  • Join Date: 31-Mar 11
  • 9 posts

Posted 09 April 2013 - 07:43 AM #7

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.
The think is the order generate a Order ID #1 and # to reporte company of tribute is #100002.
How i can manage other consecutive?