# Import inventory Batch create

**URL:** https://forum.manager.io/t/import-inventory-batch-create/35186
**Category:** Uncategorized
**Created:** [May 26, 2021, 7:43am UTC](https://forum.manager.io/t/import-inventory-batch-create/35186 "2021-05-26T07:43:36Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Terrymac](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/terrymac/32/31826_2.png) [@Terrymac](https://forum.manager.io/u/Terrymac)
#### Post date: [May 26, 2021, 7:43am UTC](https://forum.manager.io/t/import-inventory-batch-create/35186/1 "2021-05-26T07:43:36Z")

</div>

OK

Have setup the spreadsheet for the inventory and done a test run, however it fails to pick up the Tax code and custom expenses field in Batch Create, tax code is as below (for Aust)

TaxCode  
GST 10%

Batch Create custom expense account  
Inventory - cost

Would appreciate any advice on what I am doing wrong as have to many to adjust manually

thanks

---

<div class="post-metadata">

### Author: ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)
#### Post date: [May 26, 2021, 8:03am UTC](https://forum.manager.io/t/import-inventory-batch-create/35186/2 "2021-05-26T08:03:01Z")

</div>

1. Enter some representative data manually via the GUI

2. Do a Batch update

3. Look at the details of the records exported. They are identical to what you would have required to create them with a batch create except for the final “Key” field

Data base records in Manager have an underlying unique identifier GUID or UUID

- The GUID is used to link data in one table to another, for example link an inventory item to the Tax code database table.

- When using batch create or update you need to supply this pointer value/ GUID.

- Lubos apparently is planning to replace the GUID with unique record names however doing so would require users to use unique names in their businesses.

- For records which are the same as you testing manual entries you can just copy the GUID form them.

- GUID is shown in grey in the top right corner of most screens.

- A list of all GUID for a database table is available by doing a batch update on the destination tab. VLOOKUP can be used in a spread sheet to convert between the GUID and records name.

---

<div class="post-metadata">

### 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:20pm UTC](https://forum.manager.io/t/import-inventory-batch-create/35186/3 "2026-07-05T20:20:55Z")

</div>

Uncategorized topics older than 3 years with no recent activity