Regenerate invoices

[nibianaswen]

Hi,

in a period where the "enable invoices" had been turned off is possible to regenerate invoices for the orders processed? 

"Generate PDF by date" under invoices only create invoice for order that are processed when the option is enabled. 

 

thanks

[nibianaswen]

i found the solution. search in orders & invoice_order tables

 

close thanks

[Solver]

What you need exactly? you need to generate invoices for old orders only?

[nibianaswen]

yes but in a period where the "enable invoice" are turned off. But i found the solution looking the structure of the db, specifically the two table that i have mentioned

[Solver]

There many tables in database with prefix invoice and order, if you want tooch order_invoice you may modify all other tables.

[nibianaswen]

yes, but i'have found the right tables. Issue solved. Topic can be closed.

[maxclee]

On 11/7/2020 at 9:59 AM, nibianaswen said:

yes, but i'have found the right tables. Issue solved. Topic can be closed.

could you please give us more details ?  how i can change this, i have on severals invoices wrong EAN 

[maxclee]

ok i found solution by myself :  

UPDATE `ps_order_detail` SET `product_ean13`="XXXXXXX" WHERE `product_id`="XXX"  

but i found strange that we have no possibility to regenerate invoices 

[Yulia Vitun]

Partial Solution on How to Regenerate an Invoice (checked on PS 8.1.2):

Run this link in your browser and replace highlighted text as mentioned below: https://your.site/admin/index.php/sell/orders/1234/generate-invoice-pdf

Note:

1. change the name of your.site

2. replace admin with actual admin folder name from your back office

3.  replace 1234 with actual order number found in your back office

N.B. this will generate invoice with IN000000 number, but will not update/save it in database

May be somebody knows how to update database with invoice, so that customer can download the invoice from their account page?

Edited December 22, 2023 by Yulia Vitun (see edit history)