BV Commerce Forum
»
BV Commerce Support
»
Development
»
Need BVC5 SQL Append and Update Tables
Rank: Member
Joined: 10/9/2008(UTC)
Posts: 45
|
Hi,
We are changing our many carts to one format based on BVC5. In doing this we are consolidating our product info for all sites to Stone Edge order Manager. Then we will use a middle "Content Manager" to push the Manaufacturer, categories, and Products to the BVC5 carts.
We are in the last stage of building the content manager to manage our 80+ carts from one tool. We have tried the import 1032 tool to see how the import worked, and are now using ODBC to connect direct.
In BVC5 there are SQL tables for Product that need to be populated as the product is written to the cart SQL products table. One is customURL that we are writing to. Is there anyone who has done a complete import using only ODBC that may have a list of tables to write to, and the order in which to write? and if there is any update trigger we need to run please let me know.
Thank you,
Mark
GM The Power Shopper
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Hello Mark,
Can you please be more specific. I definitely could not understand. There are no triggers per say. But a lot does happen when you add an item to the cart. It really depends on what functionality you need. If you can explain what you are trying to achieve, we can suggest something. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 10/9/2008(UTC)
Posts: 45
|
Hi Satya, Had to push forward to get this done. got the issues solved and we are pushing data up direct to BVC5 tables and creating the items and options there as well. We found key violations were our problem. Once we got the order to load straight we were fine.
Thank you,
Mark Domaille
|
|
|
|
|
|
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.