SharePoint List Formatting
Back to view formats
View formattingSharePoint Online

Shopping Cart

The JSON template is designed for an online shopping cart. It displays items within the cart, including product details, pricing, shipping information, and user interactions like adding or removing items.

Get this format View on GitHub

Shared by Sudeep Ghatak
Updated Sep 11, 2024

Shopping Cart formatting preview
Sample preview · View original image

Copy. Apply. Make it yours.

Get this format

1 definition

Review the requirements below, then paste this JSON into the matching formatting panel. Show me where.

Use your list's internal column names and replace any tenant-specific URLs or flow IDs. Formatting is presentation, not a way to secure data.

View formatting
Download JSON
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/view-formatting.schema.json",
  "hideSelection": true,
  "hideColumnHeader": true,
  "rowFormatter": {
    "elmType": "div",
    "style": {
      "width": "600px",
      "height": "auto",
      "background-color": "#f7f9fc",
      "border-radius": "12px",
      "box-shadow": "0 6px 12px rgba(0, 0, 0, 0.1)",
      "padding": "10px",
      "display": "flex",
      "flex-direction": "column",
      "align-items": "center"
    },
    "children": [
      {
        "elmType": "div",
        "style": {
          "width": "100%",
          "height": "100%",
          "display": "flex",
          "align-items": "center",
          "justify-content": "center",
          "padding": "10px"
        },
        "children": [
          {
            "elmType": "img",
            "attributes": {
              "src": "[$ImageUrl]",
              "alt": "[$Title]"
            },
            "style": {
              "max-width": "100%",
              "height": "auto",
              "border-radius": "8px"
            }
          }
        ]
      },
      {
        "elmType": "div",
        "style": {
          "width": "100%",
          "background-color": "#ffffff",
          "border-radius": "10px",
          "box-shadow": "0 4px 8px rgba(0, 0, 0, 0.2)",
          "padding": "10px",
          "overflow": "hidden",
          "display": "flex",
          "flex-direction": "column"
        },
        "children": [
          {
            "elmType": "div",
            "style": {
              "background-color": "#7b4397",
              "color": "#ffffff",
              "font-weight": "bold",
              "padding": "6px 12px",
              "font-size": "14px",
              "margin-bottom": "10px",
              "box-shadow": "0 2px 4px rgba(0, 0, 0, 0.2)"
            },
            "txtContent": "[$Offer]"
          },
          {
            "elmType": "div",
            "style": {
              "font-size": "18px",
              "color": "#333333",
              "font-weight": "bold",
              "margin-bottom": "8px"
            },
            "txtContent": "[$Title]"
          },
          {
            "elmType": "div",
            "style": {
              "margin-top": "10px",
              "display": "flex",
              "align-items": "center"
            },
            "children": [
              {
                "elmType": "span",
                "style": {
                  "color": "grey",
                  "font-style": "italic",
                  "font-weight": "bold",
                  "font-size": "20px",
                  "padding-right": "30px"
                },
                "txtContent": "Units sold: "
              },{
                "elmType": "span",
                "style": {
                  "color": "grey",
                  "font-style": "italic",
                  "font-size": "20px",
                  "padding-right": "30px"
                },
                "txtContent": "[$QuantitySold]"
              },
              {
                "elmType": "span",
                "style": {
                  "color": "grey",
                  "font-style": "italic",
                  "font-weight": "bold",
                  "font-size": "20px",
                  "padding-right": "15px"
                },
                "txtContent": "Rating:"
              },
              {
                "elmType": "span",
                "style": {
                  "color": "#FFD700",
                  "font-size": "20px",
                  "padding-right": "5px"
                },
                "txtContent": "=if([$Rating] >= 1, '★', '')"
              },
              {
                "elmType": "span",
                "style": {
                  "color": "#FFD700",
                  "font-size": "20px",
                  "padding-right": "5px"
                },
                "txtContent": "=if([$Rating] >= 2, '★', '')"
              },
              {
                "elmType": "span",
                "style": {
                  "color": "#FFD700",
                  "font-size": "20px",
                  "padding-right": "5px"
                },
                "txtContent": "=if([$Rating] >= 3, '★', '')"
              },
              {
                "elmType": "span",
                "style": {
                  "color": "#FFD700",
                  "font-size": "20px",
                  "padding-right": "5px"
                },
                "txtContent": "=if([$Rating] >= 4, '★', '')"
              },
              {
                "elmType": "span",
                "style": {
                  "color": "#FFD700",
                  "font-size": "20px",
                  "padding-right": "5px"
                },
                "txtContent": "=if([$Rating] == 5, '★', '')"
              },
              {
                "elmType": "span",
                "style": {
                  "color": "grey",
                  "font-style": "italic",
                  "font-size": "20px"
                },
                "txtContent": "='(' + [$Rating]+ ')'"
              }
            ]
          },
          {
            "elmType": "div",
            "style": {
              "margin-bottom": "10px",
              "display": "flex"
            },
            "children": [
              {
                "elmType": "div",
                "style": {
                  "font-size": "16px",
                  "color": "#333333",
                  "display": "flex",
                  "flex-direction": "column",
                  "font-weight": "bold"
                },
                "children": [
                  {
                    "elmType": "div",
                    "style": {
                      "font-size": "28px",
                      "color": "green",
                      "font-weight": "bold",
                      "margin": "0",
                      "display": "flex",
                      "align-items": "center"
                    },
                    "children": [
                      {
                        "elmType": "span",
                        "style": {
                          "font-size": "16px",
                          "margin-right": "4px"
                        },
                        "txtContent": "$"
                      },
                      {
                        "elmType": "span",
                        "style": {
                          "font-size": "48px"
                        },
                        "txtContent": "[$DollarValue]"
                      },
                      {
                        "elmType": "span",
                        "style": {
                          "font-size": "16px"
                        },
                        "txtContent": "[$CentsValue]"
                      }
                    ]
                  }
                ]
              },
              {
                "elmType": "div",
                "style": {
                  "font-size": "16px",
                  "color": "#666666",
                  "display": "flex",
                  "flex-direction": "column",
                  "padding": "10px",
                  "align-items": "flex-end"
                },
                "children": [
                  {
                    "elmType": "div",
                    "style": {
                      "text-decoration": "line-through",
                      "color": "#999999",
                      "margin-bottom": "4px"
                    },
                    "txtContent": "='Was $' + [$OldPrice]"
                  },
                  {
                    "elmType": "div",
                    "style": {
                      "color": "#d32f2f"
                    },
                    "txtContent": "='Save $' + [$PriceDifference]"
                  }
                ]
              }
            ]
          },
          {
            "elmType": "div",
            "style": {
              "display": "flex",
              "align-items": "center",
              "justify-content": "space-between",
              "margin-bottom": "12px",
              "width": "100%"
            },
            "children": [
              {
                "elmType": "span",
                "style": {
                  "font-size": "16px",
                  "color": "#ff6347",
                  "font-weight": "bold"
                },
                "txtContent": "=if([$Shipping] > 0, 'Shipping: $' + [$Shipping], 'Free Shipping')"
              },
              {
                "elmType": "button",
                "customRowAction": {
                  "action": "setValue",
                  "actionInput": {
                    "AddedToCart": "=if([$AddedToCart] == true, false, true)"
                  }
                },
                "txtContent": "=if([$AddedToCart] == true, 'Remove from cart', 'Add to cart')",
                "style": {
                  "background-color": "#0078d4",
                  "color": "#ffffff",
                  "border": "none",
                  "border-radius": "4px",
                  "padding": "8px 16px",
                  "font-size": "16px",
                  "cursor": "pointer"
                }
              }
            ]
          },
          {
            "elmType": "div",
            "style": {
              "color": "#666666",
              "font-size": "16px",
              "margin-bottom": "12px"
            },
            "txtContent": "[$Description]"
          }
        ]
      }
    ]
  }
}
View sourceLink to this definitionshopping-cart.json

From the contributor

How to use this sample

Summary

The JSON template is designed for an online shopping cart. It displays items within the cart, including product details, pricing, shipping information, and user interactions like adding or removing items.

Clicking on 'Add to Cart' updates the 'AddedToCart' field to true and changes the display text to 'Remove from Cart'

screenshot of the sample

View requirements

Column Name Type
Title Single line of text
Description Multiple lines of text
Price Currency (Number of decimal places=2)
OldPrice Currency
ImageUrl Single line of text
Offer Single line of text
CalculatedPrice Calculated (calculation based on other columns)(Formula = =ROUND(Price,2)) (Type = 'Single line of text')
PriceDifference Calculated (calculation based on other columns)(Formula = =OldPrice-Price) (Type = 'Single line of text')
Rating Number
DollarValue Calculated (calculation based on other columns)(Formula = =INT(Price)) (Type = 'Single line of text')
CentsValue Calculated (calculation based on other columns)(Formula = =TEXT(ROUND((Price-INT(Price))*100,0),"00"))(Type = 'Single line of text')
QuantitySold Number
AddedToCart Yes/No
Shipping Currency

Sample

Solution Author(s)
shopping-cart.json Sudeep Ghatak

Version history

Version Date Comments
1.0 September 11, 2024 Initial release

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

Additional notes

None

Keep exploring

More formats like this

Picture Link Tiles Doc Lib

Creates a card-style tile view in a SharePoint Document Library with file previews, badges, titles, and a footer with actions.

Explore format

Book Template Card Formatter

This SharePoint JSON view formatting sample transforms your list items into visually rich book cards.

Explore format

Employee Recognition Card

This sample acts as a digital shout-out board for your team, built right into SharePoint. It gives employees an easy way to recognize and appreciate each other's hard work. Colleagues can show their support by clicking on emojis to cast their votes.

Explore format