copy and paste fields to the product bulk editor

Danman
Tourist
6 1 5

Hi,

 

I'm looking for a way to copy and paste multiple values from a spreadsheet into the fields of the product bulk editor. For example, if I have ten values I copy from my spreadsheet and paste them into the ten open fields of the bulk editor, it puts all ten values into all ten cells. I want it to copy and paste like from one spreadsheet to another.

 

Any ideas?

 

thanks

0 Likes
JonWright
Shopify Partner
727 107 313

Probably better/easier to do an export of the products in question, then open that file in Google Sheets (Excel can introduce some issues, so whilst you can use it, best avoided for this), paste the data you want into the right fields and then import the Google Sheets file back into Shopify.

If helpful then please Like and Accept Solution
0 Likes
enrique00
Tourist
8 0 1

And then what you do after importing back?

0 Likes
natashadisante
Shopify Partner
39 0 1

Hi @Danman ,

Take a look at Mixtable. Mixtable is essentially Google Sheets, but with all Excel-style formulas and behavior. And it seamlessly syncs to and from Shopify. You can easily paste your data as described in order to bulk edit your Shopify store's data.

0 Likes
CharlyR
New Member
1 0 0

Hey guys I am having the same issue.

I am selling prints (over 80 prints available) and each of them have 97 variants (same for all products). I have allocated weights (to calculate shipping accordingly) to each variant of my first product. It took me a little while as there were 97 variants.

I'd like to copy and paste these 97 weights to all my products to save me hours and hours of manually doing 97 variants x 80+ products. HEEEELP!

 

Thanks a lot!

0 Likes