CSV or XML import

Phoca Cart - complex e-commerce extension
User avatar
EsDeeEm
Phoca Member
Phoca Member
Posts: 11
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: 49125
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
User avatar
EsDeeEm
Phoca Member
Phoca Member
Posts: 11
Joined: 30 Jun 2024, 22:48

Re: CSV or XML import

Post by EsDeeEm »

Hey Jan,

After upgrading to the latest version (5 b87) I no longer have problems importing. Thanks for your follow up.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49125
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: CSV or XML import

Post by Jan »

Hi, great to hear it.

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