BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Is there no way to update inventory other than manually?
Rank: Member
Joined: 12/19/2006(UTC)
Posts: 153
|
The SF6 to BV5 migration tool does not update the bvc_ProductInventory table.
The flat file import tool does not have an option to import inventory and does not update the bvc_ProductInventory table.
Using the boards search function I find at least 5 posts on this topic but none of them have a single answer.
What am I missing? Are we really expected to go through each sku and manually type in the number? The inventory batch update might be applicable for established users with inventory levels already inputed, but what about those of us who are importing 600 products?
Thanks for your feedback. . . I realy hope there are some real answers out there.
|
|
|
|
|
|
Rank: Member
Joined: 7/3/2007(UTC)
Posts: 79
|
Hi Mark,
I've recently been creating a new site and imported all my inventory unsing the SQL Server Management tool. I updated the inventory for one product, copied it from the database, then used that as an example to create a txt file to import back into sql server for all my products. You'll need to modify the table so that the BVin is automatically generated using the default value: newid()
I also had to update the main bvc_Product table so that all stock showed as out of stock on the site and that inventory was enabled. Those last 2 had me stumped for a day as I'd successfully uploaded inventory but had no products on the site!
Hope that helps...
Jason
|
|
|
|
|
|
Rank: Member
Joined: 10/15/2006(UTC)
Posts: 37
|
may seem like a silly question, but for a different reason i need to make the bvin column in the CustomrUrl table automatically generate the entires for me.
I read your suggestion above but being new to SQL coding dont know where to start using SQL Server Management Studio Express.
How can i make the bvin column of the CustomURL table do this?
Thanks |
|
|
|
|
|
|
Rank: Member
Joined: 7/3/2007(UTC)
Posts: 79
|
Hi,
All you need to do is right click on the table you want to modify and select "Modify", select the column you want to change, then in the "Default Value" type "newid()" then save your table.
Any new entry should now automatically generate a guid.
Hope that helps!
|
|
|
|
|
|
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.