Skip to content
English
Go to Flieber, Inc.
  • There are no suggestions because the search field is empty.

How to add and configure Inbound Shipment using Google Sheet

Learn how to add orders in transit to your locations in Flieber

To ensure full visibility into your Inventory Forecast and receive accurate recommendations, it’s essential keep your inbound shipments updated in Flieber. In this article, you’ll learn how to add orders or units using a standardized Google Sheet, automating the process so that whenever your spreadsheet is updated, the data will automatically sync to Flieber.

On the Inbound Shipments page, you can easily add new orders or units in transit and edit shipment details such as expected delivery dates and destination locations. This option is best if your Iinbound Shipments are not connected through a native integration and you want to manually update data within the platform.

 

For a more automated workflow, you can configure Inbound Shipment inputs by integrating a standardized Google Sheets template provided by Flieber. With this setup all information entered into the sheet is automatically synced with Flieber, updates only need to be made in the spreadsheet (no manual editing in the platform) and data is incorporated directly into Flieber’s inventory calculations.

 

 

The standardized spreadsheet is designed to capture all relevant Inbound Shipment data, including Shipment ID, Destination, Delivery Date, SKU, Quantity Ordered, and Shipment Status. Once the data is added, your purchase orders will be reflected in Flieber.

If you already have a standard file containing all your order information, we recommend using formulas such as VLOOKUP and IMPORTRANGE to pull data directly from your spreadsheet into Flieber. Below, we’ll explain how to use these formulas to further automate your Inbound Shipment information.
Click here to learn more about the VLOOKUP formula.
Click here to learn more about the IMPORTRANGE formula.

 

Keeping your inbound shipments updated through Google Sheets ensures improves youur inventory forecasts and replenishment recommendations. By leveraging this integration, you’ll save time, reduce errors, and keep your supply chain running smoothly.