BULB AND ACCESSORIES
SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3336) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3917) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3269) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3951) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3952) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3909) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3953) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3337) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3911) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3954) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3339) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3918) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

SELECT * FROM `tinxit_b2bpricing_salesprice` WHERE `product_id` in (3338) AND (`sales_type` = 'All Customers' ) AND (`currency_code` = 'USD') AND (`starting_date` IS NULL OR `starting_date` <= '2018-12-12' ) AND (`minimum_qty` <= 1 OR `minimum_qty` IS NULL) AND (`ending_date` IS NULL OR `ending_date` >= '2018-12-12 ') ORDER BY `unit_price` ASC

Filter
Hide
At this time you have the option to mark up your price.
If you choose you to markup, the mark-up price will be shown in your order,
your Wishlist and when you email a product to your customers.
Enter your mark up here: time of the wholesales price.