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
  • Replies 3
  • Views 1.2k
  • Created
  • Last Reply

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 me: I'm Paul. A SQSP User for 18 yrs, I joined Circle when it launched in 2016 and have been a Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥.
Work: Founder of SF.DIGITAL, providing expertise and extensions to supercharge your Squarespace website. 
Content: Views and opinions are my own. Links in my posts may refer to my own SF.DIGITAL products or may be affiliate links.
Forum advice is free. You can thank me by clicking one of the feedback emojis below. Coffee fuels my work.

Book paid help with a Squarespace Domain

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 me: I'm Paul. A SQSP User for 18 yrs, I joined Circle when it launched in 2016 and have been a Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥.
Work: Founder of SF.DIGITAL, providing expertise and extensions to supercharge your Squarespace website. 
Content: Views and opinions are my own. Links in my posts may refer to my own SF.DIGITAL products or may be affiliate links.
Forum advice is free. You can thank me by clicking one of the feedback emojis below. Coffee fuels my work.

Book paid help with a Squarespace Domain

Link to comment

Archived

This topic is now archived and is closed to further replies.

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