Skip to main content

Inventory History

Retrieve daily SKU-level stock snapshots by warehouse from your TikTok Shop account.

Select Account

Allows you to select the TikTok Shop account from where data will be retrieved.

  • Reload Accounts & Marketplaces:

    • Use this to refresh the connection list if you have recently added or updated in the app.gorillaroi.com

  • Click here to connect additional accounts:

    • Click here to open the Gorilla ROI app, where you can add, update, or manage your account connections.

Period

Select the time range for your report using one of these options:

  • Predefined ranges (e.g., Today, Yesterday, Last 7 Days, Last 30 Days, This Year, Last Month, Last 12 Months, etc.) for quick selection.

  • Custom to choose a specific start and end date.

  • Last X Daily Values to get day-wise historical data for the selected number of past days (e.g., Number of days --> 22).

Metrics

  • SKU ID

  • Warehouse ID

  • Product ID

  • Seller SKU

  • Available Quantity

  • Committed Quantity

  • Total Available Quantity

  • Total Committed Quantity

  • In-Shop Quantity

  • Campaign Inventory

  • Creator Inventory

Group by

  • Period: Shows all datapoints grouped under one time range (e.g., Last 7 Days, Yesterday, etc.).

  • Datapoint: Shows each metric separately, with the time range shown for each.

Filter

Results per Query: Select the maximum number of records (rows) returned in the output (e.g., 5, 10, 50, 100, 500, 1000, 50,000).

Field: Select the field to filter by, such as:

  • Seller SKU (supports EQUALS or CONTAINS)

  • Product ID (supports EQUALS or CONTAINS)

  • Warehouse ID (supports EQUALS or CONTAINS)

Operator: Choose how the filter is applied:

  • EQUALS → Matches the exact value

  • CONTAINS → Matches partial values

Value: Enter the value for the chosen field manually (e.g., Seller SKU, Product ID, Warehouse ID).

Add Filter: Use Add Filter to apply multiple conditions within the same group.

Add Filter Group: Use Add Filter Group to create separate groups for advanced filtering.

Options

Replace Blank Values with 0 or N/A: Replaces empty or missing values with 0 or N/A (where applicable).

No Header Row: Removes the header row from the output.

Products with Data Only: Displays only products that have data, hiding those with no data or activity.

Sample output (partial view) showing selected datapoints

Did this answer your question?