OsCommerce Data Importer - Errors

Hi
I am looking to import just some products from a OsCommerce webshop to my zen-cart webshop, is it possible to do that?

fredsjo:

Hi
I am looking to import just some products from a OsCommerce webshop to my zen-cart webshop, is it possible to do that?

1. import_osc_configure.php
   Open file and define the mysql server, data base name, user, password, MYSQL Character Set code

2. import_osc_customers.php
   Run if you want to transfer Customers

3. import_osc_products.php
   Run if you want to transfer Products

4. import_osc_orders.php
   Run if you want to transfer Orders

You can not select what records are transfered within each group, all records are transfered.

Skip

So I just used this contribution and was very impressed at the speed and how well it worked (and I had a store with 2,000 items!)
Everything transfered except the photos. Now I know I have to move my photos to a certain folder and then ping they should show up... but where do I put them??
Thanks guys!

pattie1970:

So I just used this contribution and was very impressed at the speed and how well it worked (and I had a store with 2,000 items!)
Everything transfered except the photos. Now I know I have to move my photos to a certain folder and then ping they should show up... but where do I put them??
Thanks guys!
I think I figured it out... I am copying the current Images folder from the OSC version of the store and moving it to the Images folder for the Zen cart version. On my products page I can see where it shows the correct names for the photos so I assume this is all I need to do.
Cudos for the person(s) who developed this! What a HUGE time saver ;)

Hi Skip,
I am transferring another site over to Zen Cart using your script. I had the same problems as before with the customers numbers not matching the address book. I cleaned that up and got it work.
This time im having a problem with "import_osc_orders.php".
It freezes on this line:
Exporting Orders Status ...
...3 -|

Done 3 Records Exported
Exporting Orders Status History ...
.......................................................................................................................................................................................................200 -|
.......................................................................................................................................................................................................400 -|
....................................................

Is this another case where the old oscommerce database numbering is messed up and if so what do I need to match up?
Thank you very much,
Matt

Matt,
I had similar problem with the orders status. If my recollection is correct, I disabled that particular table and ran the others successfully. That table only had limited columns so I manually imported it. The only issue I had was that before I manually imported it, some of the orders status's were missing. When the admin searched through the records, if there wasn't a status, it generated one dated today. Suddenly some of my client's orders from years ago appeared as having just been placed. So don't do very much with the imported data without making sure you get all of those order status records moved over either thru the import or manually.

Best of luck!

Jim

skipwater:

In the admin are all the Categories / Products showing?

All your languages files are in /includes/languages/Italian

Are the Category set to active?

Are the Products set to active?

Check that your Admin and Catalog are using the same database:
/includes/configure.php
/admin/includes/configure.php

Skip

I have this problem, and could not find a resolution in the forum. I see the products in the admin. The categories display in the front end, but *some *of the products do not. The categories and products are all "enabled" and they are visible when searched from the front end search feature. I switched to the default template to confirm that it was not specific to my template, and it is not.

This is the url:
http://detroitshirt.com/cart/index.php

For an example, the Men's category when clicked does not display the products, but when you search for "belle isle racing club" the product from this category is displayed in the results.
Also, when "stickers" category is clicked, the products do display for this one.
Any ideas would be appreciated!

Thanks

jdyach:

I have this problem, and could not find a resolution in the forum. I see the products in the admin. The categories display in the front end, but *some *of the products do not. The categories and products are all "enabled" and they are visible when searched from the front end search feature. I switched to the default template to confirm that it was not specific to my template, and it is not.

This is the url:
http://detroitshirt.com/cart/index.php

For an example, the Men's category when clicked does not display the products, but when you search for "belle isle racing club" the product from this category is displayed in the results.
Also, when "stickers" category is clicked, the products do display for this one.
Any ideas would be appreciated!

Thanks

Check the products_to_categories table. If the categories_id values do not matched the categories_id value in the categories table, then most likely that is your trouble.

You are getting your category menus so I think the products_to_categories values are incorrect so when you select a category to show products there is no matching product id to link up a product.

Skip

skipwater:

Check the products_to_categories table. If the categories_id values do not matched the categories_id value in the categories table, then most likely that is your trouble.

You are getting your category menus so I think the products_to_categories values are incorrect so when you select a category to show products there is no matching product id to link up a product.

Skip

This was in fact the problem. Thank you!

Please can some one just help me out here i am moving everything over to zen cart using the os data transfer but keep getting errors

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 811 bytes) in /var/www/siteimport/import_osc_products.php on line 354

when i manually edit the code it just moves to a different line i have seen the fix somewhere when i had this problem last year i just can't remeber what it was i did

Thanks in advance

Looks like your php memory setting is 16M and you are trying to use more then you have. If you have access to your php.ini increase the memory say to 64M some systems can go as high as 128M. If you do not have access to your php.ini file you could create your own see http://www.zen-cart.com/forum/showpost.php?p=656459&postcount=2.

Skip

Many thanks for this, have successfully converted all products over.

Just one problem (which I think could be connected to converting over meta), the product pages are not displaying title within the browser at the very top, it just says 'Mozilla Firefox' and no meta. On viewing source, I am getting <title></title> with no product title showing.

Any ideas?

Sunburn:

Many thanks for this, have successfully converted all products over.

Just one problem (which I think could be connected to converting over meta), the product pages are not displaying title within the browser at the very top, it just says 'Mozilla Firefox' and no meta. On viewing source, I am getting <title></title> with no product title showing.

Any ideas?

Using the import_osc_meta_tags.php you would need to edit the code because osc has no common meta-tag system.

What template are you using have you tried the default template and see if the title shows?

Skip

Thanks for your reply skip.

I am actually using the default template. I had header tags controller for osc set up so think it may have copied over info from that and confused it possibly?

I did a clean install of OSC 2.2 Release Candidate 2a and Zen Cart 1.3.8a, Patch: 1:: Database Patch Level: 1.3.8 to test OsCommerce Data Importer on a test site before using it on a client's site and I'm getting the following errors on the customer page. I saw a thread about this but didn't see a good resolution of the problem. I only want to use it for customers. Please help! Thanks.

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/n4nmco5/public_html/zencart/admin/customers.php on line 1099

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/n4nmco5/public_html/zencart/admin/customers.php on line 1101

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/n4nmco5/public_html/zencart/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/n4nmco5/public_html/zencart/admin/includes/classes/object_info.php on line 30

Thanks

max101:

I did a clean install of OSC 2.2 Release Candidate 2a and Zen Cart 1.3.8a, Patch: 1:: Database Patch Level: 1.3.8 to test OsCommerce Data Importer on a test site before using it on a client's site and I'm getting the following errors on the customer page. I saw a thread about this but didn't see a good resolution of the problem. I only want to use it for customers. Please help! Thanks.

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/n4nmco5/public_html/zencart/admin/customers.php on line 1099

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/n4nmco5/public_html/zencart/admin/customers.php on line 1101

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/n4nmco5/public_html/zencart/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/n4nmco5/public_html/zencart/admin/includes/classes/object_info.php on line 30

Thanks

Sorry but I am at a loss to your errors because none of these file calls are done in the OsCommerce Data Importer mod.

Are these errors after the data transfer?

Skip

The errors happen after the import. The customers page is fine before the import. I'm only doing a customers import. Does that matter?

I used the osCommerce Data Importer in version 1.8 - and got the products, customers and so on exported into Zen-Cart 1.3.8a but Categories and Products did not show as they should. My guess is that happened because both the osCommerce and Zen-Cart stores are using Norwegian as their default language. Is this now fixed with version 1.9??

Thanks,
Geir

RsUnv:

I used the osCommerce Data Importer in version 1.8 - and got the products, customers and so on exported into Zen-Cart 1.3.8a but Categories and Products did not show as they should. My guess is that happened because both the osCommerce and Zen-Cart stores are using Norwegian as their default language. Is this now fixed with version 1.9??

Thanks,
Geir

There was no change in 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 Norwegian ?

After you check and see what value Norwegian 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.

ok so ive installed the contrib - but the only prob that i have is that my osc files are all backup in a download file (i had to remove osc to install zen) so what do i do now? do i re-install osc or is there a way i can create another DB - keep in mind i dont know a whole lot about databases :)

thanks