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
- konstantinos29
- RO CSVI
- Tuesday, 19 January 2021
- Subscribe via email
0
Accepted Answer
Pending Moderation
Hello,
Yes as of now related product is sorted based on product id.
Load the patch file so to export related_products field based on ordering field.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
Accepted Answer
Pending Moderation
[RO CSVi 7.19.1 (without the 2021 patch you sent us)]
I am getting 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)
CSV import file sample below:
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"
Accepted Answer
Pending Moderation
Hello,
Thank you for confirming patch is working. This fix will be included in upcoming RO CSVI release.
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
Try updating available fields and check. Patch file has no relation to this error.
Your import content is good so try import after updating available fields.
This setting mentioned in my previous reply is for VirtueMart Product import template and is not for VirtueMart related products import template.
[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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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)
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
Accepted Answer
Pending Moderation
Hello,
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.
Patch has ordering fixed for related_categories as well.
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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!
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!
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?
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?
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »