dont know why but import file has stopped it was ok now its not can you help again here is what i get when i try all lines say the same?will attach a sample of the file


Line 1: Incorrect column count: Configuration: 13 fields :: File: 1 fields
Fields
1: category_path
2: product_availability
3: product_desc
4: product_full_image
5: product_name
6: product_price
7: product_publish
8: product_sku
9: manufacturer_id
10: manufacturer_name
11: product_weight
12: product_available_date
13: product_in_stock

I think you have problems in your csv file. Some of the fields are like: "abc","def" but some of others are like "abc",def
I think you need to fix " issue, I recommend you to use notepad++ software for editing your csv file.

sorry i must be thick done that now i get this
category_pathproduct_avilabilityproduct_descproduct_full_imageproduct_nameproduct_priceproduct_publishproduct_skuproduct_thumb_imageproduct_mpnmanufacturer_nameproduct_weightproduct_available_dateproduct_in_stock
FOUND_FIELD_DELIMITER:
FOUND_TEXT_ENCLOSURE:
Do they match your template settings?

will attach the new one as i am sure i am missing somthing

I checked your toy.csv file and syntax was wrong so I corrected titles syntax (first row in file) and I corrected syntax of first 4 products.
Your all products in that file should look like my corrected ones ok? So rest of the file needs some editing, I recommend you to use Notepad++ software while editing your toy.csv file!

In "joomla admin panel => Components => CSVI Virtuemart => import => then on Options tab, you will see:
Auto detect delimiters: NO
Field Delimiter is ,
Text Enclosure is "
Category separator is \ as default

These are OK for your file, but you need to create a "conversion template" to pair titles in your toy.csv with virtuemart product table.

It is a long work and there is no much explanation or video on this web site, I wish that component developer would put a video showing how to import your csv to virtuemart by creating an "example conversion template" step by step.
Check attachment.

well i redone the whole file but still get the same answer i must be missing something?


this is the version i am using
Name: CSVI
Version: 1.9.2

@colin136: Your first CSV file is fine. The use of text enclosures in your CSV file are only placed around fields that need it. That is why some fields have them and others not. The only thing I see is that the file is ISO-8859-1 instead of UTF-8, not a real problem if you don't use accented characters.
colin136 wrote: This usually means that the delimiters are not set or incorrect. So the CSV file can't be read correctly.

Your CSV file has a field called product_mpn, did you add this field into VM?

As G.S. pointed out, you need to set Auto detect delimiters to No and fill in the delimiters yourself. The category separator is a forward slash / as default, so that is fine too.

@G.S. I am not sure what you mean with a conversion template but I guess you mean the fields you add to a template?