Shopify products
Shopify product upload
Adding products to Shopify looks simple until there are hundreds of them. A spreadsheet that groups variants wrongly, an image link that no longer works or a changed option name can create duplicates, delete variants or fail the import entirely.
We upload products by manual entry or CSV import, depending on the catalogue, and check the result product by product before it reaches customers.
Illustrative diagram
- Header row — Shopify's column names
- URL handle — groups rows into one product
- Option values — up to three options
- Price and SKU — per variant
- Flagged cell — missing or inconsistent data
- Image URL — publicly reachable link
- Test batch — a few complex products first
- Import — overwrite setting chosen deliberately
Manual entry or CSV import
Manual entry in the admin
Suits you when
- A few dozen products or fewer
- Each product has unique descriptions and images
- Products are added gradually
Watch out for
- Slow for large catalogues
- Easy to be inconsistent with naming
CSV import
Suits you when
- Many products or variants
- Data already exists in a spreadsheet or another system
- Bulk updates later
Watch out for
- The file format is strict
- Mistakes apply to many products at once
How a product CSV is structured
Shopify groups rows in a product CSV by URL handle. The first row for a product holds its full details; following rows with the same handle add variants or images. A product can have up to three options, such as size, colour and material, and each variant row fills in its option values, price and SKU.
For a new product, the title is the only required column, but once variants are involved the handle is also required. Images are added by public URL, one image per row with the same handle. The file must be saved as UTF-8 with comma-separated columns, which is worth checking when spreadsheets are exported from desktop software.
Import settings that can change existing products
| Situation | What happens | How we handle it |
|---|---|---|
| Overwrite products with matching handles is selected | Blank non-required cells clear existing values | Only include columns we intend to change |
| Option values are changed in the file | Existing variant IDs are deleted and new ones created | Avoid renaming options on live products with app dependencies |
| Variant columns present without option columns | A default variant may be created and existing ones removed | Keep option name and value columns together |
| Image URLs are not publicly reachable | The import can fail | Host images somewhere accessible before importing |
Based on Shopify's documentation for CSV imports. We test every import on a small batch first.
How we upload a catalogue
Inspect the data
Review your spreadsheet or export for missing prices, inconsistent option names and duplicate SKUs.
Output: Data issues list
Prepare the file
Map your columns to Shopify's template, group variants by handle and confirm image links.
Output: Import-ready CSV
Test import
Import a handful of products, including the most complex, and check them in the admin and on the store.
Output: Verified sample
Full import
Import the remaining products, then review counts, variants and images against the source.
Output: Reconciled catalogue
Checks after an import
Numbers
- Product count matches the source file
- Variant count per product is as expected
- No accidental duplicate products with similar handles
On the store
- Variant pickers show options in a sensible order
- Images appear on the right variants
- Prices and compare-at prices display correctly
- Products appear in the intended collections
Naming rules that keep a catalogue tidy
Imports magnify inconsistency. If one product uses "Navy" and another "Navy Blue", filters show two colours and shoppers see an untidy list. Agreeing naming rules before the import avoids hours of corrections afterwards.
We agree a title pattern, the exact spelling of every option value, the order of sizes, and the tags that drive collections. These rules are written down with the import file, so anyone adding products later, including you, can follow the same pattern.
Questions about Shopify product upload
Can products be imported from another platform's export?
Usually, after the export is reshaped to Shopify's column format. Option structures often need adjusting because platforms model variants differently.
How many images can each product have?
Shopify's CSV documentation states up to 250 images per product. In practice a smaller, consistent set works better for shoppers.
Will importing create duplicate products?
It can if handles differ slightly from existing products. We match handles carefully and check for near-duplicates after importing.
Can stock levels be imported too?
Yes for stores with a single location, according to Shopify's documentation. Stores with several locations need inventory handled separately.
Do you write product descriptions during upload?
Upload uses the descriptions you provide. Writing or rewriting descriptions can be added as separate work.
Can you add products to collections in the same import?
A Collection column can be included in the import file. We usually set up collections first so products land in the right place.
Sources referenced
Platform features, guidance and rules change. We check the current versions before committing to an approach. This page is general information, not legal advice.
- Shopify Help Center: Using CSV files to import and export products (opens in a new tab) — reviewed 2026-10-22
Request a Custom Quote
Ask about Shopify product upload
Thank you — your enquiry has been sent.
We have received your message and will reply by email. If you need to add anything, email info@letgetgrow.com.