import xcart data

[g1media]

I currently use X-Cart on my site and I'm looking to transfer Zen Cart.

I've setup the site using the latest version (v1.3.8a/v1.3.8) - however, I don't want to lose the existing data that I have in my X-Cart store, mainly just the past orders and customer details - I have very few products so that's a simple one.

Is there a way I can export and then import this data?

[schoolboy]

Anything is possible, but this may require a fair amount of work.

Firstly, ZC associates a lot of the data in the database between the tables - so it's quite "relational" in many places. This is most certainly true of customer data, which would include their order history. Just how ZC relates all the data is a subject that is largely beyond me, but what you will need to do is:

1. Examine the structure of the Xcart database to determine how it achieves the relationship between customers and their purchase history, etc.
2. Do the same with ZC
3. Export the Xcart data and reconfigure it as a SQL command to populate the ZC database.

As I said... possible, but probably not easy. You may also have the added headache of sessions data... Perhaps a ZC guru can help you further.

[kobra]

I have not seen the X-Cart data structure???

But if you can get this into the ZenCart table structure you can then import it.

[beyre]

Let me say this ... x-cart's database is FUBAR! I've been working on x-cart stores for the better part of 4 years now.

We just transferred two X-cart stores to Zencart (and have 2 more to do). Thank god we have a great database guy. But he did have to spend many hours getting the x-cart database worked out to fit into zencart. It's like putting a square peg into a round hole. Granted, each store has 3500+ products in each. But whether it's 3500 products or 20 products, the process was the same.

But he was very impressed with Zencart's simple, yet solid database structure.

So, I would spend the money to get a person who is very knowledgeable in SQL/databases to restructure x-cart database and upload to zencart. Otherwise, the typical layperson would not be successful.