Connect SellerCloud and SQL Server

Both apps 27SellerCloud 16SQL Server 11

• Trigger
  New Inventory

  Triggers when a new inventory product appears in Sellercloud.

• Trigger
  New Order

  Triggers when a new sales order is created in Sellercloud.

• Trigger
  New Purchase Order

  Triggers when a new purchase order is created in Sellercloud.

• Trigger
  New Queued Job

  Triggers when a new queued job (import, export or other background task) is submitted in Sellercloud.

• Trigger
  Updated Order

  Triggers when a sales order in SellerCloud is created or updated.

• Action
  Adjust Inventory Quantity

  Adds or subtracts physical inventory units for a product in a SellerCloud warehouse, with a reason.

• Action
  Create Customer

  Creates a customer in Sellercloud and returns the new customer's ID.

• Action
  Create Order

  Creates a new sales order in Sellercloud with customer, items, addresses and shipping details.

• Action
  Create Product

  Creates a new product in the Sellercloud catalog with a SKU, name and product type.

• Action
  Find a Customer

  Finds Sellercloud customers by email or keyword.

• Action
  Find an Order

  Finds a Sellercloud sales order by its order ID.

• Action
  Find a Purchase Order

  Finds purchase orders by ID, keyword, status, company, warehouse or date range.

• Action
  Find a Queued Job

  Returns a Sellercloud queued job by its ID, including its status details, progress counts and input/output files.

• Action
  Get Inventory Quantity

  Returns the available and physical inventory quantities of a product (SKU) in each warehouse, or in one warehouse.

• Action
  Update Inventory

  Updates an inventory item's catalog details in Sellercloud, such as name, UPC, weights, dimensions and case quantities.

• Action
  Update Order Shipping Status

  Marks a Sellercloud sales order as shipped, recording its carrier, service, tracking number and package details.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.