Error message on import

-- HikaShop version -- : 2.3.3
-- Joomla version -- : 3.3.1
-- PHP version -- : 5.4.32
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : Notice
The line ',,,,,,,,,,,,,,,,' could not be imported Product not found

The line ',,,,,,,,,,,,,,,,' could not be imported Product not found

Message
855 products found : 91 new products imported, 569 invalid product code, 195 already existing products

Warning: substr() expects parameter 1 to be string, object given in /home1/sison246/public_html/iheartsin/administrator/components/com_hikashop/helpers/import.php on line 1031

Warning: substr() expects parameter 1 to be string, object given in /home1/sison246/public_html/iheartsin/administrator/components/com_hikashop/helpers/import.php on line 1031

Warning: substr() expects parameter 1 to be string, object given in /home1/sison246/public_html/iheartsin/administrator/components/com_hikashop/helpers/import.php on line 1031
...etc

Delete all my products via PHP my admin, to start my shop over again.
Used the SQL attached. Verified no products were listed in the Product menu.

Imported using the attached CSV.

Received the following error message saying:

1) I had duplicate products, even though I deleted all my products
2) I was important hundreds of more products than was in my CSV

Removed all the spaces from my columns in my CSV. Thank you for the catch. Also deleted the produce_id column. I am still getting the issue I brought up in a different thread

www.hikashop.com/forum/import-export-csv...g-on-csv-import.html <last post>

Which is on import, Hikashop seems to be creating all possible variants and listing unlimited quantity, regardless if I have specific variant combinations and quantities in my CSV upload files.

Hi,

So I close this topic and we will continue on the other one as soon as possible.

Updated to 2.3.4. Now I see the following message when I am the page looking at the product list

Warning: vsprintf(): Too few arguments in /home1/sison246/public_html/iheartsin/libraries/joomla/language/text.php on line 92

I'm oddly still getting a "already existing products", when importing, even if I delete all my products first. Is there a way to figure out which products Hika thinks are already existing, so I can fix my import file?

Here is the specific message. This is after I clear my products via SQL, so there are no products remaining, before I import.

2246 products found : 2068 new products imported, 0 invalid product code, 178 already existing products

I followed all the steps and am having problems importing. I have the latest version of php/Hika/Joomla.

I deleted all the products and tried to import. That did not work as I got the error message saying that the products exist.

I then emptied the table in phpMyadmin but still got errors (see attached).

Attached is the file 'rows518-to-end.csv' which contains only the products. The 'hikashopexport-done.csv' contains a bunch of other rows that we did not update (the first 517 rows).

Please help!

I just tried the entire database (with products) but get this error:
An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE jom_hikashop_category SET category_right = category_right + 2 WHERE category_right >=


The attached file is the exact same as the export only the variants have price changes. No other changes were made to the file.

Thank you

I tried (using phpMyadmin) emptying the table "jom_hikashop_product" and then tried importing the attachment (unzipped) on the previous email and get these errors:

4625 products found : 0 new products imported, 27 invalid product code, 4598 already existing products

Error
The column "" is twice in your CSV. Only the second column data will be taken into account.

The line ';;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Coffee;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;' could not be imported Product not found

The line ';;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Coffee;coffee.jpg;Coffee;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;' could not be imported Product not found

Are you sure? The import message said "0 new products imported"?

I will try the same method tomorrow and check if the prices increased.

OK, this time I did the same steps.
1. emptied the product database
2. imported the attached 'hikashopexported-done.csv' file

See attached errors, along with the original export and updated export (just price changes).
See how the category menu got messed up as well (so I restored the site) as a lot of products were missing after the import.


thank you for helping!

OK, I think it worked this time.

See the attached errors. Please confirm they are not important.