So you want to import a couple of thousand WooCommerce products and you want them imported included attached cross-sell. This as you need to have each product shown with cross-sells as thumbnails below each product. So what do you do? What plugin options are out there? Well, WP All Import comes to mind right away, but there is also Product Import Export for WooCommerce by Webtoffee. Let’s discuss them here.
Product Import Export for WooCommerce
Product import export plugin allows you to import or export WooCommerce simple products. If you want to import other product types such as variable products you will need the premium version which costs $69 for a single site license.
Product Import Export for WooCommerce by Webtoffee allows attaching cross-sells to products as well on import by settings things properly during import:
Use SKU to link up-sells and cross-sells: Check this option to use SKU to link the up-sells and cross-sells of a product. If this option is not checked, up-sells and cross-sells of a product will be linked using the Product ID.
WP All Import with WooCommerce Addon
WP All Import is the most famous import export tool in the WordPress arena and it a really nice tool made by the developer that also built Oxygen. WP Import / Export + All ad-ons costs you $249 USD. This will allow exporting as well as importing and using all add-ons including the WooCommerce ad-on. This allows importing of all kinds of post types, not just WooCommerce products.
This means you can import products with product cross sells and up sells as mentioned here below. You just need to prepare all properly on import.
WP All Import Cross Sells and Up Sells
Also see another example on how to link up sells and cross sells at Nexcess using WP All Import. It shows how you can connect and import not just the products but the up sells and cross sells as well.
In the linked products tab, you can import the up-sells and cross-sells for each product. You can match up-sells and cross-sells by SKU, ID, or Product Name. WP All Import will search for the products in your WooCommerce shop and automatically add their IDs to these fields for you.
So on import you need to refer to these up sells or cross sells using curly braces syntax. And in the WP All Import documentation and their videos you can read or see more about this. When I do have more time I will add more information.