How to import Products using CSV with metafields

Huy1
Visitor
1 0 0

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.

Replies 11 (11)

Jason
Shopify Expert
11196 226 2287

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.

★ I jump on these forums in my free time to help and share some insights. Not looking to be hired, and not looking for work. http://freakdesign.com.au ★
ben314
Visitor
1 0 0

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
Shopify Partner
319 5 74

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

Matrixify (Excelify) | Bulk Import Export Update Migrate | https://matrixify.app

Liezle
Visitor
1 0 6

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

HCMANDS
Tourist
10 0 13

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

aequivalentin
Tourist
3 0 1

Does it work?

Shua
Shopify Partner
1 0 0

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

 

ElijahStownton
Tourist
17 0 3

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

ten32guitars
Visitor
1 0 1

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
Tourist
16 0 1

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
Shopify Partner
2 0 0

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

Need some help with your store? Email me at contact@thejokingdev.com