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:
- Display All Products by Category with WooCommerce
- Retrieve Product category ‘NAME’ by product category ID – WooCommerce?
- Woocommerce get category image full size
- Programmatically create product category and add thumbnail in woocommerce
- Reflect nested categories in appearance > menus
- Create product category and keyword search form in woocommerce? [closed]
- Remove child products from woocommerce category page [closed]
- How do I edit pre_get_post for the category the user is currently in?
- Display WooCommerce product categories in a 4 columns custom menu [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
- Display “add to cart” button on every listing in product category page?
- 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
- How to get category URL with the slug?
- get_cat_ID() not wokring
- Display child categories in WooCommerce
- WooCommerce duplicate sub categories and product slugs
- Show parent category wp_list_categories wordpress
- Conditional label Woocommerce archive [unsolved]
- Show audio player only in specific post type category
- How to make product image inherit from category image
- How to show given products only using product id array from specific category page in woocommerce
- 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?
- WooCommerce REST API not returning the default products category
- In if…else condition, the else statement shows even if if statement is correct
- How to show WooCommerce Categories on ‘shop’ page instead of products?
- Show the parent taxonomy by creating shortcode in woocommerce?
- How can I display all products from all categories on one page with woocommerce?
- Showing the category hierarchy as clicked in WordPress, with image and desc
- 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
- Linking to the most recent post in my podcast category
- echo $category[0]-> cat_name; shows only one category name
- Get WooCommerce product category list in functions.php
- in post content shortcode works, but hardcoded in same page template doesn’t?
- Is there a reason to put a product in both the Child and Parent Categories?
- WordPress category title not update in navigation menu
- WooCommerce showing active product categories on single product page
- 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
- Creating a linkable category list with post count
- 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
- product_cat image url from database
- How to get WooCommerce Product Categories and its children’s children?
- Woocommerce change tag_id to name
- Woocommerce product catalog, products with different description
- WooCommerce – Get products from category right before deleting category
- set a parent category in a product woocommerce
- No results found for second level category
- How to display products with multiple conditions, product_id and category_id
- Categories and Tags Conflict after Woocommerce Installation
- How to get related category/categories in WordPress archive page
- Category menu that filters out empty categories
- woocommerce – products by category slug? [closed]
- How can I add a Categories page link to a menu? [closed]
- 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
- Woocommerce – Display product category of product in Orders page
- Changing Woocommerce categories programatically
- Get all categories
- Woocommerce Force the category choice before creating new product? [duplicate]
- Categories and products woocommerce wordpress
- Custom EndPoint not working when strip child category in URL
- Function to reference post meta in place of category Woocommerce
- Add custom fields to Woocommerce Category Page
- 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?
- How can I display the category descriptions below the category name using a functions.php filter?
- Change woo status automatically [closed]