Skip to main content

Create Stock Adjustments in Sumtracker Using Make.com (No-Code)

This guide walks you through automating stock adjustments in Sumtracker using a Google Sheet and Make.com β€” no coding required.

Yaman Garg avatar
Written by Yaman Garg
Updated over 2 weeks ago

πŸ”§ Step 1: Prepare Your Google Sheet

Create a sheet with the following columns:

Column Name

Description

warehouse_id

ID of the warehouse to apply the adjustment

product_id

ID of the product to adjust

type

Type of adjustment (ADD or SUBTRACT)

quantity

Quantity to be adjusted

reason

Reason for the adjustment

Ensure the header row is in the first row of the sheet.

πŸ”„ Step 2: Set Up Google Sheets Trigger in Make

  1. Create a new scenario in Make.

  2. Add a new module β†’ Choose Google Sheets > Watch New Rows.

  3. Configure the module:

    • Connection: Connect your Google account.

    • Search Method: Select Search by path.

    • Drive: Choose My Drive.

    • Spreadsheet ID: Select your prepared file.

    • Sheet Name: Select the relevant sheet.

    • Table contains headers: Yes.

    • Row with headers: A1:E1

    • Limit: Set the number of rows Make should watch (e.g., 10).

  4. Under Choose where to start, select All to process all rows.

🌐 Step 3: Add HTTP Request to Call Sumtracker API

  1. Add another module β†’ Choose HTTP > Make a Request.

  2. Configure the module as follows:

    • Method: POST

    • URL:

      https://inventory-api.sumtracker.com/api/version/2025-03/stock/adjustment/
    • Headers:

Name

Value

Authorization

Api-Key YOUR_API_KEY_HERE

content-type

application/json

accept

application/json

  • Body Type: Raw

  • Content Type: JSON (application/json)

  • Request Body (use Make variables from Google Sheets):

{
"adjustment_type": "<select (type) header>",
"product_id": <select (product_id) header>,
"quantity": <select (quantity) header>,
"warehouse_id": <select (warehouse_id) header>,
"reason": "<select (reason) header>"
}

After selecting the correct headers, request content should look like this:

▢️ Step 4: Run & Test the Scenario

  • Save the scenario.

  • Run once to test.

  • You should see the stock adjustment reflected in Sumtracker immediately.

  • If successful, set the scenario to run automatically on schedule.

Did this answer your question?