Bulk Import a Whole Product Category to Shopify (Without CSV)

Why CSV imports fall over for category-page bulk loads

The default way to add lots of products to Shopify in one shot is the built-in CSV importer. It works — provided you already have a clean CSV that matches Shopify's schema. The reality, for most stores stocking a supplier or dropshipping category, is the opposite:

• You don't have a CSV. The supplier publishes a category page on their website, not a downloadable feed. The data you want is locked behind HTML.
• Shopify's schema is fiddly. Variant rows, image rows, option columns, exact handle rules — one missed column and the whole row imports broken or not at all.
• Images don't come for free. CSV gives Shopify URLs to fetch, but if the supplier hot-link-blocks or rate-limits, you get blank product pages and a hand-fix queue.
• Variants are the worst part. A category of 40 lamps, each with 3 finishes and 2 sizes, is 240 rows you have to keep in sync by hand.

That's the gap category imports fill. Give us the URL of the page you're looking at; products land in your Shopify store ready to publish.

How category imports work in Product Upload

Watch the flow

Here's the whole flow end-to-end, condensed into a 12-second loop. Same screens you'll see in the app.

What category pages are supported

The short answer: any supplier site with a product grid. There's no hardcoded list of integrations to maintain — if it loads in a normal browser tab, it almost always imports cleanly.

What transfers across — and what you should still review

Everything lands as a draft by default, so nothing goes live until you publish. You can flip that to "Active" in import settings if you trust the source enough to skip review.

Category import vs CSV vs one-by-one

Tips for a clean import

• Pre-set your price multiplier and default collection. Both apply to every product in the batch — change them once before you click import, not per-product after.
• Use the URL of the deepest category that fits. The category "Lighting" might be 800 SKUs. The sub-category "Brass desk lamps" is 24. Smaller, more relevant batches are faster to triage and easier to merchandise.
• Turn on AI rewrite if you're importing dropship content. Supplier descriptions are often a wall of stock phrases that Google has seen on a thousand other stores. AI rewrite gives each product its own copy without you typing it.
• Deselect during the triage step, not after. Every selected product spends a search credit. Cull before you import.

Limits and gotchas

• Category imports cost one search credit per product — same rate as a single-URL import. A 60-product category drains 60 credits.
• The triage screen tells you the count. Big categories that span many pages mostly come through whole; some JavaScript-heavy listings expose less. Either way you'll see the total before you commit credits.
• Variant detection isn't perfect on every supplier. Brand-new or unusual sites sometimes hide variants behind a click. For those, the single-product import path tends to do a better job than the category-grid path.
• You're responsible for the rights to import. Brand-name and trademarked goods will get your store shut down on Shopify whether you imported them via CSV or via category URL — the import method doesn't change the rules.