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` = '142'
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
Magnet Sheet-Sy Bunting King

Magnet Sheet

Please make sure that all text sizes no smaller than 8pt, please noted that for small graphic and fonts UV machine printout will not be very sharp. All of the finished goods may not be 100% in actual size some of them will be differences in 0.5 inches - 2 inches due to the different types of finishing and size of the material.
Please send the file in Ai CS 6



Size


SELECT *
FROM `sy_inkjet_stickerfinishing`
WHERE `set_id` = 1
AND `product_id` = '142'
AND `finishing_id` = '12'
AND `location_id` = 1
ORDER BY `price_id` ASC

Finishing : 1Pc 1Pc Cut to size

Remarks

Quantity

Final Total (not including SST 10%)

RM Normal Price
RM Classic Price
27 = SELECT `mv`.`material_id`, `mv`.`machine_id`, `mv`.`price` as `price`, `mv`.`desc_price` as `desc_price`, `m`.`thickness`, `m`.`material_name`, `m`.`thickness`, `m`.`material_image`
FROM `sy_material_variables_new` AS `mv`
LEFT JOIN `sy_materials` AS `m` ON `mv`.`material_id` = `m`.`material_id`
WHERE `mv`.`material_id` = '55'
AND `mv`.`machine_id` = '3'
AND `mv`.`set_id` = '27'
AND `mv`.`location_id` = 1
AND `m`.`material_image` != ""
ORDER BY `m`.`sort` ASC
RM Gold Price
29 = SELECT `mv`.`material_id`, `mv`.`machine_id`, `mv`.`price` as `price`, `mv`.`desc_price` as `desc_price`, `m`.`thickness`, `m`.`material_name`, `m`.`thickness`, `m`.`material_image`
FROM `sy_material_variables_new` AS `mv`
LEFT JOIN `sy_materials` AS `m` ON `mv`.`material_id` = `m`.`material_id`
WHERE `mv`.`material_id` = '55'
AND `mv`.`machine_id` = '3'
AND `mv`.`set_id` = '29'
AND `mv`.`location_id` = 1
AND `m`.`material_image` != ""
ORDER BY `m`.`sort` ASC
RM Premium Price
31 = SELECT `mv`.`material_id`, `mv`.`machine_id`, `mv`.`price` as `price`, `mv`.`desc_price` as `desc_price`, `m`.`thickness`, `m`.`material_name`, `m`.`thickness`, `m`.`material_image`
FROM `sy_material_variables_new` AS `mv`
LEFT JOIN `sy_materials` AS `m` ON `mv`.`material_id` = `m`.`material_id`
WHERE `mv`.`material_id` = '55'
AND `mv`.`machine_id` = '3'
AND `mv`.`set_id` = '31'
AND `mv`.`location_id` = 1
AND `m`.`material_image` != ""
ORDER BY `m`.`sort` ASC


You may top up to get lower price. click here

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.)

Terms and Conditions Read the full terms and conditions here


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