Jmckinstry: New page: = 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 se...

2009-11-02T17:33:55Z

New page: = 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 se...

New page

= 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 [http://bugzitsu.isoftdata.com/show_bug.cgi?id=849 Bug 849] for more details.

[[Category:ITrack/Enterprise]]

Talk:ITrack/Enterprise/Remote Store Sales - Revision history

Jmckinstry: New page: = 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 se...