[checkout] Editing custom prices for more than one item at a time?

Landis

Joined: 2006-02-24
Posts: 15
Posted: Sat, 2006-02-25 01:32

Is there a way to edit custom prices for more than one item at a time? Currently I'm having to go through an album, click on the photo, click 'edit photo' on the left, and edit the custom field. This is very time consuming for dozens of images. Is there a method similar to the 'edit captions' method that would let me enter the proper numbers for more than one at a time?

I've got a number of different sized images and some that have different prices - so just setting the prices in the checkout module isn't quite enough.

Any suggestions would be greatly appreciated.

By the way: awesome mod - thank you VERY much.
 
turnbulm

Joined: 2004-10-03
Posts: 431
Posted: Sat, 2006-02-25 08:59

Unfortunately there's no way I know of to 'bulk edit' the custom prices at the moment. Thie feature was added in using Custom Fields because it was frequently requested, but there is a pretty big rewrite in the works to entirely change how it all plugs together. I'd hope to be able to get some kind of bulk editing feature in at that time.
 
Landis

Joined: 2006-02-24
Posts: 15
Posted: Sat, 2006-02-25 19:16

Ok, definitely looking forward to the rewrite and this possibility.

In the mean time, is it at all possible to do this directly through MySQL?
 
turnbulm

Joined: 2004-10-03
Posts: 431
Posted: Sat, 2006-02-25 22:34

You definitely could do it directly through MySQL, but I can't tell you what tables you'd need to work on for sure. At a guess though...

  • A custom field record is likely to be a child of a main item - there's a table that maps children to parents
  • Threr is probably a dedicated table for custom field records - the ID in here will be the child ID in the parent->child mapping table
  • After making any changes directly to tthe DB you must flush the DB cache (Site admin -> Maintenance)

Hope this is of some help.
 
Luke7799

Joined: 2007-07-10
Posts: 35
Posted: Thu, 2008-01-24 11:23

This is just what I need to do, be able to somehow bulk edit 70,000 photos to only have 3/5 prices.
Could someone please give me a detailed explanation on how to edit the MySQL tables.
Any help will be fantastic!

Thanks!