Product CSV Import - Error when update a 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!
Re: Product CSV Import - Error when update a product
In the TSConfig field this setting is overridden. I think at that time I copied that from a template of the documentation. This has always worked with version 18.10.11. Maybe in the old version there was no UNIQUE on the table?
What is the correct way now?
Is it enough to add the catalog to the domain list?
Code: Select all
plugin.tx_aimeos.settings.controller.jobs.product.import.csv {
# File or directory where the content is stored which should be imported
location = /var/www/xxxxxxxxxxxx/import/product/csv
# Name of the backup for sucessfully imported files
backup = /var/www/xxxxxxxxxxxx/import/product/archive/%Y-%m-%d_%H%i%s
# List of item domain names that should be retrieved along with the product items
domains {
0 = attribute
1 = media
2 = price
3 = product
4 = product/property
5 = text
6 = customer
7 = customer/group
}
# Mapping
mapping {
item {
0 = product.code
1 = product.label
2 = product.type
3 = product.status
}
text {
4 = text.type
5 = text.content
6 = text.languageid
7 = text.status
8 = text.type
9 = text.content
10 = text.languageid
11 = text.status
}
media {
12 = media.url
}
price {
13 = price.currencyid
14 = price.quantity
15 = price.value
16 = price.taxrate
}
attribute {
17 = attribute.type
18 = attribute.code
19 = attribute.label
20 = product.lists.type
21 = attribute.type
22 = attribute.code
23 = attribute.label
24 = product.lists.type
25 = attribute.type
26 = attribute.code
27 = attribute.label
28 = product.lists.type
29 = attribute.type
30 = attribute.code
31 = attribute.label
32 = product.lists.type
}
catalog {
33 = catalog.code
34 = catalog.lists.type
}
stock {
35 = stock.stocklevel
}
cgroup {
36 = customer.group.code
37 = customer.code
}
}
}
Is it enough to add the catalog to the domain list?
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
Re: Product CSV Import - Error when update a product
Yes, add "catalog" and "supplier" to the domain list.
The change occurred in 2022.x because the categories and suppliers are linked via the mshop_product_list table since then. Before, they had been linked via the mshop_catalog_lists resp. mshop_supplier_list tables.
The change occurred in 2022.x because the categories and suppliers are linked via the mshop_product_list table since then. Before, they had been linked via the mshop_catalog_lists resp. mshop_supplier_list tables.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Product CSV Import - Error when update a product
That solves the problem. Thank you very much!
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3