Importing only customers and previous orders

[nathanzachary]

Hello,

I have finally gotten my OSCM installation almost customised the way I had my old OSC. I am going to re-create all the items in the store, but I would like to be able to have my customers and previous orders imported. I don't want users to have to re-register. Is there a clean way to accomplish this task?

Thank you preemptively.

[ridexbuilder]

By using phpmyadmin to export/import all the relevant tables.

[jdistad]

I think this topic should be addressed completely in a nice easy to follow tutorial. The voodoo magic that has been used to describe a site migration from osc to oscmax amazes me. I have gone through this process and it can be a nightmare until you get it right, I know I would have really appreciated some solid meaningful documentation on this process.

For a process that so many will be doing there should be a sticky tutorial completely outlining the steps to complete a database migration from osc to oscmax. I see the same answers all the time here to questions where they are answered by simply rephrasing the question.

When someone asks "How to I make scrambled eggs?" the correct way to answer then is NOT to say "you scramble some eggs" Make sense??

[nathanzachary]

I guess I was asking whether or not OSCM modified any of the database structures from OSC. If not, then I should be able to dump the appropriate tables from OSC using phpMyAdmin and then add them into the new database.

As I look at the structure, it seems like I will need to use the following OSC tables:

address_book
customers
customers_info*
orders
orders_products**
orders_products_attributes**
orders_status_history
orders_total

*I'm not sure about this one as it contains last login dates from before the OSCM store creation.

**As I have completely gone through and re-entered all the products and product attributes, I hope this one doesn't mess up anything. I had a problem with my original OSC installation where the quantities were not updated when someone purchased an item with attributes.

Any further insight would be helpful.
Thank you again.

[ridexbuilder]

Originally Posted by jdistad

I think this topic should be addressed completely in a nice easy to follow tutorial.

If so inclined, why not write the wiki document yourself? [There has been a lot of free information given out recently, which should be known already by any IT person with some modicum of professionalism.]

There really is no magic involved, only an inkling of how databases are structured, how tables are linked etc.
Some of us to try (unsuccessfully, in some cases) to make some pennies from doing this. On a piece of free software, would you like the migration done for you?
The information is there, if one chooses to use the internet to its' best capabilities.

[Having seen some of the amateurish attempts at setting up what is essentially a fairly complex piece of software, the mind boggles as to the damage that can made from users 'fiddling' with data structures.]
Remember, some users of this forum are 'developers' and some run a business and don't want to 'program' - with all points in between.

[jdistad]

Originally Posted by ridexbuilder

If so inclined, why not write the wiki document yourself?

Well, mainly because I'm not a member of the osCMax Team so its not my responsibility. I think providing support, assistance and useful help for things like this should fall firmly on the shoulders of those who develop and produce the product itself.

I do understand this is a community and everyone contributes but when those behind producing the product don't want to help on a given topic noone else will either.

IF you want to make money on this, that's great but at least make a sticky post saying something like "If you would like an osc to oscmax migration completed for you, the price is $, contact us here" OR if you would like to purchase a step by step tutorial on how to do this the price is $" etc etc etc.. The premium tutorial method of site monetization isn't new and can be very effective if implemented properly.

Make the information readily available

[ridexbuilder]

Originally Posted by jdistad

... I'm not a member of the osCMax Team so its not my responsibility. I think providing support, assistance and useful help for things like this should fall firmly on the shoulders of those who develop and produce the product itself...

Just so that there is no ambiguity: osCMax Team members do not get paid for any part of being on the team. We are volunteers, who give our advice and help in our own free time. We are just like any other person who posts on here, just more prolific in trying to assist.
In using this open-source software, it is everyone's responsibility to contribute, on moral grounds alone. It is principally through the extremely generous efforts of Michael_S that this software is made available. I feel obliged to assist where/when I can but under no obligation.

[nathanzachary]

As a Gentoo Linux developer, I completely understand and embrace open contribution (including documentation). Therefore, I would be willing to help write documentation, but I need to successfully get it done on this site firstly. I'm just a little nervous about the inventory issue that I mentioned. I am switching to OSCM for a multitude of reasons, but one of the main ones is the hope that it will fix that problem.

[jdistad]

Originally Posted by ridexbuilder

Just so that there is no ambiguity: osCMax Team members do not get paid for any part of being on the team.

I understand that completely and respect those who do what you do very much. It's the following part that my entire meaning for this can be summed up.

Originally Posted by ridexbuilder

We are just like any other person who posts on here, just more prolific in trying to assist.

When users come here for years looking for assistance and asking endless questions on how to move a store from oscommerce to oscmax and there are no solid answers, tutorials or instructions included, it makes the entire process a PITA for many people (most will just give up or seriously break something in the process). I would imagine one of the goals of the Team would be to get as many people using oscmax as possible, perhaps helping people move from osc would aid in that task?

[ridexbuilder]

Originally Posted by jdistad

...move a store from oscommerce to oscmax ...

[There has been some background discussion on this recently but I don't wish to elaborate. ]

Originally Posted by jdistad

...come here for years looking for assistance and asking endless questions...

Not any different to me, on some subject areas and sometimes with no solution. So I write my own - eventually and where I can.