Resolved VM Related Products ordering

Hello,

It seems VM related products are being exported in a different order, as the one defined in the backend? Perhaps sorted by ascending product id or SKU?

Yes as of now related product is sorted based on product id.

We need to keep the ordering defined in the backend. We want to promote to our customers certain products first.

Is there something we missed?

Load the patch file so to export related_products field based on ordering field.

Thank you, I tried the patch and the related products seem to be exported in the desired order.

Now I am about to import them (on a dev site) to see it in action, and I have the following question...

Do I need to delete the previous related products from the database, before import?

My aim is to replace the previous related product entries, with the new ones (with the desired ordering), for the SKUs included in the CSV.

Thanks

[RO CSVi 7.19.1 (without the 2021 patch you sent us)]
I am getting this error:

Import file contains 1398 lines
No supported fields have been found in the import file

Template is set to the following:
Operation: Related Product
Use file for configuration: Yes
Fields: product_sku, related_products
(although we also tried with no pre-set fields)


CSV import file sample below:

"product_sku","related_products"

"Tr200002","Tr200004|Tr200005|Tr200036|Tr200026|Tr200058|Tr200003|Tr200007|Tr200021|Tr200670|Tr200679|Tr200376|Tr200546|Tr200550|Tr200676|Tr200824|Tr200862|Tr201027"

"Tr200003","Tr200002|Tr200576|Tr200573|Tr200376|Tr200510|Tr200004|Tr200005|Tr200006|Tr200007|Tr200032|Tr200013|Tr200009|Tr200017|Tr200670|Tr200679|Tr200703|Tr200770|Tr200568|Tr200673|Tr200738|Tr200546|Tr200548|Tr200824|Tr200862|Tr200976|Tr201021"

"Tr200004","Tr200003|Tr200526|Tr200408|Tr200252|Tr200131|Tr200240|Tr200002|Tr200032|Tr200036|Tr200619|Tr200616|Tr200680|Tr200738|Tr200881|Tr200962|Tr200974|Tr200773|Tr200893|Tr201104|Tr200111|Tr200538|Tr201013|Tr201036"

"Tr200005","Tr200003|Tr200576|Tr200510|Tr200562|Tr200021|Tr200376|Tr200013|Tr200403|Tr200002|Tr200004|Tr200032|Tr200036|Tr200738|Tr200568|Tr200045|Tr200073a|Tr200160|Tr200321|Tr200546|Tr200548|Tr201027"

"Tr200006","Tr200003|Tr200005|Tr200002|Tr200004|Tr200007|Tr200032|Tr200036|Tr200770|Tr200573|Tr200568|Tr200738|Tr200548|Tr200546"

"Tr200007","Tr200005|Tr201014|Tr200568|Tr200683|Tr200032|Tr200036|Tr200026|Tr200085|Tr200875|Tr200885|Tr200027|Tr200013|Tr200392"

"Tr200009","Tr200003|Tr200005|Tr200012|Tr200019|Tr200017|Tr200010|Tr200058|Tr200061|Tr200021|Tr200027|Tr200631|Tr200619|Tr200729"

"Tr200010","Tr200009|Tr200003|Tr200005|Tr200019|Tr200018|Tr200011|Tr200027|Tr200049"

"Tr200011","Tr200009|Tr200010|Tr200002|Tr200004|Tr200017|Tr200019|Tr200013|Tr200021|Tr200064"

"Tr200012","Tr200011|Tr200009|Tr200005|Tr200059|Tr200064|Tr200058|Tr200015|Tr200019|Tr200046"

"Tr200013","Tr200009|Tr200392|Tr200354|Tr200094|Tr200146|Tr200268|Tr200004|Tr200012|Tr200010|Tr200026|Tr200027|Tr200017|Tr200413|Tr200225"

"Tr200026","Tr200009|Tr200027|Tr200162|Tr200029|Tr200005|Tr200013|Tr201048"

"Tr200014","Tr200009|Tr200013|Tr200003|Tr200026|Tr200064|Tr200018"

"Tr200015","Tr200009|Tr200013|Tr200012|Tr200017|Tr200003|Tr200007"

"Tr200017","Tr200009|Tr200013|Tr200004|Tr200010|Tr200036"

"Tr200018","Tr200017|Tr200009|Tr200014|Tr200002|Tr200026|Tr200066|Tr200027|Tr200008|Tr200021"

"Tr200019","Tr200017|Tr200018|Tr200006|Tr200026|Tr200007|Tr200001"

"Tr200032","Tr200003|Tr200576|Tr200339|Tr200408|Tr200491|Tr200510|Tr200162|Tr200151|Tr200152|Tr200141|Tr200021|Tr200073a|Tr200031|Tr200718|Tr200873"

"Tr200036","Tr200376|Tr200679|Tr201167|Tr201161|Tr200021|Tr200032|Tr200670|Tr200824|Tr200576|Tr200162|Tr200562|Tr200510|Tr200273|Tr200003|Tr200026|Tr200678|Tr200862|Tr200965|Tr201027|Tr200925|Tr200894"

"Tr200028","Tr200162|Tr200351|Tr200026|Tr200003|Tr200073|Tr200105|Tr200104|Tr200238|Tr200278|Tr200266|Tr200464|Tr200115|Tr200234|Tr200181|Tr200013|Tr200859"

"Tr200058","Tr200884|Tr200063|Tr200145a|Tr200578|Tr200419|Tr200242|Tr200510|Tr200338|Tr200246|Tr200034|Tr200273|Tr200050|Tr200367|Tr200021|Tr200013|Tr200009|Tr200723|Tr200769|Tr200736|Tr200775|Tr200873|Tr200948"

"Tr200059","Tr200193|Tr200605|Tr200263|Tr201317|Tr200519|Tr200512|Tr200462|Tr200468|Tr200401|Tr200383|Tr200369|Tr200386|Tr200216|Tr200243|Tr200027|Tr200249|Tr200244|Tr200100|Tr200101|Tr200013|Tr200940|Tr200963"

"Tr200061","Tr201384|Tr200066|Tr201315|Tr200520|Tr200479|Tr200473|Tr200486|Tr200392|Tr200494|Tr200442|Tr200019|Tr200022|Tr200013|Tr200108|Tr200106|Tr200715|Tr200886|Tr201055"

"Tr200063","Tr200058|Tr200576|Tr200591|Tr200578|Tr200530|Tr200367|Tr200419|Tr200510|Tr200246|Tr200034|Tr200338|Tr200211|Tr200170|Tr200242|Tr200145a|Tr200344|Tr200013|Tr200021|Tr200710|Tr200723|Tr200736|Tr200775|Tr200873|Tr200948"

Hello,

Thank you, I tried the patch and the related products seem to be exported in the desired order.

Thank you for confirming patch is working. This fix will be included in upcoming RO CSVI release.

Do I need to delete the previous related products from the database, before import?

In your import template on Options tab set Delete related products field to Yes, save the template and run the import. This setting will delete the existing related products for a product and imports the new ones from file.

Hello,

[RO CSVi 7.19.1 (without the 2021 patch you sent us)]
I am getting this error:
Import file contains 1398 lines
No supported fields have been found in the import file

Try updating available fields and check. Patch file has no relation to this error.

Template is set to the following:
Operation: Related Product
Use file for configuration: Yes
Fields: product_sku, related_products
(although we also tried with no pre-set fields)

Your import content is good so try import after updating available fields.

In your import template on Options tab set Delete related products field to Yes, save the template and run the import. This setting will delete the existing related products for a product and imports the new ones from file.

This setting mentioned in my previous reply is for VirtueMart Product import template and is not for VirtueMart related products import template.

Thank you.

I am still unable to use the exported "Related Products" file. Getting the "No supported fields have been found in the import file" error.
(yes, I did maintenance update available fields)

Could you please try to import the attached file and tell me if you can parse it ok?

Thanks

Hello,
I was able to reproduce "No supported fields have been found in the import file" error with your import file and that is because your file is a BOM file.

What you can do is
1. In import template on Options tab set Autodetect Delimiters to No and set Field delimiter to ,(comma) and Text enclosure to " (double quote). See attached screenshot.
2. on Options tab set Use file for configuration to No, save the template.
3. On template fields page, select the import template and add fields product_sku and related_products.
4. Run the import and check.

Thank you, that was it. I re-saved the file as UTF8 without BOM, and problem was fixed.
Just know that the file was exported as such (with BOM) from CSVi. I don't know if you have control over this, or it's a server/browser/OS thing.

And questions that came up:
Does this whole discussion apply to related_categories as well?
Does related_categories need fixing in export ordering, or has it been fixed with this patch?
If I set "Delete related products" option, also delete related categories?

Didn't have time to check/confirm the above. Will do so soon. Thanks

Hello,

Just know that the file was exported as such (with BOM) from CSVi. I don't know if you have control over this, or it's a server/browser/OS thing.

In your export template on File tab is you have set Excel CSV option to Yes you will get file with BOM on export. By default this option is set to No.

Does this whole discussion apply to related_categories as well?
Does related_categories need fixing in export ordering, or has it been fixed with this patch?

Patch has ordering fixed for related_categories as well.

If I set "Delete related products" option, also delete related categories?

No, Delete related products option is for related_products only. We have Delete related categories option in our todo list and will be included in our future release.

We proceeded with the import, all went well.

Even though there was no "Delete related categories", the imported related_categories did not create double entries over the previous ones, which is awesome.

Thank you very much!

Update:

The imported related products, are not in the order they are defined in the CSV!

This is on a production site (CSVi 7.19.1 without the 2021 patch in this thread).

Do we need the patch for the correct import order as well?

Hello,
The patch file has ordering only for export and not for import. As of now related products ordering is not supported. I will develop this feature and send you a patch file once it is ready.