Menu

Catch CSV feed errors before importing into Google Merchant Center
📰

Catch CSV feed errors before importing into Google Merchant Center

DEV Community: python·member_f3d66a7b·3 days ago
#vGik4qgS
#devtopython#devto#dev#shirt#feed
Reading 0:00
15s threshold

A product feed can be valid CSV and still contain bad product data. Before importing a new export, check for duplicate variant IDs, missing currency codes and unsupported stock values. These are errors you can fix in the exporter while you still know what changed.

Reproduce 3 common failures

Save this synthetic export as feed.csv. The quotes around the titles keep the commas inside each field.

id,title,price,availability,link,image_link shirt-blue-s,"T-Shirt, Blue, S",29.90 EUR,in_stock,https://example.com/shirt-blue-s,https://example.com/shirt-blue-s.jpg shirt-blue-s,"T-Shirt, Blue, M",29.90 EUR,in_stock,https://example.com/shirt-blue-m,https://example.com/shirt-blue-m.jpg shirt-red-m,"T-Shirt, Red, M",29.90,available,https://example.com/shirt-red-m,https://example.com/shirt-red-m.jpg

Enter fullscreen mode

Exit fullscreen mode

Rows 2 and 3 reuse the same ID for different sizes. Give each variant a stable ID.

Row 4 omits the currency. Export a value such as 29.90 EUR .

Row 4 uses available .…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.