Categories
View Replies (10)

Resolved Duplicate images on HikaShop import

  1. imthebige
    imthebige
  2. RO CSVI
  3. Tuesday, 01 November 2016
  4.  Subscribe via email
Hello Rolandd,

Issues Ocuured:

First Issue :-->images get duplicated after import.

See the screenshot : http://prntscr.com/d1jcx7
http://prntscr.com/d1jw7j

For this i have deleted the products and add attached patch file send by you earlier and then import.But still same problem
occurs.

I have attached two log files which i imported recently after delete products.

Second Issue :--> I have changed the cron jobs timing Earlier it was run with same timings.Still same problem...:(

1) Product Cron job : Run (Once per 15 minutes)

/usr/local/bin/php70 /home/juicy672/public_html/administrator/components/com_csvi/helper/cron.php --key="testimport" --template_id="51" --file="/home/juicy672/public_html/cron/Tmpfile.csv"

2)Brands Cron job : Run (Once per hour)

/usr/local/bin/php70 /home/juicy672/public_html/administrator/components/com_csvi/helper/cron.php --key="Final Brand Cron" --template_id="56" --file="/home/juicy672/public_html/cron/1.csv"

See the screenshot : http://prntscr.com/d1jay9

http://prntscr.com/d1jb6d

Third Issue :-->

Also Skip first line option ticked but not working as field names are being added as products.and same with categories

Please check and let me know.

Thanks
0
Responses (10)
imthebige
imthebige
Accepted Answer Pending Moderation
Hello,

I have noticed this error in my products related to patch file i think.

See the screenshot : http://prntscr.com/d1k1fu

Regards.
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

To keep things clear I am not going to answer all issues at once but will tackle one issue at a time. Otherwise it gets confusing really fast. So, first let's look at the duplicate images problem, I have changed the title of this thread to match that.

Attached is a patch file that fixes the issue of the duplicate images, please load the patch file and let me know if this solves your problem.

As for the other issues, let's take a look at the cron issue next. Please make another thread for the cron issue, so we can deal with it there. You said you have the "same problem", please explain in the other thread what this same problem is. At this moment, I do not know what the problem is.
Attachments (1)
patch_duplicateimage_hikashop_20161101.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. # 2
imthebige
imthebige
Accepted Answer Pending Moderation
Hello,

I have load the patch file but my problem not solved with this.

getting error : http://prntscr.com/d1ls8o

Also shows too many images : http://prntscr.com/d1lser

Please check

Thanks & regards
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

That error is unrelated to the duplicate images. It just means that you have an invalid image file.

Also shows too many images
Did you clean that product before importing?

Where is the debug log?
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. # 4
imthebige
imthebige
Accepted Answer Pending Moderation
Hello,

yes i delete all products and then imported.

Image is there when edit a product.But error shows.

See the screenshot :http://prntscr.com/d1lxzg

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Post the debug log of your import, so I can see what happens.
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. # 6
imthebige
imthebige
Accepted Answer Pending Moderation
Hello,

Please find attach log file.

Thanks
Attachments (1)
com_csvi.log.467.txt
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Thank you for the logfile. Now the logfile shows that the patch I posted earlier is actually working as the images are no longer inserted but updated.

So, that you see multiple images for a product is not related to your import but that the database table still has old values. So to clean up all these duplicate and extra images you need to empty the image table. If you know how, go to PhpMyAdmin and open the table jd_hikashop_file. When it is open, click on the SQL tab and paste the following query 
DELETE FROM jd_hikashop_file WHERE file_type = 'product';
This will remove all product images and now you can run your import. This should give you a single image per product.

Let me know how it goes.
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. # 8
imthebige
imthebige
Accepted Answer Pending Moderation
Hello Rolandd,

Yes now it is fine.Single image shows now. Thanks..!

But As i saw there is still error shows in some images even if there is a image in it.

See the screenshot : http://prntscr.com/d1nal9

Please check attach recent log files first for brands and second for products.

Thanks & Regards.
Attachments (2)
com_csvi.log.473.zip
com_csvi.log.475.txt
  1. more than a month ago
  2. RO CSVI
  3. # 9
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

OK, good to hear the image import is solved. As for the error you see, this is not a CSVI issue. As you can see in the error it is an issue with HikaShop processing the image. I think it is just an issue with the image file itself having something odd. If you want to investigate this issue further I suggest to contact HikaShop support 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. # 10
  • Page :
  • 1


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