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 5 replies - 1 through 5 (of 5 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

    Thread Starter catwingz

    (@catwingz)

    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

    Thread Starter catwingz

    (@catwingz)

    @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)

    @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 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How to Migrate Cart Orders’ is closed to new replies.