Import Products from BigCommerce

Overview

Sellercloud allows you to automatically import products and product information from BigCommerce and to store them in your catalog.

Once you set up the BigCommerce V3 Account Integration, you can synchronize your catalog between the two platforms by importing information from your existing listings on BigCommerce. This feature both creates and updates products in Sellercloud.

BigCommerce V2 is not supported – you can only import from BigCommerce V3.

Prerequisites

Before you can import products from BigCommerce:

  • Make sure you have successfully connected BigCommerce to Sellercloud. The following fields must be configured on the Website > Sellercloud Plug-in Website > Cart General page:
    • Website URL
    • OAuth Store Hash
    • OAuth Client ID
    • OAuth Access Token
    • OAuth Secret Token
  • Contact Sellercloud Support to request the product import plugin.

Import Products From BigCommerce

You can import and update products from BigCommerce automatically or manually. 

Variation Products are supported. Based on the BigCommerce product’s variation list, local products will be created or updated in Sellercloud, and then the N-Matrix relationship will be created. Kit Product relationships, on the other hand, will not be created.

The following product properties will be updated, both upon initial product import and during regular updates:

  • On the BigCommerce (Website) Properties page:
    • Website Merchant SKU
    • Website Product ID
    • Manufacturer SKU
    • Long Description
    • Website Price
    • Retail Price
    • Website Categories
    • Enabled (Website)
  • On the Product Details page:
    • UPC
    • GTIN
    • Product Status
    • Product Name 
    • Product Type
    • Product Weight
    • Product Dimensions (Length, Width, Height)
    • Product Images
Sellercloud uses the Website Merchant SKU identifier to match corresponding products on BigCommerce. If a product is not found under the company you intend to import information for, but its Website Merchant SKU matches a product on BigCommerce, the product will still be updated, but its company in Sellercloud will remain unchanged.
Each time you use this import, the properties listed above will be updated based on the corresponding fields’ values on BigCommerce. If you have already configured these properties in Sellercloud, the product import will overwrite their current values and this may affect how your listings are updated on other channels. The Site/Retail Price is an exception – if it already has a value, it won’t be overwritten.

Automatically

To import and update products from BigCommerce automatically:

To set up the scheduled task:

  1. Go to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:

    1. Click Task Type and select Import Products.
    2. Set the Task Name.
    3. Select the Company where this task will be created.
    4. Select the Start Time. This will be used if you start syncing products automatically.
    5. Click CREATE.
  4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click the Create Products For Company menu and select the company where products will be imported and updated.
    2. Click the Plugin menu and select BigCommerceV3 Product Import Plugin.
  7. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. Click the Enable toggle button in the General panel.
  9. Click Save on the top right.

Manually

To import and update products from BigCommerce manually:

  1. Go to Catalog > Tools > Import Product Info.
  2. Select Import Info Via Plugin/Profile.
  3. Select the targeted company next to Update Products For Company.
  4. Choose Select Plugin and select BigCommerceV3 Product Import Plugin.
  5. You will be required to upload a File. This particular plugin does not require a list of SKUs, so you can upload a blank CSV or Excel file.
  6. Click Import.

Alternatively, if you have already followed the steps above to set up a scheduled task:

  1. Go to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Find the product import task and select it.
  3. Click the blue Actions icon at the bottom right and select Execute.
  4. Alternatively, you can click the Execute task icon in the General panel on the task’s page.

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support