Categories
View Replies (27)

Resolved Product ordering after new import

  1. Marcel
    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
0
Responses (27)
Marcel
Marcel
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. # 21
tharuna
tharuna
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 22
Marcel
Marcel
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. # 23
Marcel
Marcel
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. # 24
tharuna
tharuna
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 25
Marcel
Marcel
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. # 26
tharuna
tharuna
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 27
  • Page :
  • 1
  • 2


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