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

Hi,

You have extra spaces in the names of the columns in your CSV ( " product_name" and " categories" instead of "product_name" and "categories") so that would explain why the products do not appear after the import. Also, the product_id column should be removed from the CSV. It is not necessary, and if present, it should only contains numbers and that's not the case on your CSV.
The warning messages come from a bug of HikaShop 2.3.3. It has been fixed in the 2.3.4 that we released today and that you can manually install and download via the My account>My subscriptions menu on our website.

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

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

That's an warning with a translation string. You can ignore it.
I don't know why you get it, but you should turn off the "error reporting" option of the Joomla configuration. That option should be turned off on a live website for security reasons and that will remove that warning as well.

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

Hi,

Open the table hikashop_product via your phpmyadmin and you'll see the entries left in the product table.

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!

Hi,

Your CSV file only contains variants. As specified in the import documentation ( which I invite you to read here: www.hikashop.com/support/support/documen...hikashop-import.html ), the CSV need to contains the variants AND the products (the products have to be listed above the variants in the CSV file). That is not the case on your CSV which explains why it doesn't work.

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

Hi,

These are not real errors of the import. Just informations that you have an empty column and that the categories lines didn't contain any product data (that's normal).
So the import actually worked in that case.

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

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

Yes. It also says 4598 already existing products, meaning that the products were already in the database and so the system just updated them.

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!

Hi,

Here is what I see in your original CSV that you export from HikaShop : take.ms/TS9Cv
And here is what I see in the hikashopexported-done.csv CSV file that you use for the import : take.ms/IZVHv
As you can see, the product name is split up in all the columns after it and so all the data is moved to different columns than what they should be in the CSV you're trying to import.

That's why you get all the error messages of columns with empty names. That's because the product data columns were moved to the right because of the product names being split up and thus the data was on columns without any name in the CSV.
That's also why all the store data is messed up after the import as the import data is completely wrong.

OK, I think it worked this time.

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

Hi,

These are normal and just say that the categories lines didn't contain any product data as I explained previously.