WooCommerce – How to Fix Bad Imports from Magento or Shopify

Compatibility is one of the main problems people face when migrating from one platform to another. If you’re coming from Magento or Shopify to WooCommerce and import your products from a CSV document you downloaded from any of those platforms, you may experience some following problems:

  • Products duplicated
  • Variations duplicated
  • Simple products imported as variable products
  • Product galleries and featured images imported incorrectly
  • Categories duplicated

We know that can be really disappointing, and you may think you’ll have to spend lots of hours fixing those and many other problems that may appear. However, we want to show you how to fix those problems using a powerful spreadsheet that allows you to apply changes to thousands of products, categories, attributes, etc.

WooCommerce Products Spreadsheet

This plugin displays all your products on a spreadsheet where you can edit freely; you can also apply changes on thousands of products using the Bulk Edit tool.

Once you install and activate the plugin, go to WP Sheet Editor > Edit Products to open the spreadsheet.

woocommerce-how-fix-bad-imports-magento-shopify

Therefore, if you’re facing those problems, you can follow the following tutorials in order to solve them quickly:

Also, you can follow the tutorial in these sections in order to solve these other problems.

1- Delete all photo galleries and featured images

Another problem you may face when importing products from Magento or Shopify is that your product galleries and featured images can be imported mistakenly.

Fortunately, you can quickly fix that problem. You just need to follow these steps in order to delete the photo galleries and featured images.

a) Open the Bulk Edit tool

It is located on the plugin’s toolbar, so just click on it to open.

woocommerce-how-fix-bad-imports-magento-shopify

b) Delete photo galleries

Select these values to delete your product photo galleries.

woocommerce-how-fix-bad-imports-magento-shopify

  • Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
  • What field do you want to edit: Gallery
  • Select type of edit: Clear value
  • Click on Execute now

c) Delete featured images

Select these values to delete your product featured images.

woocommerce-how-fix-bad-imports-magento-shopify

  • Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
  • What field do you want to edit: Featured Image
  • Select type of edit: Clear value
  • Click on Execute now

2- Delete all duplicate categories

Categories, Tags, Product Attributes, Taxonomies Spreadsheet

This plugin displays all your categories, tags, attributes, etc., on a spreadsheet where you can edit freely. Also, you can apply changes on thousands of them using the powerful Bulk Edit tool.

Once you install and activate the plugin, go to WP Sheet Editor > Edit Categories, Tags, Taxonomies > Edit Product Categories to open the spreadsheet.

woocommerce-how-fix-bad-imports-magento-shopify

Your product categories can be duplicated the same as your products and variations. Thus, we show you here how to delete all duplicate product categories.

Just follow these simple steps:

a) Open the Bulk Edit tool

It’s located on the plugin’s toolbar, so just click on it to open.

woocommerce-how-fix-bad-imports-magento-shopify

b) Delete all duplicate product categories

You need to select these values to delete all duplicate categories.

woocommerce-how-fix-bad-imports-magento-shopify

  • Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
  • What field do you want to edit: Title
  • Select type of edit: Delete Duplicates
  • Click on Execute now

After that, all your duplicate product categories will be deleted.

Done

As you can see, no import process will be a headache anymore. You can quickly fix them using a simple but powerful spreadsheet. It only takes some seconds and some simple steps.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.