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:
- Retrieve Product category ‘NAME’ by product category ID – WooCommerce?
- Reflect nested categories in appearance > menus
- Remove child products from woocommerce category page [closed]
- How to select product category while adding new product in woocommerce? [closed]
- Use get_term_children to get the sub category of a parent category for the current post
- Hide uncategorized products from the shop page
- Remove word “Category” from WooCommerce product page [closed]
- Filtering search results
- WooCommerce change category url and product base
- Output link to category from WP_Query loop of woocommerce products
- display woocommerce all category title on home page
- Add Icons to the Product Category Sidebar Widget WooCommerce
- Add Product categories to WordPress menu without losing hierarchy
- How to get product count with respect to categories in WooComerce
- Custom page for WooCommerce’s /product-category/
- Getting categories id for all products in cart
- Get woocommerce catogry
- Get the name an the description of a link category
- get_cat_ID() not wokring
- Display child categories in WooCommerce
- WooCommerce duplicate sub categories and product slugs
- Set post categories to include parents when setting child category
- WooCommerce IF statements not working
- Warning: sizeof (): Parameter must be an array or an object that implements Countable, On products pages
- Omit specific product categories from WooCommerce shortcode
- force category base – archive pages work WITH & WITHOUT category base slug in url?
- Multiple Domain Names – One WP Install (non-Multisite) – Default Each Domain name to Product Category WooCommerce
- Hide woocommerce category name from specific pages
- Hide woocommerce category name from specific pages
- need to add custom field in more products
- How to redefine the sorting of product categories by menu_order?
- Pagination is not working properly in Product Category/Tag pages
- How to recreate a copy of a product category in WooCommerce? [closed]
- Get parrent category name
- Sorting category products not working
- Place category Base URL at the end
- Categories for each brands
- WordPress/Woocommerce only show category in shop to a single role
- WooCommerce – How to show specific category first-rest of products-specific category last
- How to display post type and category links in foreach WordPress code
- Woocommerce custom category page with pagination [closed]
- Why is it so hard to show the URL of the current category and how to do it?
- Categories are not listing their respective products
- Display single category name in woocommerce loop
- Building Menu from Woocommerce Product Categories
- Include WooCommerce product to all child categories
- woocommerce related products by specific categories [closed]
- List just subcategory and products of active category page in Woocommerce
- List a maximum of ‘x’ product categories with qty of ‘y’ in each column
- Display all product tags associated with a specific product category
- Adding custom ID field to the categories
- How can i change what one category displays?
- How to display product with two condition, category and brand taxonomy
- Template for product-category page [closed]
- wp_insert_link not working
- displaying the last product comment in the woocommerce category
- Woocommerce only display child category when parent is checked (on add new product page)
- category description not showing in my woocommerce
- Show parent category wp_list_categories wordpress
- Show audio player only in specific post type category
- How to make product image inherit from category image
- Shop Category Pages missing s
- How to set acf color field as background color to product category
- How to target all woocommerce categories that don’t have any subcategories in them?
- In if…else condition, the else statement shows even if if statement is correct
- How can I display all products from all categories on one page with woocommerce?
- How to add all subcategories as submenu in WordPress menu
- How to edit woocommerce sub-category page
- When creating a new product, auto assign it to all custom taxonomy woocommerce
- echo $category[0]-> cat_name; shows only one category name
- in post content shortcode works, but hardcoded in same page template doesn’t?
- selecting categories that have products with tag/category
- Restrict retrieved terms by category?
- How to fix 404 error in pagination in categories of woocommerce with common url base /shop/?
- How to display custom fields as table in Woocommerce
- How do I merge WooCommerce categories with the same name?
- Woocommerce Category Sort Dropdown
- Woocommerce: all products of all categories instead products of one category
- How to delete WooCommerce categories in bulk that only have one product
- Product Category page showing all products
- How to load terms of a custom taxonomy of a product in woocommerce cart page
- How to get WooCommerce Product Categories and its children’s children?
- Woocommerce change tag_id to name
- Category menu that filters out empty categories
- Custom Woocommerce Category view
- Displaying categories and subcategories without link
- WooCommerce category display in custom page
- Sorting Woocommerce products by category and attributes
- Woocommerce custom taxonomy order
- Update wordpress menu with woocommerce products
- How to get Woocomerce categories count
- Get all categories
- Categories and products woocommerce wordpress
- Function to reference post meta in place of category Woocommerce
- Restricted category in Woocommerce [closed]
- category id (term_id) in url instead of slug
- Products showing up in subcategory when they shouldn’t
- Adding 400 product categories with their hierarchy to a navigation menu
- How do we ReWrite HTACCESS to point a cat/subcat Product URL, to Cat/ only?
- What would be the easiest way to show subcategories under specific parents as text links only?