Home » Forums » Ubercart » Development

Oscommerce to Ubercart

Submitted by kosmic on Tue, 10/16/2007 - 10:58
kosmic
Posts: 1
 Joined: 10/16/2007

Hi i really would like to transfer my half built oscommerce store to ubercart as im really fed up with hacking this and that to get osc to work...

I have been reading a bit through the threads and im preparing to use the xml schemea to map it out.

I have 56 products so far, but those products do not have a price.. all the pricing is done by attributes and there are about 1050 of them, im having problems understanding where to map theses to, are they're any examples to follow?

Or is there a magic oscommerce to ubercart convertor?...i wish!!

thanks

Claire
permalink #1 Tue, 10/16/2007 - 13:04
Lyle

Posts: 2267
 Joined: 08/07/2007
AdministratoreLiTe!

I think any magic that deals with osCommerce can be considered Deep Magic, and not fit for mere mortals.

Shocked 1050 attributes.... How long does it take to load the attribute edit page for products? uc_attribute.module was designed with that page in mind, as an anti-pattern.

What I can do is show you how osCommerce tables map to Ãœbercart tables. That should help you figure out which values go in which tags in the XML file.

osCommerce Ubercart
products_options uc_attributes
products_options_values uc_attribute_options
products_options_values_to_products_options uc_attribute_options
products_attributes uc_product_attributes
products_attributes uc_product_options

It's probably a good idea to make a few test attributes and products to see where all the data goes. osCommerce doesn't have any equivalent to the price and weight fields in uc_attribute_options, but if most of your products use the same values for those options, you can figure out what to put there.

Good luck.

permalink #2 Sat, 10/20/2007 - 16:48
Guest (not verified)

I'm in the midst of migrating an OSCommerce site to Drupal ubercart. I am taking notes here: http://dirkgomez.de/de/migrating-oscommerce-shop-drupal-ubercart

-- Dirk

permalink #3 Sun, 10/21/2007 - 14:20
Ryan

Posts: 5367
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Rock on. Thanks for posting the link, Dirk.

permalink #4 Wed, 01/16/2008 - 00:15
fsiddiqi
Posts: 10
 Joined: 01/02/2008

Not sure if this is the best place to ask this. I searched, but couldn't find anything.

How about importing customers (I'm mainly concerned about user IDs and passwords) from oscommerce.

Has anyone tried this?

Thanks

--

Followup - my apologies - I found aswalla's excellent post describing his experiences. Pl. disregard if no solution is known.

permalink #5 Wed, 01/16/2008 - 10:22
Ryan

Posts: 5367
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Can't remember what aswalla posted, but for posterity's sake I'll mention that the osCommerce method of storing passwords involves using "salt" on the password... appending some random characters and making an MD5 of it all. You can't undo MD5 hashes to get the original password, unfortunately, and Drupal just uses an MD5 of the password itself. The only way to preserve customers would be to implement a custom user validation that preserves/uses the osC method... and this would get messy pretty fast. Sad

You can at least migrate the customers and let them request new passwords when they want to login.