chrometweaks.org

Where did my iPage web site go how do I get it back?

Click Here To View All Answers...


Quick question... Where did my iPage web site go how do I get it back? Thanks in advance for any comment. Another quick question... My friend was filing the catalogue while I was away and simply forgot to add weight to the products so my question is very simple: can you add weight to a whole category? We have several categories but I have no idea how to correct his mistake..

Sorta related but less important, how do you add a date to a whole category? He forgot that too!.

Yeah, I know, gotta change my friends.....

Comments (58)

Hmm... I need to find out myself. I don't know what is the answer to that question. I'll do some research in Google and get back to you if I got an good answer. You should email the people at iPage as they probably could help you..

Comment #1

You could You could write some sql to set all the wts in a category to the same wt.

Or.

Install a contribution called EasyPopulate and use that..

Comment #2

Unfortunately, we didn't have any files to use along easy populate so that's outta question and well, let's say my sql knowledge is close to zero (actually, it's IS nil) so I have no way to write such thing...

Comment #3

Install EP download a file which will contain all your current products..

Edit the file and add the wts..

Import the file.

Or go to www.w3schools.com.

You will need something along the linews of....

Update product set product_wt = 1.0 where product_caegory_id = 17..

Comment #4

Try the following:.

Edit the $category, $weight, $date as required .. then ...

Save it as a file in shop root (cat_update.php or something) then browse to the file, it will show a list of queries that it WOULD run..

If you are happy with those queries then edit the file and set $testrun = false; run it again and the queries will be actioned..

<?php.

Require_once 'includes/application_top.php';.

// User settings.

$testrun = true;.

$category = 10;.

$weight = 1.0;.

$date = '2009-04-11 00:00:00'; // date("d-m-Y h:i:s").

// End user settings.

$sql = ".

SELECT products_id FROM "TABLE_PRODUCTS_TO_CATEGORIES".

WHERE categories_id = $category";.

$result = tep_db_query($sql);.

While ( $row = tep_db_fetch_array($result) ){.

If ( false !== $testrun ){.

Echo "UPDATE "TABLE_PRODUCTS" SET products_weight = '"(float)$weight"', products_date_available = '"$date"' WHERE products_id = "$row['products_id']""'<br>';.

} else {.

$sql = "UPDATE "TABLE_PRODUCTS" SET products_weight = '"(float)$weight"', products_date_available = '"$date"' WHERE products_id = "(int)$row['products_id']"";.

Tep_db_query($sql);.

}.

}.

Tep_db_free_result($result);.

?>.

This post has been edited by.

FWR Media.

: 11 April 2009, 19:58..

Comment #5

My friend was filing the catalogue while I was away and simply forgot to add weight to the products so my question is very simple: can you add weight to a whole category? We have several categories but I have no idea how to correct his mistake..

Sorta related but less important, how do you add a date to a whole category? He forgot that too!.

Yeah, I know, gotta change my friends.....

Comment #6

I would edit each product and add the weight to them..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.