Airtable + Ecwid by Lightspeed

Create records in Airtable from new orders in Ecwid by Lightspeed

Effortlessly streamline your e-commerce operations with this automated workflow. When a new order comes in via your Ecwid by Lightspeed app, a corresponding record is created in your Airtable app. This not only saves you time from manual data entry but also minimizes mistakes, ensuring accurate and up-to-date order records. It's an effective solution to balancing customer demands and business needs seamlessly.

When this happens...
New Order
Triggered when a new invoice is placed (with line item support).
TriggerScheduled
automatically do this!
Create Record
Creates a new record with auto-populating fields.
ActionWrite

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

Supported triggers and actions

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
- BaseRequired
- TableRequired
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Lookup FieldRequired
- Secondary Lookup Field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
- Max Records
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
- Max Records
Action
Search or write

- 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
- BaseRequired
- TableRequired
- Help Text
- Which timestamp field should this Zap use to check for updates?Required
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more

Related categories

Databases

Similar apps

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