# How to pass on complex SKU to Product ID buy button? **URL:** \ **Category:** Ask for Help\ **Created:** [May 22, 2020, 10:12pm UTC](https://community.glideapps.com/t/how-to-pass-on-complex-sku-to-product-id-buy-button/9608 "2020-05-22T22:12:18Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![nvandable](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nvandable/32/7802_2.png) [@nvandable](https://community.glideapps.com/u/nvandable)\ **Post date:** [May 22, 2020, 10:12pm UTC](https://community.glideapps.com/t/how-to-pass-on-complex-sku-to-product-id-buy-button/9608/1 "2020-05-22T22:12:18Z")
Hello, I made a public app with a list of products with various options to choose from. For instance a type of pizza and then some extra toppings to choose from. The pizza itself has an SKU and the extra toppings have also SKU. All the selections made by the client are recorded using user specific columns. I am combining SKU values using a template column that i would like to use as the Product ID in the buy button but glide does not allow me to do so… Please help, is there anyone who found a solution to this kind of issue? Thanks Nicolas ---
**Author:** ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)\ **Post date:** [May 24, 2020, 10:27am UTC](https://community.glideapps.com/t/how-to-pass-on-complex-sku-to-product-id-buy-button/9608/2 "2020-05-24T10:27:52Z")
I had a need to pass an ID to my SKU. So I created a column in my google sheet. It is an array formula that picks up and joins two columns. AX is column with SKU and A2 is a unique Row ID. _**=ARRAYFORMULA(if(AX2:AX \<\> “”, AX2:AX & “~~~” & A2:A, “”))**_ In addition, see this post if it is helpful. > [@How to handle this with "App: Sales"?](https://community.glideapps.com/t/how-to-handle-this-with-app-sales/4357/9): > > Thanks Jeff. I keep exploring this. But if those two attributes of the buy button start acting like the first three, it would be really great. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 25, 2020, 8:03pm UTC](https://community.glideapps.com/t/how-to-pass-on-complex-sku-to-product-id-buy-button/9608/3 "2020-05-25T20:03:14Z")
I think Name, ID and Price do not work with templates or possibly user specific columns. I would try to incorporate all that information into the description as that appears to be more open to template columns. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [July 20, 2020, 3:20am UTC](https://community.glideapps.com/t/how-to-pass-on-complex-sku-to-product-id-buy-button/9608/4 "2020-07-20T03:20:56Z")
Hi Jeff…you’re right. Name doesn’t accept Template columns for whatever reason (@mark—your input here?). But the description also doesn’t write to sheet—only the cart before entering CC info. Alternatives? ---
**Author:** ![Gregory](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory/32/21180_2.png) [@Gregory](https://community.glideapps.com/u/Gregory)\ **Post date:** [May 23, 2021, 8:44am UTC](https://community.glideapps.com/t/how-to-pass-on-complex-sku-to-product-id-buy-button/9608/5 "2021-05-23T08:44:39Z")
@nvandable , maybe it is still relevant, as I needed to cope with the same issue: I think it is best to work with a “orders” sheet, let users configure new orders, add a row for every new order, concatenate in gsheets to make a complex SKU, and add a buy button to place a new order. With user specific columns you run into even more problems. like this: [“Item No Longer Available” Buy Button issue - Glide Community (glideapps.com)](https://community.glideapps.com/t/item-no-longer-available-buy-button-issue/18795) ---
**Author:** ![dripdrop](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dripdrop/32/38576_2.png) [@dripdrop](https://community.glideapps.com/u/dripdrop)\ **Post date:** [January 31, 2023, 7:06pm UTC](https://community.glideapps.com/t/how-to-pass-on-complex-sku-to-product-id-buy-button/9608/6 "2023-01-31T19:06:49Z")
Is there a solution to this? ---
**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:** [February 1, 2023, 12:27am UTC](https://community.glideapps.com/t/how-to-pass-on-complex-sku-to-product-id-buy-button/9608/7 "2023-02-01T00:27:52Z")
Basically what Gregory said above, but it’s complex. > [@How to do I add a order customization addons for each products on my store and it has to automatically?](https://community.glideapps.com/t/how-to-do-i-add-a-order-customization-addons-for-each-products-on-my-store-and-it-has-to-automatically/56554/3): > > I think you have to either: Add each product variant on its own row, e.g: White T-Shirt Red T-Shirt Yellow T-Shirt And pre-calculate the cost for each item, have the “add to cart” button on each independent screen. This uses the native buy button flow. Or have only one T-Shirt row, add your add-ons (white, red, yellow). Make the user choose an add-on, calculate the cost with a math column, then when the user clicks the “Check Out” button, you add a row to the Orders table with info of the …