CSV or XML import
Posted: 10 Nov 2024, 15:27
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>
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>