Page 1 of 2

TSConfig CSV Import Product

Posted: 02 Mar 2016, 10:10
by mueironshark
I have an csv file from an magento system. Now are there items that belongs to multiple/several catalog categories. How can i set this in the TSconfig for the csv import job?

Re: TSConfig CSV Import Product

Posted: 02 Mar 2016, 10:56
by aimeos
All categories have to be in one field and at best separated by a newline (that's configurable).
How does the data in the file looks like? Can you give us an example?

Re: TSConfig CSV Import Product

Posted: 02 Mar 2016, 11:02
by mueironshark
The Catalog categories are comma separated. Looks like:
sku;category_ids;
MAC205002;59,61,64,75;de;

Re: TSConfig CSV Import Product

Posted: 02 Mar 2016, 13:00
by aimeos
mueironshark wrote:The Catalog categories are comma separated
That's OK, you only have to set a comma as separator:
https://aimeos.org/docs/Configuration/C ... /separator

Before you import the products, create the categories and use the Magento category IDs as code.

Re: TSConfig CSV Import Product

Posted: 04 Mar 2016, 13:18
by mueironshark
If i start the import with the valid example csv, get successful message but there are no products imported. Here is the TsConfig:
plugin.tx_aimeos {
settings {
controller.jobs.product.import.csv {
location = fileadmin/import/
mapping {
item {
0 = product.code
1= product.label
2 = product.type
3 = product.status
}
text {
4= text.type
5 = text.content
6 = text.type
7 = text.content
}
price {
8 = price.value
}
}
}
}
}
What is wrong?

Re: TSConfig CSV Import Product

Posted: 04 Mar 2016, 13:23
by aimeos
Did you enter the configuration in the TSconfig field of the scheduler task?
Try an absolute URL instead because relative URLs depend on the directory the task is executed from.

Re: TSConfig CSV Import Product

Posted: 04 Mar 2016, 14:13
by mueironshark
Yes in the field of the scheduler task. And also with absolute path was nothing imported. Then i tried to import from the product tab import. The same result. Success message with see it in the overview and no products imported.

Re: TSConfig CSV Import Product

Posted: 04 Mar 2016, 14:28
by aimeos
Are there any messages in the logs ("Overview" tab or madmin_log table) regarding product import? There should be at least messages for the start and end of the import, and messages is lines couldn't be imported.

The import button in the "Product" tab is only for importing translated product texts, not the products itself.

Re: TSConfig CSV Import Product

Posted: 08 Mar 2016, 12:21
by mueironshark
The import works partly now. But what keys and values are needed in the csv file for products being active in the catalog categories / shown in frontend? When look into the categories after the import, they products are correct imported but not shown in fronted. By clicking each product and save it and save the category, these are shown.

Re: TSConfig CSV Import Product

Posted: 08 Mar 2016, 12:40
by aimeos
You must rebuild the index (via the scheduler task) after product imports to update the frontend (maybe clear the frontend cache as well)