Jump to content

Display Sales Data by SKU

Recommended Posts

Site URL: https://www.haveteewilltravel.com/

Hello squarespace experts!

I am looking for advice on a feature I am trying to add to my site. 

Summary: I would like to add client accounts that will display sales information originated from my Squarespace account but only about specific SKU numbers or product names. 

Use: I plan to sell merchandise for individuals. They get a commission of the sales so I would like them to be able to log into a client account and see real time how many sales they have made. 

Method: I am looking into using memberstack to generate and manage the accounts (I'm open to other methods though). This is new to me but I think I can work out adding the code and setting it up. However, I am not sure how to display information from the Squarespace website and how to limit it to specific SKU numbers or product names per account. 

 

If you have any resources, videos, or advice that I could research I would be very grateful for the help. 

Thanks!

Link to comment

You will not be able to build a real-time solution to do this on the Squarespace platform, because you do not have access to the backend data. The order information can be extracted using Squarespace APIs, but this could only be done from a non-Squarespace server. 

About: Squarespace Circle Leader since 2017. I value honesty, transparency, diversity 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.

Catch up on all the release notes and announcements 2023 [for Circle members only]. There's a public version here too!
If I helped, you can thank me by clicking one of the emojis below. If you prefer, you can buy me a coffee.
Improve your online store with our extensions.

Link to comment

Forgive me if I state something that seems obvious as I'm new. 

Could I use an API to export order information to an Excel document, create a sub file that only uses the SKU or product information that I want to display, then embed the code in a code block to show the contents? 

This is the article I was reading based on what you said previously https://support.squarespace.com/hc/en-us/articles/205814348-Displaying-files-on-your-site

Link to comment
1 hour ago, cccruver37 said:

Could I use an API to export order information to an Excel document, create a sub file that only uses the SKU or product information that I want to display, then embed the code in a code block to show the contents?

2 hours ago, cccruver37 said:

I would like them to be able to log into a client account and see real time how many sales they have made.

You could export order information to Excel using the Orders panel. Of course, exporting and embedding won't provide "real time" information.

 

About: Squarespace Circle Leader since 2017. I value honesty, transparency, diversity 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.

Catch up on all the release notes and announcements 2023 [for Circle members only]. There's a public version here too!
If I helped, you can thank me by clicking one of the emojis below. If you prefer, you can buy me a coffee.
Improve your online store with our extensions.

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.