BV Commerce Forum
»
BV Commerce Support
»
How Do I? Questions
»
Refreshing existing old product items into new arrivals
Rank: Member
Joined: 9/8/2008(UTC)
Posts: 16
|
Refreshing existing old product items into new arrivals?
We have 10000 items on our site. How do we refresh certain items to new arrivals without having to recreate the product?
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
New item status is controlled by the "DateCreated" field. If you update that field the products will be flagged as new again.
|
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
hmmm... maybe adding a date created field to the admin product page edit would be a good thing to do so you can update it from the admin instead of opening up the database... but i dont know how to add that ;)
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Pretty straight forward. Go to the query analyzer in SQL Server and execute the statement:
UPDATE bvc_Product SET CreationDate = getdate() WHERE ...
Fill up your where condition appropriately. All you are doing here is updating the creationdate field for specific products to today. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 11/25/2003(UTC)
Posts: 370
|
If you have a developer add an AJAX button to the product detail that will update the 'Creation Date' |
|
|
|
|
|
|
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.