walidon Posted August 20, 2014 Share Posted August 20, 2014 Dear all, Here is my problem; when a costomer makes an operation all is good and he gets a correct invoice, but for me in the admin area i have this like 360 euro plus paid (see attached pictures) and when I try to get an invoice i have the same error! see also attached picture.. we have two payment options bankwire and paypal (but it happens in both so i doubt it is related to them?) I wonder from where this cheque is appearing? and + why that ammount appears only in admin? thank you in advance for your help.. Link to comment Share on other sites More sharing options...
vekia Posted August 22, 2014 Share Posted August 22, 2014 hello you've got the same problem ALWAYS or only for certain of orders? Link to comment Share on other sites More sharing options...
walidon Posted August 22, 2014 Author Share Posted August 22, 2014 (edited) always and either for paypal or bankwire! just to add that i one cleared all order tests from the DB, and now I remember that some amounts resemble that of the deleted orders!!! Edited August 22, 2014 by walidon (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted August 22, 2014 Share Posted August 22, 2014 The correct amount up there is the second one? 12 935? And it says the customer paid 24? Are you using multiple currencies? Link to comment Share on other sites More sharing options...
walidon Posted August 22, 2014 Author Share Posted August 22, 2014 The correct amount up there is the second one? 12 935? And it says the customer paid 24? Are you using multiple currencies? the correct amount is 24 not 12935! no we use only Euro as a currency! Link to comment Share on other sites More sharing options...
NemoPS Posted August 22, 2014 Share Posted August 22, 2014 ah! wow. Ok, is the difference always identical? or does it chance following any pattern? Link to comment Share on other sites More sharing options...
walidon Posted August 22, 2014 Author Share Posted August 22, 2014 yes it is different each time P.S: just to add that i one cleared all order tests from the DB, and now I remember that some amounts resemble that of the deleted orders!!! Link to comment Share on other sites More sharing options...
NemoPS Posted August 22, 2014 Share Posted August 22, 2014 If you didn't clear order IDs everywhere, that's your issue Link to comment Share on other sites More sharing options...
walidon Posted August 22, 2014 Author Share Posted August 22, 2014 yes u r right! and as i guessed b4, the same amounts of the old orders (tests) which I thought i cleared, were still there! the problem was solved by starting invoices (new ones) from #20 and it works. any good way to clear orders with all the information. Link to comment Share on other sites More sharing options...
NemoPS Posted August 22, 2014 Share Posted August 22, 2014 Try running a query to erase everything from the order-related tables. And if you need to target specific ones use id_order > *number*. Make sure you reset the auto increment value for ps_orders then though Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
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