Thread tagged as: Question, Shop

Reset invoice numbers

Is it possible to reset the invoice numbering? We've finished testing and are looking to go live but the client would like the invoices to start at 1 again, rather than the current number which has been set throughout testing.

Rob Saunders

Rob Saunders 0 points

  • 5 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

At the moment you would need to update that in the shop settings table in the database.

I dont have a shop settings table. I can see a perch settings table but nothing in there to do with invoices...

Drew McLellan

Drew McLellan 2638 points
Perch Support

The table is perch2_shop_orders_meta and the value is last_invoice_number

Perfect thank you!