# Combine Products

**URL:** <https://community.glideapps.com/t/combine-products/72751>\
**Category:** Ask for Help\
**Created:** [April 20, 2024, 9:07am UTC](https://community.glideapps.com/t/combine-products/72751 "2024-04-20T09:07:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ozodbek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ozodbek/32/79413_2.png) [@Ozodbek](https://community.glideapps.com/u/Ozodbek)\
**Post date:** [April 20, 2024, 9:07am UTC](https://community.glideapps.com/t/combine-products/72751/1 "2024-04-20T09:07:46Z")

</div>

Hello everyone! I have created a sales App of selling drinks. But I have a problem with the Product of several litres. E.g Take Pepsi as an example there 0.5\1\1.5 and 0.33 litres of them. How I can combine them into one Pepsi Card and when I wanna sell them choose litre(NB when I choose litre it must lookup the price of the choosen litre) Thanks in advance!

---

<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:** [April 21, 2024, 12:44am UTC](https://community.glideapps.com/t/combine-products/72751/2 "2024-04-21T00:44:51Z")

</div>

Do all your products have variations or just some of them?

---

<div class="post-metadata">

**Author:** ![Ozodbek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ozodbek/32/79413_2.png) [@Ozodbek](https://community.glideapps.com/u/Ozodbek)\
**Post date:** [April 21, 2024, 6:05pm UTC](https://community.glideapps.com/t/combine-products/72751/3 "2024-04-21T18:05:41Z")

</div>

Some of them because we have for example fruit juices which are in the standard liter.

---

<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:** [April 21, 2024, 11:35pm UTC](https://community.glideapps.com/t/combine-products/72751/4 "2024-04-21T23:35:06Z")

</div>

I would structure your pricing table like this.

| Product | Variation | Price |
| --- | --- | --- |
| Pepsi | 0.5L | 10 |
| Pepsi | 1L | 20 |
| Pepsi | 1.5L | 30 |
| Apple Juice | | 5 |
| Orange Juice | | 4 |

Then in your Products screen, show an Order button that opens up a form. This form would write to an Order Lines table, with columns being: User ID, Product ID, Variant, Quantity.

The form would show fields for inputting quantity, and a variant where your product has variants. You can determine if a product has variants by using a relation + lookup approach on the Products table.

In your Order Lines table, create a query, filtering by Product ID and Variant on the Pricing table. I think empty variants can just take care of themselves, and you can use a single value column to retrieve the price from the query.