Jump to content

Bulk editing product and variant pricing

Go to solution Solved by paul2009,

Recommended Posts

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!

 

Link to comment
  • 3 weeks later...

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

Link to comment
  • Solution
5 hours ago, ITSupportBelfast said:

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.

If you’re on the Commerce Basic or Advanced plan, you can bulk edit products by importing an updated products .csv file that contains the updated information. There isn't a way to bulk edit in other ways within the UI or the App.

It is possible to create different prices for each variant. You do this by creating variant rows in the CSV with different prices in the Price column. I think it's fair to say that Squarespace has an unfamiliar (unhelpful?) way of managing variants in that you must create a variant "row" for each combination of options. For example, as you've probably found, instead of adding two sizes and two colours you must create four rows, one each for:

  • Red & Small
  • Red & Large
  • Blue & Small
  • Blue & Large

For more information see Bulk edit products and Importing products from a .csv.

Improve your online store with our extensions.
About: Squarespace Circle Leader since 2017. I value honesty, transparency, appreciation and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™.
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Buy me a coffee

Link to comment

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

Link to comment
50 minutes ago, ITSupportBelfast said:

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

Yep, that's correct!

Improve your online store with our extensions.
About: Squarespace Circle Leader since 2017. I value honesty, transparency, appreciation and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™.
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Buy me a coffee

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.