OsCommerce Data Importer - Errors

[skipwater]

I only did the products import and the site is now doing the same thing. I chose products status as approved and did not import specials. I have the results of the import if you need to see that. I don't understand what I'm doing wrong.

It seems a post of mine went to never never land. So try again.

What version OSC are you coming from?

From what I can see there is bad data in your import. By what I can tell it almost looks like a zen to zen transfer (which this mod can not do).

Skip

[laurelsstitchery]

The OSC version is 2.2MS2

It seems a post of mine went to never never land. So try again.

What version OSC are you coming from?

From what I can see there is bad data in your import. By what I can tell it almost looks like a zen to zen transfer (which this mod can not do).

Skip

[hellsmash]

If someone need script for migration from Oscommerce to ZenCart, Opencart to Zencart, CreLoaded to Zencart and VirtueMart to Zencart can write me an email using my site Contact form

[ttfan]

I've done a succesful import, great script!

If I import again. with the latest OSC database (my OSC shop is still 'live') will it just overwrite the existing zen-cart database?

I've imported an older version of the OSC DB so that I can tinker and get it all working. Once I'm done, I would like to upload the lastest OSC database so that I can go live with zen-cart. So I'd like to know if I can just import again, to basically update the database to the latest?

Thanks a lot!

[skipwater]

I've done a succesful import, great script!

If I import again. with the latest OSC database (my OSC shop is still 'live') will it just overwrite the existing zen-cart database?

I've imported an older version of the OSC DB so that I can tinker and get it all working. Once I'm done, I would like to upload the lastest OSC database so that I can go live with zen-cart. So I'd like to know if I can just import again, to basically update the database to the latest?

Thanks a lot!

YES it will overwrite the old data.

Skip

[ttfan]

Beautiful, thank you very much!!!

[lwest]

Hey Skip,

Used your import script and it worked great. One issue: I have two OSC sites/databases that I want to transfer over. I transferred one, then tried the other, and it overwrote the first transfer. I went back and did the first, bigger database import again. Is there any way to transfer a second one over without overwriting my zencart database?

THanks,
Lindsay

[alexoverton]

osCommerce Online Merchant v2.2 RC1 exported to Zen Cart 1.3.9g
Clean install
No Addons - French and English Language installed on both OSC and Zen

Hi Thanks for your add on !

I have successfully exported my osc database but for some reason I can not get French product descriptions to show up .......It looks like the data was imported ok (it shows the tables) but does not show up if I select French language from the admin ? In my database the language code for French is 4 and English is 1

please help ........any Ideas thoughts gratefully received

Thanks

Alex

[skipwater]

osCommerce Online Merchant v2.2 RC1 exported to Zen Cart 1.3.9g
Clean install
No Addons - French and English Language installed on both OSC and Zen

Hi Thanks for your add on !

I have successfully exported my osc database but for some reason I can not get French product descriptions to show up .......It looks like the data was imported ok (it shows the tables) but does not show up if I select French language from the admin ? In my database the language code for French is 4 and English is 1

please help ........any Ideas thoughts gratefully received

Thanks

Alex

No change is made on the language codes.

Look at your osc languages table and see what is the value of your languages_id (1 is normally English, 2 is Deutsch, 3 is Español ) so what value is French 4 ?

After you check and see what value French 4 is look at products_description table. You should find that the language_id has the same value.

Now all you need to do is in the new zen cart languages table make a record that matches the languages_id in you products table languages_id.

Skip

[achyuta]

First let me vigorously agree, fantastic life-saving script! Many many thanks!

I am having a similar trouble with my address book as previously described. I have changed all my address_book_id entries to unique sequential numbers. All the data is there (in database), but I cant see it through admin > customers. All other imports went fine.

OSC was set up back in 2002, although it was updated to v2.2 RC2a. ZC is 1.3.9h. PHP 5.2.14 and Linux OS.

Another symptom, when I log in as a previously stored customer in my new zen-cart store, my shipping address is a ","

Any clue? Thanks,
Achyuta