This will use ‘Merge‘ function but need to add date for ‘sale date from‘ and ‘sale date to‘ to stop sale price
- Go to: WooCommerce > CSV Import Suite.
- Select ‘Export Variation‘
- After you get export file, must remove other column that you not use except for required column. (please see no 4)
- Must keep ‘Parent’, ‘parent_sku’,’post_parent’,’ID’,’SKU’,’meta:_sale_price_dates_from’ and ‘meta:_sale_price_dates_to’ – please see example file
- For ‘meta:_sale_price_dates_from’ and ‘meta:_sale_price_dates_to’ please fill in pass date,
- Then save to csv file, and do ‘Merge Variation‘ again