Shopping Cart Software e-Commerce Forums

Shopping Cart Software e-Commerce Forums > BV Commerce 5 > BV Commerce 5 Tools and Downloads > Migration Tool - BVC2004 to BV Commerce 5.4 and 5.5 Migration Tool - Requires .Net 3.5 sp1

Forum Quick Jump

[ | Show Newest Post First ]

Marcus
Forum Moderator

Date Joined Nov 2003
Total Posts : 5611

Posted 4/13/2009 12:23 PM (GMT -4)

This is an updated version of the migration tool for moving from BVC 2004.7 to BV Commerce 5.4 and 5.5. This version was rewritten to work directly against databases, skipping the web services.

IMPORTANT: This version requires .net 3.5 to be installed.

USEAGE: Ideally, this tool would run directly on the SQL server where your live databases are located. Second best is on the same local network and the SQL server. Last best is remote.

INVENTORY OPTIONS: There is a new checkbox that you should use if you have disabled all inventory on your BVC 2004 store. The checkbox will make more your bvc5 store more efficient by choosing modifiers instead of choices during the import process. It will also guarantee non-inventory tracking products show up correctly on the new store.

Marcus

Shopping Cart Software

File Attachment :
MigrationTool_BVC2004_to_BVC5_5501.zip 211KB (application/zip)

This file has been downloaded 180 time(s).

Aaron
BVC Expert

Date Joined Apr 2004
Total Posts : 1027

Posted 6/30/2009 6:05 PM (GMT -4)

Is the source code for this available? I don't see it in my account.

Aaron Sherrick
Develisys | Web smart. Market savvy.
Tel 717-566-9455 - Toll free 866-674-4770
www.develisys.com

Roxy
Registered Member

Date Joined Aug 2009
Total Posts : 26

Posted 11/17/2009 5:47 PM (GMT -4)

What if I am on BVC 2004.0? Sounds like I can't use this tool. I generated an email today which sent my version information to support asking the same question.

Aaron
BVC Expert

Date Joined Apr 2004
Total Posts : 1027

Posted 1/5/2010 1:44 PM (GMT -4)

We recently migrated site data from 2004 to 5.6 and it only imported the first Related Item (from BV 2004) as a cross sell (in BV 5). Has anyone else experienced this?

Aaron Sherrick
Develisys Web smart. Market savvy.
Tel 717-566-9455 - Toll free 866-674-4770
www.develisys.com

Marcus
Forum Moderator

Date Joined Nov 2003
Total Posts : 5611

Posted 1/6/2010 10:02 PM (GMT -4)

Aaron,

The import tool should match all related items. They will always come in as cross-sells because 2004 doesn't have an "up-sell" concept.

If you think the tool isn't functioning correctly some sample data for us to try and import would be helpful.

Thanks,
Marcus

Shopping Cart Software

Matt@9BallDesign
Graphics Guru

Date Joined Dec 2003
Total Posts : 2807

Posted 1/7/2010 11:58 AM (GMT -4)

hey aaron,

you mention "imported the first Related Item (from BV 2004) as a cross sell (in BV 5)."

Before I hit the go button.... i am interpreting your statement two ways..lol

1. All related item assignments are imported, however the first one is a cross sell and the rest are up sells

2. Only one related assignment is imported and it is set as a cross sell

can you expand a tiny bit?

thanks

Matt Martell
------------------------------------------------

http://www.9balldesign.com - Web, Print, Graphic

------------------------------------------------

Aaron
BVC Expert

Date Joined Apr 2004
Total Posts : 1027

Posted 1/7/2010 1:02 PM (GMT -4)

Hah, I thought that was probably a bit confusing. My intended meaning was #2 (only one related assignment is imported and it is set as a cross sell).

Let me know how it goes for you. If you run into problems we did write a SQL script to do this import.

Aaron Sherrick
Develisys Web smart. Market savvy.
Tel 717-566-9455 - Toll free 866-674-4770
www.develisys.com

Matt@9BallDesign
Graphics Guru

Date Joined Dec 2003
Total Posts : 2807

Posted 1/7/2010 1:15 PM (GMT -4)

Thanks aaron, I'm cool with the item being assigned as a cross sell.

script pulls all of the 'related items' and imports in (BV2004 -> BV5)?

Matt Martell
------------------------------------------------

http://www.9balldesign.com - Web, Print, Graphic

------------------------------------------------

Aaron
BVC Expert

Date Joined Apr 2004
Total Posts : 1027

Posted 1/7/2010 1:45 PM (GMT -4)

Yes, our script imports all 'Related Items' from BV 2004 to 'Cross Sells' in BV 5. Did the BV import tool work for you?

Aaron Sherrick
Develisys Web smart. Market savvy.
Tel 717-566-9455 - Toll free 866-674-4770
www.develisys.com

Matt@9BallDesign
Graphics Guru

Date Joined Dec 2003
Total Posts : 2807

Posted 1/7/2010 2:39 PM (GMT -4)

I'm going to give it a go later today. just doing all my backups and organizing at the moment. artwork uploads, brewing another pot of coffee, etc...

Matt Martell
------------------------------------------------

http://www.9balldesign.com - Web, Print, Graphic

------------------------------------------------

Matt@9BallDesign
Graphics Guru

Date Joined Dec 2003
Total Posts : 2807

Posted 1/8/2010 4:09 PM (GMT -4)

hey aaron, I'm willing to compensate you for that sql script.

Matt Martell
------------------------------------------------

http://www.9balldesign.com - Web, Print, Graphic

------------------------------------------------

Matt@9BallDesign
Graphics Guru

Date Joined Dec 2003
Total Posts : 2807

Posted 1/12/2010 1:23 PM (GMT -4)

just a heads up that Aaron shared the necessary script with me via email. worked perfectly.

aaron asked for nothing in compensation. I offered buddy....lol.... :)

Matt Martell
------------------------------------------------

http://www.9balldesign.com - Web, Print, Graphic

------------------------------------------------

Aaron
BVC Expert

Date Joined Apr 2004
Total Posts : 1027

Posted 1/12/2010 2:15 PM (GMT -4)

For anyone else that is experiencing this problem, here is the script that I shared with Matt. This is provided as-is with absolutely no warranty, guarantee, etc. Be sure to backup your databases before running it. Before you run the script you will need to do a search/replace of the database names in the script. This script assumes that both your BV 2004 and BV 5 databases are on the same SQL Server. This isn't the most efficient query (it took about 5 minutes to run on a catalog of 3,000 SKU's), but that wasn't a priority when it was written (i.e. get it done ASAP since we will only run this once). Also note that this script deletes any Cross Sells from the BV 5 database that correspond to products in the 2004 database before importing the Related Items.

Aaron Sherrick
Develisys Web smart. Market savvy.
Tel 717-566-9455 - Toll free 866-674-4770
www.develisys.com

File Attachment :
Related Items import.sql.txt 2KB (text/plain)

This file has been downloaded 76 time(s).

Rich
Pro Member

Date Joined Mar 2004
Total Posts : 145

Posted 8/17/2010 5:20 PM (GMT -4)

BVC2004.7 to bv5.7.1 user import problem? Has anyone else tried to import to 5.7.1 using the latest tool? I have recently and the user data will not import. Everything else seems to have been imported correctly except the users. Any help would be appreciated being the updated store is currently live.

Thanks
Rich

Forum Information

Currently it is Thursday, September 09, 2010 2:23 PM (GMT -4)
There are a total of 57,389 posts in 12,471 threads.
In the last 3 days there were 2 new threads and 23 reply posts. View Active Threads

Shopping Cart Software and complete e-Commerce solutions