Talk:ITrack/Enterprise/Remote Store Sales

Remote Store Sales

Enterprise provides the ability to control which stores are allowed to sell to other stores, as well as which, if you so wish. This is done by enabling the store setting Remote Sales: Enable regulation of remote sales.

Controlling Remote Store Sales

Currently, there is no user interface for modifying the remote stores list, so the changes have to be made directly on the database. The table storeremotesales controls which stores are able to sell to others, and determines which. In order to see which stores a specific store can sell to, you can run the following query:

SELECT `partatstoreid` AS `can_sell_to_storeid` FROM `storeremotesales` WHERE `storeid` = 1

If you wish to reset the table, the following query allows every store to sell to every other store:

TRUNCATE TABLE `storeremotesales`;

INSERT INTO `storeremotesales` (`storeid`, `partatstoreid`) SELECT `a`.`storeid`, `b`.`storeid` FROM `store` AS `a` JOIN `store` AS `b` ON `a`.`storeid` != `b`.`storeid` ORDER BY `a`.`storeid`, `b`.`storeid`;

User Interface

While a user interface for changing these values is in the works, we do not currently have a timeline for it. Please see Bug 849 for more details.