# Shopping cart data
**URL:** https://community.glideapps.com/t/shopping-cart-data/29697
**Category:** Ask for Help
**Created:** [July 29, 2021, 11:49am UTC](https://community.glideapps.com/t/shopping-cart-data/29697 "2021-07-29T11:49:14Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [July 29, 2021, 11:49am UTC](https://community.glideapps.com/t/shopping-cart-data/29697/1 "2021-07-29T11:49:14Z")
Hi there,
I’m making a food delivery app where the type of use that’s “customer” can choose food at a restaurant, order and pay through Glide to me, and the “restaurant” type of user can view the orders in a separate tab. But the table with transactions isn’t viewable in the app and I can’t link it as a source to the “Orders” tab.
E.g. If “Restaurant” shares that “scones” are available for purchase, “User” adds them to cart and pays, the transaction is visible in the “App.transactions” tab in Google sheet, but is it possible for the restaurant to also see this transaction in the 'Orders" tab? I.e. can you think the “app.transactions” table to that tab?
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 29, 2021, 12:34pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/2 "2021-07-29T12:34:23Z")
I think you’re referring to the App: Sales tab. In that case please create a new sheet and use this arrayformula in cell A1.
```auto
={'App: Sales'!A:Z}
```
To duplicate the sheet for Glide to “see” it.
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [July 31, 2021, 4:49pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/3 "2021-07-31T16:49:31Z")
Thank you very much, it worked.
However, I’m now having an issue with pulling the vendor’s name and email into that new sheet. Since the data is sent through Stripe, there’s no field to enter the vendor’s (restaurant’s) name.
I have a separate sheet with users where the user types (restaurant and customer) are specified, and a sheet with “Foods on offer”, that pulls data of “restaurant” user types (e-mail, etc.). Is there a way to pull that data into the Orders sheet, so that the “restaurant” could only view its own orders?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 31, 2021, 11:16pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/4 "2021-07-31T23:16:39Z")
What fields are you using for the buy button?
If the data you’re writing to App: Sales has some info related to a restaurant then you can do a relation - lookup then filter.
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [August 1, 2021, 11:35am UTC](https://community.glideapps.com/t/shopping-cart-data/29697/5 "2021-08-01T11:35:39Z")
Customer’s name, user email, SKU, ordered item, amount, price, delivery address, phone number. But these fields come from Stripe payment screen, and there’s no way to customize it by adding the vendor/restaurant to it.
So, I’d like to figure out how to pull the restaurant’s name into the Sales tab in another way.
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 1, 2021, 12:08pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/6 "2021-08-01T12:08:00Z")
Isn’t the SKU tied to the restaurant? Or it’s a global SKU for all restaurants?
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [August 1, 2021, 12:42pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/7 "2021-08-01T12:42:01Z")
SKU is tied to the item sold by the restaurant.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 1, 2021, 12:55pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/8 "2021-08-01T12:55:22Z")
But if it’s unique to the restaurant, then you can do a relation - lookup to get the restaurant info back, is that correct?
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [August 1, 2021, 2:02pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/9 "2021-08-01T14:02:25Z")
Yes, that is correct. Many thanks for your tip, it works now! 😄
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [August 5, 2021, 10:26am UTC](https://community.glideapps.com/t/shopping-cart-data/29697/10 "2021-08-05T10:26:09Z")
I have one more question lol.
I have a “Delivered” button which restaurants can press when the order has been completed. The button has two actions - “delete row” with the data of the relevant order from the duplicated App:sales tab, and “adding row” to another tab where all of that restaurant’s completed orders are contained.
However, when I click the button, all the records are erased from the duplicated App:sales tab, not just the completed order. Is there a way to tweak the formula to make sure only the right orders are erased?
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 5, 2021, 10:32am UTC](https://community.glideapps.com/t/shopping-cart-data/29697/11 "2021-08-05T10:32:23Z")
As you’re “duplicating” the sales sheet by a formula, when you input something into that range, naturally it will break the formula.
Can you go into more details on why you want to delete that row?
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [August 5, 2021, 10:39am UTC](https://community.glideapps.com/t/shopping-cart-data/29697/12 "2021-08-05T10:39:41Z")
Because I want the orders to disappear from the “Open orders” screen.
Is there another way to do that? I tried adding a boolean column that goes “true” when the delivery button is clicked, but that also erases the data.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 5, 2021, 10:57am UTC](https://community.glideapps.com/t/shopping-cart-data/29697/13 "2021-08-05T10:57:04Z")
Assuming you will never delete anything from the App: Sales sheet (the original one), just add the column after the last column in the duplicated sheet and it will stick.
Also you don’t necessarily have to expand A:Z in the formula. Just expand to the last column you need.
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [August 7, 2021, 11:22am UTC](https://community.glideapps.com/t/shopping-cart-data/29697/14 "2021-08-07T11:22:06Z")
Me again 🙂
I want to make sure that restaurants can invoice me (app creator) for the % of the products they’ve sold through the app. I’ve got a separate sheet for invoices and I’ve integrated a Zap through which they send me an email with all the details. But the email looks really clunky and unattractive. Is there a way to make a PDF of the invoice generated on screen (see screenshot - there’s an "issue invoice button at the bottom which triggers the Zap) and then send it to me ?
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 7, 2021, 11:24am UTC](https://community.glideapps.com/t/shopping-cart-data/29697/15 "2021-08-07T11:24:47Z")
Ideally this would be a PDFMonkey integration to pass the fields on the screen to a HTML template but it’s pretty complex.
I don’t know if this works right, I have just searched for it, maybe you can give it a try.
> **[GetScreenshot Integrations | Connect Your Apps with Zapier](https://zapier.com/apps/getscreenshot/integrations)**
>
> Instantly connect GetScreenshot with the apps you use everyday. GetScreenshot integrates with 3,000 other apps on Zapier - it's the easiest way to automate your work.
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [August 8, 2021, 11:51am UTC](https://community.glideapps.com/t/shopping-cart-data/29697/16 "2021-08-08T11:51:20Z")
I created the Zap with GetScreenshot, but it wants the URL of the page I’m screen-grabbing. The URL of the app doesn’t work - I just receive a white blank page PDF in the email I provided.
Should I be using another URL?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 8, 2021, 12:24pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/17 "2021-08-08T12:24:18Z")
Does passing the “link to the current screen” not work? I don’t know if it can grab a screenshot of a screen that requires logging in.
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [August 8, 2021, 2:41pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/18 "2021-08-08T14:41:52Z")
Tried that - still getiting a white page blank PDF 😕 tried it with JPEG too - same result.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 8, 2021, 2:53pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/19 "2021-08-08T14:53:22Z")
So I would recommend using the PDFMonkey approach. It will definitely work, but you would need some time to construct the template.
---
### Author:  [@Kate\_Sorenson](https://community.glideapps.com/u/Kate_Sorenson)
#### Post date: [August 8, 2021, 4:15pm UTC](https://community.glideapps.com/t/shopping-cart-data/29697/20 "2021-08-08T16:15:41Z")
Actually, I figured it out with Webhook! thanks! 😃
[Next page](https://community.glideapps.com/t/shopping-cart-data/29697.md?page=2)