Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

how to reset "new orders"


maury

Recommended Posts

hello...i'm using my old database on new oscommerce version...when i go in admin page i can see 20 "new" orders..but when i click on it and i go on "new orders page" there are not orders ( infact these 20 orders come from the old database"..someone can help me? how i can reset the "new order" ...

 

sorry for my bad english

 

 

thanks

 

Maury

Link to comment
Share on other sites

my tip on this thread should help you

http://www.oscommerce.com/forums/index.php?showtopic=213605

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

 

..ok..i found the id of the orders that i need to delete but which are orders tables?

 

these? :

 

orders

orders_products

orders_products_attributes

orders_products_download

orders_status

orders_status_history

orders_total

 

i have to click on them and delete where i found the id orders thati want to delete?

 

thanks for your help

 

Maury

Link to comment
Share on other sites

apart from order_status that list is correct. Order_status is a lookup table, witzh the staus names, no need to touch that one. the procedure you described is correct :-)

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

apart from order_status that list is correct. Order_status is a lookup table, witzh the staus names, no need to touch that one. the procedure you described is correct :-)

 

thank you

 

Maury

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...