Rank: Member
Joined: 6/27/2007(UTC)
Posts: 63
|
I'm getting the following error everytime when attempting to run a data migration during the products migration (see attached screenshot). Please let me know what we need to do to complete the data migration - thanks! blueacorn attached the following image(s):  bv_migration_tool_error.jpg (16kb) downloaded 47 time(s).You cannot view/download attachments. Try to login or register. |
|
|
|
|
|
|
Rank: Member
Joined: 6/27/2007(UTC)
Posts: 63
|
Thought I should clarify I'm referring to the BVC2004 - BV5 migration and I am using the latest version of the tool 5.3.0.1 |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
List All Paged is only available in 2004.9. If your store is 2004.7 you can not use the "paged" option.
|
|
|
|
|
|
Rank: Member
Joined: 6/27/2007(UTC)
Posts: 63
|
I was able to complete the product migration using a previous version of the migration tool, everything appears to have migrated correctly. The products appear in the admin, are correctly categorized, but in the store interface nothing shows up. I've checked to make sure the products are active, using the default template for now. My guess is there's some table not being populated or something? Anything specifically I should check for?
FYI - the products themselves show up just fine when browsing to their URL directly. |
|
|
|
|
|
|
Rank: Member
Joined: 6/27/2007(UTC)
Posts: 63
|
Did some digging around in the db - and encountered something strange. The bvc_product table's bvin column shows the SKU (vs. a GUID) and the bvc_productXCategory table also shows the SKU and category # instead of the respective GUIDs. Is this the expected behavior of the migration? I have a feeling this is why the products aren't showing up because it's expecting a GUID but it's getting a SKU? |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
The Bvin field can be any unique string. As long as your SKU's are unique, they will work fine. I have no idea why the products are not displayed in the front-end. |
|
|
|
|
|
|
Rank: Member
Joined: 6/27/2007(UTC)
Posts: 63
|
Thanks Andy, I think I've found the answer, I still need to do some testing to verify but it looks like it defaulted the track inventory field to "1" and had an inventory of 0 - even though the option was set to leave on the store it would remove it from the store (they're not tracking inventory so everything is 0 qty). If I went into the admin and reset those fields it showed up. I was only working with one test product though so I'm going to reimport them all and run a SQL update to make sure those fields are set accordingly and see if that fixes it. |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
I have a 5.3.0.3version of the import tool ready to go in tomorrow that should correct the inventory flag for sites with "inventory disabled" at the store level.
|
|
|
|
|
|
Rank: Member
Joined: 6/27/2007(UTC)
Posts: 63
|
Well, after looking into it even further, the issue is that the bvc_ProductInventory table isn't populated with any data after import. So just by going into a product and clicking on the save button, it creates the appropriate record in the table and then the product shows up. So again, to recap the setting is that inventory is enabled, and it is set to leave on store if inventory is 0 - which in our case all products are 0. But, apparently, because there is no corresponding record in the bvc_ProductInventory table it does not show up.
So to fix it in my case, I either need to go into each product and save them to initiate the bvc_ProductInventory record, or, run a SQL update to ignore all inventory (TrackInventory = 0) - so Marcus if you are working on a fix, I think the issue is with the bvc_ProductInventory table not being populated during migration. Feel free to contact me if you'd like more details to help you troubleshoot. |
|
|
|
|
|
|
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.