# How do I automatically name the sku in a increases **URL:** \ **Category:** Ask for Help\ **Created:** [July 30, 2022, 10:29am UTC](https://community.glideapps.com/t/how-do-i-automatically-name-the-sku-in-a-increases/45584 "2022-07-30T10:29:30Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [July 30, 2022, 10:29am UTC](https://community.glideapps.com/t/how-do-i-automatically-name-the-sku-in-a-increases/45584/1 "2022-07-30T10:29:31Z")
Hi How can I increase my sku I’d automatically Say, SKU1001 as first I’d,. SKU I’d should not be entered,it automatically increase or decrease based on users activity like edit, delete n add. Now if a user login add a new product it should, SKU1002 SKU1003 SKU1004 If a user deletes SKU1003,SKU1004 should become SKU1003. Or i expect any solution for this. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 30, 2022, 11:02am UTC](https://community.glideapps.com/t/how-do-i-automatically-name-the-sku-in-a-increases/45584/2 "2022-07-30T11:02:05Z")
> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572): > > This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time… ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [July 30, 2022, 11:30am UTC](https://community.glideapps.com/t/how-do-i-automatically-name-the-sku-in-a-increases/45584/3 "2022-07-30T11:30:08Z")
Hi But here Im creating a marketplace,so the business owners allowed to enter their products.so each business owners will add,edit, delete product of their own. How can I ask the business owners to enter the skuid correctly. So i don’t need an skuid here,but i need some fake id in the name of skuid to maintain the total no of products in the app. I gave an example before,if i have,1,2,3 as skuid,if some business owners say their products created in the I’d no “2” 3 will have to become 2.i just change the no only,not other details of the product. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 30, 2022, 1:39pm UTC](https://community.glideapps.com/t/how-do-i-automatically-name-the-sku-in-a-increases/45584/4 "2022-07-30T13:39:23Z")
> [@Manikandan\_R](#): > > SKU1002 > SKU1003 > SKU1004 > > If a user deletes SKU1003,SKU1004 should become SKU1003. Use the option in my second video. You just need a couple of extra columns. - A math column to add 1 to the Row Index (assuming that you want to start at one, not zero) - An (optional) if-then-else column to determine if zero-padding is required: – If RowNumber is less than 10, then 000 – If RowNumber is less than 100, then 00 – If RowNumber is less than 1000, then 0 - A template column to build your SKU number, using the previous two columns. ![Screen Shot 2022-07-30 at 9.34.32 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e60a29914f530fb81718b4c1202074c034ec9e31.png) The above assumes that your SKU’s should always be unique. ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [July 30, 2022, 2:15pm UTC](https://community.glideapps.com/t/how-do-i-automatically-name-the-sku-in-a-increases/45584/5 "2022-07-30T14:15:17Z")
It’s looks fine,i will try n check and see I’m okay with it. Thanks Darren