Export products as CSV file?

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.

phpmyadmin export as a csv file

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

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.

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

Ryk:

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

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

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 :laugh:.

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

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...

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...

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

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

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