BigCommerce User Guide
Set up vendors, product mapping, order routing, tracking, stock and price updates for your BigCommerce store.
This guide shows how to use Spark Shipping with your BigCommerce store after the install. If you have not installed the app yet, start with the BigCommerce Installation Guide.
How Spark Shipping works with BigCommerce
- Vendors: you connect your vendors (suppliers, distributors or dropshippers). Spark Shipping reads their catalog, stock and cost.
- Products: Spark Shipping reads your BigCommerce products and connects each one to a vendor SKU. A vendor SKU is a vendor's item for a product.
- Stock and prices: Spark Shipping updates stock on your BigCommerce products from your vendor data. It can also update prices when you turn on price updates.
- Orders: Spark Shipping imports new BigCommerce orders and sends each item to the best vendor.
- Tracking: when a vendor ships, Spark Shipping adds a shipment with the tracking number to the BigCommerce order.
Find your way around
The top menu has Dashboard, Sites, Orders, Products, Vendors, Automation and Support.
Your BigCommerce store is a site. To open its settings, click Sites and select the store. The site menu includes:
- Credentials: connect to BigCommerce and run Test Connection.
- Custom Settings: BigCommerce order, stock and price settings.
- Order Routing: how Spark Shipping selects a vendor for each order item.
- Product Auto Mapping: how your products are connected to vendor SKUs.
- Order On Hold Rules: rules that hold orders for a manual review.
- Default Product Options: settings for new products that Spark Shipping creates in BigCommerce.
- Profit Margin, Integrations, Alert Options and Jobs.
The pages you see can depend on your plan and your user permissions.
Step 1: Add a vendor
- In the top menu, click Vendors.
- In the Integrations panel, find your vendor. Click Expand All to see all categories.
- Click Add Vendor on the vendor card.
- Is your vendor not on the list? Under Custom Integrations, use Self Setup for plain-text email, CSV or XML vendor files, or select one of the onboarding options and our team sets up the feed for you.
- On the vendor's Credentials page, enter the details from your vendor. Then click Test Connection.
Spark Shipping then pulls the vendor's catalog, stock and costs on a schedule. To see the vendor's products, open the vendor and click Product Catalog.
Step 2: Connect your BigCommerce products to vendor SKUs
Spark Shipping pulls your BigCommerce products and their variants. It reads the SKU, the UPC (barcode) and the MPN (part number) of each one.
To connect them to vendor SKUs automatically:
- Open your site and click Product Auto Mapping.
- Turn on Product Auto Mapping.
- In Vendor SKU, select Product SKU if your BigCommerce SKUs are the same as your vendor SKUs, or Barcode to match on the UPC. If your SKUs have a prefix, a suffix or another pattern, contact support and we help you set up the rule.
- Click Update Product Auto Mapping.
Leave Auto Update SKU Mapping and Auto Remove SKU Mapping off unless support recommends them. They change or remove the mappings of all your products.
To check or edit the mapping of one product, click Products in the top menu and open the product.
Step 3: Add new products from a vendor catalog (optional)
Spark Shipping can create products in BigCommerce from your vendor's catalog.
- First, set your defaults on the site's Default Product Options page (see "Default Product Options" below). Select a Default product category. If the category list is empty, run Test Connection on the Credentials page.
- Open the vendor and click Product Catalog.
- Use the filters to find products. In the Add To Site section, select the category and (optional) a Product Template.
- Click Add To Site next to each product. To add many products, click Upload SKU List (CSV) and upload a list of vendor SKUs.
Spark Shipping creates each product in BigCommerce with its name, SKU, price, cost, weight, dimensions, stock, images, brand, UPC and category.
Step 4: Check your order settings
Spark Shipping imports new BigCommerce orders automatically.
Which orders are fulfilled
- Orders in Awaiting Fulfillment or In Process are imported and sent to your vendors.
- By default, orders in these statuses are not imported: Incomplete, Cancelled, Declined, Awaiting Payment, Manual Verification Required, Pending Approval, Awaiting Pickup and Awaiting Shipment.
- To change this list, open Custom Settings and edit Order statuses to be skipped (not imported). If you remove a status from the list, orders in that status are imported and fulfilled. Cancelled orders are never fulfilled.
Other order rules
- Order Processing Delay (in Custom Settings): wait 15 to 240 minutes before Spark Shipping processes a new order. Use it to give your team time to cancel or edit an order. The default is no delay.
- Orders older than one month are not imported. Orders older than the Skip Fulfillment Days setting on the Advanced Options page (3 days by default) are imported but not sent to vendors.
- During the first full order sync of a new site, Spark Shipping imports existing orders but does not send them to vendors. Only new orders are fulfilled.
- Use Order On Hold Rules to hold orders that need a manual review, for example with Hold orders with a Grand Total at or over.
Step 5: Route orders to vendors
When an order is imported, Spark Shipping sends a fulfillment request for each item to a vendor. It selects the vendor with the rules on the site's Order Routing page. By default, each item goes to the vendor that has enough stock at the lowest total cost.
To see your orders and their status, click Orders in the top menu. Open an order to see the request that was sent to each vendor and the vendor's reply.
Step 6: Tracking goes back to BigCommerce
When a vendor ships an item, Spark Shipping gets the tracking number from the vendor. It then creates a shipment on the BigCommerce order with the tracking number, the shipping method and the shipped items. For UPS, USPS and FedEx shipments, Spark Shipping also sets the shipping provider.
What BigCommerce does after a shipment is added (for example, the order status and the shipment email to your customer) depends on your BigCommerce settings.
Step 7: Stock and price updates
Spark Shipping updates your BigCommerce products and variants from your vendor data:
- Stock: on by default. The inventory level of each mapped product or variant is updated from your vendors' stock. To also turn on BigCommerce inventory tracking for a product when Spark Shipping updates it, select Update Inventory Tracking Method on the Advanced Options page.
- Price: off by default. To turn it on, go to Automation → Pricing, set your pricing rules and select Enable Automatic Updates. The price is calculated from the vendor cost and your rules.
- To stop one type of update for this store, open Custom Settings and select Disable Stock Updates or Disable Price Updates.
If your store manages stock by location in BigCommerce, the stock that BigCommerce saves can be different from the stock that Spark Shipping sends. In this case, the site's job log shows a warning.
Custom Settings reference
Open your site and click Custom Settings. The BigCommerce Settings panel includes:
- Order statuses to be skipped (not imported): see Step 4.
- Order Processing Delay: see Step 4.
- Disable Price Updates / Disable Stock Updates: see Step 7.
- Enable oauth login from BigCommerce: shown only for accounts that existed before the app was installed. It lets other users of your BigCommerce store open Spark Shipping from the control panel. See BigCommerce Multi-User Support.
- Enable Shipping Origins product metafield (for ShipperHQ support): writes the vendors that have stock for a product to a product metafield, so ShipperHQ can calculate shipping rates by origin. This feature is in beta.
- Separator for order item product_options: the character that separates product options on imported order items. The default is a comma.
Default Product Options reference
These settings apply to new products that Spark Shipping creates in BigCommerce:
- Default product category: the BigCommerce category for new products.
- Set product visible status to false (product is not published): create new products as hidden, so you can review them before your customers see them.
- Push product Retail Price (MSRP): send the vendor MSRP as the BigCommerce retail price.
- Push product Sale Price from user_field_1: send a sale price.
- Push product attributes as BigCommerce custom fields: add vendor attributes (for example color or material) as custom fields.
- Use HTML for product descriptions and Disable product meta description.
- Product Condition: for example New.
- Limit number of product images: 0 to 10 images for each product.
Other features
- FFL dealers (firearms): Spark Shipping can read the FFL dealer that your customer selects at checkout. Open your site, click Integrations and select your FFL checkout app: AutomaticFFL, FFL Locator or g-FFL Checkout. Orders with an FFL that Spark Shipping cannot read are put on hold for review.
- Currency conversion: if your vendors and your store use different currencies, use the site's Currency page (if your plan includes it).
- Several BigCommerce stores: install the app on each store. Each store becomes a separate site. A store is added to your existing Spark Shipping account when the store owner's email address matches your login, or when you are signed in to Spark Shipping in the same browser. Otherwise the install creates a new account; contact support and we move the store to your account.
Get help
- Help Center: kb.sparkshipping.com
- Email: support@sparkshipping.com, or use Support → Email in the Spark Shipping top menu
- Live training: Support → Live Training in the Spark Shipping top menu