Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

Cannot Import categories

Started by Zakawyka, May 23, 2021, 03:45:05 PM

Previous topic - Next topic

Zakawyka

I just installed 1.3.0
I removed sample categories, created few new ones and exported those as csv. Fields received are:
categories.category_id
categories.parent_id
categories.sort_order
categories.status
categories.date_added
categories.date_modified
category_descriptions[0].category_id
category_descriptions[0].language_id
category_descriptions[0].name
category_descriptions[0].meta_keywords
category_descriptions[0].meta_description
category_descriptions[0].description
categories_to_stores[0].category_id
categories_to_stores[0].store_id

I filled those fields and when I try to import i'm being switched to WISARD and some strange things happen: after selectin a delimiter and CATEGORIES I am asked to make a map, but something strange is wi th list of parameters offered: there is no category id there, there is no parent_id there,  etc. BTE, there are 3 lines in the file : titls and 2 new categories.
After Load Wizard say - not enough data fer TWELVE records.

and this is funny reply:

Task Failed
Import Process has been completed. 1027 row(s) processed. 4108 row(s) with errors.
For more details see log file categories_import_4.txt

What I am doing wrong? is anywhere there a Categories .csv template?

Kind regards


Zakawyka

#2
Thank you for the link. There is no documentation either how to create the file or how to use it so I assumed the folowing:
the first line contains partially names from the table [aboh_categories] with missing fields [category_id] and [parent_id], with underscore replaced by space in others.
Format of fields varies: the first two are numbers (no wrapper).
[Name] field is of text format, and the name itself includes all parents separated by comma (usually it is /, but anyway)
[meta ..] - text fields with wrapper
[seo url] and [image] format unknown as there is no wrapper but the field filled with text.
DID NOT WORK -  Screenshots are attached.
I added two fields from  table [aboh_categories] -> [category_id] and [parent_id] , changed the first line to
category id,parent id,status,sort order,name,description,meta keywords,meta description,seo url,image

The same result.

Please note that there are two unidentified symbols in front of STATUS.

Regards

Basara

It looks like your CSV editor broke something. Try OpenOffice

Forum Rules Code of conduct
AbanteCart.com 2010 -