Where are my orders. Orders not showing in Customer > Orders

[frannyp]

My cart works fine as far as processing orders. They go through Authorize.net, and we are notified that we have a new order by email.

 

They are not showing up in the Admin area of the cart so that we can manage them as shipped etc.

 

Can anyone help me with this?

 

Fran

[boxtel]

My cart works fine as far as processing orders. They go through Authorize.net, and we are notified that we have a new order by email.

 

They are not showing up in the Admin area of the cart so that we can manage them as shipped etc.

 

Can anyone help me with this?

 

Fran

 

if you receive an email (from checkout I presume) then the order should be in the tables.

Myabe they have been given a status id which is not present in your orders_status table.

[lorilepow]

I'm having the exact same problem. This just started occurring on our site around a week ago and has occurred with every order since then.

 

The order is placed, I get an email confirming it, as does the client.

 

However, when I go into Admin >> Customers >> Orders, none of the new orders show. However, the interesting thing is that I can actually go up to the corner and input the order number manually (from the email) and it WILL come up. This appears to be strictly a display issue, obviously the order is still in the database.

 

Lori

[boxtel]

I'm having the exact same problem. This just started occurring on our site around a week ago and has occurred with every order since then.

 

The order is placed, I get an email confirming it, as does the client.

 

However, when I go into Admin >> Customers >> Orders, none of the new orders show. However, the interesting thing is that I can actually go up to the corner and input the order number manually (from the email) and it WILL come up. This appears to be strictly a display issue, obviously the order is still in the database.

 

Lori

 

and the status of those orders is?

[lorilepow]

and the status of those orders is?

 

The status of all the orders is "pending" which is a valid status. Any other ideas?

[ptouch]

I am having this same problem. anyone find the solution. even in my paypal i doesn't tell me what the person ordered.

[boxtel]

I am having this same problem. anyone find the solution. even in my paypal i doesn't tell me what the person ordered.

 

 

the default orders query is:

 

$orders_query_raw = "

select o.orders_id,

o.customers_name,

o.payment_method,

o.date_purchased,

o.last_modified,

o.currency,

o.currency_value,

s.orders_status_name,

ot.text as order_total

from " . TABLE_ORDERS . " o left join

" . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id),

" . TABLE_ORDERS_STATUS . " s

where o.orders_status = s.orders_status_id

and s.language_id = '" . (int)$languages_id . "'

and ot.class = 'ot_total'

order by o.orders_id DESC";

 

so put an

 

echo $orders_query_raw;

 

after this and see what the actual query is.

with that query you can look in phpmyadmin whether you find anything and why (not).

[CCastell]

Can I join in on this one too... it's not every order, but most of them - oddly enough I cannot replicate it myself. My test orders are showing ok, and we have had purchased made through Paypal, Protx & 'cheque' which have worked but equally have had purchased that don't show in the orders.. confusing?

 

I'm working through the obvious - operating system, cookie, etc issues, but as yet have found no consistency in them working/not working so any light that could be shed on this would be good!

 

??

[boxtel]

the default orders query is:

 

$orders_query_raw = "

select o.orders_id,

o.customers_name,

o.payment_method,

o.date_purchased,

o.last_modified,

o.currency,

o.currency_value,

s.orders_status_name,

ot.text as order_total

from " . TABLE_ORDERS . " o left join

" . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id),

" . TABLE_ORDERS_STATUS . " s

where o.orders_status = s.orders_status_id

and s.language_id = '" . (int)$languages_id . "'

and ot.class = 'ot_total'

order by o.orders_id DESC";

 

so put an

 

echo $orders_query_raw;

 

after this and see what the actual query is.

with that query you can look in phpmyadmin whether you find anything and why (not).

 

so basically:

 

the orders_id in the orders table needs to match the orders_id in the orders_total table

 

and

 

the status in the orders table needs to match a status in the orders_status table

 

and

 

the language id in that orders_status table occurrence needs to match the language you are using in admin

 

 

so my bet is still on the status

[CCastell]

Thanks Boxtel... as near as I can see the database is the same as what is reported by the shop reports.. I'll need to get a note the 'fails' so that I can try and find them...

 

back the drawing board

 

C

[ptouch]

boxtel

sorry i'm soooo a newbie and i'm not sure what youre tellin me i need to do. do i need to change a file?> i'm not using myphpadmin yet. i'm using dreamweaver .

[boxtel]

boxtel

sorry i'm soooo a newbie and i'm not sure what youre tellin me i need to do. do i need to change a file?> i'm not using myphpadmin yet. i'm using dreamweaver .

 

for the default orders list this query is performed:

 

select o.orders_id,

o.purchased_without_account,

o.customers_name,

o.customers_id,

o.payment_method,

o.date_purchased,

o.last_modified,

o.currency,

o.currency_value,

s.orders_status_name,

ot.text as order_total

from orders o left join orders_total ot on (o.orders_id = ot.orders_id),

orders_status s

where o.orders_status = s.orders_status_id

and s.language_id = '6'

and ot.class = 'ot_total'

order by o.orders_id DESC

 

(language id as only variable)

 

if you type in the order id in the orders search box this query is performed:

 

select orders_id

from orders

where orders_id = '12'

 

so very simple just on the id afterwhich the order class is setup with all the other relevant info also based solely on the id.

 

 

so if you can find the order using a search on the order id but not in the default list then the only reasonable explanation is in a deviation in the orders_status table.

That is, the status the order is given does not exist in that table at all or for the language used in admin (orders_status_name field).

[Guest]

I´m having the same problem. I found that order_total table is empty. Why, I don´t know ...

[Guest]

I found a solution to my problem

 

http://www.oscommerce.com/forums/index.php?showtopic=125432 Post #4