BigCommerce as a Channel
Summary
BigCommerce is a fully supported sales channel in Flxpoint. Connect over OAuth (recommended) or an API Account, then import and publish listings, sync price and quantity, and pull orders with tracking write-back. Set Inventory Tracking to variant in BigCommerce or quantity updates are silently discarded.
In Flxpoint go to Sales Channels → +, choose BigCommerce, name the channel and pick your processes, then on the Connect step choose a method and enter the values below. Click Continue / Authorize (OAuth) or Save (API Account), and use Test Connection to confirm.
store-XXXXXX in your Admin URL, or after /stores/ in an API Account's API Path.Set Inventory Tracking to "variant" before syncing quantities
BigCommerce does not persist per-variant quantity when Inventory Tracking is set to product or none – Flxpoint's sync appears to succeed but quantities never update on the storefront. Set Inventory Tracking to variant on all products, either manually in BigCommerce or by mapping it as a static value in your Publish Listings template.
Quantity must be mapped in the Get Orders template
Leaving Quantity unmapped in Get Orders causes a NullPointerException that blocks all order import – no orders come through. Go to Templates → Get Orders → Field Mapping, map Quantity → Line Quantity, save, and re-run.
Product images must be under 8 MB
BigCommerce rejects images larger than 8 MB on Publish Listings. Publish appears to succeed but the listing fails or shows no image on the storefront. Compress product images below 8 MB (prefer JPG or WEBP) before running Publish.
Staging and production are separate connections
Staging environments have a different Store Hash from production and separate product/order databases. If you configured the integration against a staging store it will not sync to your live store. Confirm the correct Store Hash – found in your BigCommerce Admin URL after /stores/ – for the environment you intend to connect.
| BigCommerce Field | Imported As – Notes |
|---|---|
| Name | → Product title. Shown on the parent product. |
| SKU | → Primary identifier. Used for later linking/matching. |
| Description | → Description. Long/HTML description, sanitized to supported HTML. |
| Price | → Price. Imported for reference only; not sent back by this job. |
| Images | → Images. Product image URLs; keep each under 8 MB if you plan to publish later. |
| Categories | → Categories. Multi-level category paths are preserved. |
| Brand | → Brand. Imported if set on the product. |
| Weight / Dimensions | → Physical attributes. Imported if present on product/variant. |
| Variant SKU | → Child identifier. Critical for later linking. |
| Inventory Level | → Quantity. Per-variant stock, when managed per variant. |
| UPC / Barcode | → Global identifier. Useful as a secondary match key. |
| Options (name/value) | → Options. Option label & value (e.g. Color: Blue). No mapping template is used for Import. |
Import options (Product & Listing Management)
This required setting controls what each run is allowed to create and update. All four options are available on BigCommerce.
| Option | What it does | When to use it |
|---|---|---|
| Change feed (recommended) | Creates new products and listings and updates existing ones. Each run only fetches what changed on BigCommerce since the last successful run, so runs stay fast. | Your everyday default. |
| New products and listings | Creates new products and new listings only. Existing Flxpoint records are left untouched. | When you have curated data in Flxpoint that BigCommerce should not overwrite. |
| New listings | Creates new listings only. No products are created in your catalog, and existing records are not updated. | When your catalog is built from your sources and BigCommerce should only contribute listings. |
| Catalog refresh (not recommended) | Creates new products and listings and updates all existing ones, re-reading your entire BigCommerce catalog. | One-off recovery after a bulk edit on the BigCommerce side. Expect a long-running job. |
| Flxpoint Field | BigCommerce Field – Notes |
|---|---|
| Quantity | → Inventory Level. Required. Updates variant stock – only persists when Inventory Tracking = variant. |
| List Price | → Price. Recommended. Apply markup/rounding rules as needed. |
| Sale Price | → Sale Price. Optional. Leave blank if you don't run sales in BigCommerce. |
| MSRP | → Retail Price (MSRP). Optional. Reference / compare-at price. |
| SKU | → SKU. Recommended. Primary match key for Linking Priority (keep SKU ↔ SKU as your first row). |
| Availability Description | → Availability Description. Optional. Customer-facing availability note. |
| Metafields | → Metafields. Optional. Creates missing and updates mapped metafields; unmapped metafields are preserved (not deleted). |
| Flxpoint Field | BigCommerce Field – Notes |
|---|---|
| Title | → Name. Required. ≤ 250 chars; use the truncation setting if needed. |
| Type | → Type. Required. physical / digital. |
| Price | → Price. Required. Base product price. |
| Weight | → Weight. Required for physical items – needed for shipping rates (kg). |
| Brand | → Brand. Optional. Created if missing. |
| Category 1–3 | → Categories. Optional. Up to 3 levels, created if missing; no duplicate or multi-parent categories (can return a 409 Conflict). |
| Description (HTML) | → Description. Optional. Sanitize HTML if copied from external sources. |
| Images (URLs) | → Images. Optional. Each ≤ 8 MB; controlled by "Parent Images Direct Copy." |
| SKU | → Variant SKU. Recommended. Primary identifier for updates. |
| List / Sale / MSRP | → Price / Sale Price / Retail Price. Variant pricing; use rules for markups/rounding. |
| UPC / GTIN / MPN | → UPC / GTIN / MPN. Optional. Helpful for marketplace feeds and audits. |
| Option Name/Value | → Options. Optional. Each value ≤ 250 chars. Up to 250 variants per product. |
| Inventory Tracking | → static value variant. Recommended so per-variant quantity syncs actually persist on the storefront. |
| Metafields | → Metafields. Optional. Created on publish and updated on re-publish, at parent and variant level. |
| BigCommerce Field | Maps To – Notes |
|---|---|
| SKU | → Line - SKU. Required. Orders/lines without a SKU won't import. |
| Quantity | → Line - Quantity. Required. Unmapped quantity triggers a NullPointerException that blocks all order import. |
| Date Created | → Order - Created. Required. Creation date. |
| State Code (Billing / Shipping) | → State Code. Recommended. Prefer the two-letter code (e.g. CA) for downstream tax/shipping rules. |
| Shipping Method | → Shipping - Method. Map each method to a Flxpoint shipping policy; unmapped methods put orders On Hold. |
| Order ID / Status / Totals | → Order fields. Optional. Identifier, BC status, and subtotal/tax/total context. |
| Staff / Customer Notes | → Order - Notes. Optional. Communication captured on the order. |
| Gift Certificate (no SKU) | Uses a generated SKU: name-orderItemId, or type-orderItemId for duplicate names. Digital items import as type digital. |
| FFL Details | Optional. Enable Import FFL Details to read FFL info from Order Comments when present. |
| Flxpoint Field | BigCommerce Shipment Field – Notes |
|---|---|
| Tracking Number | → tracking_number. Required. Unmapped tracking prevents shipment creation. |
| Tracking Link | → tracking_url. Optional. Direct tracking URL. |
| Tracking Carrier / Shipping Provider | → carrier. Optional. Use a BigCommerce-accepted value, or map empty if it isn't recognized. |
| Shipping Method | → shipping_method. Optional. Service/method label. |
| Merchant Shipping Cost | → shipping_cost. Optional. Merchant cost. |
| Date Created | → shipped_at. Optional. Shipment timestamp. |
| Comments | → comment. Optional. Note included on the shipment. Shipments post via POST /v2/orders/{order_id}/shipments; order status becomes Partially Shipped until all lines ship. |
NullPointerException on Quantityvariant value in your Publish Listings template./stores/ in the Admin URL. (2) API scopes – for an API Account, enable Products, Orders, Customers, Content, and Information & Settings; missing scopes return a credentials error even when the token is valid. (3) Account permissions – OAuth approval requires the store owner or staff with app-install permission.What's the difference between OAuth and API Account connection – which should I use?▸
Where do I find my BigCommerce Store Hash?▸
store-XXXXXX, or after /stores/ in the API Path when creating an API Account. It's a short alphanumeric string (e.g. abc123def). If you have multiple stores, confirm you're using the hash for the correct one – staging and production stores have different hashes.Quantities sync successfully in Flxpoint but aren't updating on my BigCommerce storefront – why?▸
variant to your Publish Listings template.