Regenerated Invoice that was only partially created and a double order

[lukewood]

Hi,

I have received an order that has been paid for. The status has been updated to payment accepted. Normally, a document symbol will appear by the order that allows me to download an invoice. This is missing.

I can create an invoice by selecting 'Generate PDF Invoice by Date' using the invoices tab. However, the invoice only lists one of the 15 purchased items. Unfortunately, the customer has received this incorrect invoice through email.

Is it possible to manually delete this invoice from the system and create a new one manually?

I also had another issue where one order was created twice. I cancelled the order as shown in the screenshot. However, it messed up my inventory because when I cancelled, the items were added back to the stock even though they had already been updated by the first order. So I had to manually remove the items from the stock.

Any help would be greatly appreciated.

Regards,

Luke

[datakick]

On 1/17/2019 at 6:58 AM, lukewood said:

Frontcontroller::init - Cart cannot be loaded or an order has already been placed using this cart

This is really harmless debug message. In fact, I'll drop it from the code in the next version, as it does not help anyone.

It can mean one of two things:

1) visitor's cookie contains reference to a cart that not longer exists in your database. This can happen, for example, when some module removes abandoned carts from the database.

2) visitor's cookie contains reference to a cart that has been already converted to an order. This will usually happen on order confirmation page.

In both cases we just need to remove cart reference from cookie and carry on. Neither of these are bug, and I don't see any reason why it should fill merchant's log

[lukewood]

Hi,

Just to update. I believe I have figured out how to fix the problem manually. The values in entries in two MYSQL tables were blank:

• tborders.invoicenumber contained a 0. I entered the correct invoice number from tborderinvoice.idorderinvoice

• tborderdetail.idorderinvoice for all the purchased products also contained 0s. I added the invoice numbers to all the products.

I would really appreciate input from someone who understands the coding. First of all, when is the invoice number added is it when the status is changed to payment accepted or once the order has been placed? Are there any other entries to check that I haven't thought of that may not have been written to the database? Are there any implications for changing these numbers manually? What could cause this glitch?

Any help would be greatly appreciated. Thanks so much.

Kind regards,

Luke

[lukewood]

In case it is any use, the following was in the error log from the same IP address that ordered:

PHP Notice: Undefined index: ogtype in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://www.domain.my/quick-order?step=1 PHP Notice: Trying to get property of non-object in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://www.domain.my/quick-order?step=1 PHP Notice: Undefined index: ogtype in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://live.adyen.com/hpp/pay.shtml PHP Notice: Trying to get property of non-object in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://live.adyen.com/hpp/pay.shtml PHP Notice: Undefined index: ogtype in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://www.domain.my/quick-order PHP Notice: Trying to get property of non-object in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://www.domain.my/quick-order PHP Notice: Undefined index: ogtype in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://3dsecure.hlb.com.my/ImsControl.do PHP Notice: Trying to get property of non-object in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://3dsecure.hlb.com.my/ImsControl.do PHP Notice: Undefined index: ogtype in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://www.domain.my/order-confirmation?idcart=290&idmodule=132&idorder=54&key=521fc88b0b3514344a63b23095b4676a PHP Notice: Trying to get property of non-object in /html/vendor/smarty/smarty/libs/sysplugins/smartyinternaltemplatebase.php(157) : eval()'d code on line 38, referer: https://www.domain.my/order-confirmation?idcart=290&idmodule=132&id_order=54&key=521fc88b0b3514344a63b23095b4676a

[lukewood]

Dear All,

I also noticed that I have a lot of these alerts;

Frontcontroller::init - Cart cannot be loaded or an order has already been placed using this cart

Could this be causing the problem? I am running 1.0.7

Regards,

Luke

[wakabayashi]

In my BO log I have similair warning: Warenkorb kann nicht geladen werden. Eine Bestellung mit diesem Warenkorb ist bereits vorhanden. Thats not good, but I don't think it's the reason for the problem.

[lukewood]

Thanks for helping me rule it out. 

[lukewood]

Just in case anyone reads this in the future, this was actually an Adyen Payment module that was causing the issues. Nothing to do with Thirty Bees. Is there a way to mark this a closed or solved?

 

Edited January 31, 2019 by lukewood