# Customer hex ids during batch creation **URL:** \ **Category:** Uncategorized\ **Created:** [August 14, 2020, 8:04am UTC](https://forum.manager.io/t/customer-hex-ids-during-batch-creation/30033 "2020-08-14T08:04:53Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![xpixelcookiex](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/xpixelcookiex/32/26157_2.png) [@xpixelcookiex](https://forum.manager.io/u/xpixelcookiex)\ **Post date:** [August 14, 2020, 8:04am UTC](https://forum.manager.io/t/customer-hex-ids-during-batch-creation/30033/1 "2020-08-14T08:04:53Z")
I’d like to know how to be aware of customer hex id’s as i would like to use batch create on my invoices and quotes. But i notice they require hex ids of preexisiting customers. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 14, 2020, 8:20am UTC](https://forum.manager.io/t/customer-hex-ids-during-batch-creation/30033/2 "2020-08-14T08:20:48Z")
The UUID function as links between relational database tables. Typically each tab in Manager corresponds to an underlying relational database table. So to find a list of all customers UUID, go to the Customer tab in Manager and do a batch update. The key for each customer is the last field in the line. This key can then be used to specify customer in invoices and quotes ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [August 14, 2020, 9:29am UTC](https://forum.manager.io/t/customer-hex-ids-during-batch-creation/30033/3 "2020-08-14T09:29:31Z")
As correctly stated, the easiest way is to export customer list through Batch Update. To make the easier the creation of the invoices in Excel I suggest than to use VLOOKUP ---
**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:** [January 18, 2023, 2:53pm UTC](https://forum.manager.io/t/customer-hex-ids-during-batch-creation/30033/4 "2023-01-18T14:53:42Z")