Connect PostgreSQL and Shoplazza

Both apps 27PostgreSQL 10Shoplazza 17

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

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected PostgreSQL database.

• Action
  Add Row

  Adds a new row.

• Action
  Delete Row

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

• Action
  Find Row

  Finds a row in a table via a lookup column.

• Action
  Find Rows via Custom Query

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

• Action
  Find Row via Custom Query

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

• Action
  Update Row

  Updates an existing row.

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

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