Supplier conversion

Supplier Excel to Shopify CSV

Turn supplier product workbooks into a Shopify-ready CSV workflow.

Tool entry

Start with your product workbook.

The current self-service workflow accepts XLSX uploads. If your catalog is a CSV, save it as an XLSX workbook first, then use this entry to run the relevant Shopify CSV cleanup flow.

Open upload workflow

Scenario

Supplier spreadsheets are usually not built for Shopify. They may include product names, model numbers, colors, sizes, wholesale prices, inventory, and image links, but the structure is often made for purchasing or internal catalog management instead of Shopify import. Before you can upload the data, the file needs to be cleaned, mapped, and exported in Shopify’s product CSV format.

This tool entry is closest to the core Catalog Optimizer workflow. It helps turn messy supplier Excel workbooks into a cleaner Shopify product CSV draft. The focus is on mapping supplier fields to Shopify fields, grouping variants under the right Handle, cleaning SKUs and prices, preparing image URLs, and making the file easier to review before import.

It is useful for sourcing teams, dropshipping operators, and store owners who receive files from manufacturers or wholesalers. Instead of manually copying columns into a Shopify template, you can use the upload workflow to prepare a structured output and then review the result before importing.

Real example

Input and output for this workflow.

Input

A supplier XLSX contains product name, model number, color, size, cost, stock, category, and several image columns.

Output

A Shopify-ready product CSV draft with grouped products, variant rows, SKUs, prices, inventory fields, image URLs, and cleaner handles.

FAQ

Common questions before upload.

Can Shopify import Excel files directly?

Shopify product import is based on CSV. This workflow accepts XLSX workbooks and prepares Shopify-ready CSV output after processing.

What supplier fields can be mapped to Shopify?

Common fields include product names, descriptions, SKUs, prices, stock, categories, color, size, material, pack size, and image URLs.

How are color and size converted into variants?

Color and size values can be converted into Shopify option fields and grouped under the same product Handle as variant rows.

Should I review the CSV before importing?

Yes. Supplier data often needs human review for titles, pricing, product type, and image quality before it goes live.

Related tools

Continue with the closest Shopify CSV task.