How to Merge WooCommerce Products

This instruction is for ‘Merge‘ product to WooCommerce by use csv file.

Merge is use for when you need to update some data of product that already have on our system, so our column on csv file will only have ‘required column‘ and ‘column that we need to update

Prepare csv file and data

  1. Go to: WooCommerce > CSV Import Suite.
  2. Click ‘Export Products‘ tab
  3. Select ‘Export Products‘ or ‘Export Variation‘, depend on which data that you need to change
  4. After you get export file, must remove other column that you not use except for required column. (please see no 5 and no 6)
  5. Main Product‘ file must keep ‘post_id’ and ‘sku’
  6. Variable Product‘ file must keep ‘Parent’, ‘parent_sku’,’post_parent’,’ID’ and ‘SKU’
  7. Then update your data, and save to csv file.

Do merge

  1. Go to: WooCommerce > CSV Import Suite.
  2. Click Import Product tab
  3. Click ‘Import Product CSV > Merge Products‘ for merge ‘Main Product‘ data
  4. Click ‘Import Product Variations CSV > Merge Variation‘ for merge ‘Variable Product‘ data
  5. Press ‘Submit’
Contact Us
© 2024 Imarketingonly All rights reserved.


The Great Oast, Steep Marsh Petersfield Hampshire GU32 2BN
125/5A Srisoonthorn Road. Cherngtalay District. Thalang Phuket 83110
+66 (0) 76 324184 +66(0) 898 740 040 +44 (0) 1730 895648 +44 (0) 208 1234 164 +44 (0) 7798 554540 Start Price 120 GBP