1. piosaliani
  2. RO CSVI
  3. Friday, 19 June 2020
  4.  Subscribe via email
Hello,
I switched from CSVI PRO to RO CSVI, but I get the error "RO CSVI Addons you have installed are outdated. You need to update your addons to the same version as RO CSVI extension. In the extension manager you can see the current list of adddons and their versions. You can update the addons from the Update page in the Joomla Extension Manager. " (error.jpg), but clicking on "you can see the current list of addons and their versions.", I see all the updated addons except "CSVI Pro - AwoCoupon" that I can't update. How can I solve the problem?

Thanks
Pio
Attachments (2)
Accepted Answer
Accepted Answer Pending Moderation
Hello Pio,
Yes correct. If you have product_name less than 192 characters unique slug values with increment values at the end will be generated from product_name.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
So the problem is solved by making sure that the field "product_name" has less than 192 characters?

Kind regards,

Pio
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Pio,
You are right, by default RO CSVI checks if there is an existing slug in database like in the below query and this happens nevertheless Recreate alias is set to Yes or No.


SELECT COUNT(`virtuemart_product_id`) FROM v64ze_virtuemart_products_it_it WHERE `slug` = 'cappello-sisal' AND `virtuemart_product_id` != 8701


If it finds an existing record then it generates a new slug for the next record and inserts in database like


INSERT INTO `v64ze_virtuemart_products_it_it` (`virtuemart_product_id`,`slug`) VALUES (8701, 'cappello-sisal-1')


In this case the slug is less than 192 characters and is fully inserted in database. This makes slug field unique and so no duplicate error.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hi Tharuna
I deleted all the products and categories in Virtuemart, I re-imported the csv file prodotti_12062020.csv, but the software does not give me an error.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Pio,
Yes you have Recreate alias option is set to No but you are importing products which are already existing in database. When you update a product, the fields which are in import file are updated and the other fields stays the same. In your case slug field value is already unique in database and is not updated as it is not in the import file and so no duplicate error.

You can test the import file on a clean VM installation with Recreate alias set to No in import template, you will see duplicate error then.
Kind regards,

Tharuna

=========================
If you use our extensions, 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
Hi Tharuna,
I set the Recreate alias option to "No", I imported a previous version of the csv file (prodotti_12062020.csv), which has multiple products with the same "product_name" "CAPPELLO SISAL", but I have no error.

Kind regards,
Pio
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Pio,
Thank you for posting the debug log. As per the debug log you still have Recreate alias option set to Yes in your import template and so you did not see the duplicate error:D
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Ok!

Kind regards,
Pio
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
One thing I noticed, even when the "Recreate alias" option was "No", products with the same short name (for example "CAPPELLO SISAL" see attachment), the import didn't give me an error.
Why?

Can you also post the debug log of the import to check? To get the debug log check How to get debug information? document.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Now everything is clear.
One thing I noticed, even when the "Recreate alias" option was "No", products with the same short name (for example "CAPPELLO SISAL" see attachment), the import didn't give me an error.
Why?
Having the url corresponding to the product name is very important for SEO.

Kind regards,
Pio
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Pio,
I thought it was enough to have different product_sku, to avoid duplication problems!

With RO CSVI we use product_sku to select records in database, if a record with matching product_sku is not found a new record is created else existing record is updated. With same product_sku value you are updating existing records and so we say product_sku should be different.

When we wrote to it two years ago, you didn't tell me you had to have a slug field in the csv file!

slug field is not a needed field in import but product_sku is. On import, RO CSVI generates slug(alias) field using product_name from import file. In your case the duplicate error is because of VirtueMart table definitions and the error has nothing to do with RO CSVI. To avoid this VirtueMart issue i am asking you to have slug field in import file.

I hope i have explained it clear.

Is it sufficient to have numeric values from 1 to n in the slug field?

Having numbers as slug is sufficient to run the import using RO CSVI but VirtueMart uses slug(alias) to generate product urls on frontend. What you can do is import one product with numeric value as slug and see how it goes on frontend. You can import other products after testing this one product.

One other suggestion is to write on VirtueMart forum about using these lengthy slugs. You can mention the issue as slug values are truncated after 192 characters. They might help you with a solution here.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
I thought it was enough to have different product_sku, to avoid duplication problems!
When we wrote to it two years ago, you didn't tell me you had to have a slug field in the csv file!
Is it sufficient to have numeric values from 1 to n in the slug field?

Kind regards,
Pio
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Pio,
How do I make this setting?

You don't need to do any setting. You need to have a field called slug in your import file and import value which are of 192 characters and without duplicates to avoid this error.

What is the slug field?

slug is alias in VirtueMart. Go to PHPMyAdmin and look for table v64ze_virtuemart_products_it_it. Select this table on left and on right side click on Structure tab. You can see the columns of this table with defined length(See screenshot). One of the column is slug.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
How do I make this setting?
What is the slug field?

Thanks
Pio
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Pio,
Ok, this duplicate error is because of VirtueMart table configuration. In your v64ze_virtuemart_products_it_it table the length of the slug field is set to 192 which means it can take only 192 characters and the rest of the text is truncated. When RO CSVI recreates the alias only this part of the text is accommodated in database. Since the same slug already exists in database, it shows duplicate error. This happens when there are such long slug text. To solve this you need to define slugs in your import file which are of 192 characters and are not duplicates.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello Tharuna,
I set "Recreate alias" to Yes on Options tab in my import template (ricreate_alias.jpg), but I keep seeing the same error (duplicate.jpg).

Thanks
Pio
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello Pio,
The error is not because of product_sku but because of slug field. When there is no slug field in import file, RO CSVI will use product_name value and generates slug field. Since you have three products with same name, same slug is generated and that is causing Duplicate error. To solve this you can set Recreate alias to Yes on Options tab in your import templat, save the template and run the import or you can set your own slug field value in the import file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hi,
I have uploaded the csv, but I see the error in the attachment (duplicate.jpg). We checked, there are no equal product_sku.

Thanks
Pio
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello Pio,
The old version of CSVI Pro - AwoCoupon is causing to show this error. If you are not using that extension for your import/exports, uninstall the extension. After that clear the cache by going to System -> Clear Cache and delete the RO CSVI cache.
Kind regards,

Tharuna

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


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