Connect Shoplazza and SQL Server

Both apps 28Shoplazza 17SQL Server 11

• Trigger
  New Product

  Triggers when a new customer is added to your Shoplazza account.

• Trigger
  Updated Customer

  Triggers when a customer's information is updated.

• Action
  Adjust Inventory Quantity

  Add to or subtract from the on-hand stock of an inventory item at a location.

• Action
  Create Customer

  Creates a new customer in your Shoplazza store, identified by email or phone, with optional name, tags, addresses and marketing preferences.

• Action
  Create Product

  Creates a product in your Shoplazza store, with its images, options and variants.

• Action
  Create Variant

  Creates a new variant on an existing Shoplazza product, with its price, options, SKU, inventory and shipping details.

• Action
  Delete product

  Deletes a product from your Shoplazza store.

• Action
  Find Customer

  Finds customers in your Shoplazza store by email, phone or email contact, customer ids, or created/updated date range.

• Action
  Find Product by Title

  Finds products in your Shoplazza store whose title matches the one you give, returning the first match and the full list.

• Action
  Get customer

  Returns a customer's full details, including contact info, marketing preferences, order totals and saved addresses.

• Action
  Get product

  Returns a single product by its ID, including its options, images and variants.

• Action
  List customers

  Returns the store's customers, optionally filtered by email, contact, IDs or created/updated date ranges.

• Action
  List Inventory Levels

  Returns inventory (stock) levels for inventory items across store locations, optionally filtered by item, location or update time.

• Action
  List products

  Returns the products in the store, optionally filtered by keyword, publish status, vendor, collection or tags.

• Action
  Update Customer

  Updates an existing customer's name, marketing subscriptions and tags in your Shoplazza store.

• Action
  Update Product

  Updates an existing product in your Shoplazza store, such as its title, description, pricing, tags, images, options and variants. Only the fields you fill in are changed.

• Action
  Update Product Variant

  Updates an existing product variant's price, options, SKU, inventory, weight and other 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.