Hmm... I need to find out myself. I don't know what is the answer to that question. I'll do some research in Google and get back to you if I find an good answer. You should email the people at iPage as they probably could give you help..
Well, you could share the same database as long as both sites were yours... but what I have in mind is to own the wholesale/dropship iPage site and sell you the retailer my product at a specific cost..
You on the other hand, the retail iPage site would be marketing the products, and setting your own pricing. I doubt if you'd like me lurking through your business back end. I know I don't want my customers, sharing my database..
I envision a whole new twist to affilliate / broker sales...
From what I've seen in oscommerce and in the contributions, everything is here except one thing. That is the automatic export / import of the data. If that's possible, please tell me how..
You could create two cron jobs that handle this for you. One runs on the retailer side and one that runs on your side. The retailer one would run a SQL file that runs a query to get all the orders for the day, then exports them to an XML file or something. It would then FTP the file up to your server and another cron job would run later that day against all the uploaded files that imports the data into your database...
That sounds feasible. Do you know how to write that? It's a little more than I know how to do?..