PrestaShop Forum

The best place in the world to ask questions about PrestaShop and get advice from our passionate community!

PrestaShop Forum

Jump to content

 

Orders not shows correctly after update...

24 replies to this topic
#1
ziggy

    PrestaShop Newbie

  • Members
  • Pip
  • 23 posts
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 Files

  • Attached File  img1.jpg   75bytes   536 downloads
  • Attached File  img2.jpg   88bytes   523 downloads
  • Attached File  img3.jpg   61bytes   512 downloads


#2
ziggy

    PrestaShop Newbie

  • Members
  • Pip
  • 23 posts
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...

#3
Radu

    PrestaShop Addict

  • Moderators
  • 572 posts
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?

#4
ziggy

    PrestaShop Newbie

  • Members
  • Pip
  • 23 posts
Original install Version 1.1.x upgraded to 1.2.5

#5
L. Brett Sinclair

    PrestaShop Apprentice

  • Members
  • PipPip
  • 320 posts
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
Tout sur la Country avec
www.Country-Cowboy.com

Blanchiment des dents avec
www.DentsDeStars.com
:cheese:

#6
ziggy

    PrestaShop Newbie

  • Members
  • Pip
  • 23 posts
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.....

#7
ziggy

    PrestaShop Newbie

  • Members
  • Pip
  • 23 posts
after some investigation ... prestashop is not writing to the ps_order_detail Table....

#8
L. Brett Sinclair

    PrestaShop Apprentice

  • Members
  • PipPip
  • 320 posts
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.
Tout sur la Country avec
www.Country-Cowboy.com

Blanchiment des dents avec
www.DentsDeStars.com
:cheese:

#9
harial

    PrestaShop Newbie

  • Members
  • Pip
  • 24 posts
Did you find out how to solve this problem? I have a similar problem though mine is not exactly the same.
SL Publishing Group
Book Shoppe

#10
ziggy

    PrestaShop Newbie

  • Members
  • Pip
  • 23 posts
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

#11
L. Brett Sinclair

    PrestaShop Apprentice

  • Members
  • PipPip
  • 320 posts
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.
Tout sur la Country avec
www.Country-Cowboy.com

Blanchiment des dents avec
www.DentsDeStars.com
:cheese:

#12
ziggy

    PrestaShop Newbie

  • Members
  • Pip
  • 23 posts
did you have the same problem as me...

#13
L. Brett Sinclair

    PrestaShop Apprentice

  • Members
  • PipPip
  • 320 posts
yes, kind of : phantom orders...meaning I could seem them n my Paypal account, but nothing in Presta.
Tout sur la Country avec
www.Country-Cowboy.com

Blanchiment des dents avec
www.DentsDeStars.com
:cheese:

#14
ziggy

    PrestaShop Newbie

  • Members
  • Pip
  • 23 posts
and are your new test orders showing correctly....

#15
fxtc

    PrestaShop Newbie

  • Members
  • Pip
  • 8 posts
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 :)

#16
ziggy

    PrestaShop Newbie

  • Members
  • Pip
  • 23 posts
i already have this column in my order_detail table... please see image

Attached Files



#17
muktadir

    PrestaShop Apprentice

  • Members
  • PipPip
  • 166 posts
so...any one else with anything else for the solution?
Yet another prestashop store for prestashop :)
http://www.prestaworld.com/

#18
eknepfler

    PrestaShop Newbie

  • Members
  • Pip
  • 12 posts
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.

#19
muktadir

    PrestaShop Apprentice

  • Members
  • PipPip
  • 166 posts
is the cart having the order? are you using paypal IPN?
Yet another prestashop store for prestashop :)
http://www.prestaworld.com/

#20
eknepfler

    PrestaShop Newbie

  • Members
  • Pip
  • 12 posts
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.