Resolved Skip first line option ticked but not working as f

Hello,
Thank you for sending me your site details, i tested product import on your site with first 5 records and from your test import file and the category_path went fine. Also these categories and products are already in your database so with my import they were just updated. I am pasting the process of one record here where category_path has been imported correct. I dont even see the issue of first record getting imported when skip first row set to yes. Can you try import again and check? else you may need to explain me the procedure to replicate the issue. With my import i don't see any problem.

Process path: product category/Pet Supplies

2016-10-28	03:55:22	1	[DEBUG]	Check category exists: product category

2016-10-28	03:55:22	1	[QUERY]	SELECT `c`.`category_id` FROM `jd_hikashop_category` AS `c` LEFT JOIN `jd_hikashop_category` AS `p` ON `c`.`category_id` = `p`.`category_id` WHERE `c`.`category_left` BETWEEN `p`.`category_left` AND `p`.`category_right` AND `c`.`category_name` = 'product category' AND `c`.`category_parent_id` = 1

2016-10-28	03:55:22	1	[DEBUG]	Check category exists: Pet Supplies

2016-10-28	03:55:22	1	[QUERY]	SELECT `c`.`category_id` FROM `jd_hikashop_category` AS `c` LEFT JOIN `jd_hikashop_category` AS `p` ON `c`.`category_id` = `p`.`category_id` WHERE `c`.`category_left` BETWEEN `p`.`category_left` AND `p`.`category_right` AND `c`.`category_name` = 'Pet Supplies' AND `c`.`category_parent_id` = 54

2016-10-28	03:55:22	1	[DEBUG]	Check if a category reference already exists

2016-10-28	03:55:22	1	[QUERY]	SELECT COUNT(*) AS total FROM `jd_hikashop_product_category` WHERE `product_id` = 3425 AND `category_id` = 78

2016-10-28	03:55:22	1	[DEBUG]	Category reference does not exist yet

2016-10-28	03:55:22	1	[DEBUG]	COM_CSVI_ADD_NEW_CATEGORY_REFERENCES

2016-10-28	03:55:22	1	[ADD]	COM_CSVI_TABLE_HikashopTableProductCategory_ADDED

2016-10-28	03:55:22	1	[QUERY]	INSERT INTO `jd_hikashop_product_category` (`category_id`,`product_id`,`ordering`) VALUES ('78','3425','1')

Hello,

Skip first line option ticked but not working as field names are being added as products.

Please let me know what can i do ?

http://prntscr.com/czh1s3

Can you send me the your sample import file, debug log and also a copy of your template XML file to check?

2) My cron job products added in wrong way and if i import it without cron it import correctly.Please check the attached file of log of cron job.

Added like this way : category

2016-10-27 05:00:05
2016-10-27 05:00:05
2016-10-27 05:00:05
2016-10-27 05:00:05
2016-10-27 05:00:05
2016-10-27 05:00:05
2016-10-27 05:00:05

when cron runs.

I don't see any issue in the debug log file you posted. Though the cron output shows as you mentioned, do you have any problem with your products after the import? Can you be more specific on what is the issue you are having?

Hello,

explaining in brief:-

I have 2 csv files on my server which is updated with a cron job. 1 is for products and other one is for brands.

For both csv cron job runs for import process.

Getting problem : 1) Skip first line option ticked but not working as field names are being added as products.

2)Products Category imported in wrong way.

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

-I have also attached files below.please check

I have send template xml file for both brand and products in one xml.

Thanks & Regards.

Hello Tharuna,

One Issue more in my import...

When products are existing already and cron job run then products will update not insert new one works correctly.

But my issue is that if image updated second time than it shows like this way :

see the screenshot : http://prntscr.com/czis84

Media should have updated image only.

Can you please suggest about it.

Thanks & Regards

Hello,
There is something weird going on with your import, the category_path has been processed like Process path: product category/2016-10-25T10:43:26-07:00 which is product_modified date value in your import file. I tested your template with both cron and normal import and don't see this issue, Can you send me a private message of your Joomla administrator login details and database access details to check? Just to confirm, this don't happen when you import from CSVI interface?

Hello,

How to send message Privately here ?

Thanks

Hello,
You can go to forum page and look for New private messages link and post it there or you can send an email to me at tharuna@csvimproved.com.

Hello,

Just emailed you details.

Please check

Thanks

Hello,

When products are existing already and cron job run then products will update

my issue is that if product updated second time , It will look like this :-

see the screenshot : http://prntscr.com/czis84

please check this one also.

Thanks & Regards

Hello,

Can you load the attached patch file and see if the images don't get duplicated after import.

First clean the product before import please and then try. If they still duplicate, please post the new debug log.

Hello,

Can you please see cron runs now.and categories same import in wring way in admin panel.

You can check now.

Please let me know if you able to find the issue.

Thanks

Hello ,

The cron import file names showing same for brands and products in log.

Please see t he screenshot : http://prntscr.com/czwo4s

I didnot know why this is happening...It takes so long..

Thanks

Hello,
Can you also send the cron url you have used? Manually import has no issue so i doubt something to do with cron setup.

Hello,

I just send you email.Please check

Thanks