Connect SQL Server to WiziShop

Both apps 27SQL Server 11WiziShop 16

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

• Action
  Add customer

  Create a new customer record on the shop.

• Action
  Add order

  Create a new order on the shop.

• Action
  Add product

  Create a new product.

• Action
  Cancel order

  Cancels an order in a WiziShop store, setting its status to cancelled (status code 50).

• Action
  Create Brands

  Create a Brands

• Action
  Delete brand

  Deletes a brand from a WiziShop store.

• Action
  Delete product

  Deletes a product from a WiziShop store.

• Action
  Get brand

  Retrieve a single brand by id.

• Action
  Get customer

  Retrieve a single customer by id.

• Action
  Get product

  Retrieve a single product by id.

• Action
  Get shop

  Retrieve shop-level detail (name, settings).

• Action
  Get SKU

  Retrieves a single SKU (product or variation) by its SKU code, including stock, EAN13, brand and weight.

• Action
  Ship order

  Move an order to the shipped status.

• Action
  Update brand

  Update fields on an existing brand.

• Action
  Update product

  Updates an existing product in a WiziShop store. Only the fields you fill in are changed.

• Action
  Update Sku

  Update Sku's stock: increase, decrease or replace stock.

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