Orders not shows correctly after update...

[ziggy]

Hi need some advice

i have recently updated and found a problem....

i inserted my old db into the new installation upon completion of installation ..as you do..

only to find that when a pre-existing customer places a new order the only record that i have to this order is the paypal email i receive, (it does not show in the orders panel, no emails received).
I then have to click into the customer tab find the customer who ordered, click into details and find the order in the orders window, (see img 1)

if i then click the order it shows me the order details with a payment set to awaiting bank wire transfer, also in the order summary the product detail is 0.00 and only the shipping shows along with the total..(see img 2)

further down the the order page in the product summary box no summary details appear...(see Img 3).

if it is a new customer creating a new account etc it works as it should, product updated, emails received etc..

any advice would be appreciated..

Thanks...
hope i have provided concise and clear documentation to this problem...

Attached File(s)

•  img1.jpg (75bytes)
  Number of downloads: 536
•  img2.jpg (88bytes)
  Number of downloads: 523
•  img3.jpg (61bytes)
  Number of downloads: 512

what's the point of a forum if nobody moderates or at least trys to help...
maybe prestashop should rename this to a bulletin board
and we could all charge for being software testers...

I have not came across the same problem sorry. The help here is offered for free - in my case I just don't have the time overwritting a new installation with an old database (I don't even know what presta version did you had before and after) and then check what happens.

So in my opinion help will come if someone is familiar with your problem.

Till then what was the version of the prestashop for your old database? and what's the version of your new prestashop?

Original install Version 1.1.x upgraded to 1.2.5

Ziggy, I hear you...but they do a "great" job moving a post submitted on the wrong forum and letting you know about it.
I had all kind of problem upgrading from 1.1 to 1.2.5.
- check the languages to see if you are missing some files.
- if you overwrote the "mails" put the defaults one first, then overwrite them 1 by 1 and test.
- I tried to check the difference between my DB and a "new" default prestashop DB: I'm still waiting for an answer on that post.
- I had phantom order from Paypals (they were recorded on paypal, not presta): I deleted everything and recreated my setup in prestashop and paypal...it seems OK BUT you must keep "Consider the associated order as validated" for the status "Payment accepted"...

hope that will help

your right about that...its like stealth moderation...

now all my orders arrive as awaiting bank payment.. and i cant view the order at all .. this is frustrating and annoying.....

after some investigation ... prestashop is not writing to the ps_order_detail Table....

try to change you invoice statuses.
maybe try remove the payment module you are using, ftp back the directory to your site, re-install it.

Did you find out how to solve this problem? I have a similar problem though mine is not exactly the same.

hi i think i did but i need more testing with live orders ...

i just uninstalled the bank wire module in the payments module section.... and my test orders worked o.k
but will need to verify with real orders....

to fix the cms for orders that have come through and show no detail i.e picture 3 you need to manually update the order_detail table in the db via Navicat etc.. some of the information you need will be found in the orders ps_Orders table i.e id_cart etc

Hope that helps for now ... as i said before not sure if its fixed permanently...time will tell....

let me know how you get on with testing this fix

Ziggy, it seems consistent with me , except it was with Paypal. Once I uninstalled and re-installed and re-did the setup, it seems to work fine.

did you have the same problem as me...

yes, kind of : phantom orders...meaning I could seem them n my Paypal account, but nothing in Presta.

and are your new test orders showing correctly....

I have same problem and affther update you need add one line to DB

ALTER TABLE `ps_order_detail` ADD `product_quantity_in_stock` INT( 10 ) NOT NULL DEFAULT '0'

in ps_order_detail table :)

i already have this column in my order_detail table... please see image

Attached File(s)

•  order_detail_grab.jpg (96bytes)
  Number of downloads: 405

so...any one else with anything else for the solution?

I'm having same problem with a fresh 1.2.5.0 install.

Just tried a simple Paypal order and when returning to the site, it says there's no orders in the history.

Validation URL is fine. Permissions are checked and fine.

is the cart having the order? are you using paypal IPN?

After returning from Paypal, the order is still in the cart. I tried with and without Paypal IPN and it doesn't make any difference, though I think maybe with IPN enabled the order would disappear from the cart afterward. However, either way it doesn't show up in the backoffice orders history so it doesn't matter.

I have actually resorted to editing the order-confirmation.php redirects to point to a CMS page explaining that the Prestashop paypal interface is broken and that they should not expect to see the orders show up in their history. Sad.