Unable to Import from a Exported CSV file.

-- HikaShop version -- : 3.4.1
-- Joomla version -- : 3.8.10
-- PHP version -- : 5.6.3
-- Browser(s) name and version -- : Chrome 67.0.3396.79 (Official Build) (64-bit)
-- Error-message(debug-mod must be tuned on) -- : You need 73 arguments per line

@support, @forum,

I did a export of ONE product (checked the product and selected export).
Generated the hikashopexport.csv
I updated 4 variants (record numbers #29251, #29275, #29283 & #29291) with Image file paths and names in the csv file, saved it.

Ran the import, and error message "You need 73 arguments per line" came up.

Have attached the csv file, and 3 screen shots with the config for the import and error messages.

I read the doco and that didn't help, has there been a change in the 3.4.1 version ?

I realise there are way too many Variants for the product, but I am just trying to make this easier for me to get all the products and variants into the shop without screen input everything.

Thanks and Regards,

MSF

And now I have a database full of junk from that import.

See attached.

Thanks Nicolas,
I thought it may have been the editor when I thought about it, but not having looked at this exported file before, wasn't so sure.

Is there a way that I can delete all the extra product lines that it put in.?

MyPhpadmin, export the SQL, drop the product data set, edit the sql file and then import it ?? After a backup of course ?
How do I know good / bad product and their links ?
Good or bad idea ?

Hi Nicolas,

The products are no in the hikashop interface, there just 1000's of rouge entries in the Product Database set.
Hence why I was thinking of just doing SQL dump and cleaning that up and re-importing it.

MSF

Hi,

Where in the DB is the counter for the product ID number ?

After my rogue database import, all my id's are now starting at 39000 and I only have 1600 records in the database.

I would like to reset it to 2000.

Also, why does the import put a name (truncated image name) in the Main Options name of the Variant when the import file has "" in the csv field?

I have attached the csv file, look at product_id 39119, then look at the attached screen shot of the Variant after the import, and last image is of the hikashop_file dataset and what it puts in there. It also replaces name also with a truncated image file name.

I have wasted hours today, deleting and rebuilding the database in phpmyadmin.

I have 34 more imports to do, I just want it to work, if I say "" in name field or something, thats what I would like.

Is there a patch needed to fix this, or some code replace you want to send me ?


Thanks in Advance,
MSF

Hi,

Also modified the code when using another product as the template. It used the name of the product and places it in all the variants names.

$product->product_name = $this->template->product_name; to

$product->product_name = "";

MSF

Hi,

Thanks Nicolas, have changed the code.

MSF