Shopify missing products from uploaded CSV

Topic summary

Bulk product upload via CSV resulted in some items missing from the Shopify store, despite the import completing with validation errors.

Reported errors (from Shopify’s email):

  • Lines 185–192 and 193–196: Title exceeds the 255-character limit.
  • Lines 1110–1117: Duplicate variant “Sampler (30 mL)” detected.

Observed behavior: Products tied to error lines (e.g., Strawberry Basil Olive Oil on lines 186–189) still appear, while products without reported errors (e.g., Meyer Lemon Olive Oil on lines 102–105) are missing.

Proposed explanation: Missing product entries may be malformed or in an invalid format. Suggested action: review the CSV rows for the missing items and, if needed, manually create them in Shopify Admin.

Follow-up: The original poster requested a review of the attached file, stating they couldn’t find any differences. The attachment is central to diagnosing the issue.

Status: Unresolved and ongoing. No concrete fix yet; awaiting file review or clearer guidance.

Key terms:

  • CSV: a bulk import file (comma-separated values) for product listings.
  • Variant: a specific product option (e.g., size/flavor) within a product.
  • Shopify Admin: the backend dashboard to manage products.
Summarized with AI on January 19. AI used: gpt-5.

I am uploading all my products and their variants to Shopify, but I see that some are missing.

I receive the following errors in the email Shopify sends after the upload:

  • Line 185-192: Validation failed: Title is too long (maximum is 255 characters)
  • Line 193-196: Validation failed: Title is too long (maximum is 255 characters)
  • Line 1110-1117: Validation failed: The variant ‘Sampler (30 mL)’ already exists.

The products at the lines that are erroring are displayed, but some other ones are missing. For instance, my Strawberry Basil Olive Oil is on lines 186-189, but it is displayed. In contrast, my best-selling Meyer Lemon Olive Oil on lines 102-105 cannot be found in my Shopify store. Can someone please help me fix this issue?

Hello @aspanner1 :waving_hand:

It happened because the missing product info is malformed or in an invalid format. I think you should check the missing ones and manually create them in Shopify Admin.

Could you look at the attached file and let me know how they are malformed
or invalid? I looked carefully and couldn’t find any difference. Thanks.