HTTP/404 Products

I’ve added two products, one that fails and the other which is ok:

I’ve altered the URL to “someURL” in the text editor.

https://someURL/?product=produkt-1965?utm_source=Google%20Shopping&utm_campaign=WellCAMP%20Product%20Feed&utm_medium=cpc&utm_term=2944 (FAILED)

https://someURL/?product=produkt-1483&attribute_dachzelt=Breite+140cm&utm_source=Google%20Shopping&utm_campaign=WellCAMP%20Product%20Feed&utm_medium=cpc&utm_term=3362 (OK)

Hi,

sorry, of course it’s the export!

And there’s the debug log:

July 3, 2020, 12:17 pm
Array
(
[PHP] => 7.3
[Wordpress] => 5.4.2
[WooCommerce] => 4.2.2
[WooCommerce Product Feed PRO] => 8.3.9
)
Array
(
[Single products] => 51
[Variation products] => 73
[Total products] => 124
)
Array
(
[0] => Array
(
[channel_hash] => d4cb75caae5a73ac6b01171816b33bfb
[name] => Google Shopping
[fields] => google_shopping
[taxonomy] => google_shopping
[utm_source] => Google Shopping
[type] => Advertising
[projectname] => WellCAMP Product Feed
[countries] => Austria
[delimiter] => ,
[cron] => twicedaily
[step] => 100
[project_hash] => uIoAMwQtnVZNkzyzT6zzo7XVPVtgSW4w
[filename] => uIoAMwQtnVZNkzyzT6zzo7XVPVtgSW4w
[external_file] => [sitename]/wp-content/uploads/woo-product-feed-pro/xml/uIoAMwQtnVZNkzyzT6zzo7XVPVtgSW4w.xml
[query_log] => [sitename]/wp-content/uploads/woo-product-feed-pro/logs/query.log
[query_output_log] => [sitename]/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] => 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] =>
[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] =>
[suffix] =>
)

[9] => Array
(
[rowCount] => 9
[attribute] => g:gtin
[prefix] =>
[mapfrom] =>
[suffix] =>
)

[10] => Array
(
[rowCount] => 10
[attribute] => g:mpn
[prefix] =>
[mapfrom] =>
[suffix] =>
)

[11] => Array
(
[rowCount] => 11
[attribute] => g:identifier_exists
[prefix] =>
[mapfrom] => calculated
[suffix] =>
)

[12] => Array
(
[rowCount] => 12
[attribute] => g:condition
[prefix] =>
[mapfrom] => condition
[suffix] =>
)

[13] => Array
(
[rowCount] => 13
[attribute] => g:item_group_id
[prefix] =>
[mapfrom] => item_group_id
[suffix] =>
)

[14] => Array
(
[rowCount] => 14
[attribute] => g:shipping
[prefix] =>
[mapfrom] => shipping
[suffix] =>
)

)

[addrow] => 2
[mappings] => Array
(
[63] => Array
(
[rowCount] => 63
[categoryId] => 63
[criteria] => Campingbox
[map_to_category] => 1014 – Sporting Goods > Outdoor Recreation > Camping & Hiking > Camp Furniture
)

[88] => Array
(
[rowCount] => 88
[categoryId] => 88
[criteria] => Dachzelt aufblasbar
[map_to_category] => 1022 – Sporting Goods > Outdoor Recreation > Camping & Hiking > Tents
)

[89] => Array
(
[rowCount] => 89
[categoryId] => 89
[criteria] => Dachzelt faltbar
[map_to_category] => 1022 – Sporting Goods > Outdoor Recreation > Camping & Hiking > Tents
)

[87] => Array
(
[rowCount] => 87
[categoryId] => 87
[criteria] => Dachzelt Hartschale
[map_to_category] => 1013 – Sporting Goods > Outdoor Recreation > Camping & Hiking
)

[55] => Array
(
[rowCount] => 55
[categoryId] => 55
[criteria] => SaunaMobil Anhänger
[map_to_category] => 3992 – Home & Garden > Pool & Spa > Saunas
)

[71] => Array
(
[rowCount] => 71
[categoryId] => 71
[criteria] => Fahrrad Wohnwagen
[map_to_category] => 1013 – Sporting Goods > Outdoor Recreation > Camping & Hiking
)

[77] => Array
(
[rowCount] => 77
[categoryId] => 77
[criteria] => Zelt
[map_to_category] => 1022 – Sporting Goods > Outdoor Recreation > Camping & Hiking > Tents
)

[81] => Array
(
[rowCount] => 81
[categoryId] => 81
[criteria] => Vorzelt
[map_to_category] => 499907 – Home & Garden > Lawn & Garden > Outdoor Living > Awnings
)

[79] => Array
(
[rowCount] => 79
[categoryId] => 79
[criteria] => Zelte
[map_to_category] => 1022 – Sporting Goods > Outdoor Recreation > Camping & Hiking > Tents
)

[67] => Array
(
[rowCount] => 67
[categoryId] => 67
[criteria] => Gutscheine
[map_to_category] => 1013 – Sporting Goods > Outdoor Recreation > Camping & Hiking
)

[70] => Array
(
[rowCount] => 70
[categoryId] => 70
[criteria] => Markise
[map_to_category] => 3937 – Sporting Goods > Outdoor Recreation > Camping & Hiking > Camping Tools
)

[80] => Array
(
[rowCount] => 80
[categoryId] => 80
[criteria] => Zubehör
[map_to_category] => 3937 – Sporting Goods > Outdoor Recreation > Camping & Hiking > Camping Tools
)

[86] => Array
(
[rowCount] => 86
[categoryId] => 86
[criteria] => Dachzelt
[map_to_category] => 1013 – Sporting Goods > Outdoor Recreation > Camping & Hiking
)

[93] => Array
(
[rowCount] => 93
[categoryId] => 93
[criteria] => Sieger Preis Leistung
[map_to_category] => 1013 – Sporting Goods > Outdoor Recreation > Camping & Hiking
)

)

[utm_medium] => cpc
[utm_campaign] => WellCAMP Product Feed
[utm_term] => id
[utm_content] =>
[total_product_orders_lookback] =>
[woosea_page] => analytics
[active] => true
[last_updated] => 03 Jul 2020 10:50
[running] => ready
[nr_products] => 124
[nr_products_processed] => 0
[fileformat] => xml
[project_update] => yes
[history_products] => Array
(
[20 Jun 2020 07:55] => 0
[20 Jun 2020 07:59] => 92
[20 Jun 2020 08:05] => 92
[20 Jun 2020 08:18] => 92
[20 Jun 2020 09:01] => 92
[20 Jun 2020 09:09] => 92
[20 Jun 2020 09:13] => 92
[20 Jun 2020 09:19] => 92
[20 Jun 2020 09:22] => 92
[20 Jun 2020 09:34] => 92
[20 Jun 2020 12:17] => 92
[20 Jun 2020 12:19] => 92
[20 Jun 2020 12:23] => 92
[20 Jun 2020 12:54] => 92
[20 Jun 2020 13:01] => 92
[20 Jun 2020 13:26] => 92
[20 Jun 2020 14:12] => 92
[20 Jun 2020 14:15] => 92
[20 Jun 2020 14:20] => 92
[20 Jun 2020 14:55] => 92
[21 Jun 2020 07:43] => 92
[21 Jun 2020 07:46] => 92
[21 Jun 2020 19:46] => 92
[22 Jun 2020 07:45] => 92
[22 Jun 2020 19:47] => 92
[23 Jun 2020 07:51] => 92
[23 Jun 2020 15:32] => 92
[23 Jun 2020 15:46] => 79
[23 Jun 2020 16:09] => 79
[23 Jun 2020 19:46] => 79
[24 Jun 2020 07:45] => 79
[24 Jun 2020 19:43] => 79
[25 Jun 2020 07:48] => 79
[25 Jun 2020 19:56] => 79
[26 Jun 2020 07:47] => 79
[26 Jun 2020 19:50] => 79
[27 Jun 2020 07:44] => 79
[27 Jun 2020 19:49] => 79
[28 Jun 2020 07:44] => 79
[28 Jun 2020 19:44] => 79
[29 Jun 2020 07:49] => 79
[29 Jun 2020 19:43] => 79
[30 Jun 2020 07:43] => 79
[30 Jun 2020 19:43] => 79
[01 Jul 2020 07:50] => 79
[01 Jul 2020 19:44] => 79
[02 Jul 2020 07:50] => 79
[02 Jul 2020 17:20] => 79
[02 Jul 2020 19:48] => 79
[03 Jul 2020 07:44] => 79
[03 Jul 2020 08:24] => 79
[03 Jul 2020 08:30] => 79
[03 Jul 2020 08:37] => 79
[03 Jul 2020 09:19] => 79
[03 Jul 2020 10:17] => 28
[03 Jul 2020 10:32] => 19
[03 Jul 2020 10:45] => 79
[03 Jul 2020 10:53] => 79
[03 Jul 2020 11:53] => 79
)

[rules] => Array
(
[1592639700861] => Array
(
[rowCount] => 1592639700861
[attribute] => categories
[condition] => contains
[criteria] => Unkategorisiert
[than] => exclude
)

[1592926970531] => Array
(
[rowCount] => 1592926970531
[attribute] => price
[condition] => <
[criteria] => 100
[than] => exclude
)

)

[rules2] => Array
(
[1592657422277] => Array
(
[rowCount] => 1592657422277
[attribute] => shipping
[condition] => contains
[criteria] => eur eur
[than_attribute] => custom_attributes__default_attributes
[newvalue] => Eur
)

)

[product_variations] => on
)

)
Array
(
)

URL has been changed to [sitename].

Thank you!

Hi,

I’ve removed them and the problem vanished.

But what exactly is causing it beforehand and how can i fix it, so the exported data does not contain those defect url’s?

Thanks, Max

I really don’t know why. Since its a system which growed from time to time in its complexity, its hard to determine what brought those with the wrong the URLs in.

I will investigate said product tomorrow and will come back to you.

If you have any more hints for me until then, i would be very glad.

Thanks