Import products

Shopify Discussion
1

Hi everybody!

I need to know, why my import csv file don’t work. When I upload it it don’t show any problem and says “products import correctly” and then no product was uploaded. I tried everything, and when I upload other file with some problems, it works fine.

Thanks.

2

Hi @OnlyS ,

If your CSV file uploads successfully but no products appear, it could be due to one of the following reasons:

1. CSV Format Issues

  • Ensure that your CSV file is formatted correctly. Shopify has specific requirements for product imports:
  • Make sure all required fields (like Handle, Title, and Vendor) are filled out.
  • Check for extra spaces, special characters, or incorrect column headers in your CSV file.
  • Download a sample CSV from Shopify (Settings > Import > Download Sample CSV) and compare it with your file to ensure all columns are present and correctly named.

2. Product Visibility

  • After importing, check whether the products are set to visible:
  • Go to Products in your Shopify Admin.
  • Filter for products that might be set to “Draft” or “Hidden.”
  • Edit the product details and ensure they are set to “Active” and assigned to an appropriate sales channel.

3. Variant Issues

  • If your products have variants, ensure:
  • The Option1 Name column is filled for all rows with variants (e.g., “Size” or “Color”).
  • The first variant row must include all details for the product (e.g., Handle, Title, Body HTML, etc.).
  • Variant rows must share the same Handle value as the parent product.

4. Check for Data Limitations
Shopify limits the size and complexity of CSV files. Ensure your file isn’t exceeding those limits (e.g., no excessively long text or too many rows at once).
If your file contains hundreds or thousands of products, try importing a smaller batch first to identify if the issue is related to file size.

5. Encoding Issues
Ensure your CSV file is UTF-8 encoded. Non-UTF-8 files might upload without error but fail to display products.

Steps to Troubleshoot:

  • Re-download your file after making corrections.
  • Upload it again using the Products > Import option.
  • After the upload, check for draft or hidden products in your Admin.
  • If none of these steps resolve the issue, try sharing a small sample of your CSV (without sensitive data) for more specific help. Let us know how it goes!