CSV IMPORT

[domizzo]

When I export the product fields after creating a couple of sample products the result is the  maximum number of columns in excel (256 in the older version I am using) all filled with column headings; mostly options, etc.  I am wondering if just the product headings in the import/export section of the manual are the ones that I need and if so, can I just include them in my csv file to import or are some of the 256 headings required?(I'm using the latest version Abantecart 1.2.2

[abolabo]

You talking about custom selection of columns.
AbanteCart do export based on it's own table model that do not support customize.
Try to use some other app to view and edit csv-files. CSV is not main excel file format.

[llegrand]

Sounds like your Excel is pretty out of date 

Try one of these FREE alternatives  -  even though I have the latest MS Office programs,  I often prefer using Libre Office for export and import my db files as there is less Microsoft "extras" to strip out.


https://www.libreoffice.org/download/libreoffice-fresh/

http://www.openoffice.us.com/

[domizzo]

i can modify, delete column headings in excel but are you saying that all 256 of those unique column headings are required?

[Basara]

i can modify, delete column headings in excel but are you saying that all 256 of those unique column headings are required?

Hello. Not all columns are required. In case you dont need tags, options....etc you can remove some of them see few examples http://www.abantecart.com/ecommerce-documentation/admin-user-manual/system/data#Example%202:%20insert

[domizzo]

the reason i am asking is to avoid the number
of rows exceeded error msge

[Basara]

the reason i am asking is to avoid the number
of rows exceeded error msge

I am using OpenOffice without any issues. It is free 

[domizzo]

I have the latest version of Open Office.  It also gave me the same error message.  Finally, I used a dedicated csv program and that solved the problem. So other than what the manual shows which is which columns need to be included if you are inserting new or updated products it's safe to not include all of the other columns abantecart generates on export?  Thanks for all your help by the way.

[Basara]

Finally, I used a dedicated csv program and that solved the problem.

Can you please share "dedicated csv program" name?  This will help to others 

[domizzo]

oh ok, I didn't want you to think i was promoting any particular program.  It's a free program called, " Ron's Editor".  It's completely dedicated to csv files.  The free version does a lot and will do everything we need to do here.

[Internet Sales]

Thank you Domizzo and Especially you BASARA!!