Categories
View Replies (13)

Resolved Products gets unpublished on import

  1. imthebige
    imthebige
  2. RO CSVI
  3. Friday, 05 May 2017
  4.  Subscribe via email
Hi,

I am facing few issues like you can see csv file attached. I am able to import products easily if number of rows are limited but it is not allowing a big csv files to get imported like this one.

Please note in csv file attached , file_url file has names of all images. Few of them getting converted and few not. Besides this, I want all image names to be changed to product_code.(some image extension).

And the biggest issue is-- when i upload products there product_published value will become 0 whereas I had set it as 1 . So, after import, no product appear on site.. I manually publish them which is wrong.

Please let me know changes which I need to perform so that all products will automatically appear after import and all images will be imported and renamed.

popshop_products.csv

Thanks
Nirmal
0
Responses (13)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Nirmal,
I am facing few issues like you can see csv file attached. I am able to import products easily if number of rows are limited but it is not allowing a big csv files to get imported like this one.

Whats the error you are seeing in importing this file? You can check Manage timeout document to know on how to import big files and see if setting limits to import helps.

Please note in csv file attached , file_url file has names of all images. Few of them getting converted and few not. Besides this, I want all image names to be changed to product_code.(some image extension).

If you want to create image name then in your template settings on image tab set Create image name to Yes and Image name based on to product_code. That should convert all image names to product_code on import. If you don't see these options click on Advanced button on top right corner.

And the biggest issue is-- when i upload products there product_published value will become 0 whereas I had set it as 1 . So, after import, no product appear on site.. I manually publish them which is wrong.

Please let me know changes which I need to perform so that all products will automatically appear after import and all images will be imported and renamed.

You need to post your import debug log to check on this.
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. # 1
imthebige
imthebige
Accepted Answer Pending Moderation
Hi,

Thank you for the reply. Image rename to product_code is working fine now.

I already have field for product_published which has default value to 1 . This simply means products needs to be published instantly after import where as this is not going on as expected.

Please check log file and let me know if you feel I need to know something from my end to fix this.

Kind Regards,
Nirmal
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your debug log file is missing in your post. If the file is too big try to compress and post it. It is always advised to try the import with few records so you get smaller debug log and it is easy to attach.
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. # 3
imthebige
imthebige
Accepted Answer Pending Moderation
Hi,

Here is compressed log file. Please check and let me know the issue.

Thanks
Nirmal
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your debug log is still missing in the post.
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. # 5
imthebige
imthebige
Accepted Answer Pending Moderation
Created new log file by importing only 100 products

Please check..
Attachments (1)
com_csvi.log.71.zip
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you tell where you have product_published field added? Your debug log and import file says there is no such field.
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. # 7
imthebige
imthebige
Accepted Answer Pending Moderation
In Template associated with product import, I had added field product_published and I set its default value to 1
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
In that case you need to set Use file for configuration option to No in your template settings on File tab. Right now it is set to Yes and so the column headers from import file are used and so your product_published is not used.
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. # 9
imthebige
imthebige
Accepted Answer Pending Moderation
But incase of category, category_published which is also not available in csv fiile but created in template fields, is working fine.. How category is getting published whereas product not.
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
category is published by default in code and so it is published even when the template fields are not read. Product published is based on user import file and template fields.
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. # 11
imthebige
imthebige
Accepted Answer Pending Moderation
Hello,

I have images also for categories but no information is provided as how to set images for category during csv import. Please guide me into this also.

Thanks
Nirmal
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Nirmal,
You can import category images using HikaShop category import operation. Select component as HikaShop and operation as category in your template. You can then use category_path and file_path to import category images.
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. # 13
  • Page :
  • 1


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