product order after import

  • Posts: 290
  • Thank you received: 22
1 year 8 months ago #343733

-- HikaShop version -- : 4.6.1
-- Joomla version -- : 4.1.5
-- PHP version -- : 8.0.21

Hi,

Just a quick question about sorting products in a categorie using the sort / order function.
This works good until we import the products again. Then all the order fields are back to zero again and the sorting is gone (so it appears).

Can you help me understand why this happens?
And is the sort order stored somewhere so we can also re-import the order?

Thanks,
Nico

Last edit: 1 year 8 months ago by nico.van.leeuwen. Reason: solved

Please Log in or Create an account to join the conversation.

  • Posts: 81515
  • Thank you received: 13068
  • MODERATOR
1 year 8 months ago #343740

Hi,

If you provide the "categories" column in your CSV, then the import will delete the links between the products and the categories and add back the new ones from the CSV at each import. In that case, it will set the ordering to 0 and so you'll loose the ordering.
If you also provide the "categories_ordering" column in your CSV, then you can provide the ordering you want for each category in the "categories" column.

So either you should not provide the "categories" column so that the import leave the links "as is". Or if you need to update the categories via the CSV, you want to provide the "categories_ordering" column if the order of the product in each category is important.

Please Log in or Create an account to join the conversation.

  • Posts: 290
  • Thank you received: 22
1 year 8 months ago #343746

Hi Nicolas,

Thanks for the explanation.
It means that in some cases we wil find a workaround then.
And for some we can use the extra column.

Nico

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum