Freelancer's Guide to Setting Up Product Catalogs for Clients

If you set up Shopify stores, build WooCommerce sites, or help small businesses get online, the product catalog is always the bottleneck. Your client hands you a messy spreadsheet, a folder of photos, and says "put these online." The design is done in a day. The catalog takes a week.

This guide is about making that catalog work faster and more profitable.

The catalog bottleneck

Here's what "set up my product catalog" actually involves:

  • Cleaning the client's spreadsheet (inconsistent formatting, missing fields, duplicate entries)
  • Writing product descriptions (the client almost never has them)
  • Formatting data for the specific platform (Shopify, WooCommerce, BigCommerce, etc.)
  • Creating SEO titles and meta descriptions
  • Matching and uploading product images
  • Setting up variants, categories, and tags
  • Importing and QA-checking every product

For 50 products, this takes 8-15 hours. For 200 products, it takes 30-50 hours. Most freelancers underprice this work because they don't realize how long it takes until they're in the middle of it.

Pricing the catalog setup

Most freelancers charge catalog setup as part of a store build package and eat the hours. This is a mistake. The catalog is a separate deliverable and should be priced separately.

Fair pricing for catalog setup:

  • Under 25 products: $200-$500 flat fee
  • 25-100 products: $500-$1,500 or $5-10/product
  • 100-500 products: $1,500-$3,000 or $3-5/product
  • 500+ products: Custom quote, typically $2-3/product

These prices assume you're writing descriptions, formatting for the platform, and doing basic SEO. If the client provides descriptions and clean data, you can charge less. If they hand you a shoebox of receipts, charge more.

Building a repeatable process

The freelancers who make money on catalog work have a system:

  1. Intake template — Send the client a spreadsheet template with exactly the columns you need. Don't accept "whatever they have" without seeing it first.
  2. Data cleaning checklist — Standard steps: remove duplicates, normalize prices, standardize categories, trim whitespace, check for empty required fields.
  3. Description generation — Either batch-write using AI tools or use templates per category. Don't write each one from scratch.
  4. Platform formatting — Use a tool that exports the right CSV format. Don't manually map columns.
  5. QA checklist — After import: check 5 random products, verify images match, confirm variants work, test search.

Using Catalogd in your workflow

Catalogd handles steps 2-4 of that workflow. Upload your client's spreadsheet (messy or clean), and Catalogd cleans the data, writes descriptions in the client's brand voice, generates SEO content, and exports a platform-ready CSV. The client never sees the tool — they just see a finished catalog.

At $49-$149 per run, it pays for itself if it saves you more than an hour. For most catalog jobs, it saves 5-10 hours.

Learn more about Catalogd for freelancers, or try it free with 5 products.