Rank: Member
Joined: 11/15/2010(UTC)
Posts: 12
|
I'm trying to set up an offer that is valid only for specific products. Due to the large number of products this is valid for, I'd like to add the products to the offer directly in the database, rather than using the admin.
I've created the offer in the admin, but when looking in the database I can't seem to find which table lists the products valid for the particular offer.
Can anyone help point me in the right direction?
Thanks!
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
I believe it's the bvc_ComponentSetting table. It might be easier to script this in .NET so you can use the BV business objects rather than trying to do it in SQL. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 11/15/2010(UTC)
Posts: 12
|
That's the table, thanks Aaron!
Looks like we'll have to do it in .NET, since there is settings1 field in there that I cant identify. Plus, I'm not sure what other tables in the db are affected. Not as quick a job as I had hoped!
|
|
|
|
|
|
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.