Power BI Connector for Shopify

Build 25.0.9454

InventorySetScheduledChanges

Schedules future changes to inventory levels, allowing time-based stock updates.

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.

  • InventorySetScheduledItems references the InventorySetScheduledItems temporary table.

InventorySetScheduledItems Temporary Table Columns

Column NameTypeDescription
InventoryItemIdStringSpecifies the inventory item to which the change will be applied.
InventoryLevelLocationIdStringThe ID of the location.
LedgerDocumentUriStringA freeform URI that represents what changed the inventory quantities.
InventorySetScheduledItemChanges (references InventorySetScheduledItemChanges)StringAn array of all the scheduled changes for the item.

InventorySetScheduledItemChanges Temporary Table Columns

Column NameTypeDescription
FromNameStringThe quantity name to transition from.
ToNameStringThe quantity name to transition to.
ExpectedAtDatetimeThe date and time that the scheduled change is expected to happen.

Input

Name Type Description
Reason String The explanation or justification for creating the scheduled inventory changes, such as planned restocking.

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 reference URI linking to the document, transaction, or process that triggered the scheduled inventory updates.
InventorySetScheduledItems String A detailed list of inventory items for which scheduled quantity changes will be created or modified.

Result Set Columns

Name Type Description
Success Boolean Indicates whether the operation to create or update scheduled changes completed successfully.
Details String Provides additional information or context about the execution of the scheduled change operation, including errors or warnings if applicable.
ScheduledChanges String A collection of the scheduled inventory changes that were successfully created or updated during the operation.

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