TSConfig CSV Import Product

Questions around the TYPO3 integration and plugins
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!
mueironshark
Posts: 15
Joined: 22 Feb 2016, 16:20

TSConfig CSV Import Product

Post by mueironshark » 02 Mar 2016, 10:10

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?

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: TSConfig CSV Import Product

Post by aimeos » 02 Mar 2016, 10:56

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?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

mueironshark
Posts: 15
Joined: 22 Feb 2016, 16:20

Re: TSConfig CSV Import Product

Post by mueironshark » 02 Mar 2016, 11:02

The Catalog categories are comma separated. Looks like:
sku;category_ids;
MAC205002;59,61,64,75;de;

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: TSConfig CSV Import Product

Post by aimeos » 02 Mar 2016, 13:00

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.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

mueironshark
Posts: 15
Joined: 22 Feb 2016, 16:20

Re: TSConfig CSV Import Product

Post by mueironshark » 04 Mar 2016, 13:18

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?

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: TSConfig CSV Import Product

Post by aimeos » 04 Mar 2016, 13:23

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.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

mueironshark
Posts: 15
Joined: 22 Feb 2016, 16:20

Re: TSConfig CSV Import Product

Post by mueironshark » 04 Mar 2016, 14:13

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.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: TSConfig CSV Import Product

Post by aimeos » 04 Mar 2016, 14:28

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.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

mueironshark
Posts: 15
Joined: 22 Feb 2016, 16:20

Re: TSConfig CSV Import Product

Post by mueironshark » 08 Mar 2016, 12:21

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.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: TSConfig CSV Import Product

Post by aimeos » 08 Mar 2016, 12:40

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, Image give us a star

Post Reply