Magmi overwriting position of products in category

Question

I'm using Magmi to import products into my Magento store. Categories are created on the fly and products are imported. All is working well.

Except for one thing: each time I run a Magmi import, the position of the product in the Magento category is set to 0. This way I cannot sort my products on position.

I have searched the Magmi wiki and github for someone who has run into the same problem, but didn't find anything.

Anyone familiar with this issue and is there a way to avoid it?

This is a bit tricky. the format allows to set position of item in category using ::position syntax. i may differentiate behaviours if not set & product is existing vs not set & new product (which would force 0). thx for reporting. — dweeves, Nov 27 '14 at 17:34
A bit more explanation is in place. I'm importing the same products, in the same category. So they are existing. I have also filled in the position before the import to for example 1,2,3, etc. After importing, the position is reset to 0. — Patrick Steenks, Nov 27 '14 at 20:40
that's what i was saying. for magmi no position = position 0.so when performing an update, it overwrites the position. i should add a differential test or to have a quick fix, use positioning syntax in your import file. — dweeves, Nov 28 '14 at 00:41
Ok, cool. Only problem is: we import the products from an external source, where the position is not stored. We add the position in Magento only. So we can not add the position in the csv file, as we don't know it there yet. — Patrick Steenks, Nov 28 '14 at 08:44
You are the best. Any idea when this code update would be available? — Patrick Steenks, Dec 17 '14 at 11:16
Hi Dweeves, you where saying to use the position syntax, but how does that one look like if you not want to create new categories, but put it in existing categories. which field would you ad to your csv file? — Coen, Feb 19 '15 at 12:49

AlexVegas Brander · Answer 1 · 2015-04-27T14:34:35.397

I wait too long an answer and do it myself, here is a fix:

my fix works other way - category positions clear only if you add $item["category_reset"] == 1; param to product params.

:1280 sting(in current magmi version) or find the public function assignCategories($pid, $item) in magmi_productimportengine.php. ater

$cce = $this->tablename("catalog_category_entity");

$ccpt = $this->tablename("catalog_category_product");

add next code:

  $sql = "SELECT $ccpt.*
            FROM $ccpt
            JOIN $cce ON $cce.entity_id=$ccpt.category_id
            WHERE product_id=?";
  $currentPositions = $this->selectAll($sql,$pid);

then change category reset:

 if (!isset($item["category_reset"]) || $item["category_reset"] == 1)
{...}

to

    if (isset($item["category_reset"]) && $item["category_reset"] == 1)
    {
        $sql = "DELETE $ccpt.*
        FROM $ccpt
        JOIN $cce ON $cce.entity_id=$ccpt.category_id
        WHERE product_id=?";
        $this->delete($sql, $pid);
        $currentPositions = array();
    }

after this change block with positioning

foreach ($catids as $catdef)
        {...}

to:

    // find positive category assignments

    if (is_array($currentPositions) && count($currentPositions)) {
        foreach ($currentPositions as $currentPosition) {
            $catPos[$currentPosition['category_id']] = $currentPosition['position'];
        }
    }

    foreach ($catids as $catdef)
    {
        $a = explode("::", $catdef);
        $catid = $a[0];
        if (count($a) > 1 && $a[1] != 0) {
            $catpos = $a[1];
        }
        else {
            if (isset($catPos[$catid]) && $catPos[$catid] != 0) {
                $catpos = $catPos[$catid];
            }
            else {
                $catpos = "0";
            }
        }
        $rel = getRelative($catid);
        if ($rel == "-")
        {
            $ddata[] = $catid;
        }
        else
        {
            $cdata[$catid] = $catpos;
        }
    }

if you dont import position, your current position will save. If it 0, it stay 0.

for clear actual position - add param to product item:

$item["category_reset"] == 1;

or change string back:

if ($item["category_reset"] == 1)
        { ....}

to:

 if (!isset($item["category_reset"]) || $item["category_reset"] == 1)
{...}

score 1 · Answer 2 · answered Jun 10 '16 at 16:42

Only a comment but since I'm a long-time reader but never setup an account and can't leave a comment directly with no rep. I know this is an old post, but I just found it and used AlexVegas's code above (thank you!). Worked almost fine for me, but in my case I still wanted the categories to fully reset to only what was in my Magmi import but I wanted the positions to remain intact. As-is above, the categories only append to the existing unless you use the category_reset column in your import, and if you do that it also resets the position.

If you're like me and want only the position to remain intact, but allow Magmi to overwrite the categories each time, use Alex's code above but tweak it a little

Where he says to change

if (!isset($item["category_reset"]) || $item["category_reset"] == 1) {...}

to

if (isset($item["category_reset"]) && $item["category_reset"] == 1)
{
    $sql = "DELETE $ccpt.*
    FROM $ccpt
    JOIN $cce ON $cce.entity_id=$ccpt.category_id
    WHERE product_id=?";
    $this->delete($sql, $pid);
    $currentPositions = array();
}

Don't change it. It's that simple. In his code it prevents the category reset unless the column is specified, which is why the if statement gets changed. If the column exists, it also wipes out the currentPositions array that stores the current positions within the categories so those get reset as well.

If you want to append to the categories unless category_reset is in your import, but don't want to overwrite the positioning, use Alex's code as it is above in his answer but leave out

$currentPositions = array();

That way it won't overwrite the array that is storing the positions within the categories

score 0 · Answer 3 · answered Jul 02 '15 at 16:59

0

Not an actual solution-

You can try using this plugin

http://www.magentocommerce.com/magento-connect/c3-category-position-import-export-extension.html/

answered Jul 02 '15 at 16:59

lost_in_magento

703
8
22

score 0 · Answer 4 · answered Feb 19 '18 at 16:07

You can ignore UPDATE position if exist

category creator/importer v0.2.5 at line 1248 replace with

  if (count($inserts) > 0) {
     $sql = "INSERT IGNORE INTO $ccpt (`category_id`,`product_id`,`position`) VALUES ";
     $sql .= implode(",", $inserts);
     // $sql .= " ON DUPLICATE KEY IGNORE";
     $this->insert($sql, $data);
     unset($data);
   }

score -1 · Answer 5 · answered Apr 27 '15 at 23:10

-1

The Magmi wiki specifically mentions item positioning functionality here See quoted text below. This seems to describe exactly the functionality you are looking for? I have not tested it myself.

Quote:

Item positioning

From magmi 0.7.18 , category_ids column has been enhanced with item positioning. This feature is also supported in category importer from version 0.2+ (since category importer plugin is roughly a category_ids generator)

Sample

store,sku,....,categories
admin,00001,.....,cat name with \/ in the name and positioning::3

<= here we "escaped" the tree separator with a backslash , the category will be created as "catname with / in the name and positioning"

sku 00001 will be set with position 3 in the category

End quote

answered Apr 27 '15 at 23:10

Jack Rambling

69
5

Yes, but you did not read the question correctly. There is no way for me to import the file with the correct positions. So I was looking for a way Magmi would not store the default positions. AlexVegas's answer helped in this. – Patrick Steenks Apr 28 '15 at 08:27
@Patrick Steenks, your are right, I missed comments above: " we import the products from an external source, where the position is not stored." So you are importing products with categories, and these products already exist in Magento with item position in the category? You say "I have also filled in the position before the import to for example 1,2,3, etc." Do you mean filled in in Magento, or filled in in Magmi file? If filled in in Magento, could you add the product positions that already exist in Magento to Magmi csv, then import? So it overwrites position with same number, instead of 0? – Jack Rambling Apr 28 '15 at 17:17

Magmi overwriting position of products in category

5 Answers5