Categories
View Replies (9)

Resolved Problems import Vm Product

  1. codeingenia
    codeingenia
  2. RO CSVI
  3. Wednesday, 07 October 2015
  4.  Subscribe via email
JOOMLA 3.4.4
CSVI 6.2.0
VIRTUEMART 3.0.10

Template fields:

product_sku
product_name
product_s_desc
product_price
product_in_stock
category_path
file_title
file_url
published
file_url_thumb
custom_title
custom_value
product_desc
product_gtin

I have two problems:

1) When there aren't product in virtuemart and I start import there is a problem with generation of alias:

An error has occured during the import. Below the information received from the server.
Duplicate entry 'whisky-gogo-1970-n-4' for key 'slug' SQL=INSERT INTO `wer9i_virtuemart_products_it_it` (`virtuemart_product_id`,`slug`) VALUES (258, 'whisky-gogo-1970-n-4')

I've read other topic with this problem, but I didn't manage to find a definitive solution.

Importing products when virtuemart database product is empty let me to import about 100 products (instead of 33000 of the file import)
When I try to import products when there are already products in virtuemart database, error is different:

2) Duplicate entry 'i-quaderni-del-fumetto-1975-n-17-3' for key 'slug' SQL=UPDATE `wer9i_virtuemart_products_it_it` SET `product_s_desc`='
Casa editrice:F.lli Spada
Formato:Albo Orizzontale
',`product_desc`='Ottimo~In ottimo stato~F.lli Spada~Albo Orizzontale',`product_name`='I QUADERNI DEL FUMETTO 1975 n. 17',`metadesc`='',`metakey`='',`customtitle`='',`slug`='i-quaderni-del-fumetto-1975-n-17-3' WHERE `virtuemart_product_id`='470'

So this second problem is beacuse alias generated is equal to other product?
I've setted in template Overwrite existing data to YES.

I used my csv file in joomla 2.5 with older version of csvi and all works ok.
I'm having this problem in CSVI 6.2.

I'm sending you joomla credential. Please make sure that the import of file (load from url already setted in IMPORT ALBI template) goes well without errors.

Thanks
0
Responses (9)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I don't need the credentials but I need the information as requested at the top of this page under Looking for a useful answer especially the log and the file you use for import.

The issue is indeed that the alias already exists and we need to see why this happens, the log should give some more info for that.
Kind regards,

RolandD

=========================
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. # 1
codeingenia
codeingenia
Accepted Answer Pending Moderation
I know it, but problem is that log file isn't generated (I setted YES to Enable Logging in Template Details)
When I receive the first error does not apper tha page where I can see logs. If I go in Logs Tab in CSVI I can't see first problem logs.
This problem also occurs when I receive the 2nd type of error described.
So i sent you admin access. I would want to solve in less time as possible
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I see the problem. You have set to recreate the aliases, well the alias is created based on the product name and you have multiple products with the same name, so you would get the same aliases. The same alias is not allowed, so CSVI tries to create a unique slug but that is where things go wrong.

The best way forward is to turn Recreate alias off (I already did this), remove all the products and then run the import to add them again, this should be fine to get everything in. You can also try by just deleting the products with the name I QUADERNI DEL FUMETTO 1975 n. 17 and only import those as a matter of test case.

You also had the order of the fields wrong, the product_desc was almost at the end while it is almost at the beginning in your CSV file.
Kind regards,

RolandD

=========================
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. # 3
codeingenia
codeingenia
Accepted Answer Pending Moderation
Dear Rolandd, I've tried to follow your way deleting all products from vm and relauching import (with recreate alias turned off) but I receive the same error described in my first post:

Duplicate entry 'whisky-gogo-1970-n-4' for key 'slug' SQL=INSERT INTO `wer9i_virtuemart_products_it_it` (`virtuemart_product_id`,`slug`) VALUES (258, 'whisky-gogo-1970-n-4')

When appear this error there are about 100 products in vm (insted of 30k).

I remember that in csvi for joomla 2.5 I can import the same .csv file without errors.
There I think that If I have same product name (with different sku) alias is generated with incremental value, so let me to create plural products based on the same product_name.
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

There I think that If I have same product name (with different sku) alias is generated with incremental value, so let me to create plural products based on the same product_name.
Correct, that is what should be happening now as well.

So I had a closer look and I was able to get the same issue but only after I imported the products a 2nd or more times. The attached patch file fixes the issue and you can import your products again.
Attachments (1)
patch_slug_20151008.zip
Kind regards,

RolandD

=========================
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. # 5
codeingenia
codeingenia
Accepted Answer Pending Moderation
Patch loaded. Same error:

Duplicate entry 'whisky-gogo-1970-n-4' for key 'slug' SQL=INSERT INTO `wer9i_virtuemart_products_it_it` (`virtuemart_product_id`,`slug`) VALUES (258, 'whisky-gogo-1970-n-4')

I've tried to import setting Recreate alias ON and OFF. Same error appears

EDIT: I've also tried to delete whisky-gogo-1970-n-4 product from csv file but when I relauch import error appears for another product (that has same name but different sku). There is still a problem with generation of alias with incremental value.
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I didn't test with this particular whiskey, don't drink and work :whistle:

Attached is a new patch file, that I believe is a more solid solution. Can you load this patch and tell me if it solves your issue? Thanks.
Attachments (1)
patch_slug_20181008-2.zip
Kind regards,

RolandD

=========================
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. # 7
codeingenia
codeingenia
Accepted Answer Pending Moderation
Problem solved. Now it imports all products correctly.
Great support
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Good to hear all is working. Feel free to write a review on the Joomla! Extension Directory.
Kind regards,

RolandD

=========================
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. # 9
  • Page :
  • 1


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