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.
| Field | What to enter |
|---|---|
Connection MethodSetting | Choose OAuth (recommended, no keys to manage) or API Account (Client ID / Client Secret / Access Token). Use API Account only if your organization can't approve OAuth app installs.
OAuth is the preferred, token-free setup. |
Store HashRequired | Identifies your BigCommerce store. It appears as
Needed for both methods. Staging and production stores have different hashes: confirm you're using the right one.store-XXXXXX in your Admin URL, or after /stores/ in an API Account's API Path. |
OAuth AuthorizeRequired | For the OAuth method: enter your Store Hash, click Continue / Authorize, log in if prompted, and approve the requested permissions. You return to Flxpoint with the connection shown as Connected.
Must be approved by the store owner or staff with app-install permission in BigCommerce. |
Client IDOptional | API Account method only. Create or select an API Account in BigCommerce Admin under Advanced Settings → API Accounts and copy the Client ID.
Part of the API Account fallback (skip if using OAuth). |
Client SecretOptional | API Account method only. Copied when you create the API Account in BigCommerce Admin.
Store credentials securely and rotate tokens when personnel or policies change. |
Access TokenOptional | API Account method only. The bearer token issued alongside your API Account.
Part of the API Account fallback (skip if using OAuth). |
API ScopesSetting | For API Accounts set minimum scopes: Products (Read/Write), Orders (Read/Write), Customers (Read), Content (Read), Information & Settings (Read).
Insufficient scopes return an 'invalid credentials' or permission error even when the token and Store Hash are correct. |
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.
Pulls existing BigCommerce products and variants into Flxpoint. Manual-only (no scheduling) and reads fields directly: no mapping template.
| 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. |
Links Flxpoint listings to existing BigCommerce products (SKU first, then UPC/GTIN/MPN as fallbacks) and syncs price, quantity, visibility, and mapped metafields on demand or on a schedule.
| 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). |
Creates or updates BigCommerce products from your Flxpoint listings: parent and variant fields, images, categories/brands, and metafields.
| 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. |
Imports BigCommerce orders into Flxpoint (billing/shipping, line items, totals, notes), processing up to 50 orders per page.
| 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. |
Writes tracking and shipment status back to BigCommerce via POST /v2/orders/{order_id}/shipments, with automatic carrier detection on retry.
| 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. |
Get Orders failing: NullPointerException on Quantity
Orders not importing from BigCommerce
Inventory quantities not updating on the BigCommerce storefront after sync
variant value in your Publish Listings template.Sync Orders completing but shipments not updating in BigCommerce
Publish fails: "name: The product name is a duplicate"
Connection fails: "Invalid store hash" or "Invalid credentials"
/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.Sync listing errors: 429 Rate Limit Exceeded
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.