Solved

Extra rows in my products table (export csv)

ericnickus
Tourist
8 0 1

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 ?

 

Accepted Solution (1)

Ablestar_Daniel
Shopify Partner
93 13 16

This is an 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

Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!

View solution in original post

Reply 1 (1)

Ablestar_Daniel
Shopify Partner
93 13 16

This is an 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

Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!