I have two OsCommerce shops. But I am only intersted in download orders form one of them. The reson i have 2 shops is difrent pricing and difret products
The main webshop is to regular costumers, and the second shop is for my "dealers"
both shops containe many of the same products, but the pricing is difrent.
I am intrested in to transfer ordres for one shop to another.
Shop 1 and Shop 2
I have 3 orders in my "shop2" whit order number 100 101 102 I want to transfer this orders to my "shop1" This shop have difrent order numbers maybe order 500 501 502 503 and so one. When i transfer an order from "shop2" ex order 101, I want this order to get the next free order number in "shop1" ex 504.
I have tried to look for this feature, but can't find anything yet.
I want to handel all my orders from shop1, this because it's more easy to get EDI and Invoic systems to work with only one shop.
I am sorry for my bad english.
Basicly i want to get orders for the sql order tabel sent over 2 another DB whit new order number.
I hope to get some Ides for you out there