MySQL + Webhooks by Zapier + Shift4Shop Integrations

How to connect MySQL + Webhooks by Zapier + Shift4Shop

Zapier lets you send info between MySQL, Webhooks by Zapier, and Shift4Shop automatically—no code required.

When this happens...

automatically do this...

then do this!

Free forever for core features
14 day trial for premium features & apps

Do even more with MySQL + Webhooks by Zapier + Shift4Shop

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with MySQL, Webhooks by Zapier, and Shift4Shop. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
  Query results must have a unique id field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.
  Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
  Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].
- Order ByRequired
  Usually something like date_updated or last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.
- Trigger Column
  Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
  You should include desired ordering and limiting (usually to 1 record) in the query.
  This query must run in less than ~30 seconds.
Action
Search

Catch Raw Hook
Wait for a new POST, PUT, or GET to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.
Trigger
Instant
Try It
- MethodRequired
  The HTTP method we'll use to perform the request.
- URLRequired
  Any URL with a querystring will be re-encoded properly.
- Data Pass-Through?
  If yes, request data below will be overridden with the raw data from the previous step (you are still responsible for headers though, like Content-Type). Defaults to no.
- Data
  Place raw data for the request here. Could be JSON, XML, etc. Nothing is parsed for you here (including extra line breaks or spaces -- everything is sent verbatim). You probably need to define a header below corresponding to your data Content-Type. Reminder: data provided in this field is completely ignored if you chose "yes" to pass-through.
- Unflatten
  By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Action
Write

- URLRequired
  Any URL with a querystring will be re-encoded properly.
- Payload Type
  Pay special attention to the proper mapping of the data below.
- Data
  These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
- Wrap Request In Array
  Wraps the request in an array if that is something the service requires.
- File
  A file object to be attached to the request. The request will automatically be converted to multipart/form-data, with the above payload type defining the sub content-type for the data being passed.
- Unflatten
  By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Action
Write
New Customer
Triggers when a new customer is created.
Trigger
Instant
Try It
Order Status Change
Triggers when the status of an order is changed.
Trigger
Instant
Try It
Product Deleted
Triggers when a product is deleted.
Trigger
Instant
Try It
Product Stock Changed
Triggers when a product stock changed.
Trigger
Instant
Try It
- OrderKeyRequired
  Orderkey.
- ItemQuantity
  Item Quantity.
- CatalogIDRequired
  CatalogID.
Action
Write
- BypassOrderProcessing
  Bypass order processing flag.
- BypassOrderEmail
  Bypass order email flag.
- InvoiceNumberPrefix
  Order's Invoice Prefix.
- InvoiceNumber
  Order's invoice number.
- CustomerID
  Order's customer id.
- OrderDate
  Order date.
- OrderStatusID
  Order's status id.
- AlternateOrderID
  Order's alternate id.
- BillingFirstNameRequired
  Order's billing first name.
- BillingLastNameRequired
  Order's billing lastname.
- BillingCompany
  Order's billing company.
- BillingAddressRequired
  Order's billing address.
- BillingAddress2
  Order's billing address 2.
- BillingCityRequired
  Order's billing city.
- BillingState
  Order's billing state.
- BillingZipCode
  Order's billing zipcode.
- BillingCountryRequired
  Order's billing country.
- BillingPhoneNumberRequired
  Order's billing phone number.
- BillingEmail
  Order's billing email.
- BillingOnLinePayment
  Billing online payment flag.
- BillingPaymentMethodID
  Billing payment method id.
- ShipmentOrderStatus
  Shipment order status.
- ShipmentAddressRequired
  Shipment address.
- ShipmentAddress2
  Shipment Address 2.
- ShipmentCityRequired
  Shipment city.
- ShipmentCompany
  Shipment company.
- ShipmentCountryRequired
  Shipment country.
- ShipmentEmail
  Shipment email.
- ShipmentFirstNameRequired
  Shipment firstname.
- ShipmentLastNameRequired
  Shipment lastname.
- ShipmentMethodName
  Shipment method name.
- ShipmentShippedDate
  Shipment shipped date (mm/dd/yyyy).
- ShipmentPhoneRequired
  Shipment phone.
- ShipmentStateRequired
  Shipment state.
- ShipmentZipCodeRequired
  Shipment zipcode.
- ShipmentTax
  Shipment tax.
- ShipmentTrackingCode
  Shipment tracking code.
- ShipmentNumberRequired
  Shipment number.
- CatalogIDRequired
  CatalogID.
- ItemID
  ItemID.
- ItemShipmentID
  Item Shipment ID.
- ItemQuantity
  Item Quantity.
- ItemDescription
  Item Description.
- ItemUnitPrice
  ItemUnitPrice.
- ItemWeight
  Item weight.
- ItemOptionPrice
  Item option price.
- ItemUnitCost
  Item unit cost.
- ItemUnitStock
  Item unit stock.
- OrderDiscount
  Order discount.
- SalesTax
  Sales Tax.
- OrderAmount
  Order amount.
- TransactionID
  Transaction ID.
- TransactionDateTime
  Transaction datetime.
- TransactionType
  Transaction type.
- TransactionMethod
  Transaction method.
- TransactionAmount
  Transaction amount.
- TransactionApproval
  Transaction approval code.
- TransactionReference
  Transaction reference.
- TransactionCVV2
  Transaction CVV 2.
- TransactionAVS
  Transaction AVS.
- TransactionResponseText
  Transaction response text.
- TransactionResponseCode
  Transaction response code.
- TransactionCaptured
  Transaction captured flag.
- Referer
  Referer.
- Ip
  IP.
- CustomerComments
  Customer comments.
- InternalComments
  Internal comments.
Action
Write
- Sku
  SKU of the product.
- NameRequired
  Product's name.
- Cost
  Product's cost.
- PriceRequired
  Price of the product.
- RetailPrice
  Retail price of the product.
- SalePrice
  Sale price of the product.
- OnSale
  Product's OnSale Flag.
- Stock
  Stock of the product.
- ShortDescription
  Product's short description.
- Gtin
  GTIN of the product.
- Weight
  Weight of the product.
- Height
  Height of the product.
- Width
  Width of the product.
- Depth
  Depth of the product.
- Description
  Product's description.
- Keywords
  Product's keywords.
- MainImageFile
  Product main image file path.
- MainImageCaption
  Product's main image caption.
- ThumbnailFile
  Product's thumbnail file path.
- AdditionalImageFile2
  Product's additional image file path 2.
- AdditionalImageCaption2
  Product's additional image caption 2.
- AdditionalImageFile3
  Product's additional image file path 3.
- AdditionalImageCaption3
  Product's additional image caption 3.
- AdditionalImageFile4
  Product's additional image file path 4.
- AdditionalImageCaption4
  Product's additional image caption 4.
- Title
  Product's title.
Action
Write
- OrderKeyRequired
  Order's orderkey.
Action
Search
- InvoicePrefix
  Order's invoice prefix.
- InvoiceNumber
  Order's invoice number.
- OrderStatus
  Order's order status.
- BillingEmail
  Order's billing email.
- DateStart
  Date Start (mm/dd/yyyy hh:mm:ss).
- DateEnd
  Date End (mm/dd/yyyy hh:mm:ss).
- LastUpdateStart
  Start Date that the product was last updated (mm/dd/yyyy hh:mm:ss).
- LastUpdateEnd
  End Date that the product was last updated (mm/dd/yyyy hh:mm:ss).
Action
Search

- Table/ViewRequired
  We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
- Order By
  Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like date_created or your autoincrement id. Column names that contain a space must be enclosed within brackets [ ].
- Dedupe Key
  We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- URLRequired
  This should return a list of dictionaries of content type JSON in reverse chronological order. For example: [{"id":1234},{"id":1235}]
- Key
  If the returned JSON is not a list and is instead an object (maybe paginated), enter the key that contains the results. Example: "results", "items", "objects", etc... (children via dot syntax supported)
- Deduplication Key
  Zapier deduplicates the array we see each poll against the id key. If the id key does not exist, you should specify an alternative unique key to deduplicate off of. If neither are supplied, we fallback to looking for the shortest key with id in it otherwise we will raise an error.
- Xpath
  If the content fetched is XML or HTML, optionally define an xpath to extract data from the content. Will trigger whenever the content at the xpath changes!
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Trigger
Scheduled
Try It
- Pick off a Child Key
  By default, Zapier gives you the entire payload of the webhook. If this is specified, Zapier will only grab the child key from the object(s) sent to Zapier. For example, given {"contact": {"name": "Mike"}}, add "contact" here to only return {"name": "Mike"}. Traverse more deeply nested children by using dot-separated syntax. Line item payloads will run your Zap for each instance of the child key.
Trigger
Instant
Try It
- URLRequired
  We recommend not putting any query string arguments in the URL (use "Query String Params" below).
- Query String Params
  These params will be URL-encoded and appended to the URL when making the request. Note: If you specify nothing for this field, we will automatically encode and include every field from the previous step in the query string. If you don't want this, use the "Custom Request" action.
- Send As JSON
  If "yes", this dumps the results directly to a key (set below) as JSON. If "no", we simulate a form.
- JSON key
  Only used if As JSON.
- Unflatten
  By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Action
Write
- URLRequired
  Any URL with a querystring will be re-encoded properly.
- Payload Type
  Pay special attention to the proper mapping of the data below.
- Data
  These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
- Wrap Request In Array
  Wraps the request in an array if that is something the service requires.
- File
  A file object to be attached to the request. The request will automatically be converted to multipart/form-data, with the above payload type defining the sub content-type for the data being passed.
- Unflatten
  By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
- Basic Auth
  A pipe (|) separated username, password combo for standard HTTP authentication.
- Headers
  Key, value pairs to be added as headers in all requests.
Action
Write
New Order
Triggers when a new order is placed.
Trigger
Instant
Try It
Product Changed
Triggers when a product changed.
Trigger
Instant
Try It
Product New
Triggers when a new product is created.
Trigger
Instant
Try It
- CustomerId
  Customer id.
- BillingFirstName
  Billing firstname.
- BillingLastName
  Billing lastname.
- BillingCompany
  Billing company.
- BillingAddress
  Billing address.
- BillingAddress2
  Billing address2.
- BillingCity
  Billing city.
- BillingState
  Billing state.
- BillingZipCode
  Billing zipcode.
- BillingCountry
  Billing country.
- BillingPhoneNumber
  Billing phone number.
- BillingEmail
  Billing email.
- ShipmentFirstName
  Shipment firstname.
- ShipmentLastName
  Shipment lastname.
- ShipmentCompany
  Shipment company.
- ShipmentAddress
  Shipment address.
- ShipmentAddress2
  Shipment address 2.
- ShipmentCity
  Shipment city.
- ShipmentState
  Shipment state.
- ShipmentZipCode
  Shipment zipcode.
- ShipmentCountry
  Shipment country.
- ShipmentPhone
  Shipment phone.
- ShipmentEmail
  Shipment email.
Action
Write
- EmailRequired
  Email of the Customer.
- PasswordRequired
  Password of the customer.
- BillingCompany
- BillingFirstName
  BillingFirstName.
- BillingLastName
  Billing lastname of the customer.
- BillingAddress1
  Billing address of the customer.
- BillingAddress2
  Suite / Apt #.
- BillingCity
  Billing city of the customer.
- BillingState
  Billing state of the customer.
- BillingZipCode
  Billing zip code of the customer.
- BillingCountry
  Billing country of the customer.
- BillingPhoneNumber
  Billing phone number of the customer.
- BillingTaxID
  Billing tax id of the customer.
- ShippingCompany
  Shipping company of the customer.
- ShippingFirstName
  Shipping firstname of the customer.
- ShippingLastName
  Shipping lastname of the customer
- ShippingAddress1
  Shipping address of the customer.
- ShippingAddress2
  Shipping customer's address suite / apt#.
- ShippingCity
  Shipping city of the customer.
- ShippingState
  Shipping state of the customer.
- ShippingZipCode
  Shipping zip code of the customer.
- ShippingCountry
  Shipping country of the customer.
- ShippingPhoneNumber
  Shipping phone number of the customer.
- ShippingAddressType
  Customer's shipping address type.
- CustomerGroupID
  Customer's group id.
- Enabled
  Customer is enabled.
- MailList
  Customer is subscribe to the maillist.
- NonTaxable
  Customer is non taxable.
- DisableBillingSameAsShipping
  Disable customer billing same as shipping address.
- Comments
  Customer's comments.
- AdditionalField1
  Customer additional field1.
- AdditionalField2
  Customer's additional field2.
- AdditionalField3
  Customer's additional field3.
- TotalStoreCredit
  Customer's total store credit.
- ResetPassword
  Reset password for the customer.
Action
Write
- Sku
  SKU of the product.
- NameRequired
  Product's name.
- Cost
  Product's cost.
- PriceRequired
  Price of the product.
- RetailPrice
  Retail price of the product.
- SalePrice
  Sale price of the product.
- OnSale
  Product's OnSale Flag.
- Stock
  Stock of the product.
- Mfgid
  MFGID of the product.
- ShortDescription
  Product's short description.
- Gtin
  GTIN of the product.
- NonTaxable
  Non-Taxable Flag.
- NotForSale
  Product's OnSale Flag.
- Hide
  Hide Flag.
- GiftCertificate
  Gift Certificate Flag.
- HomeSpecial
  Home Special Flag.
- CategorySpecial
  Category Special Flag.
- NonSearchable
  Non Searchable Flag.
- ShipCost
  Ship cost of the product.
- Weight
  Weight of the product.
- Height
  Height of the product.
- Width
  Width of the product.
- Depth
  Depth of the product.
- SelfShip
  Self Ship Flag.
- FreeShipping
  Free Shipping Flag.
- RewardPoints
  Reward points of the product.
- RedeemPoints
  Redeem points of the product.
- DisableRewards
  Disable Rewards Flag.
- StockAlert
  Stock alert of the product.
- ReorderQuantity
  Reorder Quantity.
- InStockMessage
  Product's InStockMessage.
- OutOfStockMessage
  Product's OutOfStockMessage.
- BackOrderMessage
  Product's BackOrderMessage.
- InventoryControl
  Product's InventoryControl Flag.
- Description
  Product's description.
- Keywords
  Product's keywords.
- ExtraField1
  Product's extra field 1.
- ExtraField2
  Product's extra field 2.
- ExtraField3
  Product's extra field 3.
- ExtraField4
  Product's extra field 4.
- ExtraField5
  Product's extra field 5.
- ExtraField6
  Product's extra field 6.
- ExtraField7
  Product's extra field 7.
- ExtraField8
  Product's extra field 8.
- ExtraField9
  Product's extra field 9.
- ExtraField10
  Product's extra field 10.
- ExtraField11
  Product's extra field 11.
- ExtraField12
  Product's extra field 12.
- ExtraField13
  Product's extra field 13.
- FeatureTitle
  FeatureTitle.
- FeatureDescription
  FeatureDescription.
- MainImageFile
  Product main image file path.
- MainImageCaption
  Product's main image caption.
- ThumbnailFile
  Product's thumbnail file path.
- AdditionalImageFile2
  Product's additional image file path 2.
- AdditionalImageCaption2
  Product's additional image caption 2.
- AdditionalImageFile3
  Product's additional image file path 3.
- AdditionalImageCaption3
  Product's additional image caption 3.
- AdditionalImageFile4
  Product's additional image file path 4.
- AdditionalImageCaption4
  Product's additional image caption 4.
- ImageGalleryFile
  ImageGalleryFile.
- ImageGalleryCaption
  ImageGalleryCaption.
- ImageGallerySorting
  ImageGallerySorting.
- CanonicalUrl
  Product's canonical url.
- PriceLevel2
  Product's price level 2.
- PriceLevel2Hide
  Product's price level 2 hide flag.
- PriceLevel3
  Product's price level 3.
- PriceLevel3Hide
  Product's price level 3 hide flag.
- PriceLevel4
  Product's price level 4.
- PriceLevel4Hide
  Product's price level 4 hide flag.
- PriceLevel5
  Product's price level 5.
- PriceLevel5Hide
  Product's price level 5 hide flag.
- PriceLevel6
  Product's price level 6.
- PriceLevel6Hide
  Product's price level 6 hide flag.
- PriceLevel7
  Product's price level 7.
- PriceLevel7Hide
  Product's price level 7 hide flag.
- PriceLevel8
  Product's price level 8.
- PriceLevel8Hide
  Product's price level 8 hide flag.
- PriceLevel9
  Product's price level 9.
- PriceLevel9Hide
  Product's price level 9 hide flag.
- PriceLevel10
  Product's price level 10.
- PriceLevel10Hide
  Product's price level 10 hide flag.
- Title
  Product's title.
- CustomFileName
  Product's custom file name.
- MetaTags
  Product's meta tags.
Action
Write
- OrderID
  Order id number xxxxxx
- OrderStatusID
  Order's status id number.
- InternalComments
  Order Internal comments.
Action
Write
- Email
  Email address of the customer.
- First Name
  Customer's billing first name.
- Last Name
  Customer's billing last name.
- Country
  Customer's billing country.
- State
  Customer's billing state.
- City
  Customer's billing city.
- Phone
  Phone of the Customer.
Action
Search
- Sku
  Product's SKU.
- Name
  Product's name.
- Cost
  Cost of a product.
- Price
  Price of a product.
- Stock
  Stock of a product.
- Hide
  Hide Flag.
- Free Shipping
  Free Shipping Flag.
- On Sale
  On Sale Flag.
- Non Tax
  Non-Taxable Flag.
- Not for Sale
  Not For Sale Flag.
Action
Search

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

How MySQL + Webhooks by Zapier + Shift4Shop Integrations Work

Step 1: Authenticate MySQL, Webhooks by Zapier, and Shift4Shop.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect MySQL + Webhooks by Zapier + Shift4Shop

About MySQL

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

Related categories

Databases

Similar apps

SQL Server

Databases

Quick Base

Databases

Firebase / Firestore

Databases

About Webhooks by Zapier

Webhooks simply POST data (or JSON) to a specific URL every time we see something new. Webhooks can also accept data (or JSON) to kick off a workflow in Zapier.

Related categories

About Shift4Shop

Shift4Shop is an all-in-one eCommerce platform for online retailers of any size. It includes a full range of website building and business management features.

Learn more

Related categories

eCommerce

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

MySQL + Webhooks by Zapier + Shift4Shop Integrations

How to connect MySQL + Webhooks by Zapier + Shift4Shop

Do even more with MySQL + Webhooks by Zapier + Shift4Shop

New Column

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Row via Custom Query

QueryRequired

Catch Raw Hook

Custom Request

MethodRequired

URLRequired

Data Pass-Through?

Data

Unflatten

Basic Auth

Headers

POST

URLRequired

Payload Type

Data

Wrap Request In Array

File

Unflatten

Basic Auth

Headers

New Customer

Order Status Change

Product Deleted

Product Stock Changed

Add Item to Cart

OrderKeyRequired

ItemQuantity

CatalogIDRequired

Create Order

BypassOrderProcessing

BypassOrderEmail

InvoiceNumberPrefix

InvoiceNumber

CustomerID

OrderDate

OrderStatusID

AlternateOrderID

BillingFirstNameRequired

BillingLastNameRequired

BillingCompany

BillingAddressRequired

BillingAddress2

BillingCityRequired

BillingState

BillingZipCode

BillingCountryRequired

BillingPhoneNumberRequired

BillingEmail

BillingOnLinePayment

BillingPaymentMethodID

ShipmentOrderStatus

ShipmentAddressRequired

ShipmentAddress2

ShipmentCityRequired

ShipmentCompany

ShipmentCountryRequired

ShipmentEmail

ShipmentFirstNameRequired

ShipmentLastNameRequired

ShipmentMethodName

ShipmentShippedDate

ShipmentPhoneRequired

ShipmentStateRequired

ShipmentZipCodeRequired

ShipmentTax

ShipmentTrackingCode