How to connect Code by Zapier + Xero + BigCommerce
Zapier lets you send info between Code by Zapier and Xero and BigCommerce automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Code by Zapier + Xero + BigCommerce
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 Code by Zapier, Xero, and BigCommerce. And don’t forget that you can add more apps and actions to create complex workflows.
CodeRequired
Warning! This is an advanced trigger! Uses Node 10.x.x. Please read the Code documentation for more information.
Zap Id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planInput Data
Use the Input Data fields above to assign key names (left) and map values (right) from previous steps. Use notation
inputData.keyName
orinputData['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.
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.New Bank Transaction
Triggers when a new bank transaction is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Contact
Triggers when you add a new contact.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planQuote Status
If left empty, Zapier will trigger on all new quotes, regardless of status.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTransaction TypeRequired
ContactRequired
Bank AccountRequired
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact NameRequired
Account Number
Primary Person - First Name
Primary Person - Last Name
Primary Person - Email
Phone - Country Code
Phone - Area Code
Phone Number
Fax - Country Code
Fax - Area Code
Fax - Number
Mobile - Country Code
Mobile - Area Code
Mobile - Number
Direct Dial - Country Code
Direct Dial - Area Code
Direct Dial - Number
Address Type Of
Address - Attention
Address - Line 1
Address - Line 2
Address - City/Town
Address - State/Region
Address - Postal/Zip Code
Address - Country
Tax Number
Also known as the ABN (Australia), GST Number (New Zealand), VAT Number (UK) or Tax ID Number (US and global) depending on which regionalized version of Xero you use.
Bank Account Number
Groups
Add contact to selected group(s). Does not replace contact's existing groups.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
ContactRequired
Date
Defaults to today's date if not specified.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact NameRequired
Email Address
Status
Defaults to Draft if not specified.
Date
Defaults to creation date if not specified.
Due Date
A due date is required for approved invoices.
Currency
Default currency for organization will be used if not specified.
Url
URL link to a source document.
Attachment
Branding Theme
The branding theme to use for this invoice.
Reference
Non-unique alpha numeric code identifying the bill.
Url
URL link to a source document.
Line Items Type
Line amounts are exclusive of tax by default if you don't specify this element.
Item Code
You must provide either an Item Code or both a Description and a Unit Price.
Description
If no Item Code is provided, this field is required.
QuantityRequired
Unit Price
If no Item Code is provided, this field is required.
Account
Tax Rate
Only specify if you want to override the default tax type for the account above.
Tracking
For example: Region - West Coast - see Setting > General Settings > Tracking in Xero for your tracking categories and options.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document Type
What you'll you provide the ID or number for via the next field.
Document ID or NumberRequired
The ID or Number for the selected Document Type.
Paid ToRequired
The bank account or clearing account the payment is being made to.
Date
Currency Rate
Exchange rate when payment is received. Only used for non base currency invoices.
AmountRequired
Reference
An optional description for the payment.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
Contact NameRequired
Account Number
Primary Person - First Name
Primary Person - Last Name
Primary Person - Email
Phone - Country Code
Phone - Area Code
Phone Number
Fax - Country Code
Fax - Area Code
Fax - Number
Mobile - Country Code
Mobile - Area Code
Mobile - Number
Direct Dial - Country Code
Direct Dial - Area Code
Direct Dial - Number
Address Type Of
Address - Attention
Address - Line 1
Address - Line 2
Address - City/Town
Address - State/Region
Address - Postal/Zip Code
Address - Country
Tax Number
Also known as the ABN (Australia), GST Number (New Zealand), VAT Number (UK) or Tax ID Number (US and global) depending on which regionalized version of Xero you use.
Bank Account Number
Groups
Add contact to selected group(s). Does not replace contact's existing groups.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFilter by Channel ID
Select the channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Address Created
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Category ID
Select the category
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Updated
Triggers when a customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Channel ID
Select the channel
Filter by Status ID
Select the status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.TitleRequired
Title of this blog post.
Url
URL for the public blog post.
BodyRequired
Text body of the blog post.
Is Published
Whether the blog post is published.
Meta Description
Description text for this blog post’s
<meta/>
elementMeta Keywords
Keywords for this blog post’s
<meta/>
elementAuthor
Name of the blog post’s author
Thumbnail Path
Local path to a thumbnail uploaded to
/product_images/
via WebDavTags
Tags to characterize the blog post. Must be separated by comma
Published Date
Example:
Wed, 10 Aug 2022 15:39:15 -0500
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
The first name of the customer address.
Last NameRequired
The last name of the customer address
Company
The company of the customer address
Address 1Required
The address 1 line
Address 2
The address 2 line
CityRequired
The city of the customer address
State Or ProvinceRequired
The state or province name spelled out in full. It is required for countries that need a state/province to complete an address. State or province codes not accepted.
Postal CodeRequired
The postal code of the customer address. It is required for countries that need postal codes to complete an address.
Country CodeRequired
The country code of the customer address.
Phone
The phone number of the customer address
Address Type
The address type. Residential or Commercial.
Customer IdRequired
The customer ID
Id
The unique numeric ID of the address.
Country
The country name of the customer address
Name
If you have required address form fields they will need to be set as optional before creating an order with the API.
Value
If you have required address form fields they will need to be set as optional before creating an order with the API.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Filter customers by email.
Company
Filter customers by company.
ID
Filter customers by id.
Customer Group
Filter customers by customer group.
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Filter items by name.
SKU
Filter items by main SKU.
ID
Filter items by ID.
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Company
The company of the customer address
Customer ID
First NameRequired
The first name of the customer address.
Last NameRequired
The last name of the customer address
Address 1Required
The address 1 line
Address 2
The address 2 line
CityRequired
The city of the customer address
State Or ProvinceRequired
The state or province name spelled out in full. It is required for countries that need a state/province to complete an address. State or province codes not accepted.
Postal CodeRequired
The postal code of the customer address. It is required for countries that need postal codes to complete an address.
Country CodeRequired
The country code of the customer address.
Phone
The phone number of the customer address
Address Type
The address type. Residential or Commercial.
Customer IdRequired
The customer ID
Id
The unique numeric ID of the address.
Country
The country name of the customer address
Name
If you have required address form fields they will need to be set as optional before creating an order with the API.
Value
If you have required address form fields they will need to be set as optional before creating an order with the API.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
CodeRequired
Warning! This is an advanced trigger! Please read the Code documentation for more information.
Zap Id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planInput 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.
Zap Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.New Expense Claim Receipt
Triggers when you add a new draft expense claim receipt.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planInvoiceRequired
Item Code
You must provide either an Item Code or both a Description and a Unit Price.
Description
If no Item Code is provided, this field is required.
QuantityRequired
Unit Price
If no Item Code is provided, this field is required.
Discount %
Account
Tax Rate
Only specify if you want to override the default tax type for the account above.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From AccountRequired
The bank account the payment is being made from.
To AccountRequired
The bank account the payment is being made to.
AmountRequired
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
Date
Defaults to current date if not specified.
Expiry
Quote Number
If you want Xero to auto-generate a Quote Number for you, leave this field blank.
Reference
Theme
Title
Summary
Currency
Amounts Are
Defaults to Tax Exclusive if not specified
Item Code
DescriptionRequired
Quantity
Unit Price
Discount %
Account
Tax Rate
Terms
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice NumberRequired
To email an invoice, it must have a status of Awaiting Approval, Awaiting Payment or Paid. The email will be sent to the primary email address of the contact on the invoice and any others marked as "Include in emails." The subject and body of the email will be based on the default email template.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact NameRequired
Email Address
Status
Defaults to Draft if not specified.
Date
Defaults to creation date if not specified.
Due Date
A due date is required for approved invoices.
Currency
Default currency for organization will be used if not specified.
Url
URL link to a source document.
Attachment
Branding Theme
The branding theme to use for this invoice.
Number
Unique alpha numeric code identifying invoice - leave blank for auto-generated value.
Reference
An additional reference number
Url
URL link to a source document.
Sent To Contact
Mark invoice as "sent" (note: does not actually send an email). This can be set only on invoices that have a status of "approved" You can set this in the Status field above.
Line Items Type
Line amounts are exclusive of tax by default if you don't specify this element.
Item Code
You must provide either an Item Code or both a Description and a Unit Price.
Description
If no Item Code is provided, this field is required.
QuantityRequired
Unit Price
If no Item Code is provided, this field is required.
Discount %
Account
Tax Rate
Only specify if you want to override the default tax type for the account above.
Tracking
For example: Region - West Coast - see Setting > General Settings > Tracking in Xero for your tracking categories and options.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact (supplier)Required
Date
When the purchase order was issued. Defaults to today's date if not specified.
Delivery Date
Order Number
If left blank, Xero will auto-generate this from your default invoice numbering.
Reference
Theme
Currency
Tax Type
Item Code
You must provide either an Item Code or both a Description and a Unit Price.
Description
If no Item Code is provided, this field is required.
QuantityRequired
Unit Price
If no Item Code is provided, this field is required.
Discount %
Account
Tax Rate
Only specify if you want to override the default tax type for the account above.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Xero are located here https://developer.xero.com/documentation/api/accounting/overview
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}
is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by Channel ID
Select the channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Created
Triggers when an new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Channel ID
Select the channel
Filter by Status ID
Select the status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Shipment Created
Triggers when a new shipment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Address Updated
Triggers when a customer address is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Status Updated
Triggers when an order status have changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
The email of the customer. Must be unique.
First NameRequired
The first name of the customer.
Last NameRequired
The last name of the customer.
Company
The company of the customer.
Phone
The phone number of the customer.
Registration IP Address
The IP address from which this customer was registered.
Notes
The customer notes.
Tax Exempt Category
The tax exempt category code for the customer.
Customer Group ID
ID of the group which this customer belongs to.
ID
The unique numeric ID of the customer.
Force Password Reset
If true, this customer will be forced to change password on next login.
New Password
New password for customer.
Accepts Product Review Abandoned Cart Emails
It determines if the customer is signed up to receive either product review or abandoned cart emails or receive both emails.
Store Credit Amounts
Values must be separated by a comma.
Origin Channel ID
Channel ID of the customer that has created the form.
Channel IDs
Arrays of channels the customer can access. Values must be separated by a comma.
Name
The form field name. Values must be separated by a comma.
Value
Values must be separated by a comma.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
The product name.
TypeRequired
The product type. One of: physical - a physical stock unit, digital - a digital download.
Sku
User defined product code/stock keeping unit (SKU).
Description
The product description, which can include HTML formatting.
WeightRequired
Weight of the product, which can be used when calculating shipping costs. This is based on the unit set on the store.
Width
Width of the product, which can be used when calculating shipping costs.
Depth
Depth of the product, which can be used when calculating shipping costs.
Height
Height of the product, which can be used when calculating shipping costs.
PriceRequired
The price of the product. The price should include or exclude tax, based on the store settings.
Cost Price
The cost price of the product. Stored for reference only; it is not used or displayed anywhere on the store.
Retail Price
The retail cost of the product. If entered, the retail cost price will be shown on the product page.
Sale Price
If entered, the sale price will be used instead of value in the price field when calculating the product’s cost.
Map Price
Minimum Advertised Price
Tax Class Id
The ID of the tax class applied to the product.
Product Tax Code
Accepts AvaTax System Tax Codes, which identify products and services that fall into special sales-tax categories. By using these codes, merchants who subscribe to BigCommerce's Avalara Premium integration can calculate sales taxes more accurately. Stores without Avalara Premium will ignore the code when calculating sales tax.
Categories
An array of IDs for the categories to which this product belongs.
Brand Id
Inventory Level
Current inventory level of the product.
Inventory Warning Level
Inventory warning level for the product. When the product's inventory level drops below the warning level, the store owner will be informed. Simple inventory tracking must be enabled (see the inventory_tracking field) for this to take any effect.
Inventory Tracking
The type of inventory tracking for the product. Values are: none - inventory levels will not be tracked; product - inventory levels will be tracked using the inventory_level and inventory_warning_level fields; variant - inventory levels will be tracked based on variants, which maintain their own warning levels and inventory levels.
Fixed Cost Shipping Price
A fixed shipping cost for the product. If defined, this value will be used during checkout instead of normal shipping-cost calculation.
Is Free Shipping
Flag used to indicate whether the product has free shipping. If true, the shipping cost for the product will be zero
Is Visible
Flag to determine whether the product should be displayed to customers browsing the store. If true, the product will be displayed. If false, the product will be hidden from view.
Is Featured
Flag to determine whether the product should be included in the featured products panel when viewing the store.
Related Products
An array of IDs for the related products.
Warranty
Warranty information displayed on the product page. Can include HTML formatting.
Bin Picking Number
The BIN picking number for the product.
Layout File
The layout template file used to render this product category. This field is writable only for stores with a Blueprint theme applied. For stores with a Stencil theme applied, see Custom Template Associations.
Upc
The product UPC code, which is used in feeds for shopping comparison sites and external channel integrations.
Search Keywords
A comma-separated list of keywords that can be used to locate the product when searching the store.
Availability Description
Availability text displayed on the checkout page, under the product title. Tells the customer how long it will normally take to ship this product, such as: 'Usually ships in 24 hours.'
Availability
Availability of the product. (Corresponds to the product's Purchasability section in the control panel.) Supported values: available - the product is available for purchase; disabled - the product is listed on the storefront, but cannot be purchased; preorder - the product is listed for pre-orders.
Gift Wrapping Options Type
Type of gift-wrapping options. Values: any - allow any gift-wrapping options in the store; none - disallow gift-wrapping on the product; list – provide a list of IDs in the gift_wrapping_options_list field.
Gift Wrapping Options List
A list of gift-wrapping option IDs.
Sort Order
Priority to give this product when included in product lists on category pages and in search results. Lower integers will place the product closer to the top of the results.
Condition
The product condition. Will be shown on the product page if the is_condition_shown field's value is true. Possible values: New, Used, Refurbished.
Is Condition Shown
Flag used to determine whether the product condition is shown to the customer on the product page.
Order Quantity Minimum
The minimum quantity an order must contain, to be eligible to purchase this product.
Order Quantity Maximum
The maximum quantity an order can contain when purchasing the product.
Page Title
Custom title for the product page. If not defined, the product name will be used as the meta title.
Meta Keywords
Custom meta keywords for the product page. If not defined, the store's default keywords will be used.
Meta Description
Custom meta description for the product page. If not defined, the store's default meta description will be used.
View Count
The number of times the product has been viewed.
Preorder Release Date
Pre-order release date. See the availability field for details on setting a product's availability to accept pre-orders.
Preorder Message
Custom expected-date message to display on the product page. If undefined, the message defaults to the storewide setting. Can contain the %%DATE%% placeholder, which will be substituted for the release date.
Is Preorder Only
If set to true then on the preorder release date the preorder status will automatically be removed. If set to false, then on the release date the preorder status will not be removed. It will need to be changed manually either in the control panel or using the API. Using the API set availability to available.
Is Price Hidden
False by default, indicating that this product's price should be shown on the product page. If set to true, the price is hidden. (NOTE: To successfully set is_price_hidden to true, the availability value must be disabled.).
Price Hidden Label
By default, an empty string. If is_price_hidden is true, the value of price_hidden_label is displayed instead of the price. (NOTE: To successfully set a non-empty string value with is_price_hidden set to true, the availability value must be disabled.).
Url
Product URL on the storefront.
Is Customized
Returns true if the URL has been changed from its default state (the auto-assigned URL that BigCommerce provides).
Open Graph Type
Type of product, defaults to product.
Open Graph Title
Title of the product, if not specified the product name will be used instead.
Open Graph Description
Description to use for the product, if not specified then the meta_description will be used instead.
Open Graph Use Meta Description
Flag to determine if product description or open graph description is used.
Open Graph Use Product Name
Flag to determine if product name or open graph name is used.
Open Graph Use Image
Flag to determine if product image or open graph image is used.
Gtin
Global Trade Item Number.
Mpn
Manufacturer Part Number.
Reviews Rating Sum
The total (cumulative) rating for the product.
Reviews Count
The number of times the product has been rated.
Total Sold
The total quantity of this product sold.
Custom Fields ID
The unique numeric ID of the custom field. Must be separated by commas
Custom Fields NameRequired
The name of the field, shown on the storefront, orders, etc. Must be separated by commas
Custom Fields ValueRequired
The value of the field, requested on the storefront, orders, etc. Must be separated by commas
Bulk Pricing Rules ID
Unique ID of the Bulk Pricing Rule. Must be separated by commas
Bulk Pricing Rules Quantity Min
The minimum inclusive quantity of a product to satisfy this rule. Must be separated by commas
Bulk Pricing Rules Quantity Max
The maximum inclusive quantity of a product to satisfy this rule. Must be separated by commas
Bulk Pricing Rules Type
The type of adjustment that is made. Must be separated by commas
Bulk Pricing Rules Amount
The discount can be a fixed dollar amount or a percentage. Must be separated by commas
Images Image File
The local path to the original image file uploaded to BigCommerce. Must be separated by commas
Images Is Thumbnail?
Flag for identifying whether the image is used as the product's thumbnail. Must be separated by commas
Images Sort order
The order in which the image will be displayed on the product page. Higher integers give the image a lower priority. When updating, if the image is given a lower priority, all images with a sort_order the same as or greater than the image's new sort_order value will have their sort_orders reordered. Must be separated by commas
Images Description
The description for the image. Must be separated by commas
Images Image URL
Must be a fully qualified URL path, including protocol. Must be separated by commas
Images ID
The unique numeric ID of the image. Must be separated by commas
Images Product ID
The unique numeric identifier for the product with which the image is associated. Must be separated by commas
Images URL Zoom
The zoom URL for this image. By default, this is used as the zoom image on product pages when zoom images are enabled. Must be separated by commas
Images URL Standard
The standard URL for this image. By default, this is used for product-page images. Must be separated by commas
Images URL thumbnail
The thumbnail URL for this image. By default, this is the image size used on the category page and in side panels. Must be separated by commas
Images URL Tiny
The tiny URL for this image. By default, this is the image size used for thumbnails beneath the product image on a product page. Must be separated by commas
Images Date modified
The date on which the product image was modified. Must be separated by commas
Videos Title
The title for the video. If left blank, this will be filled in according to data on a host site. Must be separated by commas
Videos Description
The description for the video. If left blank, this will be filled in according to data on a host site. Must be separated by commas
Videos Sort order
The order in which the video will be displayed on the product page. Must be separated by commas
Videos Type
The video type (a short name of a host site). Must be separated by commas
Videos Video ID
The ID of the video on a host site. Must be separated by commas
Videos ID
The unique numeric ID of the product video; increments sequentially. Must be separated by commas
Videos Product ID
The unique numeric identifier for the product with which the image is associated. Must be separated by commas
Videos Length
Length of the video. This will be filled in according to data on a host site. Must be separated by commas
Variants Cost Price
The cost price of the variant. Not affected by Price List prices. Must be separated by commas
Variants Price
This variant’s base price on the storefront. If a Price List ID is used, the Price List value will be used. If a Price List ID is not used, and this value is null, the product’s default price (set in the Product resource’s price field) will be used as the base price. Must be separated by commas
Variants Sale Price
This variant’s sale price on the storefront. If a Price List ID is used, the Price List value will be used. If a Price List ID is not used, and this value is null, the product’s sale price (set in the Product resource’s price field) will be used as the sale price. Must be separated by commas
Variants Retail Price
This variant’s retail price on the storefront. If a Price List ID is used, the Price List value will be used. If a Price List ID is not used, and this value is null, the product’s retail price (set in the Product resource’s price field) will be used as the retail price. Must be separated by commas
Variants Weight
This variant’s base weight on the storefront. If this value is null, the product’s default weight (set in the Product resource’s weight field) will be used as the base weight. Must be separated by commas
Variants Width
Width of the variant, which can be used when calculating shipping costs. If this value is null, the product's default width (set in the Product resource's width field) will be used as the base width. Must be separated by commas
Variants Height
Height of the variant, which can be used when calculating shipping costs. If this value is null, the product's default height (set in the Product resource's height field) will be used as the base height. Must be separated by commas
Variants Depth
Depth of the variant, which can be used when calculating shipping costs. If this value is null, the product's default depth (set in the Product resource's depth field) will be used as the base depth. Must be separated by commas
Variants Is free shipping?
Flag used to indicate whether the variant has free shipping. If true, the shipping cost for the variant will be zero. Must be separated by commas
Variants Fixed cost shipping price
A fixed shipping cost for the variant. If defined, this value will be used during checkout instead of normal shipping-cost calculation. Must be separated by commas
Variants Purchasing disabled
If true, this variant will not be purchasable on the storefront. Must be separated by commas
Variants Purchasing disabled message
If purchasing_disabled is true, this message should show on the storefront when the variant is selected. Must be separated by commas
Variants UPC
The UPC code used in feeds for shopping comparison sites and external channel integrations. Must be separated by commas
Variants Inventory level
Inventory level for the variant, which is used when the product’s inventory_tracking is set to variant. Must be separated by commas
Variants Inventory warning level
When the variant hits this inventory level, it is considered low stock. Must be separated by commas
Variants BIN Picking number
Identifies where in a warehouse the variant is located. Must be separated by commas
Variants Product ID
Must be separated by commas
Variants SKU
Must be separated by commas
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for BigCommerce are located here https://developer.bigcommerce.com/api/
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}
is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Company
Customer ID
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
The email of the customer. Must be unique.
Company
The company of the customer.
ID
The unique numeric ID of the customer.
Customer Group
Filter customers by customer group.
First NameRequired
The first name of the customer.
Last NameRequired
The last name of the customer.
Phone
The phone number of the customer.
Registration IP Address
The IP address from which this customer was registered.
Notes
The customer notes.
Tax Exempt Category
The tax exempt category code for the customer.
Customer Group ID
ID of the group which this customer belongs to.
Force Password Reset
If true, this customer will be forced to change password on next login.
New Password
New password for customer.
Accepts Product Review Abandoned Cart Emails
It determines if the customer is signed up to receive either product review or abandoned cart emails or receive both emails.
Store Credit Amounts
Values must be separated by a comma.
Origin Channel ID
Channel ID of the customer that has created the form.
Channel IDs
Arrays of channels the customer can access. Values must be separated by a comma.
Name
The form field name. Values must be separated by a comma.
Value
Values must be separated by a comma.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
The product name.
SKU
User defined product code/stock keeping unit (SKU).
ID
Filter items by ID.
TypeRequired
The product type. One of: physical - a physical stock unit, digital - a digital download.
Description
The product description, which can include HTML formatting.
WeightRequired
Weight of the product, which can be used when calculating shipping costs. This is based on the unit set on the store.
Width
Width of the product, which can be used when calculating shipping costs.
Depth
Depth of the product, which can be used when calculating shipping costs.
Height
Height of the product, which can be used when calculating shipping costs.
PriceRequired
The price of the product. The price should include or exclude tax, based on the store settings.
Cost Price
The cost price of the product. Stored for reference only; it is not used or displayed anywhere on the store.
Retail Price
The retail cost of the product. If entered, the retail cost price will be shown on the product page.
Sale Price
If entered, the sale price will be used instead of value in the price field when calculating the product’s cost.
Map Price
Minimum Advertised Price
Tax Class Id
The ID of the tax class applied to the product.
Product Tax Code
Accepts AvaTax System Tax Codes, which identify products and services that fall into special sales-tax categories. By using these codes, merchants who subscribe to BigCommerce's Avalara Premium integration can calculate sales taxes more accurately. Stores without Avalara Premium will ignore the code when calculating sales tax.
Categories
An array of IDs for the categories to which this product belongs.
Brand Id
Inventory Level
Current inventory level of the product.
Inventory Warning Level
Inventory warning level for the product. When the product's inventory level drops below the warning level, the store owner will be informed. Simple inventory tracking must be enabled (see the inventory_tracking field) for this to take any effect.
Inventory Tracking
The type of inventory tracking for the product. Values are: none - inventory levels will not be tracked; product - inventory levels will be tracked using the inventory_level and inventory_warning_level fields; variant - inventory levels will be tracked based on variants, which maintain their own warning levels and inventory levels.
Fixed Cost Shipping Price
A fixed shipping cost for the product. If defined, this value will be used during checkout instead of normal shipping-cost calculation.
Is Free Shipping
Flag used to indicate whether the product has free shipping. If true, the shipping cost for the product will be zero
Is Visible
Flag to determine whether the product should be displayed to customers browsing the store. If true, the product will be displayed. If false, the product will be hidden from view.
Is Featured
Flag to determine whether the product should be included in the featured products panel when viewing the store.
Related Products
An array of IDs for the related products.
Warranty
Warranty information displayed on the product page. Can include HTML formatting.
Bin Picking Number
The BIN picking number for the product.
Layout File
The layout template file used to render this product category. This field is writable only for stores with a Blueprint theme applied. For stores with a Stencil theme applied, see Custom Template Associations.
Upc
The product UPC code, which is used in feeds for shopping comparison sites and external channel integrations.
Search Keywords
A comma-separated list of keywords that can be used to locate the product when searching the store.
Availability Description
Availability text displayed on the checkout page, under the product title. Tells the customer how long it will normally take to ship this product, such as: 'Usually ships in 24 hours.'
Availability
Availability of the product. (Corresponds to the product's Purchasability section in the control panel.) Supported values: available - the product is available for purchase; disabled - the product is listed on the storefront, but cannot be purchased; preorder - the product is listed for pre-orders.
Gift Wrapping Options Type
Type of gift-wrapping options. Values: any - allow any gift-wrapping options in the store; none - disallow gift-wrapping on the product; list – provide a list of IDs in the gift_wrapping_options_list field.
Gift Wrapping Options List
A list of gift-wrapping option IDs.
Sort Order
Priority to give this product when included in product lists on category pages and in search results. Lower integers will place the product closer to the top of the results.
Condition
The product condition. Will be shown on the product page if the is_condition_shown field's value is true. Possible values: New, Used, Refurbished.
Is Condition Shown
Flag used to determine whether the product condition is shown to the customer on the product page.
Order Quantity Minimum
The minimum quantity an order must contain, to be eligible to purchase this product.
Order Quantity Maximum
The maximum quantity an order can contain when purchasing the product.
Page Title
Custom title for the product page. If not defined, the product name will be used as the meta title.
Meta Keywords
Custom meta keywords for the product page. If not defined, the store's default keywords will be used.
Meta Description
Custom meta description for the product page. If not defined, the store's default meta description will be used.
View Count
The number of times the product has been viewed.
Preorder Release Date
Pre-order release date. See the availability field for details on setting a product's availability to accept pre-orders.
Preorder Message
Custom expected-date message to display on the product page. If undefined, the message defaults to the storewide setting. Can contain the %%DATE%% placeholder, which will be substituted for the release date.
Is Preorder Only
If set to true then on the preorder release date the preorder status will automatically be removed. If set to false, then on the release date the preorder status will not be removed. It will need to be changed manually either in the control panel or using the API. Using the API set availability to available.
Is Price Hidden
False by default, indicating that this product's price should be shown on the product page. If set to true, the price is hidden. (NOTE: To successfully set is_price_hidden to true, the availability value must be disabled.).
Price Hidden Label
By default, an empty string. If is_price_hidden is true, the value of price_hidden_label is displayed instead of the price. (NOTE: To successfully set a non-empty string value with is_price_hidden set to true, the availability value must be disabled.).
Url
Product URL on the storefront.
Is Customized
Returns true if the URL has been changed from its default state (the auto-assigned URL that BigCommerce provides).
Open Graph Type
Type of product, defaults to product.
Open Graph Title
Title of the product, if not specified the product name will be used instead.
Open Graph Description
Description to use for the product, if not specified then the meta_description will be used instead.
Open Graph Use Meta Description
Flag to determine if product description or open graph description is used.
Open Graph Use Product Name
Flag to determine if product name or open graph name is used.
Open Graph Use Image
Flag to determine if product image or open graph image is used.
Gtin
Global Trade Item Number.
Mpn
Manufacturer Part Number.
Reviews Rating Sum
The total (cumulative) rating for the product.
Reviews Count
The number of times the product has been rated.
Total Sold
The total quantity of this product sold.
Custom Fields ID
The unique numeric ID of the custom field. Must be separated by commas
Custom Fields NameRequired
The name of the field, shown on the storefront, orders, etc. Must be separated by commas
Custom Fields ValueRequired
The value of the field, requested on the storefront, orders, etc. Must be separated by commas
Bulk Pricing Rules ID
Unique ID of the Bulk Pricing Rule. Must be separated by commas
Bulk Pricing Rules Quantity Min
The minimum inclusive quantity of a product to satisfy this rule. Must be separated by commas
Bulk Pricing Rules Quantity Max
The maximum inclusive quantity of a product to satisfy this rule. Must be separated by commas
Bulk Pricing Rules Type
The type of adjustment that is made. Must be separated by commas
Bulk Pricing Rules Amount
The discount can be a fixed dollar amount or a percentage. Must be separated by commas
Images Image File
The local path to the original image file uploaded to BigCommerce. Must be separated by commas
Images Is Thumbnail?
Flag for identifying whether the image is used as the product's thumbnail. Must be separated by commas
Images Sort order
The order in which the image will be displayed on the product page. Higher integers give the image a lower priority. When updating, if the image is given a lower priority, all images with a sort_order the same as or greater than the image's new sort_order value will have their sort_orders reordered. Must be separated by commas
Images Description
The description for the image. Must be separated by commas
Images Image URL
Must be a fully qualified URL path, including protocol. Must be separated by commas
Images ID
The unique numeric ID of the image. Must be separated by commas
Images Product ID
The unique numeric identifier for the product with which the image is associated. Must be separated by commas
Images URL Zoom
The zoom URL for this image. By default, this is used as the zoom image on product pages when zoom images are enabled. Must be separated by commas
Images URL Standard
The standard URL for this image. By default, this is used for product-page images. Must be separated by commas
Images URL thumbnail
The thumbnail URL for this image. By default, this is the image size used on the category page and in side panels. Must be separated by commas
Images URL Tiny
The tiny URL for this image. By default, this is the image size used for thumbnails beneath the product image on a product page. Must be separated by commas
Images Date modified
The date on which the product image was modified. Must be separated by commas
Videos Title
The title for the video. If left blank, this will be filled in according to data on a host site. Must be separated by commas
Videos Description
The description for the video. If left blank, this will be filled in according to data on a host site. Must be separated by commas
Videos Sort order
The order in which the video will be displayed on the product page. Must be separated by commas
Videos Type
The video type (a short name of a host site). Must be separated by commas
Videos Video ID
The ID of the video on a host site. Must be separated by commas
Videos ID
The unique numeric ID of the product video; increments sequentially. Must be separated by commas
Videos Product ID
The unique numeric identifier for the product with which the image is associated. Must be separated by commas
Videos Length
Length of the video. This will be filled in according to data on a host site. Must be separated by commas
Variants Cost Price
The cost price of the variant. Not affected by Price List prices. Must be separated by commas
Variants Price
This variant’s base price on the storefront. If a Price List ID is used, the Price List value will be used. If a Price List ID is not used, and this value is null, the product’s default price (set in the Product resource’s price field) will be used as the base price. Must be separated by commas
Variants Sale Price
This variant’s sale price on the storefront. If a Price List ID is used, the Price List value will be used. If a Price List ID is not used, and this value is null, the product’s sale price (set in the Product resource’s price field) will be used as the sale price. Must be separated by commas
Variants Retail Price
This variant’s retail price on the storefront. If a Price List ID is used, the Price List value will be used. If a Price List ID is not used, and this value is null, the product’s retail price (set in the Product resource’s price field) will be used as the retail price. Must be separated by commas
Variants Weight
This variant’s base weight on the storefront. If this value is null, the product’s default weight (set in the Product resource’s weight field) will be used as the base weight. Must be separated by commas
Variants Width
Width of the variant, which can be used when calculating shipping costs. If this value is null, the product's default width (set in the Product resource's width field) will be used as the base width. Must be separated by commas
Variants Height
Height of the variant, which can be used when calculating shipping costs. If this value is null, the product's default height (set in the Product resource's height field) will be used as the base height. Must be separated by commas
Variants Depth
Depth of the variant, which can be used when calculating shipping costs. If this value is null, the product's default depth (set in the Product resource's depth field) will be used as the base depth. Must be separated by commas
Variants Is free shipping?
Flag used to indicate whether the variant has free shipping. If true, the shipping cost for the variant will be zero. Must be separated by commas
Variants Fixed cost shipping price
A fixed shipping cost for the variant. If defined, this value will be used during checkout instead of normal shipping-cost calculation. Must be separated by commas
Variants Purchasing disabled
If true, this variant will not be purchasable on the storefront. Must be separated by commas
Variants Purchasing disabled message
If purchasing_disabled is true, this message should show on the storefront when the variant is selected. Must be separated by commas
Variants UPC
The UPC code used in feeds for shopping comparison sites and external channel integrations. Must be separated by commas
Variants Inventory level
Inventory level for the variant, which is used when the product’s inventory_tracking is set to variant. Must be separated by commas
Variants Inventory warning level
When the variant hits this inventory level, it is considered low stock. Must be separated by commas
Variants BIN Picking number
Identifies where in a warehouse the variant is located. Must be separated by commas
Variants Product ID
Must be separated by commas
Variants SKU
Must be separated by commas
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
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.
How Code by Zapier + Xero + BigCommerce Integrations Work
- Step 1: Authenticate Code by Zapier, Xero, and BigCommerce.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.
Related categories
Related categories
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.