Merging 2 WC install to one

  • Resolved esquipulas

    (@esquipulas)


    4 years ago

    Hi there, cuestion is about merging two independant WC install to one (the second one being merged with the first one).

    As far I know, customers, products and products variations, orders have a unique ID auto generated by WC.

    My concern is to keep the ID’s attributed by the second install on the merged install, mainly to allow customers of the second one now merged to keep trace of what they did.

    Obviously there is duplicates ID’s beetween the two install also. Not a lot but some.

    Is there any clean solution to do that ? And, in that case, can you enlight me ?

    Thanks by advance,

    Regards,

    Eric

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

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hi Eric,

    Great question. I would encourage you to take a look at the Customer/Order CSV Import Suite and the Customer/Order/Coupon CSV Export extensions.

    https://woocommerce.com/products/customerorder-csv-import-suite/
    https://woocommerce.com/products/ordercustomer-csv-export/

    They will allow you to export the customers and orders from one site to another one. It will handle the IDs for you. Otherwise those could be a problem since WordPress automatically assigns them to content on the site like orders and users. They could be duplicated which would cause problems.

    Both extensions come with a 30 day refund window so you can give it a try and see if it works for you. If not, you can get your money back.

    Let us know if you have any questions.

    Thread Starter esquipulas

    (@esquipulas)

    Hi Threesons, thanks for your answer. I know the extensions, a little bit expensive (need both) but why not. But, what do you mean by “handle the IDs” ? Are they allowing new IDs or are they keeping the old ones ?

    And, as you mention, in that case how manage dups ?

    Thanks by advance,

    Eric

    Good question. The import/export will handle the IDs for you so there aren’t any duplicates with the orders or customers. The orders especially have data stored across a few tables in the database. It’s helpful to have a plugin that’s designed to pull all of that information for you so that you don’t have to do it manually. It will also make sure that the IDs work correctly in their new database.

    They are a bit expensive, but they should do the trick.

    seank123

    (@seank123)

    Order, customer, product and variation IDs are all, essentially, WordPress post IDs – they are required to be unique or the data will be messed up!

    You are going to have to pay for a plugin that is specifically designed for this! There a quite a few on CodeCanyon that are less expensive: https://codecanyon.net/search/woocommerce%20import

    Plugin Support abwaita a11n

    (@abwaita)

    Hi @esquipulas,

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, the above info and plugin recommendations were helpful!

    If you have further questions, please feel free to open a new topic.

    Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Merging 2 WC install to one’ is closed to new replies.

Tags