Importing products

Learn how to import products from your e-commerce store to Flux Panda.

Product mapping

The Flux Panda Player stores a copy of the products you want sell during your live show.

This is required as the Flux Panda Player can be deployed across multiple channels (web, social, app, email, etc.) simultaneously. In addition it enables real-time inventory management, special offers and more.

Hence, when a customer has added products to the Flux Panda Player shopping cart, and clicks on checkout, we must have a way to transfer and map products to your e-commerce store.

To accomplish this for each product or product variant we store your unique product ID in the Flux Panda external_id field.

Import options

There are three options for importing your products to Flux Panda.

  1. Create each product manually using our admin panel
  2. Importing your products using a CSV file
  3. Creating products via our REST API API reference

Importing from a CSV file

In order to import products to your FluxPanda Channel you must have a standard CSV file format containing the FluxPanda product structure.

CSV file structure

In order to successfully import your products, your CSV file must have the following structure;

Column

Description

Required

product_id

The ID to identify your product. If a product has multiple variants, each variant must have the same product_id. For Example my-awesome-tshirt

Required

external_id

The unique external ID to identify your product or variant. If a product has multiple variants, each variant must have different external_id. For Example TSHIRT-001

Optional

name

The name of the product. For example, T-Shirt.

Required (except for product variants for which this must be left empty).

description

The description of the product.

Optional

image_url

Publicly accessible URL to the product image (one image only). We will fetch the image during import.

Optional

variant_option_1_name

A product’s variant name. For example, Color.

Optional

variant_option_1_value

A product’s variant value. For example, Blue.

Optional. Except if variant_option_1_name is provided.

variant_option_2_name

A product’s variant name. For example, Size.

Optional

variant_option_2_value

A product’s variant value. For example, Small.

Optional. Except if variant_option_2_name is provided.

variant_option_3_name

A product’s variant name. For example, Milliliter.

Optional

variant_option_3_value

A product’s variant value. For example, 150.

Optional. Except if variant_option_3_name is provided.

sku

SKU of the product. This should be unique for every variant of a product. For example, SKU-150.

Optional

price

Current price of the product. Must be greater than 0. For example, 10.99.

Required

compare_at_price

Original price of the product (only if it's greater than the "price"). For example, 15.99

Optional

quantity

Available quantity of the product. For example, 160.

Required

weight

Weight of the product (in kg). For example, 12.

Optional

height

Height of the product (in cm). For example, 30.12.

Optional. Except if length or width is provided.

length

Length of the product (in cm). For example, 120.10.

Optional. Except if height or width is provided.

width

Width of the product (in cm). For example, 8.50

Optional. Except if height or length is provided.

Importing variants

Every row in the CSV file corresponds to either a single product or a variant thereof.

A product and its variants must have the same product_id. When importing variants all you have to do is to make sure you group them by product_id.

The external_id is your unique ID with which you can identify a product or a variant. Let's say someone wants to order the T-Shirt 2020 in Red color, then the external_id is the unique ID in your system to identify this variant.

You can import up to three variant types such as Color, Size, Flavor, etc. per product.
To do so you specify the variant_option_1_name and variant_option_1_value as per the example below:

product_id

external_id

name

...

variant_option_1_name

variant_option_1_value

...

my-tshirt

TSHIRT001

T-Shirt 2020

Color

Blue

my-tshirt

TSHIRT002

Color

Yellow

my-tshirt

TSHIRT003

Color

Green

my-pants

PANTS002

Pants New

Make sure you have all the header names in snake case format (correct: image_url, wrong: image url) in your CSV file as specified above. Otherwise, your imports may not work as expected.

Sample CSV

You can download a sample CSV file here