Import products

Move an existing product catalog into Frontro with a CSV file. Frontro recognizes exports from Shopify, WooCommerce, and Squarespace, as well as the downloadable Frontro template. Frontro validates every row and shows row-level errors before any products are created.

Before you begin

Frontro imports the product title, description, price, SKU, barcode, inventory quantity, inventory policy, shipping requirement, weight, visibility, and destination URL when those values are available in the source file.

Keep these behaviors in mind:

  • Product variants become separate Frontro products. Their option values are added to the title, such as Trail Tee — Size: Large, so each SKU and price is preserved.
  • Product images aren't imported yet. Add images after the products are created.
  • Currency defaults to USD when the export doesn't include a currency column.
  • Shopify stores with multiple inventory locations don't include quantities in the product export. Rows that already allow continued selling import with a quantity of zero. Rows configured to stop selling show a validation error until you enter a non-negative value in the Inventory quantity column.
  • Nothing is created until you click the final Import products button.

Export products from Shopify

Shopify Products export walkthrough showing the Products page, Export action, product selection, and CSV format choices

  1. In Shopify admin, open Products.
  2. Click Export.
  3. Choose the current page, all products, selected products, or products matching your current filters.
  4. Choose either CSV format. Use the spreadsheet format if you plan to inspect or edit the file first.
  5. Click Export products. Shopify downloads smaller exports immediately and emails larger exports.

Don't reorder a Shopify export before importing it. Shopify stores product variants and additional images on adjacent rows, and sorting can separate those rows from their product.

For Shopify's current export behavior and column definitions, see Exporting products and Using CSV files to import and export products.

Import the CSV into Frontro

Frontro Products page with the Import products action highlighted

  1. In Frontro, open Content and select Products.
  2. Click Import products.
  3. Click Choose CSV file and select the export from your ecommerce platform.
  4. Confirm that Frontro detected the expected format.
  5. Review the number of products ready to import and fix any rows that need attention.
  6. Click Import products.

Frontro CSV review showing detected format, validation result, and final import action

The import button stays disabled when validation errors are present. Each error includes the CSV row number and the field that needs attention. Upload the corrected file to review it again.

Shopify field mapping

Shopify exportFrontro
TitleProduct title
Description or Body (HTML)Description
Price or Variant PricePrice
SKU or Variant SKUSKU
Barcode or Variant BarcodeBarcode
Inventory quantity or Variant Inventory QtyAvailable quantity
Continue selling when out of stock or Variant Inventory PolicySold-out behavior
Requires shipping or Variant Requires ShippingPhysical or digital product
Weight value (grams) or Variant GramsWeight in grams
Status or Published on online storeDraft or published visibility
Option valuesAppended to the Frontro product title

Frontro recognizes both Shopify's current column names and the legacy Variant ... names found in older exports.

WooCommerce exports

In WordPress, go to Products, click Export, select the product fields you need, and generate the CSV. Upload that file directly in Frontro.

Frontro supports simple products and variation rows. Variable or grouped parent rows without a price are skipped because they aren't independently purchasable. Variations retain their own name, SKU, price, stock, backorder setting, and published status.

WooCommerce can customize exports through extensions. If a plugin renames core columns, use the Frontro template or rename those columns back to the core names before importing. See WooCommerce's core CSV import/export overview.

Squarespace exports

In Squarespace, open Products & Services, select Products, and click Export all. To export only part of the catalog, select products and click Export.

Frontro supports physical and service product rows, sale prices, stock, visibility, SKUs, and up to three option values. As with Shopify, each variant becomes its own Frontro product. See Squarespace's product export guide.

Using the Frontro template

For a custom platform or spreadsheet:

  1. Open Import products in Frontro.
  2. Click Download template.
  3. Add one product per row without changing the header names.
  4. Save the file as a UTF-8 CSV.
  5. Upload it and review validation before importing.

The required columns are title and price. For reliable inventory and checkout behavior, also provide sku, available_quantity, inventory_policy, and requires_shipping.

Running into trouble? Save the original export and contact Support. Including the row-level validation message will help us diagnose the format quickly.

Was this page helpful?