Extra rows in my products table (export csv)

[ericnickus]

So I inherited this shopify project and I am a developer, but new to shopify .    I am looking at the products table export and notice that there are extra rows, some with just title and nothing else in the row, and am wondering , since I have 4 metafields defined, I know that the metafields export has 4 rows per product (which makes sense), but should the products table have extra blank rows to match the metafields rows , or are they just probably extra junk left over from the previous developer who bailed ?

[Ablestar_Daniel · Accepted solution]

Hi Eric,

Welcome to Shopify! When you're talking about the product table export, do you mean the CSV of product data that you can export from the Shopify admin?

If so, Shopify uses multiple rows for a single product in order to handle 'many to one' relationships like variants and images. The first two columns of the spreadsheet (Handle and Title) are used to uniquely identify the product but then each row can contain data for a different variant or product image. If you scroll all the way to the right in your spreadsheet is there any other data at all that appears in these rows?

Unfortunately the native Shopify export doesn't include metafields so those won't be visible in the CSV file.

Best,

Daniel