VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Google Site Map Y or N
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

VP-ASP New User

70 Posts

Posted - March 11 2010 :  15:31:41  Show Profile  Visit standout's Homepage  Reply with Quote
We are using 7.0 and originally created our 4000+ products with the Google Map set to "no". We obviously don't want to go thru each item manually to switch to "yes"; however, when we tried to upload the updated spreadsheet noting "1" in the database column for "yes" it didn't make the changes.

Any suggestions?

STANDOUT Promotional Products
Port Perry, Ontario, Canada

VP-ASP Expert

590 Posts

Posted - March 14 2010 :  05:59:47  Show Profile  Reply with Quote
We use a stand alone generator (http://www.xml-sitemaps.com/). I've found this far mor effective than any of the VP add ins as it really goes through the site with a fine tooth comb in the same way as a search engine would.

Sex toys from a UK sex shop including vibrators and dildos.
Go to Top of Page

VP-ASP New User

191 Posts

Posted - May 16 2010 :  14:40:46  Show Profile  Visit savvymedias's Homepage  Reply with Quote
I second http://www.xml-sitemaps.com/ .

To answer your original question,

Go to Misc > Query

Export out the product ids --

Add columns:

smFrequency smPriority gsmincluded
weekly 0.5 Yes

And import back into the products table.

It is easier if you can do an update to the table with SQL but I am assuming you would have done it already if you knew how.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000