Export products as CSV file?

[gabenn2]

Is there a way to export products as a CSV file with zen cart. I checked into easy populate but from what I can tell that only allows import. I have a client that wants to switch from Zen Cart to X-cart. I would like to be able to easliy switch over her products to X-cart. Does anyone know how to do this? Thanks in Advance.

[kobra]

phpmyadmin export as a csv file

[poolprorich]

Try this,

SELECT * 
INTO OUTFILE 'YOUR FOLDER/result.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM products, products_discription

if its not on a local server u will have to retrive file from where you saved it.

Always Backup Your Database First

[Ryk]

Is there a way to export products as a CSV file with zen cart. I checked into easy populate but from what I can tell that only allows import. I have a client that wants to switch from Zen Cart to X-cart. I would like to be able to easliy switch over her products to X-cart. Does anyone know how to do this? Thanks in Advance.

Easy Populate will allow you to EXPORT - but what a strange place to be asking if anyone knows who to switch TO X-Cart

[poolprorich]

Easy Populate will allow you to EXPORT - but what a strange place to be asking if anyone knows who to switch TO X-Cart

i was going to say that but thought i would be nice!

[gabenn2]

It isn't for me, trust me I love my zen. I tried asking on the X-cart forums but they all acted like they didn't know what zen cart was .

And duh , why didn't I think of doing the database export, Sorry guys and thanks!

[webguygary]

I'm actually in the opposite end of this problem - have a new client on x-cart and they are miserable. Are there any thread links about how I'd go about converting an x-cart database to zen cart? I'm hoping it's an easy conversion, I haven't even quoted them a price yet...

[poolprorich]

I'm actually in the opposite end of this problem - have a new client on x-cart and they are miserable. Are there any thread links about how I'd go about converting an x-cart database to zen cart? I'm hoping it's an easy conversion, I haven't even quoted them a price yet...

Hi,
I dont believe the database fields match but you could export your database to cvs and modify it for upload with zencart with easypopulate it will take some time but i think its worth it to switch to zencart

[thenax]

Try this,

SELECT * 
INTO OUTFILE 'YOUR FOLDER/result.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM products, products_discription

if its not on a local server u will have to retrive file from where you saved it.

Always Backup Your Database First

where have I to insert this code? in a new php page? or in sql section in phpmyadmin?