Resolved Price is not updated while import

Hello,
The debug log shows that there is no processing on product_price field which has happened. I doubt if these are some old entries in your database. HikaShop stores product prices in table hikashop_price, you may need to empty this table for any old entries and then do fresh import for products.

Also blank category of products is also created.Don't know why blank category created..

Can you give me an example of this issue?

Hello Tharuna,

Regarding : The debug log shows that there is no processing on product_price field

It means if there is price value in csv then also it is not processing ??

I have empty the table hikashop_price.Now no price value comes.But i am confused if there is price of any product available then it will show price or not ?

Regarding : Can you give me an example of this issue?

Blank category appears in categories section.

->See the screenshot : http://prntscr.com/d2wtae

I have attach the recent log file also

Please check

Thanks and regards

Hello,

It means if there is price value in csv then also it is not processing ??

No, i meant only for the product you sent in the screenshot. There is no price entered for the product as per your debug log.

I have empty the table hikashop_price.Now no price value comes.But i am confused if there is price of any product available then it will show price or not ?

If there is any price in your csv file it will be imported. In the file you sent the SalePrice column is 0 for all records.

This is one reason why we always suggest to test the import with few records initially and when all goes good, clean up the database and do a full import. This way all the leftovers are cleaned and there are no such issues.

Blank category appears in categories section.

->See the screenshot : http://prntscr.com/d2wtae

I have attach the recent log file also

The category for that record in your csv file is empty and so empty category has been imported and created. Load the attached patch file using CSVI maintenance menu and that should solve the issue. But make sure that you clean category table for products before you import.


patch_HS_category_2016-11-04.zip

Hello,

I found same problem again with price.As in import csv file there is $0 with products but from database it is showing $1.

Earlier you said : I doubt if these are some old entries in your database. HikaShop stores product prices in table hikashop_price, you may need to empty this table for any old entries and then do fresh import for products.

I need to ask that this same problem occur again and again.? Why it is picking old entries ? Need to empty table again and again for this ?

Don't have any better solution for this.?

Please let me know

Regards.

Hello,

I need to ask that this same problem occur again and again.? Why it is picking old entries ? Need to empty table again and again for this ?

If you are doing test imports, empty only #__hikashop_product table without emptying #__hikashop_price table you would see this issue. The price table has product_id linked with it so when you clear the product table and not the price tables, do a import, the new entries in products table will be automatically linked to product_ids in price table. This is why we suggest to clean tables before doing a import. Once your done with all your testing, clean up the tables and start with your active data you should not be having this issue.

Don't have any better solution for this.?

Its the record mismatch which is the issue. I don't think there is any better solution, either you clean the related tables or you can leave the records as it is so ids remain the same.