Oscommerce Customer import?

[Znapper]

Hello!
First of all i want to say: GREAT Shop!

And now over to my question. I have Oscommerce shop and need to get my user accounts with adresses and orderhistory over to Presta!

Any1 knows how to import users from oscommerce? Script? Gudie? Pls!

[prestabase]

Znapper,

You can export your customer list with oscommerce, then make the necessary changes to the spreadsheet so it is compatible with PrestaStore. Once updated, simply upload that spreadsheet into your PrestaStore.

[TropischBruin]

Find you answer here!

[Znapper]

Thanks,
Got the customer over, but now when i need adress import it cant save...

[Znapper]

Got it to work:

To import user adress from Oscommerce you have to add your CSV file and add Alias and a Email add.. Tried different editing of CVS, and when i added te email add, the adress was imported to the real user...

bbbb <--- alias ,4 <--- ID ,[email protected] <--- Email ,Name,LastName,Adress,123 45 <----Postal code ,State,Country

The CSV file from Oscommerce doesent include the mail add, you have to add it.. Why dont change the import function to just look that the ID match? The mail is alredy in the user from the user import...

[dbasch]

Here is the SQL query to get the address information along with the customer information.

SELECT *
FROM `customers`
LEFT JOIN `address_book` ON `customers`.`customers_default_address_id` = `address_book`.`address_book_id`

You can link an address to a customer, by using the same email address for the customer email field and the address alias field.