Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Orders Not Showing in Admin Section


captgary

Recommended Posts

I'm using 2.3.1 and have installed QTPro and Attribute add-ons. Just recently discovered that customer orders are showing on admin->customers->orders but only the price not the actual product that was sold. This occurs also on the customers history page. They can't see what product has been ordered.

Further investigation indicates the orders_products table is not being updated.

 

Anyone have any idea what I did wrong with the two add-ons?

 

Thanks,

Capt Gary

Link to comment
Share on other sites

1) you need to check if the order is recorded into mysql table

2) check the error logs

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites

OK...found the error. It was occurring in checkout_process.php file.

 

Here's what the piece of code looked like and was causing the error.

 

//++++ QT Pro: End Changed Code tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

$order_products_id = tep_db_insert_id();

 

Changed to........................

 

//++++ QT Pro: End Changed Code

tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

$order_products_id = tep_db_insert_id();

 

Don't know what the one line got to the above commented out like, but it works fine now.

 

Thanks for everyone's suggestions and help

 

Capt Gary

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...