Power BI Connector for Shopify

Build 25.0.9454

InventorySetQuantities

Sets absolute inventory quantities for specified quantity names at a location.

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.

  • InventorySetChanges references the InventorySetChanges temporary table.

InventorySetChanges Temporary Table Columns

Column NameTypeDescription
InventoryItemIdStringSpecifies the inventory item to which the quantity will be set.
InventoryLevelLocationIdStringSpecifies the location at which the quantity will be set.
CompareQuantityIntThe current quantity to be compared against the persisted quantity.
QuantityIntThe quantity to which the inventory quantity will be set.

Input

Name Type Description
Name String The name of the quantity group to update.

The allowed values are available, on_hand.

Reason String The reason provided for making 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 URI reference that identifies the source or context for the inventory change.
IgnoreCompareQuantity Boolean Specifies whether to skip the compare-quantity check before applying updates.
InventorySetChanges String The new quantity values to assign for each inventory item and location.

Result Set Columns

Name Type Description
Success Boolean Indicates whether the operation completed successfully.
Details String Additional details about how the operation was executed.
Id String The unique ID assigned to the group of quantity changes created by the operation.

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