Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search

Sort orders by Shipping Option


Recommended Posts

  • Replies 9
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

There's nothing built-in that offers what you need, but Squarespace have a very powerful Orders API that provides access to detailed order data including shipment information. This may be more useful,

You cannot do this within the Squarespace interface, but you can export your orders to a spreadsheet and sort them there. 

sf-digital-signature-logo-email145.png.46606a2288a2847f44d81b9b7b58f3a5.png
Hi, I'm Paul, founder of SF Digital, a specialist company helping Squarespace users by building the features that Squarespace didn't include.
Explore our range of Squarespace Extensions, including the Wishlist, and Datepicker Extension or book a Squarespace Expert for 1:1 help. Note that links in my posts may be affiliate links.

Link to post
  • 2 weeks later...
  • 1 month later...

I'm looking for an option to customize the sales report, too - I'm having exactly the same problem where a client needs to sort "free delivery" from "couriered" items. 

The spreadsheet isn't perfect for sorting this as it only specifies the shipping option per customer, not per each product, so if you data sort by shipping option you lose the information you need.

Link to post
2 hours ago, AJH said:

if you data sort by shipping option you lose the information you need.

There's nothing built-in that offers what you need, but Squarespace have a very powerful Orders API that provides access to detailed order data including shipment information. This may be more useful, although I haven't specifically tried to sort orders by delivery method.

With a Robotic Process Automation (RPA) tool like Parabola or Integromat you may be able to pull the order data from the API, then flatten, filter and/or sort it to meet your requirements. In addition to running an export on demand, these tools allow you to schedule it to run regularly.

 

sf-digital-signature-logo-email145.png.46606a2288a2847f44d81b9b7b58f3a5.png
Hi, I'm Paul, founder of SF Digital, a specialist company helping Squarespace users by building the features that Squarespace didn't include.
Explore our range of Squarespace Extensions, including the Wishlist, and Datepicker Extension or book a Squarespace Expert for 1:1 help. Note that links in my posts may be affiliate links.

Link to post
  • 1 month later...

Hi everyone! I'm JP and I work at Parabola. We have many customers using Parabola to import and transform Squarespace Order Data, just as @paul2009 described.

This Recipe (template) should help you get started with connecting to the Squarespace API: https://parabola.io/recipes/squarespace-orders-analysis

Should you have any questions, our Support Team is ready to help in our Community as well: https://community.parabola.io/

Link to post
  • 1 month later...

Hi JP, I did try Parabola for a short while - there's a good template for Shopify but not for Squarespace. It took me so many steps to try and extract what I wanted in the way I wanted it that we eventuallly gave up. It's a great tool, a little clunky for what I needed, though.

Link to post
  • 3 months later...
On 2/9/2020 at 10:19 AM, paul2009 said:

You cannot do this within the Squarespace interface, but you can export your orders to a spreadsheet and sort them there. 

@paul2009 how do I export to a sheet and have it automated?

Link to post
31 minutes ago, Roxyjee said:

How do I export to a sheet and have it automated?

I guess it depends on what aspect you want to automate.

If you're asking about how to connect to the API and export the data, you may want to check out Parabola's recipe as this template provides the basis for getting started.

RPA tools are extremely customisable so once you've successfully exported the data, there's almost no limit to what you can do, once you are familiar with the tool.

sf-digital-signature-logo-email145.png.46606a2288a2847f44d81b9b7b58f3a5.png
Hi, I'm Paul, founder of SF Digital, a specialist company helping Squarespace users by building the features that Squarespace didn't include.
Explore our range of Squarespace Extensions, including the Wishlist, and Datepicker Extension or book a Squarespace Expert for 1:1 help. Note that links in my posts may be affiliate links.

Link to post

Create an account or sign in to comment

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


×
×
  • Create New...