JDBC Driver for Shopify

Build 25.0.9434

InventoryAdjustQuantities

Applies relative changes to inventory quantities for specified items.

Procedure-Specific Information

The following input can accept either a temporary table name or a JSON aggregate that matches the structure of the referenced table as a value.

  • InventoryAdjustChanges references the InventoryAdjustChanges temporary table.

InventoryAdjustChanges Temporary Table Columns

Column NameTypeDescription
InventoryItemIdStringSpecifies the inventory item to which the change will be applied.
InventoryLevelLocationIdStringSpecifies the location at which the change will be applied.
LedgerDocumentUriStringA freeform URI that represents what changed the inventory quantities.
DeltaIntThe amount by which the inventory quantity will be changed.

Input

Name Type Description
Name String The name of the inventory quantity to adjust.

The allowed values are available, damaged, quality_control, reserved, safety_stock.

Reason String The reason for making the inventory adjustment.

The allowed values are correction, cycle_count_available, damaged, movement_created, movement_updated, movement_received, movement_canceled, other, promotion, quality_control, received, reservation_created, reservation_deleted, reservation_updated, restock, safety_stock, shrinkage.

ReferenceDocumentUri String A URI identifying the origin or context of the adjustment (for example, the related Shopify resource or external document).
InventoryAdjustChanges String The set of item quantity changes to apply across specific locations.

Result Set Columns

Name Type Description
Success Boolean Indicates whether the operation completed successfully.
Details String Additional details about the execution of the operation.
Id String The globally unique identifier of the adjustment group created by the operation.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434