eCommerce construction > Fresh Installation

Cannot Import categories

(1/1)

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

Basara:
Hello.
Try the example CSV file https://abantecart.atlassian.net/wiki/spaces/AD/pages/16777227/Import+Wizard#ImportWizard-Categoriesimportexample

Zakawyka:
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

Navigation

[0] Message Index

Go to full version
Powered by SMFPacks Social Login Mod