Jump to content
SWANNB02

Product added to Order (not ordered/purchased), shopping cart correct.

Recommended Posts

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.

post-332604-0-20778400-1337567929_thumb.jpg

post-332604-0-53184500-1337567930_thumb.jpg

post-332604-0-97385600-1337567931_thumb.jpg

Share this post


Link to post
Share on other sites

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 by ltempest (see edit history)

Share this post


Link to post
Share on other sites

Hi Lee,

What product is being added specifically? Is it something you added to your Catalog manually?

 

-Mike

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

post-293463-0-25537900-1342712505_thumb.png

Share this post


Link to post
Share on other sites

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 by SWANNB02 (see edit history)

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

  • Like 1

Share this post


Link to post
Share on other sites

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 !

Share this post


Link to post
Share on other sites

×

Important Information

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