JDBC Driver for Shopify

Build 25.0.9434

InventoryAdjustQuantities

Apply changes to inventory quantities.

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 quantity name to be adjusted.

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

Reason String The reason for the quantity changes.

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 freeform URI that represents why the inventory change happened.
InventoryAdjustChanges String The quantity changes of items at locations to be made.

Result Set Columns

Name Type Description
Success Boolean Indicates whether or not the operation executed successfully.
Details String Any extra details on the operation's execution.
Id String The ID of the group of changes made by the operation.

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