Too few column delimiters
-
Feed worked without problems. I haven’t made any changes since creating it which was almost 3 years ago. But now i got an error message in Merchant center and it only finds 34 out of the 138 products.
Notification is:
Too few column separators
Your items contain fewer attributes than the items specified in the header row.I downloaded the CSV and all the columns are correct so i don’t know why its not working like it used too.
The page I need help with: [log in to see the link]
-
I tried changing the separator and file format but it doesn’t help.
Hi @stefrikhof ,
Usually the error message of To few column delimiters are due to missing fields.
I suggest going through Google Merchant and look at your mapped columns and see if it’s required and what’s it’s accepted values:?Product data specification – Google Merchant Center Help
Can you please pass on your debug log? You can find it in Product Feed > Settings > Plugins System check
April 26, 2024, 5:35 am
Array
(
[PHP] => 8.1
[Wordpress] => 6.5.2
[WooCommerce] => 8.8.2
[WooCommerce Product Feed PRO] => 13.3.2
)
Array
(
[Single products] => 138
[Variation products] => 0
[Total products] => 138
)
Array
(
[0] => Array
(
[channel_hash] => d4cb75caae5a73ac6b01171816b33bfb
[name] => Google Shopping
[fields] => google_shopping
[taxonomy] => google_shopping
[utm_source] => Google Shopping
[type] => Advertising
[projectname] => AEDonline Feed
[countries] => Netherlands
[fileformat] => xml
[delimiter] => #
[cron] => daily
[products_changed] => on
[step] => 100
[project_hash] => Qf9rlEtMYdAM5eE6AZTm0S4r5qLSOO9g
[filename] => Qf9rlEtMYdAM5eE6AZTm0S4r5qLSOO9g
[external_file] => https://aedonline.nl/wp-content/uploads/woo-product-feed-pro/xml/Qf9rlEtMYdAM5eE6AZTm0S4r5qLSOO9g.xml
[query_log] => https://aedonline.nl/wp-content/uploads/woo-product-feed-pro/logs/query.log
[query_output_log] => https://aedonline.nl/wp-content/uploads/woo-product-feed-pro/logs/query_output.log
[attributes] => Array
(
[0] => Array
(
[rowCount] => 0
[attribute] => g:id
[prefix] =>
[mapfrom] => id
[suffix] =>
)[1] => Array ( [rowCount] => 1 [attribute] => g:title [prefix] => [mapfrom] => title [suffix] => ) [2] => Array ( [rowCount] => 2 [attribute] => g:description [prefix] => [mapfrom] => short_description [suffix] => ) [3] => Array ( [rowCount] => 3 [attribute] => g:link [prefix] => [mapfrom] => link [suffix] => ) [4] => Array ( [rowCount] => 4 [attribute] => g:image_link [prefix] => [mapfrom] => image [suffix] => ) [5] => Array ( [rowCount] => 5 [attribute] => g:availability [prefix] => [mapfrom] => availability [suffix] => ) [6] => Array ( [rowCount] => 6 [attribute] => g:price [prefix] => EUR [mapfrom] => price [suffix] => ) [7] => Array ( [rowCount] => 7 [attribute] => g:google_product_category [prefix] => [mapfrom] => categories [suffix] => ) [8] => Array ( [rowCount] => 8 [attribute] => g:brand [prefix] => [mapfrom] => pa_fabrikant [suffix] => ) [9] => Array ( [rowCount] => 9 [attribute] => g:gtin [prefix] => [mapfrom] => custom_attributes__gtin [suffix] => ) [10] => Array ( [rowCount] => 10 [attribute] => g:mpn [prefix] => [mapfrom] => [suffix] => ) [16] => Array ( [rowCount] => 16 [attribute] => g:additional_image_link [prefix] => [mapfrom] => image_1 [suffix] => ) [17] => Array ( [rowCount] => 17 [attribute] => g:additional_image_link [prefix] => [mapfrom] => image_2 [suffix] => ) ) [addrow] => 1 [mappings] => Array ( [22] => Array ( [rowCount] => 22 [categoryId] => 22 [criteria] => Merken [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [33] => Array ( [rowCount] => 33 [categoryId] => 33 [criteria] => Cardiac Science [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [34] => Array ( [rowCount] => 34 [categoryId] => 34 [criteria] => CU Medical [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [35] => Array ( [rowCount] => 35 [categoryId] => 35 [criteria] => Defibtech [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [36] => Array ( [rowCount] => 36 [categoryId] => 36 [criteria] => DefiSign [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [38] => Array ( [rowCount] => 38 [categoryId] => 38 [criteria] => Heartsine [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [23] => Array ( [rowCount] => 23 [categoryId] => 23 [criteria] => Philips [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [39] => Array ( [rowCount] => 39 [categoryId] => 39 [criteria] => Physio-Control [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [40] => Array ( [rowCount] => 40 [categoryId] => 40 [criteria] => Primedic [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [42] => Array ( [rowCount] => 42 [categoryId] => 42 [criteria] => Schiller [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [43] => Array ( [rowCount] => 43 [categoryId] => 43 [criteria] => Zoll [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [21] => Array ( [rowCount] => 21 [categoryId] => 21 [criteria] => AED [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [47] => Array ( [rowCount] => 47 [categoryId] => 47 [criteria] => Batterijen [map_to_category] => 7166 - Electronics > Electronics Accessories > Power > Battery Accessories ) [46] => Array ( [rowCount] => 46 [categoryId] => 46 [criteria] => Elektroden [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [48] => Array ( [rowCount] => 48 [categoryId] => 48 [criteria] => Kasten en wandbeugels [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [49] => Array ( [rowCount] => 49 [categoryId] => 49 [criteria] => Tassen en koffers [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) [88] => Array ( [rowCount] => 88 [categoryId] => 88 [criteria] => Mindray [map_to_category] => 3230 - Business & Industrial > Medical > Medical Equipment > Automated External Defibrillators ) ) [utm_medium] => cpc [utm_campaign] => Google Shopping Feed [utm_term] => id [utm_content] => [total_product_orders_lookback] => [woosea_page] => analytics [active] => 1 [last_updated] => 25 Apr 2024 18:41 [running] => ready [nr_products] => 138 [nr_products_processed] => 0 [history_products] => Array ( [13 Jan 2021 10:35] => 139 [13 Jan 2021 10:41] => 139 [13 Jan 2021 11:06] => 139 [13 Jan 2021 11:14] => 139 [14 Jan 2021 12:23] => 139 [14 Jan 2021 13:26] => 139 [20 Jan 2021 09:35] => 0 [20 Jan 2021 09:39] => 0 [20 Jan 2021 09:41] => 0 [20 Jan 2021 09:47] => 0 [20 Jan 2021 10:15] => 0 [20 Jan 2021 10:24] => 278 [20 Jan 2021 10:29] => 139 [20 Jan 2021 15:12] => 139 [20 Jan 2021 15:45] => 139 [20 Jan 2021 15:57] => 139 [21 Jan 2021 10:06] => 139 [21 Jan 2021 10:13] => 139 [21 Jan 2021 10:21] => 139 [21 Jan 2021 10:27] => 139 [21 Jan 2021 10:31] => 139 [25 Jan 2021 18:56] => 139 [25 Jan 2021 19:02] => 139 [25 Jan 2021 19:27] => 139 [25 Jan 2021 19:37] => 139 [26 Jan 2021 16:31] => 139 [10 Feb 2021 09:10] => 140 [10 Feb 2021 19:42] => 140 [18 Feb 2021 17:44] => 140 [12 Mar 2021 07:21] => 138 [12 Mar 2021 08:54] => 138 [12 Mar 2021 12:14] => 138 [12 Mar 2021 16:42] => 138 [23 Mar 2021 13:47] => 137 [13 Apr 2021 09:42] => 137 [14 Apr 2021 18:19] => 137 [05 May 2021 09:32] => 136 [07 May 2021 08:00] => 136 [18 May 2021 12:36] => 136 [02 Jun 2021 14:30] => 139 [02 Jun 2021 14:40] => 139 [04 Jun 2021 17:24] => 139 [13 Jul 2021 10:32] => 140 [13 Jul 2021 14:10] => 140 [13 Jul 2021 14:27] => 140 [18 Aug 2021 09:00] => 139 [02 Nov 2021 14:07] => 139 [02 Nov 2021 14:12] => 139 [09 Dec 2021 19:14] => 139 [19 Jan 2022 11:59] => 139 [19 Jan 2022 12:17] => 139 [19 Jan 2022 19:35] => 139 [20 Jan 2022 19:54] => 139 [02 Feb 2022 15:18] => 139 [04 Mar 2022 07:10] => 141 [04 Mar 2022 12:29] => 141 [28 Mar 2022 07:23] => 141 [13 May 2022 08:53] => 141 [11 Aug 2022 12:22] => 141 [05 Dec 2022 13:57] => 142 [09 Jan 2023 09:51] => 142 [16 Jan 2023 07:14] => 142 [16 Jan 2023 19:56] => 142 [30 Jan 2023 08:25] => 142 [30 Jan 2023 08:47] => 142 [30 Jan 2023 09:56] => 142 [06 Feb 2023 07:42] => 142 [06 Feb 2023 09:14] => 142 [08 Feb 2023 11:56] => 142 [10 Feb 2023 14:03] => 142 [10 Feb 2023 14:21] => 142 [10 Feb 2023 15:33] => 142 [22 Feb 2023 15:06] => 142 [06 Mar 2023 07:47] => 142 [06 Mar 2023 17:14] => 142 [07 Mar 2023 20:20] => 142 [08 Mar 2023 12:26] => 142 [14 Mar 2023 14:27] => 142 [21 Mar 2023 06:49] => 142 [26 Mar 2023 17:51] => 140 [28 Mar 2023 09:41] => 140 [03 Apr 2023 06:22] => 139 [11 Apr 2023 12:42] => 139 [01 May 2023 07:08] => 139 [15 May 2023 07:54] => 139 [15 Jun 2023 11:14] => 139 [17 Jul 2023 10:37] => 139 [17 Jul 2023 11:29] => 139 [31 Jul 2023 08:58] => 139 [17 Aug 2023 09:59] => 138 [17 Aug 2023 10:10] => 138 [21 Aug 2023 07:48] => 136 [30 Aug 2023 12:27] => 135 [30 Aug 2023 17:22] => 135 [11 Sep 2023 11:08] => 135 [09 Oct 2023 06:37] => 134 [09 Oct 2023 08:06] => 134 [18 Oct 2023 11:38] => 134 [18 Oct 2023 12:05] => 134 [30 Oct 2023 10:02] => 134 [14 Nov 2023 18:47] => 134 [20 Nov 2023 09:11] => 134 [21 Nov 2023 17:53] => 134 [21 Nov 2023 18:12] => 134 [04 Jan 2024 13:21] => 134 [08 Jan 2024 09:09] => 134 [22 Jan 2024 08:13] => 134 [22 Jan 2024 08:26] => 134 [19 Feb 2024 09:04] => 136 [08 Mar 2024 19:34] => 137 [09 Mar 2024 13:32] => 137 [11 Mar 2024 09:21] => 138 [26 Mar 2024 08:07] => 138 [28 Mar 2024 14:26] => 138 [22 Apr 2024 07:58] => 138 [22 Apr 2024 18:41] => 138 [25 Apr 2024 11:58] => 138 [25 Apr 2024 12:55] => 138 [25 Apr 2024 13:03] => 138 [25 Apr 2024 13:40] => 138 [25 Apr 2024 13:46] => 138 [25 Apr 2024 14:00] => 138 [25 Apr 2024 14:10] => 138 [25 Apr 2024 17:14] => 138 [25 Apr 2024 17:21] => 138 [25 Apr 2024 17:43] => 138 [25 Apr 2024 17:57] => 138 [25 Apr 2024 18:00] => 138 [25 Apr 2024 18:17] => 138 [25 Apr 2024 18:23] => 138 [25 Apr 2024 18:32] => 138 [25 Apr 2024 18:36] => 138 [25 Apr 2024 18:39] => 138 [25 Apr 2024 18:42] => 138 ) [project_update] => yes [_wpnonce] => 142e644210 [_wp_http_referer] => /wp-admin/admin.php?page=woo-product-feed-pro%2Fwoocommerce-sea.php&action=edit_project&step=0&project_hash=Qf9rlEtMYdAM5eE6AZTm0S4r5qLSOO9g&channel_hash=d4cb75caae5a73ac6b01171816b33bfb ))
Hi @stefrikhof,
Looks like you are missing the Image mapping: Image link [image_link] – Google Merchant Center Help
I also noticed that you mapped out the description to your short description: ensure that your products have short descriptions.
Usually these issues are due to the mapping or a missing attribute field/not mapped. I suggest going through your fields and cross reference with Google Shopping
- The topic ‘Too few column delimiters’ is closed to new replies.
