Ecwid by Lightspeed + Schedule by Zapier + SQL Server Integrations

How to connect Ecwid by Lightspeed + Schedule by Zapier + SQL Server

Zapier lets you send info between Ecwid by Lightspeed and Schedule by Zapier and SQL Server automatically—no code required. With 7,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Do even more with Ecwid by Lightspeed + Schedule by Zapier + SQL Server

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 Ecwid by Lightspeed, Schedule by Zapier, and SQL Server. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

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

- TitleRequired
- PriceRequired
- SKU Number
- Description
- Quantity
- Weight
- Enabled
- Unlimited
- Compare To Price
- Is Shipping Required
- Warning Limit
Action
Write
- Product IDRequired
- Link on your imageRequired
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 EmailRequired
- 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
- Frequency TypeRequired
- Interval
- Start DateRequired
- Time of DayRequired
Trigger
Instant
Try It
- Time Offset
- Trigger on weekends?
Trigger
Instant
Try It
- Day of the WeekRequired
- Time of DayRequired
Trigger
Instant
Try It
- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Scheduled
Try It
New Table
Triggers when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search

- Customer Email
- Agreed to receive email marketing
Trigger
Scheduled
Try It
New Paid Order
Triggered when a new paid order is placed (with line item support).
Trigger
Scheduled
Try It
New Product
Triggers when a new product is created.
Trigger
Scheduled
Try It
- Customer's EmailRequired
- Customer's Password
- Customer group ID
- Customer's Name
Action
Write
- EmailRequired
- Payment StatusRequired
- Fulfilment StatusRequired
- Product NameRequired
- Product PriceRequired
- Product QuantityRequired
- 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 IDRequired
- 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
- TitleRequired
- PriceRequired
- Description
- Quantity
- Weight
- Unlimited
- Compare To Price
- Is Shipping Required
- Warning Limit
Action
Search or write
- Time of DayRequired
- Trigger on weekends?
Trigger
Instant
Try It
- Day of the MonthRequired
- Time of DayRequired
Trigger
Instant
Try It
- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

How Ecwid by Lightspeed + Schedule by Zapier + SQL Server Integrations Work

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

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 more

Related categories

eCommerce

Similar apps

About Schedule by Zapier

Schedule is a native Zapier app you can use for recurring tasks. Trigger an action every day of the month, every day of the week or every single day. You can also select the hour of the day. If you're a developer, this is similar to a crontab, cronjob or cron.