Well, I'm thinking does an item really have a base price if it's got a different price in every country? Now if the price difference were formulaic, sure, and you'd only have to store the base price and the formula. But taking the example of books sold in US and Canada, why is either price the base price? And as for new items, if you haven't established a price for Canada, then the item can't be sent to Canada yet, so no row is created for the new item for the Canada zone in the item-zone-shipping table until the price and shipping are established. I guess I'm trying to avoid the "logic" of: "if the override price is null..." : ) -----Original Message----- From: rudy [mailto:r937 at interlog.com] how do you get "the" base price out of multiple rows that may all have different prices? what about new items added to inventory before you establish override pricing and shipping to various zones? gotta record the base price somewhere, so do you add an item_zone row with a null zone_id? (ouch) rudy -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !