SQL Server + Code by Zapier + Magento Integrations

How to connect SQL Server + Code by Zapier + Magento

Zapier lets you send info between SQL Server, Code by Zapier, and Magento automatically—no code required.

When this happens...

automatically do this...

then do this!

Free 14-day trial

5,000+ supported apps

Do even more with SQL Server + Code by Zapier + Magento

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 SQL Server, Code by Zapier, and Magento. 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

- CodeRequired
  Warning! This is an advanced trigger! Please read the Code documentation for more information.
Trigger
Scheduled
Try It
- Input Data
  Use the Input Data fields above to assign key names (left) and map values (right) from previous steps. Use notation input_data['keyName'] to access the values within your code. The data will be provided as strings. Learn more here.
- CodeRequired
  Warning! This is an advanced trigger! Please read the Code documentation for more information.
Action
Write

New Customer
Triggers when Magento gets a new customer.
Trigger
Scheduled
Try It
New Sales Order Invoice
Triggers when Magento gets a new sales order invoice (with line item support).
Trigger
Scheduled
Try It
New Order
Triggers when Magento gets a new order.
Trigger
Scheduled
Try It
New Sales Order Invoice
Triggers when Magento gets a new sales order invoice.
Trigger
Scheduled
Try It
- Parent Category IDRequired
- NameRequired
- Available Sort ByRequired
  All available options by which products in the category can be sorted. Use commas to sort by multiple fields.
- Default Sort ByRequired
  Option which will be used to sort products by default. Must be one of the options in Available Sort By.
- Would you like to include in main menu?Required
  Enter 1 for Yes, 0 for No
- Store View
  The store view this category will be added to. To see which views map to which stores, go to System -> Manage Stores in Magento admin.
- Category Visibility
- Position
  Position of the created category.
- Category Custom Design
- Apply to all products
  Apply the custom design to all products assigned to the category (optional)
- Custom Design Start Date
- Custom Design End Date
- Custom Layout Update
- Description
- Email
- Email
- Landing Page
- Meta Description
- Meta Keywords
- Meta Title
- Page Layout
- URL Key
- Price range
- Inherit custom design
Action
Write
- EmailRequired
- First Name
- Last Name
- Password
- Website IDRequired
- Store ID
- Group ID
- Prefix
- Suffix
- Date Of Birth
- Tax or VAT number
- Gender
  Type 1 for Male, 2 for Female
- Middle Name
Action
Write
- Order StatusRequired
- Order comment
- Email
  Send invoice on email (optional)
- Optionally, include comments in email
- Order Item IDRequired
  This should be a number.
- Quantity
Action
Write

- 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
- CodeRequired
  Warning! This is an advanced trigger! Uses Node 10.x.x. Please read the Code documentation for more information.
Trigger
Scheduled
Try It
- Input Data
  Use the Input Data fields above to assign key names (left) and map values (right) from previous steps. Use notation inputData.keyName or inputData['keyName'] to access the values within your code. The data will be provided as strings. Learn more here.
- CodeRequired
  Warning! This is an advanced action! Uses Node 10.x.x. Please read the Code documentation for more information.
Action
Write
New Product
Triggers when a new product is created in Magento.
Trigger
Scheduled
Try It
New Order
Triggers when Magento gets a new order (with line item support).
Trigger
Scheduled
Try It
New Sales Order Shipment
Triggers when Magento gets a new sales order shipment (with line item support).
Trigger
Scheduled
Try It
New Sales Order Credit Memo
Triggers when Magento gets a new sales order credit memo.
Trigger
Scheduled
Try It
New Sales Order Shipment
Triggers when Magento gets a new sales order shipment.
Trigger
Scheduled
Try It
- NameRequired
  The name of the product
- TypeRequired
  Product Type
- Attribute SetRequired
  Select an attribute set that this product will use as its base set of attributes.
- Store ViewRequired
  The store view this product will be added to. To see which views map to which stores, go to System -> Manage Stores in Magento admin.
- DescriptionRequired
- Short DescriptionRequired
- SKURequired
  Product SKU.
- Categories
  Specify categories (by exact name) which this product will be placed into.
- StatusRequired
- VisibilityRequired
  Set the product's visibility in the store.
- Price
- Product Weight
- Tax Class
- URL Path
  (Advanced) When specifying a custom URL, this contains the path portion of the URL. Leave blank for a default URL.
- URL Key
  (Advanced) When specifying a custom URL, this should be the final portion of the URL (i.e. my-product in example.com/magento/my-product). Leave blank for a default URL.
- Meta Description
- Meta Keyword
- Meta Title
Action
Write
- Order Increment IDRequired
- Order Status
- Order comment
- Notification Flag
Action
Write

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 SQL Server + Code by Zapier + Magento Integrations Work

Step 1: Authenticate SQL Server, Code by Zapier, and Magento.
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 SQL Server + Code by Zapier + Magento

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Related categories

Databases

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases

About Code by Zapier

Write custom Python or Javascript code in response to any data from any service! Transform, mutate, customize or even do custom HTTP in a native and familiar environment.

Related categories

About Magento

Magento is the premier open source e-commerce app used by millions of customers each and every day.

Related categories

eCommerce

Similar apps

Shopify

eCommerce

BigCommerce

eCommerce

WooCommerce

eCommerce, WordPress

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.

SQL Server + Code by Zapier + Magento Integrations

How to connect SQL Server + Code by Zapier + Magento

Do even more with SQL Server + Code by Zapier + Magento

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

Run Python

CodeRequired

Run Python

Input Data

CodeRequired

New Customer

New Sales Order Invoice

New Order

New Sales Order Invoice

Create Category

Parent Category IDRequired

NameRequired

Available Sort ByRequired

Default Sort ByRequired

Would you like to include in main menu?Required

Store View

Category Visibility

Position

Category Custom Design

Apply to all products

Custom Design Start Date

Custom Design End Date

Custom Layout Update

Description

Email

Email

Landing Page

Meta Description

Meta Keywords

Meta Title

Page Layout

URL Key

Price range

Inherit custom design

Create Customer

EmailRequired

First Name

Last Name

Password

Website IDRequired

Store ID

Group ID

Prefix

Suffix

Date Of Birth

Tax or VAT number

Gender

Middle Name

Create Invoice

Order StatusRequired

Order comment

Email

Optionally, include comments in email

Order Item IDRequired

Quantity

New Row

Table/ViewRequired

Order By

Dedupe Key

New Table

New Row

TableRequired

Find Row

TableRequired