Resolved Sorting problem of children products and Boolean custom fields created with CSVI

Hello,
You need to use pordering field in your product import and set the order of your child products. From your screenshot it shows that ordering for child product are all set to 0 and so they appear different from what they are imported. For custom fields you need to use custom_ordering field. Please check product import with custom fields document and in the section ORDERING CUSTOM FIELDS to know on how to use custom_ordering field.

I need some help to understand how to order children products listed by the parent product through a custom field type "Variant Generic Son."

The attempt has given a completely wrong result (see ordering_image-02)!

These are the fields to be used that you have shown to me:

product_sku
custom_title
custom_value
custom_ordering

The example you've shown me

"Product_sku"; "custom_title"; "custom_value"; "custom_ordering"
"P01"; "Size ~ Color ~ Width"; "Green ~ 34 ~ 38"; "2 ~ 1 ~ 3"

in my opinion, it is more suitable to the field to manage the ordering of product variants and not of children products.

This is my requirement, I think it can also be very common to other users:

1 - Product A is the father of n-B products
2 - Product A has a custom field type "Variant Generic Son" to list the children in the cart so you can select
3 - the need is to order the publishing position in the list with the same order of the import data! (See image)

This is the data that I have entered in any field:

product_sku: his father's Product SKU A
custom_title: the name of the custom field already present in the parent product A
custom_value: the name of the child product B
custom_ordering: the gradual unique number starting with 1

product_sku custom_title custom_value custom_ordering
BOX-TO-M-001 Installation P0000001 1
BOX-TO-M-001 Installation P0000002 2
BOX-TO-M-001 Installation P0000003 3
BOX-TO-M-001 Installation P0000004 4


This approach is totally wrong! I say politely following my example, what should I match every field? (ordering-father-son images)

Thank you

Hello,
Actually the products are imported first before adding them to list as "Variant Generic Son". So first your product should be ordered when you do your product import. You need to use pordering field to do this as i mentioned in my previous post. custom_ordering field is to order the custom fields and it has nothing to do with products. I have given an example below on how to use pordering field

product_sku product_parent_sku pordering
productA 0
productA1 productA 1
productA2 productA 2
productA3 productA 3

Hope it is clear now.

Hello,

I understand that for you all is clear, but unfortunately for me it is the first time, even if it starts after two months of study to get myself a bit of experience!

The reason of my study was determined by the fact that, as mentioned, your example was not specifically created for my problem, so too many doubts left me!

Now it looks much clearer:

product_sku | product_parent_sku | pordering
productA | | 0
productA1 | productA | 1
productA2 | productA | 2
productA3 | productA | 3

Obviously:
1 - before the amount of data produced
2 - then I create the parent-child relationship by adding in the field pordering import file
3 - then they match the custom field to the father products

This should be the data structure that me advice! Correct?

Thanks again for your patience!

Hello,

product_sku | product_parent_sku | pordering
productA | | 0
productA1 | productA | 1
productA2 | productA | 2
productA3 | productA | 3

Obviously:
1 - before the amount of data produced
2 - then I create the parent-child relationship by adding in the field pordering import file
3 - then they match the custom field to the father products

pordering field will not create parent-child relation, it is a field to say in which order products should appear. product-child relation is created by product_sku and parent_product_sku fields. So the above example will do both of these in import, create parent child relation and set ordering of products. If you have any more fields to import you can add them to your import.

My advice would be to do
1. product import with above example so product-child relation is formed as well as ordering for child products is done
2. Add the custom field to the parent product.

ok, I will follow your advice, I will do new tests and will update you on the results.
Thank you