Organizing a Shopify Catalogue and Storefront

The Client

The client is a performance parts retailer with a growing Shopify catalog. Like a lot of stores that scale quickly, the backend had outpaced the cleanup. Products were duplicated, pricing was inconsistent, inventory didn't match what was on the shelf, and the storefront had become hard to work through for both customers and staff.

The goal was to get the store accurate, organized and easy to shop, without taking it offline.

The Challenge

When I stepped in, the main issues were:

• ●Hundreds of duplicate products across the catalog, often with slightly different titles or SKUs
• ●Pricing and inventory that no longer matched the client's source-of-truth sheets
• ●No reliable way for customers to browse by category or fitment
• ●Dozens of products missing images, which looked unprofessional on collection pages
• ●Theme code that had been patched over time and needed tightening up

The work touched nearly every part of the store, which meant coordination was just as important as the technical fixes.

The Approach

1. Product cleanup and deduplication

The first pass was identifying and merging duplicate products. I worked from the client's master product data, cross-referenced against the live store, and cleaned up the catalog in batches so nothing got lost in the shuffle.

2. CSV-based pricing and inventory updates

Rather than touching products one at a time in the Shopify admin, I moved everything through CSV imports. That meant pricing and inventory changes could be reviewed, approved, and applied in bulk, with a paper trail. It was quicker to review and easier to check than editing products one at a time.

3. Automated collections across 9 categories

I set up automated collections with conditions that pull products in based on tags and product type. The result: when a new product is added with the right tags, it lands in the right category on its own. Nine categories were rebuilt this way, which cut the manual work from then on.

4. Image sourcing and a logo placeholder

For products without images, I pulled assets from the client's Google Drive and matched them to SKUs. For anything still missing a photo, I added a clean branded placeholder so the collection pages stayed consistent while we waited on final photography.

5. Theme code edits

The theme needed targeted edits. I made changes across several liquid files to fix layout issues, clean up display logic, and make sure the storefront showed the newly organized catalog the way it should.

How the Project Ran

The project moved through a handful of people. The client's product lead handled product data and approvals, and the store owner set the direction. I took on everything else end-to-end, from the catalog cleanup and CSV workflows to the theme code edits, and managed the day-to-day with the client.

Keeping the communication tight was half the job. Every batch of changes got reviewed before going live, and nothing shipped without sign-off.

The Outcome

By the end of the engagement, the store had:

• ●A deduplicated, accurate catalog that matched the client's source data
• ●Pricing and inventory in sync with the back office
• ●Automated collections doing the sorting work instead of staff doing it manually
• ●A consistent look across collection pages, including placeholders where images were still pending
• ●A cleaner theme that was easier to maintain

Day-to-day upkeep moved from hand edits in the admin to reviewed batches.

What I Took Away From the Project

A few things worth naming from this project:

• ●Batch review through CSV fit this catalogue. With hundreds of duplicates and pricing that had to match the client's source sheets, moving changes through CSV meant each batch could be checked against the sheet and approved before it went live.
• ●Automated collections cut the ongoing sorting work. The conditions took some thought up front. After that, a new product with the right tags lands in the right collection without anyone moving it.
• ●Clean up the catalog before you touch the theme. Theme work on top of messy product data is wasted effort. Get the data right first.
• ●Client-facing coordination is part of the deliverable. Clear handoffs, version control on data, and batch approvals kept the project moving without drama.

If You're Thinking About a Similar Project

If your Shopify store has grown past what you can manage by hand and you're seeing duplicates, mismatched inventory, or messy collections, it's usually worth the cleanup before investing in marketing or new features.

Happy to chat if you're working through something similar.