Bulk Upload Product Dimensions via CSV file for Metafields

Bulk Upload Product Dimensions via CSV file for Metafields

u005025
Visitor
1 0 0

Hello Shopify Community,

I am trying to process an import of product dimensions via a CSV file and am having trouble. I added metafields to our account and processed an export of all current products to use for the import. I added product dimensions to the corresponding columns (AT, AU,AV AW and AX on the attached file) and tried numerous times to import the file. I keep getting error messages stating the file failed to import due to invalid information, rows are ignored because they did not contain product data, or there is an invalid CSV value ''14.58'' for dimension. I have worked with Shopify Support and they told me to add quotation marks around the dimensions in each cell. This did not work so they advised I try single quotes vs. double quotes. The import still will not process. I have attached a file showing a portion of the data as an example. Additional columns, rows and cells not included in this file contain proprietary information. Data in cells is only populated if it exists in our Shopify store, just as shown in the example. I am using the current product export to add on dimensions for the import CSV file. Please let me know if you have any suggestions or solutions of how to resolve the issues. Thank you!

Reply 1 (1)

Ablestar_Daniel
Shopify Partner
147 26 51

Hi @u005025 ,

 

I think the issue is that dimension metafields need to have a unit associated with them. Can you try a value like 14.58cm and see if that works? The valid units should be mm, cm, m, in, ft, and yd.

I also attached a CSV that I was able to use to update dimension metafields on my test store.

 

If that still doesn't do it let me know and I'll look some more.

 

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!