Hello. How is it possible to assign the position of a product in the category on products import (related records). There is no field mapping configuration available.
I found this in the products schema:
public function beforeAssocCategory(&$values, $factory) { if (!isset($values['position'])) { $conn = $factory->getConnection(); $idCategory = (int)$values['id_category']; $sql = "select IFNULL(MAX(position), 0) + 1 from " . _DB_PREFIX_ . "category_product where id_category = $idCategory"; $position = (int)$conn->singleSelect($sql); $values['position'] = $position; } }
This resets the positions for the products in the categories, if position is not set. So I need to set it, otherwise the positions are wrong after importing products