7 replies [Last post]
kosmic's picture
Offline
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

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6841
Re: Oscommerce to Ubercart

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.

Guest (not verified)
Guest's picture
Notes from a OSCommerce to Ubercart igratio

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

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: Notes from a OSCommerce to Ubercart igratio

Rock on. Thanks for posting the link, Dirk.

fsiddiqi's picture
Offline
Joined: 01/02/2008
Juice: 22
OSCommerce Cutomer import?

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.

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: OSCommerce Cutomer import?

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.

dave1715's picture
Offline
Joined: 04/15/2011
Juice: 3
Hi everyone,

Still looking for some simple method to transfer my store from oscommerce to uberacart. I have more than 800 products, so it seems to be a whole lot of work. Can you recommend me something to do it quckly?!

qrios's picture
Offline
Cool profile pic award.Getting busy with the Ubercode.Internationalizationizer
Joined: 08/13/2007
Juice: 554
Hi, There is no simple point

Hi,
There is no simple point and click way of doing this. The data structure of both defer so much that you will have to do at least some things manually.
Look here also: http://www.ubercart.org/project/node_import_uc_product

Regards,

Loungekussenshop