Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sql cleanup for going live


ignatius

Recommended Posts

Posted

I have entered all my products and done my tesing. Now that i am going live, what do i need to cean out from the database? I tried emptying orders but when new orders are placed. it all gets automatically marked as delivered. I am afraid i might empty the wrong things. Could anyone direct me in the right direction?

 

I just need to keep everything to do with products and configuration and just need to clear up all the test orders that accumulated over the last 2 months

Posted

You can clean all tables that names begin with 'orders' with phpMyAdmin or something. This will erase ALL orders.

There is always more than one way to do it.

And always Keep It Simple, Stupid.

Posted

i have tried that but somehow when new orders are placed, their status is automatically set to delivered and it seems to mess up the order status. or am i missing out something?

Posted

The orders_status table should not have been emptied. That contains configuration data.

Posted

To change the status your orders default to, you need to change your settings in your admin.

 

1) go to your admin

 

2) Go to Localization

 

3) Go to Orders Status

 

 

You must make a decision as to what you want your default to be. For simplicity's sake, I use pending. Here is how you change the default.

 

1) Click on the pending line

 

2) Click edit

 

3) Click the "set as default" box.

 

4) Click update

 

 

If you want to add a different status name:

 

1) click insert

 

2) type the name of the new status

 

3) If you want it as default, be sure to click the set as default box.

 

 

Your orders should fall into the deafult status now. :wink:

 

 

 

Mark

Archived

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

×
×
  • Create New...