Resolved Product ordering after new import

Hello,
For exporting ordering of products you need to use pordering field in export. Did you use that?

I was trying to make an export of the Products with custom ordering but I cannot get it to work. It does not need to be XML, CSV is fine.
Can tharuna help?

Hello Marcel,

The XML example will work as you have set the value correctly. Indeed, the Append categories should be No.

Hi Roland.
That's what I thought.

The thing is, changing the custom ordering is userfriendly in VM. Just drag them in the right order and it's done, it's very visible and easy to manage. The import file is generated without a custom order setting.

I guess a solution is to export the existing custom order settings to a csv, run the import with the apen categories to "no" and after the import is don we run the csv with the custom order setting. But how about this;

<sku>12345</sku>
<category>Trouwpakken|Trouwpak-aanbiedingen</category>
<custom_ordering>1|5</custom_ordering>

does that work?
In Trouwpakken, the custom order setting is "1";
In Trouwpak-aanbiedingen, the custom order setting is "5";

Right?

Hello Marcel,

To keep customer ordering in place you need to include the product_ordering field in your import file. The reason for that is that the ordering is not stored with the category itself but with the category reference. Since you are relinking the categories, CSVI is recreating the link between the category and the product.

By adding the product_ordering to your file you are sure to always have the correct setting. The import file is basically the truth.

When the Append Categories is Yes, the existing categories with their links to the products remain and stay untouched, that is why you don't lose the ordering with that setting.

Hope that clears things up.

Hi Tharuna, Thanks for your quick reply as always!
No, it's not clear at all.

The situation is like this (live)

We import the xml where the category is set. There is no custom ordering in the import file of any kind.
The products are imported in the right category, f.e. the category "trouwpakken"

We change the custom order in VM so we determine in which order products are shown in the category view.
When we run a new import, the custom ordering stay's untouched which is great.

the setting we use for append categories is "yes" in this template.

Now we want this;

<category>Trouwpakken|Trouwpak-aanbiedingen</category>
we run an import, the product was already in "trouwpakken" but now we also want to put it in "Trouwpak-aanbiedingen".
Without changing the setting for append categories (still "yes" it adds "Trouwpak-aanbiedingen" as an extra category, the "Trouwpakken" category stays the same.

That works, the custom ordering in the category "Trouwpakken" stays the same.

We want this;
we had this;
<category>Trouwpakken|Trouwpak-aanbiedingen</category>

but we want to change the category to:
<category>unpublished</category>

When we run the import again, the product appears in "Trouwpakken", "Trouwpak-aanbiedingen" AND "unpublished".
That makes sense because append categories is set to "yes"

We want to remove the previous "Trouwpakken" and "Trouwpak-aanbiedingen" and put it to a category "unpublished"
To make that work we had to change append categories to "no", we runned the import again and it was removed from "Trouwpakken" and "Trouwpak-aanbiedingen"

Great BUT....

we had this:
<category>Trouwpakken</category> (and created a custom ordering in VM)

we changed it to
<category>Trouwpakken|Trouwpak-aanbiedingen</category> (leaving the custom ordering untouched in VM)
with append categories to "no"

OH NO! our custom ordering is gone.

What now?

Hello Marcel,
CSVI will process the fields which are in import file despite of append categories settings. If you don't need to change custom ordering field then remove that field from import when append categories is set to No. Hope it is clear.