---
title: Inventory Import
slug: inventory-import
icon: 📃
docTags: 
createdAt: 2025-10-28T22:17:02.729Z
---

### Overview

Gravity offers a comprehensive multi-location inventory management system, incorporating optional bin locations. The file architecture is organized as follows:

- **Inventory Master**: This contains a single record for every item.
  - **Inventory Location**: Each item/location combination is represented by a dedicated record, which summarizes information such as the quantity on hand for each item/location pairing.
    - **Inventory Site**: This serves as a reference point for every site utilized as an inventory location.
      - **Inventory Bin**: (Optional) This delineates the bins available at each location.
    - **Bin Quantity**: (Optional) This field is used to monitor the quantity on hand for each item/location/bin combination.
    - **Serial/Lot In Stock**: This denotes the serial or lot numbers and associated quantities (if applicable) for each item/location combination, specifically for inventory in the Inventory Master that is classified as serial or lot controlled.
      - **Country of Origin**: (Optional) This maintains a record for each country involved in the procurement of inventory. The Country of Origin feature is solely available with serial or lot tracking.
    - **Inventory Transactions**: This retains one record for each item/location transaction impacting inventory. By utilizing the Apply Date on the records, inventory can be processed with appropriate aging dates.

**Note**: When importing inventory items, the following tables and fields must be synchronized:

- **Inventory Location**
  - **Quantity on Hand**: This must reflect the total quantity of all items in the selected unit of measure for the item/location combinations.
  - **Bin Quantity**: The aggregate of the Quantity on Hand values for all Item/Location records must correspond with the Item Location Quantity on Hand.
  - **Serial/Lot In Stock**: The total of the Remaining Quantity values for all Item/Location records must align with the Item Location Quantity on Hand.
  - **Inventory Transactions**: The sum of the Inventory Quantity values for all Item/Location records must match the Item Location Quantity on Hand.

### Import Templates

::File{src="https://api.archbee.com/api/presign/X2aA_MKMIQid52VOc-G4k/1HyE90WN75k0Ijc9MIPXE-20251028-224929.xlsx" label="Inventory Site Import.xlsx"}

::File{src="https://api.archbee.com/api/presign/X2aA_MKMIQid52VOc-G4k/eJ4OcOKkAzN43x6H55aQh-20251028-225002.xlsx" label="Bin Import.xlsx"}

::File{src="https://api.archbee.com/api/presign/X2aA_MKMIQid52VOc-G4k/2qpjwsfHC4uilEDyZll-T-20251028-225028.xlsx" label="Country of Origin Import.xlsx"}

::File{src="https://api.archbee.com/api/presign/X2aA_MKMIQid52VOc-G4k/WPOv5-p-WoSkjYH1SBd9W-20251028-225048.xlsx" label="Inventory Master Import.xlsx"}

::File{src="https://api.archbee.com/api/presign/X2aA_MKMIQid52VOc-G4k/e2BbEiXs-NW-402hTVqFa-20251028-225107.xlsx" label="Inventory Location Import.xlsx"}

::File{src="https://api.archbee.com/api/presign/X2aA_MKMIQid52VOc-G4k/I3_nWdvb9nXY_C_JBvzZi-20251028-225142.xlsx" label="Bin Quantity Import.xlsx"}

::File{src="https://api.archbee.com/api/presign/X2aA_MKMIQid52VOc-G4k/sR7EyxpBIvp-wvaGi15Yl-20251028-225205.xlsx" label="Serial Lot Import File.xlsx"}

::File{src="https://api.archbee.com/api/presign/X2aA_MKMIQid52VOc-G4k/amKbKaLpbOKPSx36UqKo1-20251028-225238.xlsx" label="Item Transaction Import.xlsx"}