BigCommerce + Microsoft Excel

Update rows in Microsoft Excel when order statuses are updated in BigCommerce

Boost the efficiency of your sales tracking process with this workflow. When an order status gets updated in BigCommerce, it's swiftly reflected in a dedicated row in your Microsoft Excel files. Save time, avoid manual errors, and ensure your Excel sheets carry the most recent data. It's a powerful method for maintaining accuracy in your sales records.

When this happens...
Order Status Updated
Triggers when an order status have changed.
TriggerInstant
automatically do this!
Update Row
Updates a row in a specific worksheet.
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

- Filter by Channel ID
Trigger
Instant
Try It
Customer Created
Triggers when an new customer is created.
Trigger
Instant
Try It
- Filter by Channel ID
- Filter by Status ID
Trigger
Instant
Try It
Shipment Created
Triggers when a new shipment is created.
Trigger
Instant
Try It
Customer Address Updated
Triggers when a customer address is updated.
Trigger
Instant
Try It

Order Status Updated
Triggers when an order status have changed.
Trigger
Instant
Try It
- EmailRequired
- First NameRequired
- Last NameRequired
- Company
- Phone
- Registration IP Address
- Notes
- Tax Exempt Category
- Customer Group ID
- ID
- Force Password Reset
- New Password
- Accepts Product Review Abandoned Cart Emails
- Store Credit Amounts
- Origin Channel ID
- Channel IDs
- Name
- Value
Action
Write

- NameRequired
- TypeRequired
- Sku
- Description
- WeightRequired
- Width
- Depth
- Height
- PriceRequired
- Cost Price
- Retail Price
- Sale Price
- Map Price
- Tax Class Id
- Product Tax Code
- Categories
- Brand Id
- Inventory Level
- Inventory Warning Level
- Inventory Tracking
- Fixed Cost Shipping Price
- Is Free Shipping
- Is Visible
- Is Featured
- Related Products
- Warranty
- Bin Picking Number
- Layout File
- Upc
- Search Keywords
- Availability Description
- Availability
- Gift Wrapping Options Type
- Gift Wrapping Options List
- Sort Order
- Condition
- Is Condition Shown
- Order Quantity Minimum
- Order Quantity Maximum
- Page Title
- Meta Keywords
- Meta Description
- View Count
- Preorder Release Date
- Preorder Message
- Is Preorder Only
- Is Price Hidden
- Price Hidden Label
- Url
- Is Customized
- Open Graph Type
- Open Graph Title
- Open Graph Description
- Open Graph Use Meta Description
- Open Graph Use Product Name
- Open Graph Use Image
- Gtin
- Mpn
- Reviews Rating Sum
- Reviews Count
- Total Sold
- Custom Fields ID
- Custom Fields NameRequired
- Custom Fields ValueRequired
- Bulk Pricing Rules ID
- Bulk Pricing Rules Quantity Min
- Bulk Pricing Rules Quantity Max
- Bulk Pricing Rules Type
- Bulk Pricing Rules Amount
- Images Image File
- Images Is Thumbnail?
- Images Sort order
- Images Description
- Images Image URL
- Images ID
- Images Product ID
- Images URL Zoom
- Images URL Standard
- Images URL thumbnail
- Images URL Tiny
- Images Date modified
- Videos Title
- Videos Description
- Videos Sort order
- Videos Type
- Videos Video ID
- Videos ID
- Videos Product ID
- Videos Length
- Variants Cost Price
- Variants Price
- Variants Sale Price
- Variants Retail Price
- Variants Weight
- Variants Width
- Variants Height
- Variants Depth
- Variants Is free shipping?
- Variants Fixed cost shipping price
- Variants Purchasing disabled
- Variants Purchasing disabled message
- Variants UPC
- Variants Inventory level
- Variants Inventory warning level
- Variants BIN Picking number
- Variants Product ID
- Variants SKU
Action
Write
- Email
- Company
- ID
- Customer Group
Action
Search
- Name
- SKU
- ID
Action
Search
- Name
- Company
- Customer ID
- First NameRequired
- Last NameRequired
- Address 1Required
- Address 2
- CityRequired
- State Or ProvinceRequired
- Postal CodeRequired
- Country CodeRequired
- Phone
- Address Type
- Customer IdRequired
- Id
- Country
- Name
- Value
Action
Search or write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

- Filter by Channel ID
Trigger
Instant
Try It
Customer Address Created
Triggers when a new customer is created.
Trigger
Instant
Try It
- Filter by Category ID
Trigger
Instant
Try It
Customer Updated
Triggers when a customer is updated.
Trigger
Instant
Try It
- Filter by Channel ID
- Filter by Status ID
Trigger
Instant
Try It
- TitleRequired
- Url
- BodyRequired
- Is Published
- Meta Description
- Meta Keywords
- Author
- Thumbnail Path
- Tags
- Published Date
Action
Write
- First NameRequired
- Last NameRequired
- Company
- Address 1Required
- Address 2
- CityRequired
- State Or ProvinceRequired
- Postal CodeRequired
- Country CodeRequired
- Phone
- Address Type
- Customer IdRequired
- Id
- Country
- Name
- Value
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Name
- Company
- Customer ID
Action
Search
- EmailRequired
- Company
- ID
- Customer Group
- First NameRequired
- Last NameRequired
- Phone
- Registration IP Address
- Notes
- Tax Exempt Category
- Customer Group ID
- Force Password Reset
- New Password
- Accepts Product Review Abandoned Cart Emails
- Store Credit Amounts
- Origin Channel ID
- Channel IDs
- Name
- Value
Action
Search or write
- NameRequired
- SKU
- ID
- TypeRequired
- Description
- WeightRequired
- Width
- Depth
- Height
- PriceRequired
- Cost Price
- Retail Price
- Sale Price
- Map Price
- Tax Class Id
- Product Tax Code
- Categories
- Brand Id
- Inventory Level
- Inventory Warning Level
- Inventory Tracking
- Fixed Cost Shipping Price
- Is Free Shipping
- Is Visible
- Is Featured
- Related Products
- Warranty
- Bin Picking Number
- Layout File
- Upc
- Search Keywords
- Availability Description
- Availability
- Gift Wrapping Options Type
- Gift Wrapping Options List
- Sort Order
- Condition
- Is Condition Shown
- Order Quantity Minimum
- Order Quantity Maximum
- Page Title
- Meta Keywords
- Meta Description
- View Count
- Preorder Release Date
- Preorder Message
- Is Preorder Only
- Is Price Hidden
- Price Hidden Label
- Url
- Is Customized
- Open Graph Type
- Open Graph Title
- Open Graph Description
- Open Graph Use Meta Description
- Open Graph Use Product Name
- Open Graph Use Image
- Gtin
- Mpn
- Reviews Rating Sum
- Reviews Count
- Total Sold
- Custom Fields ID
- Custom Fields NameRequired
- Custom Fields ValueRequired
- Bulk Pricing Rules ID
- Bulk Pricing Rules Quantity Min
- Bulk Pricing Rules Quantity Max
- Bulk Pricing Rules Type
- Bulk Pricing Rules Amount
- Images Image File
- Images Is Thumbnail?
- Images Sort order
- Images Description
- Images Image URL
- Images ID
- Images Product ID
- Images URL Zoom
- Images URL Standard
- Images URL thumbnail
- Images URL Tiny
- Images Date modified
- Videos Title
- Videos Description
- Videos Sort order
- Videos Type
- Videos Video ID
- Videos ID
- Videos Product ID
- Videos Length
- Variants Cost Price
- Variants Price
- Variants Sale Price
- Variants Retail Price
- Variants Weight
- Variants Width
- Variants Height
- Variants Depth
- Variants Is free shipping?
- Variants Fixed cost shipping price
- Variants Purchasing disabled
- Variants Purchasing disabled message
- Variants UPC
- Variants Inventory level
- Variants Inventory warning level
- Variants BIN Picking number
- Variants Product ID
- Variants SKU
Action
Search or write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write

About BigCommerce

BigCommerce is an e-commerce platform that provides an all-encompassing solution for a business' online store. If you're trying to sell physical goods online, you'll want to check out Bigcommerce.

Related categories

eCommerce

Similar apps

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more

Related categories

Similar apps

Related Zap Templates

Add new BigCommerce carts to Microsoft Excel rows effortlessly

BigCommerce + Microsoft Excel

Update rows in Microsoft Excel when order statuses are updated in BigCommerce

Abandoned Cart

Customer Created

Order Created

Shipment Created

Customer Address Updated

Order Status Updated

Create Customer

Create a Product

Search Customer

Search Product

Find or Create Customer's Address

New Row

New Worksheet

Add Row

Add Row to Table

Create Worksheet

Find Row

Find or Create Row

Cart Created

Customer Address Created

Product Created

Customer Updated

Order Updated

Create Blog Post

Create Customer Address

API Request (Beta)

Search Customer Address

Find or Create Customer

Find or Create Product

New Row in Table

Updated Row

Add Row(s)

Create Workbook

Update Row

Find Worksheet

Find or Create Worksheet

About BigCommerce

Related categories

Similar apps

Shopify

Magento

WooCommerce

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

Related Zap Templates

Related Zap Templates