how do i change prices for all items in that category?

8 Feb 2011, 4:26 PM

#1

New Zenner

Join Date:: Dec 2010
Posts:: 65
Plugin Contributions:: 0

how do i change prices for all items in that category?

this is my website https://www.originalkickz.com i want to change the prices in one category for those shoes specifically and do not want to edit the price one by one which will take forever. Is there an easier way to just change all the prices to the same amount without all the hassle? Thanks

8 Feb 2011, 4:44 PM

#2

drgr33n

New Zenner

Join Date:: Oct 2010
Posts:: 84
Plugin Contributions:: 0

Re: how do i change prices for all items in that category?

You could write a simple script

$select_items = $db->execute("SELECT $foo
FROM " . TABLE . "
WHERE category_id= " . id);

while( !$select_items->EOF ) {
list( $blah, $blah2 ) = array_values($select_items->fields);
$edit_data$db->execute"INSERT INTO TABLE ($foo) VALUES ('$price')");
}

8 Feb 2011, 4:52 PM

#3

mubasher

New Zenner