Advanced Retail (UK) Ltd
Company Wiki

Two parts 1. Need to create a set of shelf edge labels 2. Need to change price list on the night of change over

We need to TEMPORARILY amend the code [dbo].[traxs_LabelPrinting2_Save] that creates the label as a it will use the price in branch.list_no and not the retail price. Therefore at the store make the following change to :

UPDATE traxs_temp.dbo.__ProductLabels SET 
	_price = P.price,
	_rrp = P.rrp,
	_vat_rate = V.vat_display,
	_vat_calc = (V.vat_rate / 100)+1
FROM 
traxs_temp.dbo.__ProductLabels L
	INNER JOIN prices_live P ON P.product = L.product
	INNER JOIN vat V ON V.vat_code = P.vat_code
WHERE
L.session_id = @session_id AND
P.list_no = 1 -- @list_no ****************************

Next go through the prices label screens and identify the session id for the store by View Source and search for 'session'

Run the following code to add the rows to the temporary tables:

New Store

INSERT INTO traxs_temp..__ProductSearchCore 
(session_id, search_phase, product, barcode, price, rrp, vat_code)
SELECT '<session id>', 1, b.product,B.barcode, price, rrp, vat_code
FROM product P
INNER JOIN barcode B ON B.barcode_id = P.barcode_id
INNER JOIN prices_live L ON L.product = P.product
INNER JOIN min_max M ON M.product = P.product
WHERE
L.list_no = 12 AND
M.branch_no = ??? AND
M.min_stock > 0 AND
L.price <> 0 

Store converting from low price to full price

INSERT INTO traxs_temp..__ProductSearchCore 
(session_id, search_phase, product, barcode, price, rrp, vat_code)
SELECT '<session id>', 1, b.product,B.barcode, l1.price, l1.rrp, l1.vat_code
FROM product P
INNER JOIN barcode B ON B.barcode_id = P.barcode_id
INNER JOIN prices_live L1 ON L1.product = P.product
inner join prices_live L12 ON L12.product = P.product
INNER JOIN min_max M ON M.product = P.product
WHERE
L1.list_no = 1 AND
L12.list_no = 12 AND
M.branch_no = ??? AND
L1.price <> L12.price AND
M.min_stock > 0

Now save the labels and send them to the store and don't forget to change [dbo].[traxs_LabelPrinting2_Save] back to P.list_no = @list_no !!

On the night of change over you need to do the following steps on the store :

(1) change the list_no on branch table (this should be updated on the Branch Server too) and run implement all

select list_no, * from branch where branch_name like '%?'
update branch set list_no = 1 where branch_no = ?

traxs_Promotions_ImplementAll
select terminal_id, count(*) from data_distribution_queue_terminal group by terminal_id  

(2) You will need to send the command to the till as per at Pets

nimbus_ApplicationCommands_ReloadConfig_All
nimbus_ApplicationCommands_RestartApplication_All
nimbus_ApplicationCommands_TerminalRefreshWithRestart

(3) add item to sale and void and check toolbar to ensure the List No has changed