Page 1 of 1

CSV or XML import

Posted: 10 Nov 2024, 15:27
by EsDeeEm
Hi all,

I'm working with 5.0b79
Two problems with the product import:
1. CSV
When trying to import products, I'm able to upload the CSV file, but when I click the import button, nothing happens.
In the database, I can see that the data was loaded into the table "_phocacart_import", but the columns are all wrong. all goes well until "title". "id", "user_id", "product_id", "row_id" are fine, "title" and "alias" are empty and the contents of the complete row is aded to the "item" colum" with contents like "Mavala Stop;mavalastop;2753911;;14.04"

File structure:
;;;;Winter Wellness Ampoules;drgrandelwellnessampoules;41815;;15.2
;;;;Mavala Scientifique Kplus;mavalascienkplus;3623584;;20.7


2. XML
very short description: nothing
file is not processed, database table is empty, no error message anywhere

For both file types I tried with the option "import column" set to ID and SKU

File structure:
<?xml version="1.0" encoding="UTF-8" ?>
<root>
<row-0>
<id></id>
<user_id></user_id>
<product_id></product_id>
<row_id></row_id>
<title>Winter Wellness Ampoules</title>
<alias>drgrandelwellnessampoules</alias>
<sku>41815</sku>
<ean></ean>
<price>15.2</price>
</row-0>
<row-1>
<id></id>
<user_id></user_id>
<product_id></product_id>
<row_id></row_id>
<title>Mavala Scientifique Kplus</title>
<alias>mavalascienkplus</alias>
<sku>3623584</sku>
<ean></ean>
<price>20.7</price>
</row-1>

Re: CSV or XML import

Posted: 15 Nov 2024, 17:18
by Jan
Hi, do you get any error message in Javascript console, when you click on import?

Jan