CSV or XML import

Phoca Cart - complex e-commerce extension
User avatar
EsDeeEm
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 30 Jun 2024, 22:48

CSV or XML import

Post 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>
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48386
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: CSV or XML import

Post by Jan »

Hi, do you get any error message in Javascript console, when you click on import?

Jan
If you find Phoca extensions useful, please support the project
Post Reply