How can I bulk edit variant print_sku's in Order Desk?

Shopify Discussion
,
1

I am not sure if i posted this in the right discussion, so if i haven’t please let me know :slightly_smiling_face:

I am using an app called Order Desk and in order to use it i need edit each of my products variants, specifically the print_sku and print_url. I have 100’s of products and even more variants, so to manually input this would be very time consuming. Each product and it’s variants have the same print_url, which isn’t the problem because it’s all the same file so i can select everything and paste in the url; however, each variant has a different print_sku. This is my problem, i cannot bulk select and paste all the different sku’s with the shopify bulk editor, it pastes all the sku’s im trying to paste into one cell. I’ve tried exporting the products, but i cannot find the column with the print_sku’s, is there a way i can do this? If you guys are unsure what i am talking about you can use the following link to see what i am trying to edit.

https://YOURSHOPIFYNAME.myshopify.com/admin/bulk?resource_name=Product&edit=variants.metafields.global.print_url,variants.metafields.global.print_sku

1 Like
2

Hi @mharr99 ,

Since you are trying to edit custom metafields, Shopify product CSV does not support it. If you are open to apps suggestion you can try Excelify app, - just use the same Shopify CSV file, and add the Metafields columns to it with the column names like “Metafield: .”.

If you are also interested you can hire us https://bit.ly/36CgHKQ to do it for you.

Hope this helps.

1 Like
3

I’ll check it out thanks. Is there a specific guide I can follow for the app and using metafields?

4

Hello @mharr99

Renars here from Matrixify (Excelify) app.

As suggested by @ESSuperCo you sure can use our app to bulk edit your Metafields.

Here we do have an amazing tutorial on how to bulk import and export Metafields from your Shopify store to a spreadsheet file.
In short, the process is really simple:

  1. Create a new export in the app, select to export Products and under Products select Basic Columns, Metafields.
  2. Once the file is exported, open it and you should see Metafield columns in the file for Metafields that are set to the exported Products. Update values in those columns.
  3. Import the file in your store with our app to update those Metafields in your store.

You can also export variant level metafields by selecting the Variant Metafields checkbox when creating an export.

If you have any questions or issues along the way - you can always reach out to our support directly. :slightly_smiling_face:

5

If you’re still looking for a solution I would recommend our Ablestar Bulk Product Editor. With our app, you can easily edit and update metafields like print_sku and print_url for multiple product variants at once.

image (3).png
image (3).png1004×756 57.2 KB

You can use the search and filter functions to find the specific variants that you need to edit, and then update the necessary fields in bulk (unlike in the Shopify Admin you can see the progress of your edit and undo it if necessary).

Additionally, you can export your products to a CSV file and then use the Bulk Product Editor to re-import the updated information back into Shopify.

We also have a free plan of 5 edits/month (with no limit on the number of products) which could be a good fit if you’re just wanting to make a few fixes.