How to import Products using CSV with metafields

[Huy1]

Hi bros, I am working with PHP to generate a csv file used to import products to Shopify. However, I need some extra meta data for each product, how can I attach metafields in CSV file? Thank all.

[Jason]

You can't. Custom metafields are not supported via the product CSV import option in the Admin.

If you're already using PHP to create the csv, why not just push the product directly in via the API. You can then include the metafields in that call.

[ben314]

This is so sad, i created a bunch of metafields to create a good interface to my customer management, now hours of work are useless.

matrixify is way to complicated for my job 😞

[Maris]

Hi, Huy!

If you are open for an app suggestion, then you can import custom Metafields using the Excelify app - just use the same Shopify CSV file, and add the Metafields columns to it with the column names like "Metafield: <namespace>.<name>".

For example: "Metafield: custom.length".

More about importing Metafields, here: https://excelify.io/shopify-excel-import-export-detailed-documentation/shopify-metafields/

If you need any help with that, contact us here: https://excelify.io/contact-us/

Maris
Excelify.io

[Liezle]

Hi! Wondering if there is a recent update for this with the 2.0 themes?

[HCMANDS]

Any updates on this?  Surely after all this time, we can now do this. 

[aequivalentin]

Does it work?

[Shua]

Still no update. Only way to import metafields with a csv is through an app.

[ElijahStownton]

I'm not sure, but you can try Skyvia as an alternative solution. It is a no-code cloud ETL tool.

[ten32guitars]

Is this natively supported yet? If not, I believe it can be done with this app as well , FYI - https://matrixify.app/how-it-works/

Of course I would prefer to do it for free, so would still like to know if this is natively supported. Thanks!

[CyberdyneJoule]

I will add to this...problem is not just defining meta field. Problem is populating values in meta fields as well...Opensource platform like Woocommerce shines on this kind of front. Full customisation upto data table level is possible. Let us see , how shopify manages this. Shopify is more of creating avenue for generating revenue for Business partner. Earlier, there was shopify review app - free. Now you have to purchase. Now there are metafields...!

[thejokingdev]

It's still in early access, but soon we'll have the option to add metafields directly to the product's csv.

https://help.shopify.com/en/manual/products/import-export/using-csv#product-metafields-csv-columns