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

Display Sales Data by SKU


cccruver37

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 post
  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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. 

sf-digital-signature-logo-email145.png.46606a2288a2847f44d81b9b7b58f3a5.png
Hi, I'm Paul, founder of SF Digitalbuilding the features that Squarespace didn't include. Pick dates in any format, show prices in other currencies, take orders without payment or improve your cartI value honesty, integrity, transparency and respect. Links in my posts may refer to SF Digital products or may be affiliate links.  Squarespace. I've been a loyal supporter of the platform since 2007. 

Link to post

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 post
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.

 

sf-digital-signature-logo-email145.png.46606a2288a2847f44d81b9b7b58f3a5.png
Hi, I'm Paul, founder of SF Digitalbuilding the features that Squarespace didn't include. Pick dates in any format, show prices in other currencies, take orders without payment or improve your cartI value honesty, integrity, transparency and respect. Links in my posts may refer to SF Digital products or may be affiliate links.  Squarespace. I've been a loyal supporter of the platform since 2007. 

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...