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

2 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

Please sign in to leave a comment.