Hi, I have a daily import of a CSV that contains stock and price data by SKU. This has been working fine, updating daily at 2am.
We have just updated prices and added sale prices to a number of items and whilst the price field has updated, the sale price field remains empty in WooCommerce.
The products are variable products, so the SKUs being updated are child variations. I have run the import manually three times today and the sale_price remains empty in WooCommerce despite the correct sale_price being in the CSV and the fields being mapped correctly in the importer.
The fields that should be imported are:
regular_price
sale_price
stock_status
stock_last_checked
stock_due_in
All matched by sku (the last two being custom fields).
From the debug window, these are the importer settings:
YToxMDp7czo4OiJ0ZW1wbGF0ZSI7czoxOToid29vY29tbWVyY2UtcHJvZHVjdCI7czoxMzoidGVtcGxhdGVfdHlwZSI7czowOiIiO3M6NDoiZmlsZSI7YToyOntzOjI6ImlkIjtpOjg2O3M6ODoic2V0dGluZ3MiO2E6Nzp7czo5OiJlbmNsb3N1cmUiO3M6MToiIiI7czo5OiJkZWxpbWl0ZXIiO3M6MToiLCI7czo2OiJlc2NhcGUiO3M6MToiXCI7czoxMzoic2hvd19oZWFkaW5ncyI7YjoxO3M6NToic2V0dXAiO2I6MTtzOjU6ImNvdW50IjtpOjI7czo5OiJwcm9jZXNzZWQiO2I6MTt9fXM6MTA6ImRhdGFzb3VyY2UiO2E6Mjp7czo0OiJ0eXBlIjtzOjY6InJlbW90ZSI7czo4OiJzZXR0aW5ncyI7YToyOntzOjEwOiJyZW1vdGVfdXJsIjtzOjcwOiJodHRwczovL3d3dy5kb29yc29ubGluZXVrLmNvLnVrL3dwLWNvbnRlbnQvcGx1Z2lucy9qc29udG9jc3Yvc3RvY2suY3N2IjtzOjk6ImxvY2FsX3VybCI7czo1NToiaG9tZS9wdWJsaWNfaHRtbC93cC1jb250ZW50L3BsdWdpbnMvanNvbnRvY3N2L3N0b2NrLmNzdiI7fX1zOjY6InBhcnNlciI7czozOiJjc3YiO3M6MzoibWFwIjthOjEwNjp7czoxNToicG9zdC5wb3N0X3RpdGxlIjtzOjA6IiI7czoxNzoicG9zdC5wb3N0X2NvbnRlbnQiO3M6MDoiIjtzOjE3OiJwb3N0LnBvc3RfZXhjZXJwdCI7czowOiIiO3M6MTQ6InBvc3QucG9zdF9uYW1lIjtzOjA6IiI7czoxNzoicG9zdC5wcm9kdWN0X3R5cGUiO3M6ODoidmFyaWFibGUiO3M6MTM6InBvc3QuX3ZpcnR1YWwiO3M6Mjoibm8iO3M6MTg6InBvc3QuX2Rvd25sb2FkYWJsZSI7czoyOiJubyI7czoxNjoicG9zdC5fdmlzaWJpbGl0eSI7czo3OiJ2aXNpYmxlIjtzOjI2OiJwb3N0LmV4dGVybmFsLl9wcm9kdWN0X3VybCI7czowOiIiO3M6MjY6InBvc3QuZXh0ZXJuYWwuX2J1dHRvbl90ZXh0IjtzOjA6IiI7czoxNjoicG9zdC5wb3N0X3N0YXR1cyI7czo3OiJwdWJsaXNoIjtzOjE5OiJwb3N0LnRheC50YXhfc3RhdHVzIjtzOjc6InRheGFibGUiO3M6MTg6InBvc3QudGF4LnRheF9jbGFzcyI7czowOiIiO3M6MjQ6InBvc3QuX2F1dGhvci5wb3N0X2F1dGhvciI7czowOiIiO3M6MjU6InBvc3QuX2F1dGhvci5fYXV0aG9yX3R5cGUiO3M6MjoiaWQiO3M6NzoicG9zdC5JRCI7czowOiIiO3M6MjA6InByaWNlLl9yZWd1bGFyX3ByaWNlIjtzOjM6Ins1fSI7czoyMjoicHJpY2Uuc2FsZS5fc2FsZV9wcmljZSI7czozOiJ7Nn0iO3M6MzM6InByaWNlLnNhbGUuX3NhbGVfcHJpY2VfZGF0ZXNfZnJvbSI7czowOiIiO3M6MzE6InByaWNlLnNhbGUuX3NhbGVfcHJpY2VfZGF0ZXNfdG8iO3M6MDoiIjtzOjE0OiJpbnZlbnRvcnkuX3NrdSI7czozOiJ7N30iO3M6Mjc6ImludmVudG9yeS5fZ2xvYmFsX3VuaXF1ZV9pZCI7czowOiIiO3M6Mjk6ImludmVudG9yeS5zdG9jay5fbWFuYWdlX3N0b2NrIjtzOjI6Im5vIjtzOjI5OiJpbnZlbnRvcnkuc3RvY2suX3N0b2NrX3N0YXR1cyI7czozOiJ7MX0iO3M6MjI6ImludmVudG9yeS5zdG9jay5fc3RvY2siO3M6MDoiIjtzOjI3OiJpbnZlbnRvcnkuc3RvY2suX2JhY2tvcmRlcnMiO3M6MzoieWVzIjtzOjMzOiJpbnZlbnRvcnkuc3RvY2suX2xvd19zdG9ja19hbW91bnQiO3M6MDoiIjtzOjM0OiJpbnZlbnRvcnkuc3RvY2suX3NvbGRfaW5kaXZpZHVhbGx5IjtzOjI6Im5vIjtzOjI3OiJzaGlwcGluZy5kaW1lbnNpb25zLl93ZWlnaHQiO3M6MDoiIjtzOjI3OiJzaGlwcGluZy5kaW1lbnNpb25zLl9sZW5ndGgiO3M6MDoiIjtzOjI2OiJzaGlwcGluZy5kaW1lbnNpb25zLl93aWR0aCI7czowOiIiO3M6Mjc6InNoaXBwaW5nLmRpbWVuc2lvbnMuX2hlaWdodCI7czowOiIiO3M6MzQ6ImxpbmtlZC1wcm9kdWN0cy5jcm9zc3NlbGwucHJvZHVjdHMiO3M6MDoiIjtzOjM3OiJsaW5rZWQtcHJvZHVjdHMuY3Jvc3NzZWxsLl9maWVsZF90eXBlIjtzOjI6IklEIjtzOjMxOiJsaW5rZWQtcHJvZHVjdHMudXBzZWxsLnByb2R1Y3RzIjtzOjA6IiI7czozNDoibGlua2VkLXByb2R1Y3RzLnVwc2VsbC5fZmllbGRfdHlwZSI7czoyOiJJRCI7czozMjoibGlua2VkLXByb2R1Y3RzLmdyb3VwZWQucHJvZHVjdHMiO3M6MDoiIjtzOjM1OiJsaW5rZWQtcHJvZHVjdHMuZ3JvdXBlZC5fZmllbGRfdHlwZSI7czoyOiJJRCI7czoxNzoiYXR0cmlidXRlcy5faW5kZXgiO2k6MDtzOjIzOiJhZHZhbmNlZC5fcGFyZW50LnBhcmVudCI7czowOiIiO3M6Mjk6ImFkdmFuY2VkLl9wYXJlbnQuX3BhcmVudF90eXBlIjtzOjI6ImlkIjtzOjI4OiJhZHZhbmNlZC5fcGFyZW50Ll9wYXJlbnRfcmVmIjtzOjA6IiI7czoxNzoiYWR2YW5jZWQuZmVhdHVyZWQiO3M6Mjoibm8iO3M6MjM6ImFkdmFuY2VkLl9wdXJjaGFzZV9ub3RlIjtzOjA6IiI7czoxOToiYWR2YW5jZWQubWVudV9vcmRlciI7czowOiIiO3M6MjM6ImFkdmFuY2VkLmNvbW1lbnRfc3RhdHVzIjtzOjI6Im5vIjtzOjI0OiJhZHZhbmNlZC5fZG93bmxvYWRfbGltaXQiO3M6MDoiIjtzOjI1OiJhZHZhbmNlZC5fZG93bmxvYWRfZXhwaXJ5IjtzOjA6IiI7czoxODoiYWR2YW5jZWQucG9zdF9kYXRlIjtzOjA6IiI7czoyMjoicHJvZHVjdF9nYWxsZXJ5Ll9pbmRleCI7aTowO3M6MTY6ImRvd25sb2Fkcy5faW5kZXgiO2k6MDtzOjE3OiJ0YXhvbm9taWVzLl9pbmRleCI7aTowO3M6MTg6ImF0dGFjaG1lbnRzLl9pbmRleCI7aTowO3M6NDI6ImludmVudG9yeS5zdG9jay5fc3RvY2tfc3RhdHVzLl9lbmFibGVfdGV4dCI7czozOiJ5ZXMiO3M6NDI6ImF0dHJpYnV0ZXMuX2l3cF9zZXR0aW5ncy5hcHBlbmRfYXR0cmlidXRlcyI7czozOiJ5ZXMiO3M6MjA6ImN1c3RvbV9maWVsZHMuX2luZGV4IjtpOjI7czoyNDoiY3VzdG9tX2ZpZWxkcy4wLnJvd19iYXNlIjtzOjA6IiI7czoxOToiY3VzdG9tX2ZpZWxkcy4wLmtleSI7czoxOToiX3N0b2NrX2xhc3RfY2hlY2tlZCI7czoyMToiY3VzdG9tX2ZpZWxkcy4wLnZhbHVlIjtzOjM6InszfSI7czoyNzoiY3VzdG9tX2ZpZWxkcy4wLl9maWVsZF90eXBlIjtzOjQ6InRleHQiO3M6Mjc6ImN1c3RvbV9maWVsZHMuMC5fc2VyaWFsaXplZCI7czowOiIiO3M6MjM6ImN1c3RvbV9maWVsZHMuMC5fbWFwcGVkIjtzOjA6IiI7czozMjoiY3VzdG9tX2ZpZWxkcy4wLnNldHRpbmdzLl9yZXR1cm4iO3M6MDoiIjtzOjM0OiJjdXN0b21fZmllbGRzLjAuc2V0dGluZ3MuX2ZlYXR1cmVkIjtzOjA6IiI7czozNDoiY3VzdG9tX2ZpZWxkcy4wLnNldHRpbmdzLl9kb3dubG9hZCI7czowOiIiO3M6MzQ6ImN1c3RvbV9maWVsZHMuMC5zZXR0aW5ncy5fZnRwX2hvc3QiO3M6MDoiIjtzOjM0OiJjdXN0b21fZmllbGRzLjAuc2V0dGluZ3MuX2Z0cF91c2VyIjtzOjA6IiI7czozNDoiY3VzdG9tX2ZpZWxkcy4wLnNldHRpbmdzLl9mdHBfcGFzcyI7czowOiIiO3M6MzQ6ImN1c3RvbV9maWVsZHMuMC5zZXR0aW5ncy5fZnRwX3BhdGgiO3M6MDoiIjtzOjM2OiJjdXN0b21fZmllbGRzLjAuc2V0dGluZ3MuX3JlbW90ZV91cmwiO3M6MDoiIjtzOjM1OiJjdXN0b21fZmllbGRzLjAuc2V0dGluZ3MuX2xvY2FsX3VybCI7czowOiIiO3M6NDM6ImN1c3RvbV9maWVsZHMuMC5zZXR0aW5ncy5fZW5hYmxlX2ltYWdlX2hhc2giO3M6MDoiIjtzOjM1OiJjdXN0b21fZmllbGRzLjAuc2V0dGluZ3MuX2RlbGltaXRlciI7czowOiIiO3M6Mzk6ImN1c3RvbV9maWVsZHMuMC5zZXR0aW5ncy5fbWV0YS5fZW5hYmxlZCI7czowOiIiO3M6MzU6ImN1c3RvbV9maWVsZHMuMC5zZXR0aW5ncy5fbWV0YS5fYWx0IjtzOjA6IiI7czozNzoiY3VzdG9tX2ZpZWxkcy4wLnNldHRpbmdzLl9tZXRhLl90aXRsZSI7czowOiIiO3M6Mzk6ImN1c3RvbV9maWVsZHMuMC5zZXR0aW5ncy5fbWV0YS5fY2FwdGlvbiI7czowOiIiO3M6NDM6ImN1c3RvbV9maWVsZHMuMC5zZXR0aW5ncy5fbWV0YS5fZGVzY3JpcHRpb24iO3M6MDoiIjtzOjMyOiJjdXN0b21fZmllbGRzLjAua2V5Ll9lbmFibGVfdGV4dCI7czozOiJ5ZXMiO3M6MjQ6ImN1c3RvbV9maWVsZHMuMS5yb3dfYmFzZSI7czowOiIiO3M6MTk6ImN1c3RvbV9maWVsZHMuMS5rZXkiO3M6MTM6Il9zdG9ja19kdWVfaW4iO3M6MjE6ImN1c3RvbV9maWVsZHMuMS52YWx1ZSI7czozOiJ7Mn0iO3M6Mjc6ImN1c3RvbV9maWVsZHMuMS5fZmllbGRfdHlwZSI7czo0OiJ0ZXh0IjtzOjI3OiJjdXN0b21fZmllbGRzLjEuX3NlcmlhbGl6ZWQiO3M6MDoiIjtzOjIzOiJjdXN0b21fZmllbGRzLjEuX21hcHBlZCI7czowOiIiO3M6MzI6ImN1c3RvbV9maWVsZHMuMS5zZXR0aW5ncy5fcmV0dXJuIjtzOjA6IiI7czozNDoiY3VzdG9tX2ZpZWxkcy4xLnNldHRpbmdzLl9mZWF0dXJlZCI7czowOiIiO3M6MzQ6ImN1c3RvbV9maWVsZHMuMS5zZXR0aW5ncy5fZG93bmxvYWQiO3M6MDoiIjtzOjM0OiJjdXN0b21fZmllbGRzLjEuc2V0dGluZ3MuX2Z0cF9ob3N0IjtzOjA6IiI7czozNDoiY3VzdG9tX2ZpZWxkcy4xLnNldHRpbmdzLl9mdHBfdXNlciI7czowOiIiO3M6MzQ6ImN1c3RvbV9maWVsZHMuMS5zZXR0aW5ncy5fZnRwX3Bhc3MiO3M6MDoiIjtzOjM0OiJjdXN0b21fZmllbGRzLjEuc2V0dGluZ3MuX2Z0cF9wYXRoIjtzOjA6IiI7czozNjoiY3VzdG9tX2ZpZWxkcy4xLnNldHRpbmdzLl9yZW1vdGVfdXJsIjtzOjA6IiI7czozNToiY3VzdG9tX2ZpZWxkcy4xLnNldHRpbmdzLl9sb2NhbF91cmwiO3M6MDoiIjtzOjQzOiJjdXN0b21fZmllbGRzLjEuc2V0dGluZ3MuX2VuYWJsZV9pbWFnZV9oYXNoIjtzOjA6IiI7czozNToiY3VzdG9tX2ZpZWxkcy4xLnNldHRpbmdzLl9kZWxpbWl0ZXIiO3M6MDoiIjtzOjM5OiJjdXN0b21fZmllbGRzLjEuc2V0dGluZ3MuX21ldGEuX2VuYWJsZWQiO3M6MDoiIjtzOjM1OiJjdXN0b21fZmllbGRzLjEuc2V0dGluZ3MuX21ldGEuX2FsdCI7czowOiIiO3M6Mzc6ImN1c3RvbV9maWVsZHMuMS5zZXR0aW5ncy5fbWV0YS5fdGl0bGUiO3M6MDoiIjtzOjM5OiJjdXN0b21fZmllbGRzLjEuc2V0dGluZ3MuX21ldGEuX2NhcHRpb24iO3M6MDoiIjtzOjQzOiJjdXN0b21fZmllbGRzLjEuc2V0dGluZ3MuX21ldGEuX2Rlc2NyaXB0aW9uIjtzOjA6IiI7czozMjoiY3VzdG9tX2ZpZWxkcy4xLmtleS5fZW5hYmxlX3RleHQiO3M6MzoieWVzIjtzOjM3OiJwcmljZS5zYWxlLl9zYWxlX3ByaWNlLl9tYXBwZWQuX2luZGV4IjtpOjA7czozNjoicHJpY2Uuc2FsZS5fc2FsZV9wcmljZS5fbWFwcGVkLjAua2V5IjtzOjA6IiI7czo0MzoicHJpY2Uuc2FsZS5fc2FsZV9wcmljZS5fbWFwcGVkLjAuX2NvbmRpdGlvbiI7czowOiIiO3M6Mzg6InByaWNlLnNhbGUuX3NhbGVfcHJpY2UuX21hcHBlZC4wLnZhbHVlIjtzOjA6IiI7fXM6NzoiZW5hYmxlZCI7YTo0OntzOjE2OiJwb3N0LnBvc3Rfc3RhdHVzIjtiOjE7czoxMDoicHJpY2Uuc2FsZSI7YjoxO3M6MTU6ImludmVudG9yeS5zdG9jayI7YjoxO3M6MTc6InBvc3QucHJvZHVjdF90eXBlIjtiOjE7fXM6MTE6InBlcm1pc3Npb25zIjthOjM6e3M6NjoiY3JlYXRlIjthOjM6e3M6NzoiZW5hYmxlZCI7YjowO3M6NDoidHlwZSI7TjtzOjY6ImZpZWxkcyI7YTowOnt9fXM6NjoidXBkYXRlIjthOjM6e3M6NzoiZW5hYmxlZCI7YjoxO3M6NDoidHlwZSI7czo3OiJpbmNsdWRlIjtzOjY6ImZpZWxkcyI7YTo2OntpOjA7czoxNDoiX3JlZ3VsYXJfcHJpY2UiO2k6MTtzOjExOiJfc2FsZV9wcmljZSI7aToyO3M6NDoiX3NrdSI7aTozO3M6MTM6Il9zdG9ja19zdGF0dXMiO2k6NDtzOjMzOiJjdXN0b21fZmllbGRzLl9zdG9ja19sYXN0X2NoZWNrZWQiO2k6NTtzOjI3OiJjdXN0b21fZmllbGRzLl9zdG9ja19kdWVfaW4iO319czo2OiJyZW1vdmUiO2E6Mjp7czo3OiJlbmFibGVkIjtiOjA7czo1OiJ0cmFzaCI7YjowO319czo4OiJzZXR0aW5ncyI7YToxNjp7czo5OiJwb3N0X3R5cGUiO2E6Mjp7aTowO3M6NzoicHJvZHVjdCI7aToxO3M6MTc6InByb2R1Y3RfdmFyaWF0aW9uIjt9czoxMjoidW5pcXVlX2ZpZWxkIjthOjM6e2k6MDtzOjI6IklEIjtpOjE7czo0OiJfc2t1IjtpOjI7czo5OiJwb3N0X25hbWUiO31zOjk6InN0YXJ0X3JvdyI7czowOiIiO3M6NzoibWF4X3JvdyI7czowOiIiO3M6MjI6InVuaXF1ZV9pZGVudGlmaWVyX3R5cGUiO3M6NToiZmllbGQiO3M6MTc6InVuaXF1ZV9pZGVudGlmaWVyIjtzOjQ6Il9za3UiO3M6MjE6InVuaXF1ZV9pZGVudGlmaWVyX3JlZiI7czozOiJ7N30iO3M6MTM6ImltcG9ydF9tZXRob2QiO3M6ODoic2NoZWR1bGUiO3M6MTM6ImNyb25fc2NoZWR1bGUiO3M6NToibW9udGgiO3M6ODoiY3Jvbl9kYXkiO3M6MToiMCI7czo5OiJjcm9uX2hvdXIiO3M6MToiMCI7czoxMToiY3Jvbl9taW51dGUiO3M6MToiMCI7czoxMzoiY3Jvbl9kaXNhYmxlZCI7YjowO3M6OToicnVuX2ZldGNoIjtiOjA7czo0OiJjcm9uIjthOjE6e2k6MDthOjY6e3M6MjE6InNldHRpbmdfY3Jvbl9kaXNhYmxlZCI7YjowO3M6MjE6InNldHRpbmdfY3Jvbl9zY2hlZHVsZSI7czozOiJkYXkiO3M6MTY6InNldHRpbmdfY3Jvbl9kYXkiO3M6MToiMCI7czoxNzoic2V0dGluZ19jcm9uX2hvdXIiO3M6MToiMiI7czoxOToic2V0dGluZ19jcm9uX21pbnV0ZSI7czoxOiIwIjtzOjE3OiJzZXR0aW5nX3J1bl9mZXRjaCI7YjowO319czoxMDoiaGFzaF9jaGVjayI7YjowO31zOjc6InZlcnNpb24iO2k6Mjt9
Here is an example of a product from the debug that should have its sale_price updated, but it remains blank in WooCommerce:
2025-08-01 15:49:10.333066 DEBUG rest::run_import – AbstractMapper::exists_get_identifier -type=\”field\” -field=\”[\”_sku\”]\” -memory=53.71 MB
2025-08-01 15:49:10.333149 DEBUG rest::run_import – PostMapper::exists -query={\”post_type\”:[\”product\”,product_variation],post_status:\”any, trash, future\”,fields:\”ids\”,cache_results:false,update_post_meta_cache:false,update_post_term_cache:false,no_found_rows:true,meta_query:[{\”key\”:\”_sku\”,value:\”VASTP24\”}]} -memory=53.71 MB
2025-08-01 15:49:10.358502 DEBUG rest::run_import – repeater_process -start -memory=53.73 MB
2025-08-01 15:49:10.358624 DEBUG rest::run_import – repeater_process -end -memory=53.73 MB
2025-08-01 15:49:10.358799 DEBUG rest::run_import – PostMapper::update -meta={\”_sku\”:\”VASTP24\”,_stock_last_checked:\”2025-08-01 01:20:05\”,_stock_due_in:\”\”} -memory=53.73 MB
2025-08-01 15:49:10.568372 DEBUG rest::run_import – import:418 -success -update -memory=53.84 MB
We\’re supposed to have a promo running this weekend but I\’ve been unable to change the prices – please help!