Vilas Posted August 4, 2014 Share Posted August 4, 2014 (edited) Hello Friends, I am trying to set order number from 1. I tried that set invoice number option. I have used delete number free module. I am getting error massage as " Invalid invoice number.1008)" Will be great if anyone do needful. Thanks Edited August 5, 2014 by Vilas (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted August 4, 2014 Share Posted August 4, 2014 On 8/4/2014 at 4:35 PM, Vilas said: Hello Friends, I am trying to set order number from 1. I tried that set invoice number option. I have used delete number free module. I am getting error massage as " Invalid invoice number.1008)" Will be great if anyone do needful. Thanks hello what you mean by "I am trying to set order number from 1." ? how you're trying to set invoice number to 1? Link to comment Share on other sites More sharing options...
Vilas Posted August 4, 2014 Author Share Posted August 4, 2014 I have used your module only to delete all test orders. After deleting all orders, I went to set invoice number option through the backend panel. i.e. in orders - invoices - set order number. But after putting 1 over there I am getting above error massage. Link to comment Share on other sites More sharing options...
vekia Posted August 4, 2014 Share Posted August 4, 2014 hello you need to reset invoices counter (auto_increment) in ps_orders_invoice table there is no other way to achieve it, even with or without module Link to comment Share on other sites More sharing options...
Vilas Posted August 4, 2014 Author Share Posted August 4, 2014 Do I have to select all values which are under "`ps_order_invoice" & have to delete am I right? Link to comment Share on other sites More sharing options...
vekia Posted August 4, 2014 Share Posted August 4, 2014 yes, remove invoices, and restore auto_increment value to "1" in phpmyadmin there is an option to "TRUNCATE" table, this option does all of this with one mouse click Link to comment Share on other sites More sharing options...
Vilas Posted August 5, 2014 Author Share Posted August 5, 2014 Done. Thanks vekia for your kind support. Have a nice time ahead. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now