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
- Reflect nested categories in appearance > menus
- Remove child products from woocommerce category page [closed]
- 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
- 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 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
- products nested by subcategories in a current category archive
- 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
- 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
- Remove product category placeholder image (Woocomerce)
- Categories for each brands
- Unwanted Duplicate Product Categories in WooCommerce
- Customize WordPress widget – Product Category
- 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]
- Do not show sub categories in the loop on archive-product.php
- List a maximum of ‘x’ product categories with qty of ‘y’ in each column
- why get_the_post_thumbnail( the_ID()) echos extra post id
- How to access deleted term inside delete_product_cat action
- Apply WordPress function on specific woocommerce product categories only
- Filter WooCommerce archive pages by an additional category
- Grandchild Term Things Grandfather Term is It’s Parent
- Woocommerce filter function not updating
- Adding custom ID field to the categories
- How can i change what one category displays?
- Two Sections on Woocommerce Catergory Page [closed]
- Woocommerce search form with category select
- How to display product with two condition, category and brand taxonomy
- Show different menu on each woocommerce category page
- Anchor tag generates blank href attribute using echo esc_url( )
- separate posts to have (kind of) 2 blogs?
- can I ‘combine’ categories as a menu item?
- WooCommerce shared categories
- Displaying Single Product Page Parent and Child Category
- category description not showing in my woocommerce
- Conditional label Woocommerce archive [unsolved]
- How to show given products only using product id array from specific category page in woocommerce
- Shop Category Pages missing s
- WooCommerce REST API not returning the default products category
- How to show WooCommerce Categories on ‘shop’ page instead of products?
- Show the parent taxonomy by creating shortcode in woocommerce?
- When creating a new product, auto assign it to all custom taxonomy woocommerce
- Linking to the most recent post in my podcast category
- 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?
- WooCommerce showing active product categories on single product page
- 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?
- 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
- product_cat image url from database
- 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
- How can I add a Categories page link to a menu? [closed]
- Custom Woocommerce Category view
- Displaying categories and subcategories without link
- Woocommerce – Display product category of product in Orders page
- Changing Woocommerce categories programatically
- 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