How to display Webflow order history in a Memberstack dashboard using Make and Airtable while managing customer shipping and payment preferences? Answered

Post author
Admin QOM

Hello everyone!

I am building a Webflow Ecommerce website, and using Memberstack I was able to create the Customer dashboard that I needed with some features available through Memberstack and it works perfectly so far.

All the shopping process is done through Webflow, only the customer dashboard functionalities are done through Membershtack.

My issues now are as follows:

  1. I need to retrieve the order history data from Webflow Ecommerce and somehow link it to Airtable so I can send it back to Webflow to be viewed in the customer dashboard. Let's say I can make that happen with Make - Airtable - Make (again) - Webflow CMS.
    What I need to see in the customer dashboard is:
    • Order number
    • Order Date
    • Payment status
    • Fulfillment status
    • Total amount
    • Products purchased (at least their names)
      obviously, specific to each customer.
      I'm thinking of creating a new CMS where I save all the Order details as they come in. But how do I filter through all that data?
      What is the best way to solve this issue and make sure that the information seen on the customer dashboard is for that specific customer? Is there a way to do this?
  2. Can the website customers have multiple shipping addresses stored as data in Memberstack and be able to select which one to use at checkout in Webflow?
  3. Is there a way to save the preferred payment method somewhere? For example, if someone uses a card to pay for the order, but next time they use another card we want to have both information stored and displayed? I understand that the payments are processed with Stripe or PayPal, so this might be impossible, but I wanted to ask.
    Or to have the options: Stripe, PayPal, on delivery - and whichever can be selected as the preferred payment method?

Sorry for the long post! Thank you for your time and help!

Comments

4 comments

  • Comment author
    A J

    Hey Admin QOM, for your dashboard requirement, I believe using Webflow CMS reference fields will solve your use-case. You can connect the Orders collection with your Customers collection and then filter the orders data in the dashboard page based on the specific logged in user.

    Hope this helps with your dashboard use-case.

    0
  • Comment author
    Admin QOM

    A J this actually helps a ton, thanks! will give it a try an see how it goes.

    0
  • Comment author
    Development AMCreative

    Hello lovelies! Question. Has anyone attempted to create a customer dashboard with Memberstack for a Webflow Ecommerce website with a functional order history? I'm having trouble doing this and need some guidance. So far I have managed to send the data I see as the site owner from orders to a CMS in Webflow using Make.com, but I have some questions:

    1. how do I filter it for each user? I was thinking of matching the customer email Webflow collects at checkout to the one from Memberstack. But how?
    2. in make.com in the scenario I'm basically copying the orders list I see and sending it to Webflow CMS, but every time it runs it just creates a copy of the list, how can I make it to update the items rather than creating new ones each time?
    3. is it safe to send sensitive data like emails through make.com from the Webflow order list to Webflow CMS? the last thing I want is to have a security breach for something so silly as an order history.

    the customer dashboard exists, and everything from Memberstack I have set there works wonderfully so far, but this order history... has me beat. Thanks for your time lovelies!

    0
  • Comment author
    Duncan from Memberstack

    I've heard this questions quite a few times, but have not had time to build a functional prototype myself. 🤔

    Have you looked into Monto? I wonder if they might be able to handle this? https://www.monto.io/customer-portal

    0

Please sign in to leave a comment.