# Add shipping costs to cart

**URL:** <https://community.glideapps.com/t/add-shipping-costs-to-cart/26702>\
**Category:** Ask for Help\
**Created:** [May 12, 2021, 2:30pm UTC](https://community.glideapps.com/t/add-shipping-costs-to-cart/26702 "2021-05-12T14:30:11Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![rockaddict](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rockaddict/32/26118_2.png) [@rockaddict](https://community.glideapps.com/u/rockaddict)\
**Post date:** [May 12, 2021, 2:30pm UTC](https://community.glideapps.com/t/add-shipping-costs-to-cart/26702/1 "2021-05-12T14:30:11Z")

</div>

Hi. I would like to know if it could be possible to add fixed transport costs to the cart ? For each order…  
thanks

---

<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 12, 2021, 2:54pm UTC](https://community.glideapps.com/t/add-shipping-costs-to-cart/26702/2 "2021-05-12T14:54:36Z")

</div>

You can add it in the Sheet column for price calculation.

---

<div class="post-metadata">

**Author:** ![rockaddict](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rockaddict/32/26118_2.png) [@rockaddict](https://community.glideapps.com/u/rockaddict)\
**Post date:** [May 12, 2021, 9:37pm UTC](https://community.glideapps.com/t/add-shipping-costs-to-cart/26702/3 "2021-05-12T21:37:42Z")

</div>

Ok. But where could I find this column ? Don’t see it ( the column for price calculation) …I’m a real newbie ^^

---

<div class="post-metadata">

**Author:** ![rockaddict](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rockaddict/32/26118_2.png) [@rockaddict](https://community.glideapps.com/u/rockaddict)\
**Post date:** [May 12, 2021, 9:46pm UTC](https://community.glideapps.com/t/add-shipping-costs-to-cart/26702/4 "2021-05-12T21:46:18Z")

</div>

Do you mean in the column where I “put” the price of the item ? Or in another column ?

---

<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 12, 2021, 11:09pm UTC](https://community.glideapps.com/t/add-shipping-costs-to-cart/26702/5 "2021-05-12T23:09:40Z")

</div>

I mean you should create a new column in your Sheet, let’s say “Final price”, then calculate the price using arrayformula.

> [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727):
>
> Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 
> 
> > **1/ Definition**
> >
> > Arrayformula is defined as “a range, mathematical expression using one cell range …

---

<div class="post-metadata">

**Author:** ![rockaddict](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rockaddict/32/26118_2.png) [@rockaddict](https://community.glideapps.com/u/rockaddict)\
**Post date:** [May 13, 2021, 12:12am UTC](https://community.glideapps.com/t/add-shipping-costs-to-cart/26702/6 "2021-05-13T00:12:26Z")

</div>

It works also if I use Glide table ?

---

<div class="post-metadata">

**Author:** ![rockaddict](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rockaddict/32/26118_2.png) [@rockaddict](https://community.glideapps.com/u/rockaddict)\
**Post date:** [May 13, 2021, 12:23am UTC](https://community.glideapps.com/t/add-shipping-costs-to-cart/26702/7 "2021-05-13T00:23:39Z")

</div>

So,if I understand well : in the same glide table than the items, I add a column “Final price” and I calculate this price with an array formula ? So I had to create a button with an action " calculate" ( because it seems to me that if I use the buy button I can’t modify its function)? My items needs a row Id so ? If I add another item, where do this result is ? In which sheet ? Sorry, I don’t see in which “area” the result is temporary placed…

Sorry for all these questions and thanks for the answers

---

<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 13, 2021, 12:40am UTC](https://community.glideapps.com/t/add-shipping-costs-to-cart/26702/8 "2021-05-13T00:40:19Z")

</div>

As far as I aware, you must use a Sheet column in order to utilize the Buy Button, due to technical privacy concerns. That’s why I recommended using arrayformula to calculate it whatever ways you want inside the Sheet.

It would be placed in whatever sheet serves as the base for you to built the screen which places the buy button on.
