Bulk editing product and variant pricing

I have recently started moving over to Squarespace from Indiemade and bringing listings from commerce sites. I'm in love with all the functionality but I seem to have really hit a snag with bulk editing listings? Am I missing something?

My listings have several variations and I have nearly 200 hundred listings. I want to be able to quickly say, select a shop category and decrease pricing by a set amount but I can't seem to be able to do something like this? It wants me do every single variation and on every single listing manually.

Is the ONLY way of doing this via downloading a CSV of your inventory and bulk editing through Excel? Why is there no user friendly way of doing this?

I was also setting up a custom listing with lots of options. Now normally I would expect say option A means +£2 is added, option b means £10 is added, and it would automatically price this up. Instead, all I found was 192 variations needing me to manually work out and input a prices.

This is madness! Please say I'm missing something obvious?? I would really appreciate some help / insight!

I’m having the exact same issue here,

It took me days to do it all manually as I couldn’t find a solution. 

They need to do something, even group variants together as an option. 
 

I can’t contact support either it makes me select a topic and when I pick one takes me off the contact form, send greyed out. 

Robert 

Hey,

I would like to know how to do this as well. I will be uploading over 2000 products onto my website when squarespace fix the current issues i have at the moment but as you can imagine manually updating over 2000 products is just not practical. Because squarespace do not offer a postcode restriction for the UK (I am in Northern Ireland and my prices vary between NI, Channel Islands and UK mainland) i am having to use product variant as a workaround. So what my plans are is to add a variant title named shipping region and then 2 options 1 for the UK mainland which keeps the product at standard price and then the other option for Northern Ireland and Channel Islands which adds the extra surcharge. I can see that you can add these options via the CSV but it does not allow you to create the 2 different pricing structures. Can we get a reply on this to advise if bulk editing 2 different pricing structures on the variants is possible. This will really be the icing on the cake for me in terms of whether i decide to ditch squarespace and go back to wordpress.

Thanks

Gary

Hey Paul,

Thank you for the reply. So what i see in the CSV file is option name and option value. So the way i understood it is in option name i would put in shipping region and then option value would be United Kingdom, Northern Ireland and Channel Islands however it does not stipulate you can put a price value in there. So in order for me to achieve what i am looking to do will i need to place 1 product onto the website, put in all the details required and then export that 1 product to see how it looks in the CSV file?

Thanks

Gary

Paul,

Ignore that i know how to do it now as i have just tested it. So you literally have to add the seperate prices in the price column against each variant. Thank you again for your response.

Thanks

Gary

50 minutes ago, ITSupportBelfast said:

you literally have to add the separate prices in the price column against each variant.

Yep, that's correct!