Importing woocommerce products & orders

  • Resolved deltazero

    (@deltazero)


    2 years, 9 months ago

    I have recently been working on my website by making a full backup and then editing it locally with Laragon. The main edit was to add many new products and variations. The easiest way I found was to just create a new csv file to import.

    All the products get imported correctly however the issue is that for all the orders that were previously placed, the products are no longer linked.

    Is there any way of achieving this so I do not lose important order history?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support nicw.a11n

    (@nicw)

    Hi @deltazero

    Products are never removed from order line items of orders that have been placed in the past.

    But as you have discovered, if products are removed from the database, the name of the original product will remain on the order as a line-item, but no link between the product edit screen and the order will exist.

    If you are updating existing products with new information, downloading the products as a CSV file, and re-uploading them using the core importer, you have the option of updating existing products, which will make the changes you require but will not change the original product ID, which will retain the live link with existing orders.

    Thread Starter deltazero

    (@deltazero)

    Thanks,

    I managed to find a solution to this incase anyone else is stuck in the same situation.

    What I had to do was to export all the orders from the live site with the most up-to-date order information using the plugin “Order Export & Order Import for Woocommerce” by WebToffee. After this, I imported these to the local site using the same plugin, ensure to select the option to link orders to products using Product Sku’s as the product id’s had changed.

    If you were like me and did not use sku for any products, you would have to add sku to both the live and local site before exporting and importing the orders.

    Hi @deltazero!

    Thank you for sharing the solution you found with the community.

    Since you already solved your original issue, I’m marking this thread as resolved. If you have any further questions, feel free to create a new topic.

    Cheers!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Importing woocommerce products & orders’ is closed to new replies.