Connect Spree and SQL Server

Both apps 35Spree 24SQL Server 11

• Trigger
  New Customer

  Triggers when a new customer is created in your Spree store.

• Trigger
  New Order

  Triggers when a new order is created in your Spree store.

• Trigger
  New Product

  Triggers when a new product is created in your Spree store.

• Action
  Add promotion

  Creates a promotion in your Spree store, optionally with its coupon code, rules and discount actions.

• Action
  Add variant

  Creates a new variant (such as a size or color) on a product, with optional per-currency prices and stock levels.

• Action
  Create Customer

  Creates a customer in your Spree store and returns the new customer.

• Action
  Create Draft Order

  Creates a draft order in your Spree store for a customer.

• Action
  Create Product

  Creates a product in your Spree store.

• Action
  Delete Customer

  Deletes a customer from your Spree store.

• Action
  Delete Product

  Deletes a product from your Spree store.

• Action
  Find Customers

  Returns customers in your Spree store matching a search term (name or email).

• Action
  Find fulfillments

  Returns the fulfillments (shipments) of an order, optionally filtered by fulfillment number or date.

• Action
  Find Orders

  Returns orders in your Spree store matching a search term (number or email).

• Action
  Find payments

  Returns the payments on an order, optionally filtered by status, amount, response code or payment method.

• Action
  Find Products

  Returns products in your Spree store matching a search term.

• Action
  Find promotions

  Returns promotions whose name or code matches the search text, optionally filtered by kind or category.

• Action
  Find variants

  Returns variants across all products that match a search on SKU, option value or product name, optionally narrowed by product, channel, market, customer or currency.

• Action
  Get Customer

  Returns one customer from your Spree store by ID.

• Action
  Get Order

  Returns one order from your Spree store by ID.

• Action
  Get Product

  Returns one product from your Spree store by ID.

• Action
  Update Customer

  Updates an existing customer in your Spree store.

• Action
  Update Order

  Updates an existing order in your Spree store.

• Action
  Update Product

  Updates an existing product in your Spree store.

• Action
  Update variant

  Updates an existing product variant's SKU, pricing, stock, dimensions, shipping and option details. Only the fields you fill in are changed.

• 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.