Resolved Problem with ordering custom fields on import

Hello,

In the Custom fields import and export tutorial it is written you can use the custom_ordering field. However, this is only possible if you use the custom_title and custom_value fields to import your fields.

Using the custom fields as an available field, there is no such option. Fields are imported in the order they are listed in your file.

yes in the file the order is correct...but on the product is not...

It isn't supposed to be correct because CSVI doesn't give it any order when saving. What you are looking for is a new feature.

Looking at it, one way to do it would be to take the ordering from the custom field itself. However this would add n extra queries to the import. Where n can be 1 or more depending on the number of custom fields you use. Let's say you have 5 custom fields and 100 records, this means 500 extra queries for that import.

The other way would be to re-use the existing custom_ordering field but you would need to know which value is for which field. The problem here is, you don't know in which order the custom fields are going to be processed. The ordering for the custom fields is limited to the groups but if you import multiple groups, the ordering no longer counts.

Need to think about this more, if you have any suggestions they are welcome. Once this is completed, it will be included in the next CSVI 6 release.

can you tell me more about the first sollution i dint get it :P

Thanks

can you tell me more about the first sollution

Sure

Let's say your custom field is called MyField. Now you import this field and you want to add ordering for this field. CSVI sends a request to the database asking for the ordering value. The value is returned and the field is stored with the ordering value. This is 1 request because you have 1 custom field. Now you have 5 custom fields, you get 5 requests. This is for 1 product. With 100 products, you get 5 *100 = 500 requests.

This is going to need some kind of caching, so it is not sending the same request every time, that will reduce the number of requests.

so i have to add to add next to each custom field the field custom_ordering with the ordering in the file?

Thanks for the help

so i have to add to add next to each custom field the field custom_ordering with the ordering in the file?

No, what you want in your current setup is not possible.

You will have to use the custom_title, custom_value, custom_param, custom_ordering fields if you need to use the ordering. These fields are explained in the tutorial I posted earlier.

ok thanks i get it

Hello,

It's been a long time coming but the changes are included in the upcoming CSVI 6.5.0 release that will respect the ordering and the group setting. Only requirement is that the fields in the import file are in the same order as they are in the group.