Ecwid by Lightspeed + SQL Server

Ecwid by Lightspeed + SQL Server integrations

Create new rows in SQL Server for new paid orders in Ecwid by Lightspeed

Effortlessly manage your sales data with this efficient workflow between Ecwid by Lightspeed and SQL Server. When a new paid order comes in through Ecwid, this automation will add a new row to your SQL Server database, ensuring your crucial order information is saved in a timely and organized manner. Stay on top of your business and streamline your sales data by integrating Ecwid and SQL Server today.

When this happens...
New Paid OrderTriggered when a new paid order is placed (with line item support).
TriggerPolling
automatically do this!
New RowTriggers when you add a new row.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Ecwid by Lightspeed and SQL Server

Discover other triggers and actions you can use with Ecwid by Lightspeed and SQL Server

New Abandoned Cart
Triggered when a customer leaves an online store without making a purchase.
Trigger
Polling
Try It
- Payment Status
- Fulfillment Status
Trigger
Polling
Try It
- Payment Status
- Fulfillment Status
Trigger
Polling
Try It
- Payment Status
- Fulfillment Status
Trigger
Polling
Try It
- Coupon Name
  Required
- Coupon Code
  Required
- Discount
- Discount Type
- Status
- Launch Date
- Expiration Date
- Total Limit
- Uses Limit
- applicationLimit
- Order Count
- repeatCustomerOnly
- catalogLimitProducts
- catalogLimitCategories
Action
Write

- Title
  Required
- Price
  Required
- SKU Number
- Description
- Quantity
- Weight
- Enabled
- Unlimited
- Compare To Price
- Is Shipping Required
- Warning Limit
Action
Write
- Product ID
  Required
- Link on your image
  Required
Action
Write

- Keywords
- Order Number
- Vendor Order Number
- Email
- Customer ID
- Payment Status
- Fulfillment Status
- Accept Marketing
- Referer ID
- Product ID
- Coupon Code
- Total From
- Total To
- Created From
- Created To
- Updated From
- Updated To
- Payment Method
- Shipping Method
Action
Search
- Keyword
- Customer's Name
- Customer's Email
  Required
- Group ID
- Minimum number of order a customer placed
- Maximum number of order a customer placed
- Accept Marketing
- Created From
- Created To
- Updated From
- Updated To
- Customer's Password
- Customer group ID
Action
Search or write
- Table/View
  Required
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table/View
  Required
- Primary_key
  Required
- Order_by
  Required
- Trigger_column
Trigger
Polling
Try It
- DisclaimerCopy
- Query
  Required
Action
Write
- Table
  Required
- ID Column
  Required
Action
Write
- Query
  Required
Action
Search

- Customer Email
- Agreed to receive email marketing
Trigger
Polling
Try It
New Paid Order
Triggered when a new paid order is placed (with line item support).
Trigger
Polling
Try It
New Product
Triggers when a new product is created.
Trigger
Polling
Try It
- Customer's Email
  Required
- Customer's Password
- Customer group ID
- Customer's Name
Action
Write
- Email
  Required
- Payment Status
  Required
- Fulfilment Status
  Required
- Product Name
  Required
- Product Price
  Required
- Product Quantity
  Required
- Product SKU
- Product Weight
- Payment Method
- Total
- Tax
- Order Comments
- Shipping Rate
- Shipping Person Name
- Shipping Method Name
- Shipping Person Company Name
- Shipping Person Street
- Shipping Person City
- Shipping Person Country Code
- Shipping Person Postal Code
- Shipping Person State Code
- Shipping Person Phone
- Billing Person Name
- Billing Person Company Name
- Billing Person Street
- Billing Person City
- Billing Person Country Code
- Billing Person Postal Code
- Billing Person State Code
- Billing Person Phone
- Subtotal
- Payment Module
- customerTaxExempt
- customerTaxId
- customerTaxIdValid
- reversedTaxApplied
- IP Address
- Coupon Discount
- Referer Url
- Volume Discount
- Customer ID
- Hidden
- Membership Based Discount
- Total And Membership Based Discount
- Discount
- Global Referer
- Create Date
- Customer Group
- Tracking Number
- Payment Message
- External Transaction ID
- Affiliate ID
- Private Admin Notes
- Pickup Time
- Accept Marketing
- Disable All Customer Notifications
- External Fulfillment
- External Order ID
Action
Write
- Product ID
  Required
- SKU
- Name
- Quantity
- Unlimited
- Price
- Compare To Price
- Weight
- Enabled
- Description
Action
Write
- Keyword
- Name
- Email
- Group ID
- Minimum number of order a customer placed
- Maximum number of order a customer placed
- Accept Marketing
- Created From
- Created To
- Updated From
- Updated To
Action
Search
- Keyword
- SKU
- Product ID
- Enabled
Action
Search
- Keyword
- SKU Number
- Product ID
- Enabled
- Title
  Required
- Price
  Required
- Description
- Quantity
- Weight
- Unlimited
- Compare To Price
- Is Shipping Required
- Warning Limit
Action
Search or write
- Table/View
  Required
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search
- Query
  Required
Action
Search

About Ecwid by Lightspeed

Ecwid by Lightspeed is a cloud online store builder which lets you instantly launch an online store on any website, Facebook page, or multiple sites simultaneously.

Learn moreLearn moreHelpHelp

Related categories

eCommerce

Similar apps

Shopify

eCommerce

Gumroad

eCommerce

SendOwl

eCommerce

About SQL Server

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

HelpHelp

Related categories

Databases

Premium

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases