Product CSV Import - Error when update a 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!
Moritz
Advanced
Posts: 153
Joined: 07 Nov 2018, 14:05

Re: Product CSV Import - Error when update a product

Post by Moritz » 20 Jan 2023, 10:00

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?

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
        }
    }
}
What is the correct way now?
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

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

Re: Product CSV Import - Error when update a product

Post by aimeos » 20 Jan 2023, 10:21

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

Moritz
Advanced
Posts: 153
Joined: 07 Nov 2018, 14:05

Re: Product CSV Import - Error when update a product

Post by Moritz » 20 Jan 2023, 10:56

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

Post Reply