SELECT `fi`.`finishing_id`, `fv`.`product_id`, `fi`.`finishing_material`, `fii`.`finishing`, `fii`.`product_id`, `fii`.`size_value`, `fv`.`price`, `fi`.`finishing_image`, `fi`.`finishing_desc_image`
FROM `sy_finishing_variables` AS `fv`
JOIN `sy_finishing` AS `fi` ON `fv`.`finishing_id` = `fi`.`finishing_id`
JOIN `sy_mounting_products` AS `fii` ON `fi`.`finishing_material` = `fii`.`finishing`
WHERE `fv`.`product_id` = '66'
AND `fii`.`size_value` IN('Mounting Only- Die Cut', 'Mounting Only- Cut to Size')
GROUP BY `fii`.`finishing`
ORDER BY `fv`.`finishing_order_number` ASC
GI Coil - WHITE STK-Sy Bunting King

GI Coil - WHITE STK


All of the finished goods may not be 100% in actual size some of it will be differences in 0.5 inches - 2 inches due to the different types of finishing and size of the material.


Size

Remarks

Quantity

Final Total (not including SST 10%)

RM Normal
RM Top Up Price


Upload Your Artwork Print Guideline (If your file size is too large, or more than 2 artworks, please zip you file and send by wetransfer, upload any small size jpeg file and remark file send by wetransfer)




Collect Date (Please noted that collection time for Normal and Urgent Order is 6pm, Same Day order is 9pm and there are extra charges for urgent order.)


Please be informed that we will close for COMPANY TRIP on 16-19 March 2023, and resume on 20th March 2023. Pick up area will be CLOSED.

All orders that proceed on the 13th (Mon) will be ready by 20th (Mon) , on the 14th (Tues) will be ready on 21st (Tues) and 15th (Wed) will be ready on 22nd (Wed), and orders between 16-19th will proceed on 20th.

Terms and Conditions Read the full terms and conditions here

©2023 SY Bunting King. All rights reserved. Term & Condition