Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

orders appear successful but not in admin site


PattiH

Recommended Posts

Posted

When I add a new test customer and place an oder, the order appears to be successful and the emails are being sent where they should go, but only the customer is added in the admin section WITHOUT an order! It's like the order never happened. Please help!!! :(

Posted

You're probably getting an order with no order total. Check in your database in the orders table and see if there are orders there, then check in the orders_products table and the orders_total table.

 

You need to tell us which shipping module, which payment module, which contributions you have installed, etc.

Contributions

 

Discount Coupon Codes

Donations

Posted

I'm having the same problem now.

I'm troubleshooting it at the moment.

What sort of modules did you install?

 

Here are mind:

 

Multiple Store - Multiple Shop

VAT Display

Dutch language pack

STS Plus

 

I think it has something to do with Multiple store.

When I installed the second shop, something went wrong with the payment modules.

 

The shipping modules showed up well, bet nu the payment modules.

 

I have only the standard payment and shipping modules installed at the moment.

Posted
You're probably getting an order with no order total. Check in your database in the orders table and see if there are orders there, then check in the orders_products table and the orders_total table.

 

You need to tell us which shipping module, which payment module, which contributions you have installed, etc.

 

 

kqt: I have think that no orders are showing up, just as they dont at my site.

Therer are orders in the database, but they don't show up in the admin panel.

(I havea great problem now, since it's a live store.. (Ok i shoudn't edditted it yesterday evening..))

Posted
kqt: I have think that no orders are showing up, just as they dont at my site.

Therer are orders in the database, but they don't show up in the admin panel.

(I havea great problem now, since it's a live store.. (Ok i shoudn't edditted it yesterday evening..))

 

If you want help, you're really going to have to give more information. I know it's confusing, but there's no way myself or anyone else can know exactly what's happening.

 

You say orders are in the database. Well, is there an entry in the orders_total table for each order? Are there entries in orders_products? Are there entries in the other orders tables.

 

You said you edited the store. What did you change, exactly?

 

What exactly did you do just before the payment modules stopped working?

Contributions

 

Discount Coupon Codes

Donations

Posted
If you want help, you're really going to have to give more information. I know it's confusing, but there's no way myself or anyone else can know exactly what's happening.

 

You say orders are in the database. Well, is there an entry in the orders_total table for each order? Are there entries in orders_products? Are there entries in the other orders tables.

 

You said you edited the store. What did you change, exactly?

 

What exactly did you do just before the payment modules stopped working?

 

 

Thats the problem: I edited 2 much files and the uploaded it.

My dbase tables looks fine. Everything is there, execept the payment_method field in the orders table.

So thats where i think something went wrong. But i checked my files on the ftp server, and also missed some file, so i am restoring my old files, and i will look what is happening then.

 

 

Now i'm looking again at my database i see that the orders_total table is empty. That might be a problem also?

 

(I'm happy that i know something about dbses and php ;-) )

Posted

The empty orders_total table is why orders don't display in your admin. The query that displays orders does a join on the orders_total table. If that table is empty, guess how many records are pulled.

Contributions

 

Discount Coupon Codes

Donations

Posted

(When i enter the right order_id into the order_id field (under orders in admin) i do see the complete order!)!!

Posted

I also notice something remarkable here:

 

If i enter a new order, into the catalog, the subtotal and totals aren't displayed.

I think i'm missing a file there...

 

Will check it now.

Posted

I just received an order and here is what happened...

 

the order email came to me just fine.

when I open the Admin panel, it showed a new pending order.

when I click on "pending", there are no orders listed.

when I enter the order number I can see the order detail.

 

My store is set up to take Money Orders/Checks only, so there are no payment options for the customer.

 

Wierd but manageable if that's how it has to be, but I'd love to have it working correctly.

Posted

Ok i put my files back, but that wasn't the solution.

Something where better know> I have a subtotal in my cart again, but still no oder total at the checkout.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...