TSConfig CSV Import Product
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Posts: 15
- Joined: 22 Feb 2016, 16:20
TSConfig CSV Import Product
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
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?
How does the data in the file looks like? Can you give us an example?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos,
give us a star
If you like Aimeos,
![Image](https://aimeos.org/fileadmin/aimeos.org/icons/star.png)
-
- Posts: 15
- Joined: 22 Feb 2016, 16:20
Re: TSConfig CSV Import Product
The Catalog categories are comma separated. Looks like:
sku;category_ids;
MAC205002;59,61,64,75;de;
sku;category_ids;
MAC205002;59,61,64,75;de;
Re: TSConfig CSV Import Product
That's OK, you only have to set a comma as separator:mueironshark wrote:The Catalog categories are comma separated
https://aimeos.org/docs/Configuration/C ... /separator
Before you import the products, create the categories and use the Magento category IDs as code.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos,
give us a star
If you like Aimeos,
![Image](https://aimeos.org/fileadmin/aimeos.org/icons/star.png)
-
- Posts: 15
- Joined: 22 Feb 2016, 16:20
Re: TSConfig CSV Import Product
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?
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
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.
Try an absolute URL instead because relative URLs depend on the directory the task is executed from.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos,
give us a star
If you like Aimeos,
![Image](https://aimeos.org/fileadmin/aimeos.org/icons/star.png)
-
- Posts: 15
- Joined: 22 Feb 2016, 16:20
Re: TSConfig CSV Import Product
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
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.
The import button in the "Product" tab is only for importing translated product texts, not the products itself.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos,
give us a star
If you like Aimeos,
![Image](https://aimeos.org/fileadmin/aimeos.org/icons/star.png)
-
- Posts: 15
- Joined: 22 Feb 2016, 16:20
Re: TSConfig CSV Import Product
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
You must rebuild the index (via the scheduler task) after product imports to update the frontend (maybe clear the frontend cache as well)
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos,
give us a star
If you like Aimeos,
![Image](https://aimeos.org/fileadmin/aimeos.org/icons/star.png)