Task — Read the product and sales mappings

Purpose

Use this reference to compare product identifiers, variant values and sales-order amounts, and to understand the limits on changes to existing orders.

Prerequisites

Use the table for the entity you are comparing: products, sales-order headers or sales-order lines. For connection fields, use Prepare a BigCommerce connection. This page does not identify your account's current settings or synchronization schedule.

Steps

  1. For products, distinguish the parent product ID from the variant ID. Match the variant to the corresponding product in Optiply.
  2. Compare the price and inventory-tracking rules, rather than assuming every value comes from the parent product.
  3. For sales orders, compare the header subtotal separately from the line price and quantity.
  4. Check order-status selection, unmatched-line exclusion and the existing-order limitations before expecting a change to synchronize.

Fields and columns

Products

Optiply fieldBigCommerce valueRule
nameParent product name + variant option labelsCombines the name and selected option labels with spaces.
remoteIdvariants.idIdentifies the variant.
articleCodeParent products.idNot the variant's remote identifier.
skuCodevariants.skuVariant SKU.
eanCodeproducts.upcParent barcode; a decimal suffix is removed.
priceVariant price, falling back to calculated_price when nullNot the parent product price. Numeric values are rounded to two decimals; invalid or empty numeric input becomes zero.
stockLevelVariant inventory_level for variant tracking; otherwise parent inventory_levelSent as a whole-number stock level.
unlimitedStockParent inventory_trackingA tracking value containing none enables unlimited stock.
statusParent availabilityExactly available becomes enabled; other values become disabled.

Products and variants are joined using the parent product ID. Newly created disabled products are excluded. An existing product can receive a status update, along with changed product values.

Sales-order headers

Optiply fieldBigCommerce value
remoteIdorders.id
placedorders.date_created
totalValueorders.subtotal_ex_tax, normalized to two decimals

The subtotal excluding tax is the order-header value. It is not the same input as the line's unit price.

Sales-order lines

Optiply fieldBigCommerce valueRule
productIdorder_lines.variant_idMatches the imported variant's remote identifier, then uses its Optiply product ID.
quantityorder_lines.quantityNumeric quantity.
subtotalValueorder_lines.base_price × order_lines.quantityPrice and quantity are each normalized before multiplication. It does not multiply an existing line total by quantity.

Lines without a matching imported variant are excluded. Orders with no matching lines are also excluded. Matching lines are attached to their order; repeated lines are not combined into a single product quantity.

Expected result

You can identify each imported variant, distinguish parent and variant fields, and compare the sales-order header subtotal with the separate line calculation.

Limitations

The standard order selection imports Completed orders. A connection configured for broader order selection can import other non-cancelled statuses. This describes the mapping's selection rule, not the current value of a connection setting.

Existing orders and their lines are not generally updated, and no completed date is sent. Cancelled, Refunded and Declined orders are excluded from creation and have a separate removal path when the connection already identifies the imported order. This is not a guarantee that a particular removal has completed.

Errors and recovery

If an order or line is missing, check its status and whether each line's variant matches an imported product. For a missing product, also check its availability and variant relationship. Review the limitations before expecting an existing order's completion date, changed lines or added lines to synchronize. Do not use an order edit as a resend procedure.