Wrong Date On Invoice And Shipment ?

[rbuelund]

Please see attached image. After having tampered with some settings around VAT all of a sudden invoices are not generated anymore (At least not correct). The date is not the correct date but has been set back to 01-11-2015 - also on the shipment?? What is going on here ??? Using latest 1.6.1.4

Also the invoice number shown is not correct - it should be #15 insted of 4 ???

Edited January 27, 2016 by rbuelund (see edit history)

[tdr170]

You have somehow crossed order id numbers take a look in the order tables of the database and I bet you will find it.

This may also need to be corrected in the cart tables.

[rbuelund]

Please see attached images of db tables - i cannot see where the crossing should be ??

 

I have not been altering in the database - so what is wrong here ??

[tdr170]

No I dont see it in these small snaps what you want to look for is either a order id cariier id customer in that was made on this date and see if you can find something crossed.

At one point I added orders from my online store to a new store I was working on and had some new orders showing older order info.

That is what made me think of this after looking and looking I finally found that teh cart ids were wrong for the new orders corrected in the database and all was well.

Im not guaranteeing this is the issue both worth taking the time ti investigate.

 

Look at teh orders with the wrong date find the order id cart id and invoice id and look through the database tables with this info and see if you find matching ids.

[eleazar]

I don't know how this error happened, but you will find the informations that Prestashop uses for the pdf invoice in the table ps_order_invoice, which is not among your posted images. However, it seems that from a certain point on the server didn't provide the correct date (and time?) to generate the time stamps stored in the database.

[rbuelund]

Ehmm.. my last image IS of the order_invoice table - and i cannot see any cross problems. All of a sudden the system just has started generating invoices with wrong number and date .... please help!

[eleazar]

I'm sorry, my bad!

However, I cannot reproduce this error.

[tdr170]

You say you messed around with VAT settings is this something you can undo, exactly what did you mess with.

 

The only way someone could help with this is to have complete access to your BO, Files and database and I am sure it won't be free and even then there is no guarantee.

 

Before you mess around to much make a backup of your shop and database, simply download the entire shop to your hard drive then export a copy of the database.

 

Now you can try things without the fear of making the shop completely unusable.

[rbuelund]

Ahhaaa.. got it now. There had been used a delete module which had messed up the tables - I managed to clean it up. Only 4 orders in the shop so not that big work :-)