How to Update the FBA Product Inventory Master Sheet

Learn how to update shelf life, expiration dates, case-pack configurations, and shipment tracking in your Amazon FBA inventory master spreadsheet.

July 8, 2026 By SellerPro Amazon Agency

This guide explains how to update the FBA Product Master spreadsheet with shelf life limits, expiration dates, and case-pack configurations. Completing this ensures accurate inventory tracking and seamless fulfillment center distribution through Amazon Seller Central.

This workflow is intended for inventory managers, Amazon FBA sellers, and fulfillment teams. Use this guide whenever you are producing new product batches, updating shipping box dimensions, or creating new inbound Amazon shipments.

Update the Per-Product Master

Products have different requirements for tracking longevity. For example, liquid sauces require explicit expiration dates, while dry boosters typically have a constant shelf life.

Step #1: Navigate to the Per-Product Master tab in your Google Sheet. — Navigate to the **Per-Product Master** tab in your Google Sheet.

Step #2: Locate the Shelf Life column and input the static shelf life (e.g., 18 months) for applicable products, or enter N/A for items that use expiration dates instead. — Locate the Shelf Life column and input the static shelf life (e.g., 18 months) for applicable products, or enter **N/A** for items that use expiration dates instead.

For shelf-life items, Amazon tracks the duration in their system automatically. If inventory sits too long and approaches the 90-day cutoff, Amazon will return the unsold product to you.

Configure Case Packs

Instead of managing box dimensions on the master sheet, use the dedicated configuration tab. Lowering the unit count in a single case pack makes it easier to distribute inventory across multiple Amazon fulfillment centers, which can save on shipping costs.

Step #3: Click the Case-Pack Configurations tab at the bottom of the screen. — Click the **Case-Pack Configurations** tab at the bottom of the screen.

Step #4: Select the applicable product variant from the list, such as Cozy. — Select the applicable product variant from the list, such as **Cozy**.

Step #5: Input the new dimensions for your box (e.g., 12 x 9 x 10). — Input the new dimensions for your box (e.g., **12 x 9 x 10**).

Step #6: Select the cell under the Case-Pack Qty column. — Select the cell under the **Case-Pack Qty** column.

Step #7: Choose the correct unit amount for your case (e.g., 30 or 10). — Choose the correct unit amount for your case (e.g., 30 or 10).

Step #8: Select the Packing Template Name (formerly Config Label) field. — Select the **Packing Template Name** (formerly Config Label) field.

Step #9: Enter a descriptive name for the configuration (e.g., Cozy 24ct) so you can easily reference it when building shipments in Seller Central. — Enter a descriptive name for the configuration (e.g., **Cozy 24ct**) so you can easily reference it when building shipments in Seller Central.

Track Shipments and Expiration

You must record dynamic expiration dates and lot numbers for each new shipment batch.

Step #10: Click on the Shipment Tracking tab. — Click on the **Shipment Tracking** tab.

Step #11: Locate the Expiration Date column for the active shipment. — Locate the **Expiration Date** column for the active shipment.

Step #12: Input the updated expiration dates and lot numbers every time a new batch is produced and prepared for Amazon. — Input the updated expiration dates and lot numbers every time a new batch is produced and prepared for Amazon.

Summary of Tracking Tabs

Depending on what you need to record, refer to the correct sheet in the master document:

Tab Name	Best Used For	Data Type
Per-Product Master	Setting baseline product details like static shelf life.	Static
Case-Pack Configurations	Managing dimensions and unit counts for boxes sent to Amazon.	Semi-Static
Shipment Tracking	Recording dynamic expiration dates and lot numbers for new batches.	Dynamic
Inventory Recs / Tracking	Agency use or dispute management for missing fulfillment center units.	As Needed

You do not strictly need to use the Inventory Tracking sheets to reconcile missing boxes. You can pull this exact missing unit data directly from Amazon Seller Central when filing disputes.

Q: How do I track shelf life versus expiration dates?

A: Shelf life is a static duration (e.g., 18 months) that Amazon tracks automatically once entered in Seller Central. Expiration dates are dynamic and must be updated in your tracking sheet for every new batch or shipment.

Q: Why should I configure smaller case packs?

A: Packing fewer units in a case allows you to distribute them more easily across multiple Amazon fulfillment centers, which can save on shipping and network fulfillment costs.

Q: What happens if a shelf-life product sits in inventory too long?

A: If a product gets too old and doesn't sell within Amazon's cutoff date (typically 90 days before the shelf life ends), Amazon will return the remaining inventory to you.

Q: Do I have to use the Inventory Recommendation and Tracking sheets?

A: No, these sheets are primarily designed for external agencies. You can find the same reconciliation and inventory tracking information directly within Amazon Seller Central to handle disputes.

Term	Definition
FBA	Fulfillment by Amazon, a service where Amazon stores, packs, and ships products on behalf of sellers.
Seller Central	The web interface used by brands and merchants to manage and market their products on Amazon.
Case Pack	A standardized box containing multiple identical units of a product sent to a fulfillment center.
Lot Number	An identification number assigned to a particular quantity or batch of material from a single manufacturer.
Shelf Life	The fixed length of time that a product may be stored without becoming unfit for use, consumption, or sale.