BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Copying sales order from one BVC store to another
Rank: Member
Joined: 11/15/2006(UTC)
Posts: 52
|
Two BVC stores will be run in tandem, while a user transition is undertaken, one of which is a new store. At some point the old store will be turned off. There is a need to take all sales orders from the old store and put them in the new one. Is there a tool to do this? Can the sales order API be used in some way? Is it wise to copy all relevant rows from all applicable tables using T-SQL?
All advice appreciated.
Thanks.
|
|
|
|
|
|
Rank: Member
Joined: 11/15/2006(UTC)
Posts: 52
|
I exported an order using code like so:
[2]
Dim[/2][2]As[/2][2]Of[/2][2]Nothing[/2]
[2]CInt[/2][2]CInt[/2][2]Me[/2][2]For[/2][2]Each[/2][2]As[/2][2]In[/2][2]If[/2][2]False[/2][2]Then
[/2][2]End[/2][2]If</P>[/2][2]Next</P>[/2]</FONT>
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Orders.Order.FindByRange does not pull line items with the order. You need to do an individual FindByBvin call to get the line items too.
|
|
|
|
|
|
Rank: Member
Joined: 11/15/2006(UTC)
Posts: 52
|
Originally Posted by: "Marcus" 
Orders.Order.FindByRange does not pull line items with the order. You need to do an individual FindByBvin call to get the line items too.
Thanks. That worked.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.