Skip to main content

Importing & Exporting Products

Products in your Reflow project can be imported and exported using standard CSV files.

Importing can be used for migrating to Reflow from another service or for moving your products to another Reflow project.

Exporting products is useful when you need to keep a backup of your products' data, or when you need to import them into things like accounting and inventory software.

Products CSV Format

The CSV format Reflow uses contains most of the properties and settings associated with your products, including prices, variants and media. You can download an example CSV file to use as a template.

The first line of the CSV file must contain the column headers as they are shown in the table below. Each line after that represents either a new product, variant or image/video.

Column HeaderRequiredDescription
Product IDalways required

A unique identifier for this product. Can be a numeric ID (12345677) or a string handle (example-product-handle).

Variant and image rows are added right after their respective product row and need to share the same Product ID.

Product Namealways requiredA string indicating the name of the product.
Product Typealways required

A string indicating the product type.
Either physical, digital or gift_card.

Description (HTML)optional

The product description as a valid HTML string.

Can include images in the format <img src=""https://cdn.reflowhq.com/csv-examples/camera.jpg"" />.

Can include YouTube video embeds in the format <iframe class=""ql-video"" frameborder=""0"" src=""https://www.youtube.com/embed/J---aiyznGQ&quot;&quot;&gt;&lt;/iframe> .

ExcerptoptionalA shorter version of the description in plaintext. Cannot include HTML tags, images or video.
Show In Storeoptional

Indicates whether or not the product is shown in your store.

Valid values are 'TRUE' and 'FALSE'. When omitted defaults to 'FALSE'.

CategoriesoptionalA string of comma-separated category names for this product.
Custom Sortoptional

An integer indicating the custom sort placement for this product.

Media Srcoptional

A link to a an image or YouTube video for the product's gallery.

Products with multiple media items are represented in the CSV as a product row followed by media rows.

Each media row represents a single image/video. It has all columns empty, except the Product ID and Media Src. The Product ID needs to have the same value as the product where media is added.

Variants Option Namerequired for products with variantsThe option name for the variants this product will have (e.g. Size, Color, Material).
Variants Namerequired for variants

The name of the product variant.

Variants are represented in the CSV as a product row followed by variant rows.

When defining a variant row, make sure the Product ID of the variant row matches that of the respective product.

Variants Image IndexoptionalThe image/video with this index in the product's media items will be associated with this variant.
Pricerequired for products and variantsThe price of the product or variant.

Should not include any currency symbols (e.g. 19.99 - valid, $19.99 - invalid). The currency for your products is instead determined by your project settings.
Original PriceoptionalFor products and variants that are discounted, shows the original price for the item when not on sale. Must be greater than the Price column.

Should not include any currency symbols.
SKUoptionalThe SKU (stock keeping unit) identifier for this product or variant.
Shipping WeightoptionalA number indicating the weight of the product or variant.

Should not include any measurement units like kg or lbs. Instead, the measurement units are determined by your project settings.
In Stockoptional

When this column is filled the product has simple inventory (inventory docs).

Indicates whether or not the product or variant is in stock and available for purchase. Valid values are 'TRUE' and 'FALSE'. When omitted defaults to 'FALSE'.

Stock Quantityoptional When this column is filled the product has advanced inventory (inventory docs).

The number of available units for this product or variant. When this is set to 0 the product/variant is considered out of stock.

Warning

Sorting the CSV file by any column other than Product ID may cause it to become invalid for importing back into Reflow. This is because the table rows for product variants and images/videos need to always come after the product defining row and have the same Product ID.

How to Import Products

Importing into Reflow is done using CSV files. There are two sources that we currently support, each requiring a specific format of the imported CSV file:

  • Reflow - When importing from a Reflow project, make sure the CSV file follows our CSV products format.
  • Shopify - When importing products from Shopify, verify that the provided CSV file matches the Shopify CSV format.

When you have your file ready, go to the products page and click the import button. This will open a dialog where you can select the platform you're importing from and upload the CSV file.

Product Export Dialog

On Duplicate ID Behavior

The On Duplicate ID option configures what happens when a product in your import CSV has an ID/handle that is already taken by an existing product in your project. There are two options:

  • Create New Product - When this option is selected a new ID will be generated and a new product will be added to your project.
  • Update Existing Product - If this is selected the existing product with the matching ID will be updated. All data from the import CSV will override the existing product settings. For any missing columns in the CSV the product will keep its original settings.

When the Import button is pressed, the CSV file will be validated and if everything is ok the import process will begin.

Depending on the number of products imported and how many product images need to be downloaded, the importing may take a while to complete. You can follow the progress from the products page. We will also send you an email once importing is finished.

How to Export Products

To export the products of your project, go to the products page and click the export button. This will open a dialog with several options for selecting which products to export.

Product Export Dialog

Here is what each option does:

  • All products - Export all the products of your project.
  • Filtered products - Export only products matching the currently applied search and filtering from the products page.
  • Selected products - Export products which are currently marked for bulk editing (the checkboxes on the left of the products table).
  • Products on current page - Exports only the products on the page currently being viewed.

Clicking the Export button will generate a CSV file with your products and start a download.