Linking products to categories

You can try using csv product import plugins like https://wordpress.org/plugins/woocommerce-xml-csv-product-import/ .
The best way is to write a custom script as per your requirements.

Related Posts:

  1. Display All Products by Category with WooCommerce
  2. Retrieve Product category ‘NAME’ by product category ID – WooCommerce?
  3. Woocommerce get category image full size
  4. Reflect nested categories in appearance > menus
  5. Remove child products from woocommerce category page [closed]
  6. Display WooCommerce product categories in a 4 columns custom menu [closed]
  7. How to select product category while adding new product in woocommerce? [closed]
  8. Use get_term_children to get the sub category of a parent category for the current post
  9. Remove word “Category” from WooCommerce product page [closed]
  10. Filtering search results
  11. WooCommerce change category url and product base
  12. Output link to category from WP_Query loop of woocommerce products
  13. display woocommerce all category title on home page
  14. Add Icons to the Product Category Sidebar Widget WooCommerce
  15. Add Product categories to WordPress menu without losing hierarchy
  16. Display “add to cart” button on every listing in product category page?
  17. How to get product count with respect to categories in WooComerce
  18. Custom page for WooCommerce’s /product-category/
  19. Getting categories id for all products in cart
  20. Get the name an the description of a link category
  21. get_cat_ID() not wokring
  22. Display child categories in WooCommerce
  23. WooCommerce duplicate sub categories and product slugs
  24. Set post categories to include parents when setting child category
  25. WooCommerce IF statements not working
  26. Warning: sizeof (): Parameter must be an array or an object that implements Countable, On products pages
  27. Omit specific product categories from WooCommerce shortcode
  28. products nested by subcategories in a current category archive
  29. Multiple Domain Names – One WP Install (non-Multisite) – Default Each Domain name to Product Category WooCommerce
  30. Hide woocommerce category name from specific pages
  31. Hide woocommerce category name from specific pages
  32. need to add custom field in more products
  33. Pagination is not working properly in Product Category/Tag pages
  34. How to recreate a copy of a product category in WooCommerce? [closed]
  35. Get parrent category name
  36. Sorting category products not working
  37. Remove product category placeholder image (Woocomerce)
  38. Categories for each brands
  39. Unwanted Duplicate Product Categories in WooCommerce
  40. Customize WordPress widget – Product Category
  41. WordPress/Woocommerce only show category in shop to a single role
  42. WooCommerce – How to show specific category first-rest of products-specific category last
  43. How to display post type and category links in foreach WordPress code
  44. Woocommerce custom category page with pagination [closed]
  45. Do not show sub categories in the loop on archive-product.php
  46. List a maximum of ‘x’ product categories with qty of ‘y’ in each column
  47. why get_the_post_thumbnail( the_ID()) echos extra post id
  48. How to access deleted term inside delete_product_cat action
  49. Apply WordPress function on specific woocommerce product categories only
  50. Filter WooCommerce archive pages by an additional category
  51. Grandchild Term Things Grandfather Term is It’s Parent
  52. Woocommerce filter function not updating
  53. Adding custom ID field to the categories
  54. How can i change what one category displays?
  55. Two Sections on Woocommerce Catergory Page [closed]
  56. Woocommerce search form with category select
  57. How to display product with two condition, category and brand taxonomy
  58. Show different menu on each woocommerce category page
  59. Anchor tag generates blank href attribute using echo esc_url( )
  60. separate posts to have (kind of) 2 blogs?
  61. can I ‘combine’ categories as a menu item?
  62. WooCommerce shared categories
  63. Displaying Single Product Page Parent and Child Category
  64. category description not showing in my woocommerce
  65. Conditional label Woocommerce archive [unsolved]
  66. How to show given products only using product id array from specific category page in woocommerce
  67. Shop Category Pages missing s
  68. WooCommerce REST API not returning the default products category
  69. How to show WooCommerce Categories on ‘shop’ page instead of products?
  70. Show the parent taxonomy by creating shortcode in woocommerce?
  71. When creating a new product, auto assign it to all custom taxonomy woocommerce
  72. Linking to the most recent post in my podcast category
  73. Get WooCommerce product category list in functions.php
  74. in post content shortcode works, but hardcoded in same page template doesn’t?
  75. Is there a reason to put a product in both the Child and Parent Categories?
  76. WooCommerce showing active product categories on single product page
  77. How to fix 404 error in pagination in categories of woocommerce with common url base /shop/?
  78. How to display custom fields as table in Woocommerce
  79. How do I merge WooCommerce categories with the same name?
  80. Creating a linkable category list with post count
  81. How to delete WooCommerce categories in bulk that only have one product
  82. Product Category page showing all products
  83. product_cat image url from database
  84. Woocommerce product catalog, products with different description
  85. WooCommerce – Get products from category right before deleting category
  86. set a parent category in a product woocommerce
  87. No results found for second level category
  88. How to display products with multiple conditions, product_id and category_id
  89. Categories and Tags Conflict after Woocommerce Installation
  90. How to get related category/categories in WordPress archive page
  91. How can I add a Categories page link to a menu? [closed]
  92. Custom Woocommerce Category view
  93. Displaying categories and subcategories without link
  94. Woocommerce – Display product category of product in Orders page
  95. Changing Woocommerce categories programatically
  96. Woocommerce Force the category choice before creating new product? [duplicate]
  97. Categories and products woocommerce wordpress
  98. Custom EndPoint not working when strip child category in URL
  99. Function to reference post meta in place of category Woocommerce
  100. Add custom fields to Woocommerce Category Page