Skip to main content
P
petel0001
February 7, 2023
Question

Not Likely, But Is This Possible?

  • February 7, 2023
  • 5 replies
  • 0 views

I know that Appian may not be the best environment for this, but I'm wondering if this is possible.

It is possible to create a simple shopping site using Appian?

The table design is simple enough:

CATEGORY
- categoryId
- name
- description

ITEMS
- itemId
- name
- description
- price

LOOKUP_CATEGORY_ITEM
- itemId
- categoryId

CUSTOMER
- customerId
- firstName
- lastName
- street1
- street2
- city
- state
- phone
- email

CART
- customerId
- itemId

I've done this many times before in different languages/environments.
This has MANY TO MANY, MANY TO ONE, aggregations and design/ui considerations with this project.
I've deliberately ignored the payment portion/part of the project.  

    5 replies

    mikes0011
    mikes0011
    Brainy
    February 7, 2023

    I know of no reason why not.  I'm not sure how payment collection / checkout would be handled (as you note), but I assume there's at least a chance some sort of custom / plug-in functionality either may already exist or at least would be plausible to handle that.  And aside from that aspect, the rest could probably be managed via out-of-box UI elements.

    You would probably even be able to handle a live, on-click persistent "shopping cart" functionality for a user with careful enough setup and use of a temp table (where the interface attempts to load any cart items for a particular user upon page load each time a new page is loaded).  AFAIK it could potentially look pretty nice, though it'd be a lot of work.

    The Expression Guru
    csteward
    csteward
    February 7, 2023

    I haven't considered the payment aspect either, but otherwise this will be straightforward with Appian.  Just don't forget QTY in the cart [emoticon:c4563cd7d5574777a71c318021cbbcc8]

    A few of our applications handle related use cases, where orders are entered and approved via a parts catalog or inventory listing which are also maintained in Appian, and we had no issues building those out.

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    February 7, 2023

    Is there a specific reason to believe this cannot be done? It might not work like Amazon, but depending on your use case, why not.

    P
    petel0001Author
    February 7, 2023

    I did not say that it could not be done, and yes from fields may be missing from the quick data model in the first posting like country, etc.
    I was just wondering out loud and I hoped that some people would set the record straight.

    J
    juergeng0002
    February 7, 2023

    Regarding the payment, you can check the example here: https://docs.appian.com/suite/help/22.4/Integration_Tutorial.html#charge-a-credit-card

    Terms & ConditionsAccessibility statement