Why am I getting a CSV file error when importing products to my online store?

Hey there - I am attempting to import products from inventory and ecomm from lightspeed to shopify. I am using the shopify templates. When I attempt to load the 2 csv files (ecomm products and inventory products) using the store importer I get an error message on the ecomm csv file that says “not a recognize file”. It recognizes the csv file for inventory though.

I thought importing directly into products (instead of Store Importer) might be a work around But I get this error message (I am using the template):

There was an error importing your CSV file. After you fix the error, try importing the CSV file again.

  • Option value provided for unknown options

I looked at all products with options and they all have a value.

What am I missing?

Thanks!

Handle

Title

Body

Vendor

Type

Tags

Published

Option 1 Name

Option1 Value

Option2 Name

Option2 Value

Variant SKU

Variant Grams

sailors-promise-ring

Sailor’s Promise Ring

The Sailor’s Promise Ring, a promise between two friends to always return to each other after life’s wildest storms. This anchor of friendship always holds true.

Kiel James Patrick

Rings

nautical, jewelry, anchor

TRUE

Color

Gold

Size

5

american-sailor-bracelet

American Sailor Bracelet

Lanyard Hitch Collection bracelets are carefully handcrafted in Rhode Island from locally twisted nautical cord in a variety of classic New England colors. Solid brass hardware surrounds a cotton nautical cord, creating the perfect accessory.

Kiel James Patrick

Bracelets

nautical, jewelry, anchor

TRUE

Size

S

american-sailor-bracelet

American Sailor Bracelet

Lanyard Hitch Collection bracelets are carefully handcrafted in Rhode Island from locally twisted nautical cord in a variety of classic New England colors. Solid brass hardware surrounds a cotton nautical cord, creating the perfect accessory.

Kiel James Patrick

Bracelets

nautical, jewelry, anchor

TRUE

Size

XS

pearl-sailor-bracelet

Pearl Sailor Bracelet

Add an extra layer of glamour to your wrist with our new pearl and chain bracelets. Perfect for layering. Can be worn as a short necklace.

Product Details:

  • Hamilton gold coated chain individually soldered
  • Alternating 10 & 8mm glass pearls
  • Champagne ribbon endÂ
  • Anchor length is 1.25" (3.17cm)
  • Anchor width from widest point 0.75" (1.90cm)
  • Made in America

Kiel James Patrick

Bracelets

nautical, jewelry, anchor

TRUE

Size

S

cape-knot-hitch

Cape Knot Hitch

Carefully hand­-knotted in Rhode Island from locally twisted nautical cord in a variety of classic New England colors.

Kiel James Patrick

Bracelets

nautical, jewelry, anchor

TRUE

Size

XS

oysters-rockefeller-ring

Oysters Rockefeller Ring

The pearls on this elegant ring sit in open scallop shells attached by a band featuring a natural rope motif, the fibers of which are carefully preserved through the polishing process, resulting in a truly unique ring.

Kiel James Patrick

Rings

nautical, jewelry, anchor

TRUE

Color

Gold

Size

5

oysters-rockefeller-ring

Oysters Rockefeller Ring

The pearls on this elegant ring sit in open scallop shells attached by a band featuring a natural rope motif, the fibers of which are carefully preserved through the polishing process, resulting in a truly unique ring.

Kiel James Patrick

Rings

nautical, jewelry, anchor

TRUE

Color

Gold

Size

7

oysters-rockefeller-ring

Oysters Rockefeller Ring

The pearls on this elegant ring sit in open scallop shells attached by a band featuring a natural rope motif, the fibers of which are carefully preserved through the polishing process, resulting in a truly unique ring.

Kiel James Patrick

Rings

nautical, jewelry, anchor

TRUE

Color

Silver

Size

6

sailor-forever-knot-ring

Sailor Forever Knot Ring

The Sailor’s forever knot ring, a promise between two friends to always return to each other after life’s wildest storms. This anchor of friendship always holds true.

Kiel James Patrick

Rings

nautical, jewelry, anchor

TRUE

Color

Silver

Size

6

dawn-treader-bracelet

Dawn Treader Bracelet

The Dawn Treader bracelet is inspired by misty mornings out on the water in the middle of summer. It goes great with just about anything, and the classic gold, blue and white color scheme works as well on the beach as it does at a fancy restaurant.

Kiel James Patrick

Bracelets

nautical, jewelry, anchor

TRUE

Size

M

dawn-treader-bracelet

Dawn Treader Bracelet

The Dawn Treader bracelet is inspired by misty mornings out on the water in the middle of summer. It goes great with just about anything, and the classic gold, blue and white color scheme works as well on the beach as it does at a fancy restaurant.

Kiel James Patrick

Bracelets

nautical, jewelry, anchor

TRUE

Size

XS

drop-the-anchor-bracelet

Drop the Anchor Bracelet

An homage to the 80's classic, the slap bracelet is like a remastered version of your favorite VHS. The hand stitched needlepoint band is sleeker than the original, but the slap is just as satisfying. Leather lined, hand stitched needlepoint.

Kiel James Patrick

Bracelets

nautical, jewelry, anchor

TRUE

Size

O/S

surf-dust

Surf Dust for the Bath

Your favorite bath bombs are now available in an easy to use multiple use jar! Just sprinkle as much as you like into your bath and let the relaxation begin!

  • Available in a Large 16oz or Medium 8oz Jar
  • Made with high grade coconut oil and FDA approved bath bomb powder color.

Surfs Up

Bath Bomb

TRUE

Scent

Coconut Lime

Size

Large

surf-dust

Surf Dust for the Bath

Your favorite bath bombs are now available in an easy to use multiple use jar! Just sprinkle as much as you like into your bath and let the relaxation begin!

  • Available in a Large 16oz or Medium 8oz Jar
  • Made with high grade coconut oil and FDA approved bath bomb powder color.

Surfs Up

Bath Bomb

TRUE

Scent

Ocean Breeze

Size

Large

@OffMainGifts

Adding values to Option 1 Name for variants is likely causing the error. For example, you have “Size” in both “Option 1 Name” columns for “american-sailor-bracelet.” A value for Option 1 Name only needs to appear once per product. The same rule applies for Option 2 & 3 Name columns. More information on product CSV files can be found here.

If that doesn’t solve your error, then please provide the CSV file so I can take a closer look.