1. konstantinos29
  2. RO CSVI
  3. Tuesday, 19 January 2021
  4.  Subscribe via email
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?

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?

Thanks
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
[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"
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
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!
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
  • Page :
  • 1


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