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>
CSV or XML import
- Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: CSV or XML import
Hi, do you get any error message in Javascript console, when you click on import?
Jan
Jan
If you find Phoca extensions useful, please support the project