Lumpia2 Posted December 16, 2008 Share Posted December 16, 2008 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 emptyProduct T1 $0.00Shipping $7.00Total with tax: $57.00what 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. Link to comment Share on other sites More sharing options...
Lumpia2 Posted December 16, 2008 Author Share Posted December 16, 2008 oh one more thing. Paypal receives the proper information and I am able to print a packing slip or invoice from there. hmmm... Link to comment Share on other sites More sharing options...
daser007 Posted January 10, 2009 Share Posted January 10, 2009 I am having the same issue. Anybody out there can help? It is very frustrating because I am receiving orders with no product info Link to comment Share on other sites More sharing options...
TropischBruin Posted January 10, 2009 Share Posted January 10, 2009 Make sure you TAX, Zones, Country's are setup correctly! Link to comment Share on other sites More sharing options...
msk69 Posted January 29, 2009 Share Posted January 29, 2009 got the same here now, worked fine before, now one order not showing the products.. also with paypal payment. Link to comment Share on other sites More sharing options...
TropischBruin Posted January 30, 2009 Share Posted January 30, 2009 New or existing customer? Link to comment Share on other sites More sharing options...
msk69 Posted January 30, 2009 Share Posted January 30, 2009 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... Link to comment Share on other sites More sharing options...
TropischBruin Posted January 30, 2009 Share Posted January 30, 2009 Is the zones and TAX setup for Germany correct? Link to comment Share on other sites More sharing options...
msk69 Posted January 30, 2009 Share Posted January 30, 2009 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.. Link to comment Share on other sites More sharing options...
msk69 Posted January 30, 2009 Share Posted January 30, 2009 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 FIRSTI 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. Link to comment Share on other sites More sharing options...
TropischBruin Posted January 30, 2009 Share Posted January 30, 2009 I still think it is related to a wrong setup of TAX and zones. Link to comment Share on other sites More sharing options...
msk69 Posted January 30, 2009 Share Posted January 30, 2009 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. Link to comment Share on other sites More sharing options...
msk69 Posted January 31, 2009 Share Posted January 31, 2009 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. Link to comment Share on other sites More sharing options...
ruilong Posted February 6, 2009 Share Posted February 6, 2009 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 Link to comment Share on other sites More sharing options...
msk69 Posted February 6, 2009 Share Posted February 6, 2009 Hi Ruilong, Sounds good, just checked and the product is indeed in the customers cart.Going to give it a go soon.Thanks! Link to comment Share on other sites More sharing options...
msk69 Posted February 6, 2009 Share Posted February 6, 2009 Works like a charm! Great solution.Thanks again! Link to comment Share on other sites More sharing options...
Bruno Leveque Posted February 9, 2009 Share Posted February 9, 2009 Hi,This is a great, quick & dirty fix 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, Link to comment Share on other sites More sharing options...
ruilong Posted February 9, 2009 Share Posted February 9, 2009 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. Link to comment Share on other sites More sharing options...
Julim76 Posted January 21, 2010 Share Posted January 21, 2010 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! Link to comment Share on other sites More sharing options...
shoulders Posted October 22, 2010 Share Posted October 22, 2010 possible solution here by meForum link Link to comment Share on other sites More sharing options...
arkwhat Posted October 22, 2010 Share Posted October 22, 2010 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 Link to comment Share on other sites More sharing options...
arkwhat Posted October 22, 2010 Share Posted October 22, 2010 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~ Link to comment Share on other sites More sharing options...
Juka Posted October 27, 2010 Share Posted October 27, 2010 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. Link to comment Share on other sites More sharing options...
MalaSilver Posted January 8, 2011 Share Posted January 8, 2011 Hi,This is a great, quick & dirty fix 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' Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted January 15, 2011 Share Posted January 15, 2011 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 Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted January 16, 2011 Share Posted January 16, 2011 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.3I hope that v1.4 already brings a solution for this problem...I'm attaching the file I made.AdminOrders.php Link to comment Share on other sites More sharing options...
Kenichi Posted January 22, 2011 Share Posted January 22, 2011 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.3I 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 Link to comment Share on other sites More sharing options...
pafka Posted January 27, 2011 Share Posted January 27, 2011 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... Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted January 27, 2011 Share Posted January 27, 2011 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?! Link to comment Share on other sites More sharing options...
pafka Posted January 28, 2011 Share Posted January 28, 2011 I talk about mySQL - admin.You must edit table ps_order_detail Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted January 28, 2011 Share Posted January 28, 2011 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!! Link to comment Share on other sites More sharing options...
PrestaGuesta Posted March 3, 2011 Share Posted March 3, 2011 My sql db doesn't have the field "reduction amount" can you give the parameters for this field as well?Thanks in advance Link to comment Share on other sites More sharing options...
acfour Posted March 18, 2011 Share Posted March 18, 2011 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. Link to comment Share on other sites More sharing options...
pafka Posted March 18, 2011 Share Posted March 18, 2011 ADD `reduction_percent` DECIMAL NOT NULL after `product_price`;ADD `reduction_amount` DECIMAL NOT NULL after `reduction_percent`; Link to comment Share on other sites More sharing options...
Doug77 Posted April 12, 2011 Share Posted April 12, 2011 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? ;-) Link to comment Share on other sites More sharing options...
kilrathi Posted September 20, 2011 Share Posted September 20, 2011 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 ... Link to comment Share on other sites More sharing options...
neomed Posted October 7, 2013 Share Posted October 7, 2013 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. Link to comment Share on other sites More sharing options...
tuk66 Posted October 8, 2013 Share Posted October 8, 2013 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. Link to comment Share on other sites More sharing options...
Rosha Posted February 3, 2016 Share Posted February 3, 2016 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? Link to comment Share on other sites More sharing options...
tuk66 Posted February 4, 2016 Share Posted February 4, 2016 Hard to say. You have to find the reason. It can be a module, core code or even server resources (timeout, memory). 1 Link to comment Share on other sites More sharing options...
Recommended Posts