Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Export / Import Customer Orders


Recommended Posts

Hi all;


I have a situation I was wondering if anyone can help with. I've built a new website for my business and I'm trying to figure out a way to export my current list of customer orders over into the new website before closing the old site down. I don't want to import the entire database into the new one as it contains contribs that I don't need. Is there any way to just export/import the customer orders?

Any suggestions?


Happy Turkey Day,


Link to comment
Share on other sites



I am using phpMyAdmin 2.9.1 provided by godaddy.com to access my database and I don't know what you are using but when you are using export utility, you should be able to export single tables in your case: Orders, OrdersProducts, OrdersStatus, or any other Order tables.

Link to comment
Share on other sites

You will also need customer, addresses, order status the list goes on.......


Might be best to copy over the entire db and remove the tables/fields no longer required.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile


Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.


For links mentioned in old answers that are no longer here follow this link Useful Threads.


If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Thank you all 3 for replying. Most appreciated. Mike, I to am on godaddy now.

I've exported the following from my old database :



customers basket

customers basket attributes

customers groups

customers info


orders products

orders products attributes

order session info

order status

order status history

orders total


From what I can tell ( the database is still a semi mystery to me lol ) I've imported this files to the new database with the exception of the customers. I'm getting this MySql error


#1054 - Unknown column 'customers_group_id' in 'field list'


Help? Also, this will probably sound like a dumb question, but after importing the above files I should be able to view customers, orders etc via my Admin section yes? Right now I can only see them in the database.


Thanks for your help,


Link to comment
Share on other sites


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

  • Create New...