i have a products sql database table from none WordPress old site with names description and category fields but the category has only id from category table and i have to move all these products and there categories to the new WordPress site database , i have tried to use the plugin Product CSV Importer and Exporter but the category field should be written by name not id . I am still a beginner any other ideas how to start?

1 Answer 1


Open the CSV file in Excel, use "find and replace" and change the each category id for the Category name you want. Then upload the CSV file again in the new Word Press.

  • sounds a good idea i will give it a try thnx
    – sonia
    May 1, 2021 at 19:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.