Jump to content
Lumpia2

Invoice not displaying purchased product.

Recommended Posts

Hi folks!

The invoice for one (maybe more) of my products doesn't display any product or charges except for the shipping.
It looks like this:


The product line is empty
Product T1 $0.00
Shipping $7.00
Total with tax: $57.00

what am I doing wrong? the only difference between this and the one other order is the size attribute, color attribute and a picture in the front end.

Share this post


Link to post
Share on other sites

oh one more thing. Paypal receives the proper information and I am able to print a packing slip or invoice from there. hmmm...

Share this post


Link to post
Share on other sites

I am having the same issue. Anybody out there can help? It is very frustrating because I am receiving orders with no product info

Share this post


Link to post
Share on other sites

got the same here now, worked fine before, now one order not showing the products.. also with paypal payment.

Share this post


Link to post
Share on other sites

New customer, german language, englisch is default.

No data of that order in PREFIX_order_detail.
hmm.... maybe gif it a go and try and add it manual...

Share this post


Link to post
Share on other sites

Yep, it is, worked fine before.

Just thought about a nice workaround. I'll make an order myself with the products the client orderd. (as can be seen from paypal luckily) and go into the database, and change the id_order field to the ordernumber of the client. So then the client order should show up with the products, and will wipe out the order i made myself..

Should work... going to give it a go now..

Share this post


Link to post
Share on other sites

Done.... Works like a charm... I know it's not a solution, but it's a workaround, if you're a bit familiar editing the database..
Actual it's quite easy to do, and if you do it..... BACKUP FIRST

I was also thinking of exporting those fields, and edit the id_order and id_order_detail (the last one has to get following up numbers which are not occupied yet) and import it to the database.
But with this last one i'm not sure if on next order everything will go alright... will try it once i got time on a testversion.

Share this post


Link to post
Share on other sites
I still think it is related to a wrong setup of TAX and zones.


Nope, i was wrong in my previous mail, it's an excisting customer, and previous order went fine. same payment methode.

Share this post


Link to post
Share on other sites

same client today, same story... maybe because he does not come back from paypal to the store? I knew this gave problems with Z.C.
Or out of stock product? i'm lost with this, as with other german clients with same kind of situation there is no problem.

Share this post


Link to post
Share on other sites

It can be that the modules/mailalerts/xx (xx for your language) is missing some mail templates.. this causes the products not to be loaded in the order during process. Check that folder.

I have attached a file for admin/tabs/adminorders.php that will display a simple button if no products is present on the order, pressing this button will reload the products from the cart.

let me know if it helps.

AdminOrders.php

Share this post


Link to post
Share on other sites

Hi Ruilong, Sounds good, just checked and the product is indeed in the customers cart.
Going to give it a go soon.

Thanks!

Share this post


Link to post
Share on other sites

Works like a charm! Great solution.

Thanks again!

Share this post


Link to post
Share on other sites

Hi,

This is a great, quick & dirty fix :P

Lot of code duplicate, I don't think that's a good idea.

We are working on this bug and try to find why order products are not shown.
This might be an error during PaymentModule.php process.

Best regards,

Share this post


Link to post
Share on other sites

Yes the big problem is that emails and stuff are done before the products are added to the order, so if there is an error the products are not added.
the most common error that happens is that the used languages mail templates for mailalerts are missing. but there could be other problems also.

Share this post


Link to post
Share on other sites

I am facing the same problem, I checked the taxes are correctly installed, shopping cart is showing the products, also the confirmation email. The main problem is that the PDF invoice does not show products and shop and delivery address.

It shows only amounts, taxes and logo as the attach.

Do somebody have any idea?

Many thanks!

17482_Xp31LynNR97JxXegpm8g_t

Share this post


Link to post
Share on other sites

I'm having the same issue.
also, when I click order detail for each client, it doesn't show product info NOR invoice.
order detail only can be found when I click 'cart'.
but once order is made, products in shopping cart should be empty showing all the product on order page?
all of order at my store have the same problem. I can find product ordered only from shopping cart and invoice doesn't show any product ordered at all.

please help me out to fix this problem.

PrestaShop™ - Administratio__.pdf

Share this post


Link to post
Share on other sites

I just uploaded adminorders.php from V.I.P and loaded the product into order. now, it works fine. BOTH invoice and products are displayed on order detail. Thanks~

Share this post


Link to post
Share on other sites

This solution works fine, but it keep happening on new orders, I checked the mailalerts lang are there for the language I use (US), it's getting really frustrated not seeing what people are ordering and having to use that solution to retrieve the order details.

Please help, I need an expert, I'll pay for your service.

Share this post


Link to post
Share on other sites
Hi,

This is a great, quick & dirty fix :P

Lot of code duplicate, I don't think that's a good idea.

We are working on this bug and try to find why order products are not shown.
This might be an error during PaymentModule.php process.

Best regards,


Have you guys found a solution for this problem?? I'm stuck with it too.. I can use the makeshift adminOrders.php, but for how long??

Also, if I use the modified adminOrders and try refunding items, I get 'fatal error'

Share this post


Link to post
Share on other sites
It can be that the modules/mailalerts/xx (xx for your language) is missing some mail templates.. this causes the products not to be loaded in the order during process. Check that folder.

I have attached a file for admin/tabs/adminorders.php that will display a simple button if no products is present on the order, pressing this button will reload the products from the cart.

let me know if it helps.


Ruilong's "patch" seems nice but it doesn't work very well... I tested it with a product of which I only have one unit. After submiting the order as client, I went to the back office to check the order and, as usual, the product was not displayed in orders tab. So I clicked in the button that ruilong created, the product showed up, but, at the same time it changed the status of the order to "On backorder". I (as a client) automatically recieved an email saying that the product was out of stock...

I really hope people from prestashop to fix this bug, because I cannot use ruilong's fix...

Many thanks

Share this post


Link to post
Share on other sites
It can be that the modules/mailalerts/xx (xx for your language) is missing some mail templates.. this causes the products not to be loaded in the order during process. Check that folder.

I have attached a file for admin/tabs/adminorders.php that will display a simple button if no products is present on the order, pressing this button will reload the products from the cart.

let me know if it helps.


Ruilong's "patch" seems nice but it doesn't work very well... I tested it with a product of which I only have one unit. After submiting the order as client, I went to the back office to check the order and, as usual, the product was not displayed in orders tab. So I clicked in the button that ruilong created, the product showed up, but, at the same time it changed the status of the order to "On backorder". I (as a client) automatically recieved an email saying that the product was out of stock...

I really hope people from prestashop to fix this bug, because I cannot use ruilong's fix...

Many thanks


Ok guys, I found a solution for the problem I was refering on the mesage above, just by removing a couple of lines from the code of Ruilong's AdminOrders.php. On top of that, you will find that his file is from the version 1.1, which has less features than the 1.3 version.

So I decided to embed the fixing code from Ruilong's file into the 1.3 file to have that "magic" button without loosing all the fancy features of v1.3

I hope that v1.4 already brings a solution for this problem...

I'm attaching the file I made.

AdminOrders.php

Share this post


Link to post
Share on other sites
It can be that the modules/mailalerts/xx (xx for your language) is missing some mail templates.. this causes the products not to be loaded in the order during process. Check that folder.

I have attached a file for admin/tabs/adminorders.php that will display a simple button if no products is present on the order, pressing this button will reload the products from the cart.

let me know if it helps.


Ruilong's "patch" seems nice but it doesn't work very well... I tested it with a product of which I only have one unit. After submiting the order as client, I went to the back office to check the order and, as usual, the product was not displayed in orders tab. So I clicked in the button that ruilong created, the product showed up, but, at the same time it changed the status of the order to "On backorder". I (as a client) automatically recieved an email saying that the product was out of stock...

I really hope people from prestashop to fix this bug, because I cannot use ruilong's fix...

Many thanks


Ok guys, I found a solution for the problem I was refering on the mesage above, just by removing a couple of lines from the code of Ruilong's AdminOrders.php. On top of that, you will find that his file is from the version 1.1, which has less features than the 1.3 version.

So I decided to embed the fixing code from Ruilong's file into the 1.3 file to have that "magic" button without loosing all the fancy features of v1.3

I hope that v1.4 already brings a solution for this problem...

I'm attaching the file I made.


Thank you!!!! This issue was making me crazy :P

Share this post


Link to post
Share on other sites

Add into ps_order_detail
aftter reduction_amount` add `group_reduction` decimal(10,2) NOT NULL default '0.00'
after ecotax add `ecotax_tax_rate` decimal(5,3) NOT NULL,
then I have order complete with products! Fantastic...

Share this post


Link to post
Share on other sites
Add into ps_order_detail
aftter reduction_amount` add `group_reduction` decimal(10,2) NOT NULL default '0.00'
after ecotax add `ecotax_tax_rate` decimal(5,3) NOT NULL,
then I have order complete with products! Fantastic...


Which file are you talking about?!

Share this post


Link to post
Share on other sites

I talk about mySQL - admin.
You must edit table ps_order_detail

Share this post


Link to post
Share on other sites
I talk about mySQL - admin.
You must edit table ps_order_detail


OMG! You are my hero!!

After changing the DB I updated AdminOrders.php to version 1.3.6 and now it works how it should!

Many thanks!!

Share this post


Link to post
Share on other sites

My sql db doesn't have the field "reduction amount" can you give the parameters for this field as well?

Thanks in advance

Share this post


Link to post
Share on other sites

I've tried all the fixes including the database fix but some of the parts in the database that need to be edited do not exist in my mysql database so I have no way of changing them?

I am willing to pay to get this fixed as this is becoming a really big problem can someone please contact me via PM to help.

Share this post


Link to post
Share on other sites

ADD `reduction_percent` DECIMAL NOT NULL after `product_price`;
ADD `reduction_amount` DECIMAL NOT NULL after `reduction_percent`;

Share this post


Link to post
Share on other sites

I have upload the AdminOerd.php and it works for the order. But I have notice that when I genarate the invoice (PDF) it has the wrong totals. Can some one help me with this issue? ;-)

Share this post


Link to post
Share on other sites

Hi...i think i solved this matter simply by just Disabling Invoices @ ORDERS > INVOICES, and Re-enabling it again.. and it worked ! Please do try it ...

Share this post


Link to post
Share on other sites

No matter what I do, it doesn't work, it looks like the content of the order_details table is gone. How could this happen?? Is there a way to get it back? Thanks.

Share this post


Link to post
Share on other sites

ADD `reduction_percent` DECIMAL NOT NULL after `product_price`;

ADD `reduction_amount` DECIMAL NOT NULL after `reduction_percent`;

The fields in all "order" tables, ps_order_detail including, are changed many times in v1.4 and 1.5.

 

I think it is quite dangerous just to add new fields to one of these tables. Rules and amounts are changed and hugely depend on your version. Even the old orders and new ones are different after shop upgrade.

 

Trust me, I know it very closely because I have to solve this in my modules very often.

Share this post


Link to post
Share on other sites

Hi!

I have installed prestashop 1.6.1.4. and i have this issue.

after installation and enabling mail alert the orders doesn't show in the order page!

what can i do to fix this problem?

Share this post


Link to post
Share on other sites

Hard to say. You have to find the reason. It can be a module, core code or even server resources (timeout, memory).

  • Like 1

Share this post


Link to post
Share on other sites

I had this same problem recently and it was solved by uninstalling and reinstalling the paypal module. Even the paypal website was having problems when I tried to log in to get all the paypal password and signature id info. Paypal said Microsoft Edge and Chrome are incompatible with their website, hence why paypal site was giving me error messages and I couldn't get the signature info. After reinstalling the paypal module and re-entering all the info, the invoices print normal.

 

Now I need to modify and add the product description to a few past invoices which customers are asking for.

 

Can someone please tell me how to add the product name and the rest of the info on the row in the Invoice area where product row normally shows it all? I am in PhpMyadmin searching around near ps_order_ . .  but I don't know where to add the product name or if it is possible.

 

Thank you if someone can help.

Edited by marcstirbl (see edit history)

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More