1. Marcel
  2. RO CSVI
  3. Wednesday, 03 July 2019
  4.  Subscribe via email
Hi Tharuna
when we import a new XML file with the template you created for us, everything works fine. The products in the file are imported in the category as defined in the Importfile. We changed the sort-order of the products in VM so we can determine which suit is shown first in the category view. After the new import that custom order stays the same. The setting we use for append categories is "yes" so it's does not need to set the category again but only add new ones. We did some changes in the import file because sometimes we want to add multiple categories or change the category of a product. To make that possible, we needed to change the setting append categories to "no", that means the category is set again during import, even if the category stays the same. Is there a way to keep the same sort order setting after a new import where we set append categories to "no"?

Thanks, kind regards, Marcel
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Marcel,

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

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
For exporting ordering of products you need to use pordering field in export. Did you use that?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
No

This;
product_sku;product_ordering
111200278;44

And that's good I think because I compared the value in VM backend and the number in the CSV.
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
This is with the pordering

product_sku;product_ordering;pordering
111200278;44;0
25000303;51;0
25000305;17;0
25000306;16;0
25000307;15;0

The value is "0" for that field.
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,
Ok, pordering field is for ordering of child products for a parent product and can be seen in virtuemart_products table. product_ordering gets the ordering of a product in a category which is from virtuemart_product_categories.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Thanks Tharuna!
I exported and that file seems ok. Then I imported it (on a different domain (server13) but it does not change the custom order
Can you take a look?

Marcel
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Marcel,
Are you looking at importing custom fields ordering or product ordering? They are two different things and seems like there is a confusion with the ordering you are doing.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Tharuna!
I was busy but now I need to solve this. To make things very clear, I created a jpg. Please check if it's clear like this
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Found it....
I needed to export and import category ID...
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
You must like it very very very much!
:D
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello Marcel,
Glad to know that you found it.:D
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Marcel,

Actually I did not like it so much ;) The system got stuck in a loop :D All should be cleared out now.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Great!
But now the final thing is this;

In the export file, there is this;
product_sku;product_ordering;category_id
111200077;5;1|14

But it should be:
product_sku;product_ordering;category_id
111200077;5|2;1|14

so, in cat. ID 1, the ordering is 5
and in cat ID 14 the ordering is 2

How can I get ordering "2" for cat ID 14 in the export?
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello Marcel,
product_ordering should work for your values 5|2 because we do support multiple values for product_ordering field. Is it not working for you?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
Hello Marcel,
Apologies, i was talking about import in my previous reply. I see you have issue with export. We do not have multiple values support in export. Will look into it and get back with an update.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!