SWANNB02 Posted May 21, 2012 Share Posted May 21, 2012 Hi, I have now had 4 orders placed, each and every order comes through showing an additional product added to the order. The shopping cart stage seems correct and does not show the additional item. However after payment (all have been via Paypal - but not important... I don't think) the order shows the same additional item on all four orders so far, please help?! I cannot understand how the item is added, it is like the controller/php file (not a website builder - I am a keen novice so probably wrong keywords/area) has a bug that adds this item. Also of note is that the item once clicked on (under the order screen in back office) it says that the item cannot be found. It was the first item I added to my catalogue, but has since been refined and updated etc. See the attached for different screen-shots (customer's personal details removed): SHOPPING CART - CORRECT ORDER - INCORRECT INVOICE - INCORRECT Thanks in advance, Brent Swann. Link to comment Share on other sites More sharing options...
ltempest Posted July 17, 2012 Share Posted July 17, 2012 (edited) I'm also getting this issue. No matter what I put in my cart once the order is completed and you view the order under Order history it has added an additional product, but does not seem to add it to the total price. What is going on! Please HELP! Lee PS Just to add, it is the same product that is being added everytime no matter what other product is actually purchased. Edited July 17, 2012 by ltempest (see edit history) Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 17, 2012 Share Posted July 17, 2012 Hi Lee, What product is being added specifically? Is it something you added to your Catalog manually? -Mike Link to comment Share on other sites More sharing options...
ltempest Posted July 18, 2012 Share Posted July 18, 2012 It is the same product every time I try a test order. it was added in the usual way along with all the other products in that category. I've unpublished it currently which has fixed the issue and will try adding the product again so its gets a different ID reference in the database, and test again. Lee Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 18, 2012 Share Posted July 18, 2012 It is the same product every time I try a test order. it was added in the usual way along with all the other products in that category. I've unpublished it currently which has fixed the issue and will try adding the product again so its gets a different ID reference in the database, and test again. Lee Let us know how that goes! -Mike Link to comment Share on other sites More sharing options...
ltempest Posted July 19, 2012 Share Posted July 19, 2012 There is something SERIOUSLY WRONG with either prestashop or my installation. I'm now getting random products added to my oder history. Have a look at the attached image, I only purchased the bottom item, and even though the price totals are correct, where is it getting the two other items from? PLEASE HELP, my client is ready to go live but not with this error happening. Lee Link to comment Share on other sites More sharing options...
SWANNB02 Posted July 19, 2012 Author Share Posted July 19, 2012 (edited) SOMEHOW I FOUND A SOLUTION: Went to the database file for php and deleted all product/order entries with the matching product number (in my case 001) and then because for me it was one product that kept showing up. I think that because I had done a few trial orders (all using the same product) myself and then deleted them all from Prestashop. Think that may have also partially been the problem. So I duplicated the product, then deleted the product that was causing issues. After doing that it seemed to be fixed? Sorry, hope this helps someone (or maybe a Prestashop specialist can help interpret this?). Don't know how it worked but it did. Thanks, Brent from www.breswaoutdoorfurniture.co.nz Edited July 19, 2012 by SWANNB02 (see edit history) Link to comment Share on other sites More sharing options...
Presta FABRIQUE Posted October 2, 2012 Share Posted October 2, 2012 Hi We also faced this problem on a shop lately, and this is what we think: the problem is due to test orders. After testing the shop, owner can delete orders with a simple trick (adding a line of code to AdminOrders.php does the trick), BUT - and here is the catch - only orders are deleted. This looks OK in BackOffice, but the situation in your database is much more complex and nested. Eg there is another table that holds order details and order history, and theese must be emptied too. Example: - order no. 1 had an ipod. this is saved in the order details table and order history too - owner deletes order no. 1 - owner decides to do another test order. Submits it, and will be ID no. 1 again - order page is OK but some other pages and emails are not, because they take the info from the details table, which now holds 2 lines of data for order no. 1 - and so on and on with every ID and every delete As a proposed solution (without checking because was easier to empty thoose tables): the request query should be changed where the list is problematic, so it takes only the last entry related to an order and not all. Hope this helps! Link to comment Share on other sites More sharing options...
ltempest Posted October 2, 2012 Share Posted October 2, 2012 Fabrique, Thanks for the explanation, can you tell me exactly which tables in the database you emptied to get back to a 'clean' database with no test orders? Thanks Lee Link to comment Share on other sites More sharing options...
fishingnet Posted October 26, 2012 Share Posted October 26, 2012 (edited) Hello ! See this post: http://www.prestashop.com/forums/index.php?/topic/197428-solved-customers-invoices-contains-items-which-have-not-been-ordered/page__view__findpost__p__980520 Edited October 26, 2012 by fishingnet (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted October 26, 2012 Share Posted October 26, 2012 Thank you fishingnet for the link to a solution that worked for you. I'm happy that you got your database fixed. This is almost always a database problem in which the orders database table is not cleared. 1 Link to comment Share on other sites More sharing options...
fishingnet Posted October 26, 2012 Share Posted October 26, 2012 Thank you fishingnet for the link to a solution that worked for you. I'm happy that you got your database fixed. This is almost always a database problem in which the orders database table is not cleared. And I thank you for your kindness and professional support ! Link to comment Share on other sites More sharing options...
Recommended Posts