change the invoice number (how to decrease it?)

[Jaguaro]

Hi, by mistake I activated the invoice for some order that didn't need it.

So the invoice number increased when it shouldn't have.

Now I've just had an order where the invoice is actually needed. I changed the number via PHPMyadmin, but for the next invoices I don't know what to do. In the BO Invoices page I can only increase the invoice starting number, but it doesn't let me decrease it. What can I do?

Thank you in advance!

C

[vekia]

you have to change AUTO_INCREMENT value of the invoices table

check "structure" settings of table, you will see there option to decrease AUTO_INCREMENT counter

[Jaguaro]

Hi Vekia, thank you for your quick reply.

I noticed that the number in the ps_order_invoice and the invoice_number in the ps_orders table don't have the AUTO_INCREMENT option set, so I suppose it's Prestashop and not the db which should be edited.

Thanks,

C

[Jaguaro]

I noticed that the Order Class (/classes/order/Order.php) has a function called getLastInvoiceNumber() that selects the MAX number in the numbers row in ps_order_invoice table. So I have to manually edit the numbers in the orders which didn't need the invoice.

Thank you anyway.

public static function getLastInvoiceNumber()
	{
		return Db::getInstance()->getValue('
			SELECT MAX(`number`)
			FROM `'._DB_PREFIX_.'order_invoice`
		');
	}

[Jaguaro]

Do you know if there is a quick way to remove the invoice in an order?

[hatak]

just in the table ps_order

in row invoice number

delete number of invoice for that specific order

if you activated next invoices for next orders
just change their numbers

[Jaguaro]

Thank you!