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’