# Batch create & batch update **URL:** \ **Category:** Uncategorized\ **Created:** [June 16, 2021, 1:57pm UTC](https://forum.manager.io/t/batch-create-batch-update/35566 "2021-06-16T13:57:10Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Ahm](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ahm/32/7653_2.png) [@Ahm](https://forum.manager.io/u/Ahm)\ **Post date:** [June 16, 2021, 1:57pm UTC](https://forum.manager.io/t/batch-create-batch-update/35566/1 "2021-06-16T13:57:11Z")
Some columns imported to excel for batch create and/or update are written in codes, even customers names in case of batch update for sales invoice are code and makes it very difficult to achieve the purpose, may be consider real text instead. ---
**Author:** ![AMM](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/amm/32/31994_2.png) [@AMM](https://forum.manager.io/u/AMM)\ **Post date:** [June 16, 2021, 2:17pm UTC](https://forum.manager.io/t/batch-create-batch-update/35566/2 "2021-06-16T14:17:00Z")
I also experience the same problem ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [June 16, 2021, 3:28pm UTC](https://forum.manager.io/t/batch-create-batch-update/35566/3 "2021-06-16T15:28:34Z")
Those are GUIDs, and are necessary to uniquely identify the various subaccounts. This subject has been discussed dozens of times on the forum. The developer has indicated long-term plans to allow plain-language entries, but that is a major software development. ---
**Author:** ![Mahmoud\_Mohsen1](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_mohsen1/32/43036_2.png) [@Mahmoud\_Mohsen1](https://forum.manager.io/u/Mahmoud_Mohsen1)\ **Post date:** [March 2, 2023, 9:30am UTC](https://forum.manager.io/t/batch-create-batch-update/35566/4 "2023-03-02T09:30:10Z")
is there a work around it ? I face the same problem in 2023 🙂 ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [March 2, 2023, 9:46am UTC](https://forum.manager.io/t/batch-create-batch-update/35566/5 "2023-03-02T09:46:50Z")
The programmer has expressed a desire to do this however that has not been implemented yet. Doing so requires all user always use unique names, so achieving a smooth transition to such an implementation will be difficult. In the interim use database lookup tools such as the vlookup() function in spreadsheets to convert from GUID to text names. ---
**Author:** ![Mahmoud\_Mohsen1](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_mohsen1/32/43036_2.png) [@Mahmoud\_Mohsen1](https://forum.manager.io/u/Mahmoud_Mohsen1)\ **Post date:** [March 2, 2023, 10:06am UTC](https://forum.manager.io/t/batch-create-batch-update/35566/6 "2023-03-02T10:06:12Z")
Hi Patch , Thanks for answering . I hope them luck but couldnt the names&code put in seperated coloumns in the DB to facilitate it ( a suggestion for discussion as an ametuer programmer myself) ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [March 2, 2023, 11:54am UTC](https://forum.manager.io/t/batch-create-batch-update/35566/7 "2023-03-02T11:54:28Z")
> [@Mahmoud\_Mohsen1](#): > > but couldnt the names&code put in seperated coloumns in the DB to facilitate it The SQLite database uses the keys to connect the different records. These keys are thus the unique identifier of each record. As @Patch explained this makes a smooth transition to another way more complicated. As an amateur programmer I would advise you to get a free application such as _DB Browser for SQLite_ (Google it) and open a backup business file. You will be able to study the structure, browse the data and thereby get a better understanding of the way keys work and why it will not be easy to change this without complications to ensure connectivity. You can also go to the SQLite homepage and forums that will also explain how the keys work and you could derive from this why we have Batch Update with existing keys and Batch Create that ensures unique key generation. ---
**Author:** ![Mahmoud\_Mohsen1](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_mohsen1/32/43036_2.png) [@Mahmoud\_Mohsen1](https://forum.manager.io/u/Mahmoud_Mohsen1)\ **Post date:** [March 5, 2023, 12:25pm UTC](https://forum.manager.io/t/batch-create-batch-update/35566/8 "2023-03-05T12:25:29Z")
Thanks for the advice I will surely do that ---
**Author:** ![ibadlon](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibadlon/32/37479_2.png) [@ibadlon](https://forum.manager.io/u/ibadlon)\ **Post date:** [March 29, 2023, 11:30am UTC](https://forum.manager.io/t/batch-create-batch-update/35566/9 "2023-03-29T11:30:26Z")
Can it be considered as an improvement that when doing batch create and/or batch update, Line items will be per row line? Example, an invoice having 5 line items, in the excel it will be 5 row lines like below in excel. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/5/e5326394c58a14d52873d9de43126439a1a520e0.png) Right now, it requires multiple sets of columns to create multiple line items - in this case 50columns at least just for the line details. ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [July 5, 2026, 8:06pm UTC](https://forum.manager.io/t/batch-create-batch-update/35566/10 "2026-07-05T20:06:51Z")
Uncategorized topics older than 3 years with no recent activity