Product CSV Import - Error when update a product

[Moritz]

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?

[aimeos]

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.

[Moritz]

That solves the problem. Thank you very much!