Support » Plugin: WordPress Simple PayPal Shopping Cart » How to Migrate Cart Orders

  • Hi, we’re about to launch a new site based on a clone of the old site. The problem is that several months have passed and new transactions are missing from the soon-to-be-public website.

    I have a feeling this is going to call for database surgery, but how can we migrate the new transactions to the new site? As of now there are 68 missing records.

    Thank you

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi,

    I have a feeling this is going to call for database surgery, but how can we migrate the new transactions to the new site? As of now there are 68 missing records.

    You can export the cart orders using Export Data button found in Tools tab.

    Would the above help you with your issue?

    Thank you

    Hi,
    That sounds like a good start. How do I import the data into the new site?

    Thank you

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, you can use the following plugin

    https://wordpress.org/plugins/wp-csv-to-database/

    You can also read the following documentation how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin to help you further if the above plugin does not work for you.

    Let me know if you need more information or help.

    Thank you

    First, you need to export data from your old site to CSV files then use an automated migration tool to transfer all these CSV files to your new store on WordPress.

    During the migration process, your store is running normally so that you still receive new orders and customers. You want to move new data to your WordPress site so you need to use Recent Data Migration service to do it automatically (for free).

    woocommercemigration

    (@woocommercemigration)

    Yes, you can either migrate directly from your database to your new store or you can migrate from your database dump (in the case your site is no longer in operation).

    This can avoid information lost during the transfer process.

    This can be donw in a few hours with the help of an automated migration tool.

    This tool helps you migrate while your current store is still be up and running normally. Then after that you can migrate your newly-came data (orders, customers,..) to your new clone site without any additional cost.

    Good luck!

    @mbrsolution, we have switched over to the new site this is a final detail I am hoping to attend to. I exported the current records and have the WordPress CSV to Database plugin installed. The problem is I don’t know which database table to target for the import of the csv. There are a lot of fields and none appear to correspond with the available options. Please advise.

    thank you

    Plugin Author mra13

    (@mra13)

    @woocommercemigration and @joshcardoso1009, Why you spamming this thread?

    Plugin Author mra13

    (@mra13)

    @catwingz, The orders actually go into a custom post type called “wpsc_cart_orders”.

    Unless you are an expert, the best option is to migrate the full database (all tables) of your site. Using PHPMyAdmin tool is the best for this. It can simply export all your data from Site A then you can import that data into Site B. It will be an easy transition. Otherwise it will get too complicated.

Viewing 8 replies - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.