• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
4 Pages<1234>
BV Commerce 5 Import/Export Tool - Version 1.2
Options Go to last post Go to first unread
Previous Topic Next Topic
danjha
#41 Posted : Friday, November 16, 2007 9:47:53 AM(UTC)
danjha

Rank: Member

Joined: 9/24/2007(UTC)
Posts: 7
Marcus is this possible? Can you release the source?
Marcus
#42 Posted : Friday, November 16, 2007 10:34:48 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786
Ebijs
#43 Posted : Friday, November 16, 2007 10:48:47 AM(UTC)
Ebijs

Rank: Member

Joined: 5/2/2004(UTC)
Posts: 109
Many thanks BV Commerce!
I appreciate that very much!

Ebijs.

Edited by user Monday, March 4, 2013 5:33:59 PM(UTC)  | Reason: Not specified
danjha
#44 Posted : Monday, November 19, 2007 4:54:03 AM(UTC)
danjha

Rank: Member

Joined: 9/24/2007(UTC)
Posts: 7
Thank you for releasing this - it will help me greatly.
Surfscience
#45 Posted : Monday, November 19, 2007 4:27:05 PM(UTC)
Surfscience

Rank: Member

Joined: 2/7/2006(UTC)
Posts: 66
Thanks Marcus, been desperate for this. I've posted some thoughts on codeplex.
Carbon Mods
Carbon Fibre Performance Components
buzworks
#46 Posted : Wednesday, November 28, 2007 11:54:33 PM(UTC)
buzworks

Rank: Member

Joined: 11/21/2006(UTC)
Posts: 29
Alright guys I have been over and over the docs and I am still getting an error, below is the log file, but only when i export the products. Users and categories work great. I just wanted to make sure that i could export before i did an import. Any thoughts would sure help.

Starting Export at 11/28/2007 10:47:54 PM
Export mode: product
Logging Into Web Store
Using Store: http://www.mysite.com/WebServices3.asmx
Successfully logged into store
Getting List of Products
Export Error: There is an error in XML document (3781, 12404). - at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at BvcImportTool.BVweb.WebServices3.Catalog_InternalProduct_FindByCriteria_WithPaging(AuthenticationToken& token, ProductSearchCriteria ProductSearchCriteria, Int32 startRowIndex, Int32 maximumRows, Int32& rowCount)
at BvcImportTool.Core.Modules.ProductTranslator.Export()
at BvcImportTool.MainForm.btnExport_Click(Object sender, EventArgs e) Deserialize
buzworks
#47 Posted : Wednesday, November 28, 2007 11:55:31 PM(UTC)
buzworks

Rank: Member

Joined: 11/21/2006(UTC)
Posts: 29
Sorry the store is sp2 and the import tool is 1.2.0.0
Marcus
#48 Posted : Thursday, November 29, 2007 12:11:37 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786
Do you have html in your product descriptions? I suspect something isn't getting correctly encoded/decoded in the SOAP web services call.
Coleen
#49 Posted : Friday, November 30, 2007 1:49:06 PM(UTC)
Coleen

Rank: Member

Joined: 4/30/2007(UTC)
Posts: 383
Will this work in the new SP3 release?
Coleen
#50 Posted : Saturday, December 1, 2007 4:28:28 PM(UTC)
Coleen

Rank: Member

Joined: 4/30/2007(UTC)
Posts: 383
Exporting works fine so far in Sp3 but it does NOT export category placements of products.
emunah
#51 Posted : Monday, March 10, 2008 10:14:45 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111
when I hit import it says unrecognizable file
mikewendricks
#52 Posted : Monday, July 14, 2008 11:13:11 AM(UTC)
mikewendricks

Rank: Member

Joined: 12/13/2005(UTC)
Posts: 43
I have 2600 products I'm trying to import and I'm not sure how to tell the products what category to go in on my excel sheet. I did product and category export but my category field is blank so I'm stuck, if anyone can help that would be great! I would assume the category field would have numbers in it so I'd know what the category numbers are?


Please help ASAP
mikewendricks
#53 Posted : Tuesday, July 15, 2008 12:24:53 PM(UTC)
mikewendricks

Rank: Member

Joined: 12/13/2005(UTC)
Posts: 43
HELP!
Surfscience
#54 Posted : Wednesday, July 16, 2008 10:36:21 AM(UTC)
Surfscience

Rank: Member

Joined: 2/7/2006(UTC)
Posts: 66
You'll need to know the 'Bvin' for each category. I'm sure there are cleverer ways to do this but here's how I did it:


  1. Go into the DB and into the categories table.
  2. Do a simple query to list the category names and their Bvins (Bvin is just B V Identification Number and is the unique column in most BV tables) - If you switch to table view you should then be able to highlight and copy all of the category names and bvins.
  3. Now switch to Excel and create a new spreadsheet and paste the category names and bvins. You'll use this as a lookup table.
  4. In the file you're preparing for import create a new, temporary column for your category names (make it to the left of the CategoryID column). Use the correct category names (as they appear on your site) in this column.
  5. Next, in the real category ID column that the importer is expecting do a lookup (check Excel help if you've never done this before) to retrieve the Bvin that corrisponds to the category name in the temporary column.
  6. You should now have a plain English category name and a Bvin next to it. Check with the lookup table to make sure they're getting mapped correctly, each time the category changes as you go down your products list you should see a different Bvin).
  7. When you're done (if there are any blanks check your spelling of your category names) save the results as the .CSV file as detailed in the importer help.
  8. IMPORTANT! - Now open the .CSV file and delete the plain English category name column.
  9. Save it back out.


If you don't have many categories you could skip the whole lookup section and just paste the correct IDs in yourself. If you don't have access to your DB and don't have too many categories then you could simply go to each category's edit page and note down the Bvin from the URL string:

http://www.yoursite.com/BVAdmin/Catalog/Categories_Edit.aspx?id=9cdedead-ac7c-4dd9-a8b3-76b7d417b7f7

That last bit (after id=) is your category ID.

This all assumes that the products have never been in your DB. Re-reading your post I'm not clear if they have or not. If they have you should be able to get their category id's out of the DB directly.

Hope that helps, Matt

Edited by user Monday, March 4, 2013 5:38:03 PM(UTC)  | Reason: Not specified

Carbon Mods
Carbon Fibre Performance Components
mikewendricks
#55 Posted : Wednesday, July 16, 2008 1:12:32 PM(UTC)
mikewendricks

Rank: Member

Joined: 12/13/2005(UTC)
Posts: 43
so for this row below would: ed38d76e-00c0-44e0-9713-b32b31c6485d</TD>
[td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 41pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" align=right width=55 x:num]0[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 119pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=158]Blown Glass[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=72][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 77pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" align=middle width=103 x:bool="FALSE"]FALSE[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 57pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=76]Manual[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 71pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=95]Bulk Order List[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 44pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=58][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 36pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=48][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 37pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" align=middle width=49 x:bool="FALSE"]FALSE[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 75pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=100][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 50pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=66][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 48pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=64][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 48pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" align=middle width=64 x:bool="TRUE"]TRUE[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 45pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=60][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 71pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=94][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 77pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=102][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 80pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=107][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 81pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=108][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 74pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=98][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 149pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" align=middle width=198 x:bool="FALSE"]FALSE[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 74pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=99]http://[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 96pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=128][color=#000000> - None -[/color]</FONT>[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 101pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=135][color=#000000> - None -[/color]</FONT>[/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 114pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" width=152][/td][td style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 93pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" align=right width=124 x:num]0[/td][td class=xl22 style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 71pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent" align=right width=94 x:num="39603.424756944441"]6/4/2008 10:11[/td]</TR>
</TABLE>
Surfscience
#56 Posted : Tuesday, July 29, 2008 3:03:15 AM(UTC)
Surfscience

Rank: Member

Joined: 2/7/2006(UTC)
Posts: 66
That's what category IDs look like yes
Carbon Mods
Carbon Fibre Performance Components
jimmarx
#57 Posted : Thursday, August 7, 2008 2:19:27 PM(UTC)
jimmarx

Rank: Member

Joined: 7/24/2008(UTC)
Posts: 5
I am unable to login with the tool to our site. The site is a wholesale only site so you need to login to a main entry page before accessing the store. My guess is that this is the problem that is keeping the BVC5 tool from accessing the files it needs. Is there a way to make this work? The site is broadbay.biz.




Thanks!

Jim
spouliot
#58 Posted : Tuesday, November 18, 2008 11:32:09 PM(UTC)
spouliot

Rank: Member

Joined: 9/24/2005(UTC)
Posts: 28
Marcus,

Could you give me a quick rundown of where to look if I wanted to add a field to the Product table, let's call it "DealerPrice", and have the Import Tool import/export it. I'm looking to do a few customizations to the software for a client of mine, and they need more price levels as a starter project. Any guidance you can offer would be great. I'm kind of under the gun to get this new list of products imported, and while I'm sure I can figure it out.....I'm not sure how long it will take me ;-)

Thanks!
ProgDan
#59 Posted : Monday, December 1, 2008 11:30:50 AM(UTC)
ProgDan

Rank: Member

Joined: 12/1/2008(UTC)
Posts: 31
I am unable to get logged in.

I have put the correct url and username and password but I get an error logging in.

Can someone give me some help?

Thanks

ProgDan
Aaron
#60 Posted : Thursday, December 18, 2008 6:06:00 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,381
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
I'm surprised that this tool doesn't import or export any of the extended production information like choices/modifiers, additional images, up-sells/cross-sells, etc. That would definitely save some time!

Aaron
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
WWW
4 Pages<1234>
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.

Powered by YAF | YAF © 2003-2024, Yet Another Forum.NET
©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012