# How to add the number of unit for each item and the "out of stock" message for my e-commerce app

**URL:** <https://community.glideapps.com/t/how-to-add-the-number-of-unit-for-each-item-and-the-out-of-stock-message-for-my-e-commerce-app/42113>\
**Category:** Ask for Help\
**Created:** [May 18, 2022, 12:46pm UTC](https://community.glideapps.com/t/how-to-add-the-number-of-unit-for-each-item-and-the-out-of-stock-message-for-my-e-commerce-app/42113 "2022-05-18T12:46:50Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 19, 2022, 11:20pm UTC](https://community.glideapps.com/t/how-to-add-the-number-of-unit-for-each-item-and-the-out-of-stock-message-for-my-e-commerce-app/42113/10 "2022-05-19T23:20:10Z")

</div>

> [@M\_Nougue](#):
>
> Indeed, I found out that the Item ID was appearing in the “App: Sales” and created the relation column and the rollup column with the instructions quoted below.

I’m not sure you have gone past that step yet or not, but you must create a “mirror” sheet by using a formula to make Glide see the “App: Sales” sheet.

> [@Can't find sales in sheet?](https://community.glideapps.com/t/cant-find-sales-in-sheet/26556/2):
>
> hey @willem In your spreadsheets you’ll see a hiden sheet called App:Sales, use the formula ={'App: Sales'!A:Z} in a new sheet to duplicate the data and make it accessible through the app.

---

_[View the full topic](https://community.glideapps.com/t/how-to-add-the-number-of-unit-for-each-item-and-the-out-of-stock-message-for-my-e-commerce-app/42113)._