Home » Forums » Ubercart » Development

Oscommerce to Ubercart

5 replies [Last post]
Submitted on Tue, 10/16/2007 - 09:58
kosmic
kosmic's picture
Joined: 10/16/2007
Juice: 3

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

#1 Submitted on Tue, 10/16/2007 - 12:04 Top View page
Lyle
Lyle's picture
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6673

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.

#2 Submitted on Sat, 10/20/2007 - 15:48 Top View page
Guest (not verified)
Guest's picture

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

#3 Submitted on Sun, 10/21/2007 - 13:20 Top View page
Ryan
Ryan's picture
Joined: 08/07/2007
Juice: 15046

Rock on. Thanks for posting the link, Dirk.

#4 Submitted on Tue, 01/15/2008 - 23:15 Top View page
fsiddiqi
fsiddiqi's picture
Joined: 01/02/2008
Juice: 22

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.

#5 Submitted on Wed, 01/16/2008 - 09:22 Top View page
Ryan
Ryan's picture
Joined: 08/07/2007
Juice: 15046

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.