Add $9 to each imported PBI product (due to their $9 per-item handling fee). We are adding the $9 here instead of on "UPDATE PRODUCT STOCKS & PRICES" so as to not throw off B2B pricing - which as of now only strictly takes prices from parts_suppliers and doesnt add additional handling charges to them.

Add $15 to each imported DEPO-CA, DEPO-IL & DEPO-NJ product (due to their $15 per-order handling fee)

{{ $importResult['output'] }}

Detect markup by rules:

If price < 50 , then (markup) = 1.45

If 50 <= price < 100 , then (markup) = 1.40

If price >= 100 , then (markup) = 1.35

final_price = (price + s/h cost) * markup; (markup is not applied to usauto smartpost handling charges);

If part has shipping / handling columns - s/h cost calculated from them, ELSE IF supplier IS NOT USAUTO then use product.average_shipping (if not set, then use it value as 10) + 2 ($2 added to cover cost of fulfillment)

Also for calculating use only in_stock items with price > 0

After all of that get cheapest from all parts, and

product price = round(final_price - 10) + 0.95; - for all categories

If the Cheapest price is > 100, then we deduct $15.

If the cheapest price is > 50 and < 100 we deduct $12

For products with skus beginning "BC0001-|B00001" make (final price * 1.15); (BUT DO NOT APPLY THIS ON KITS/SETS)

For products with skus beginning "RS0001-|H00001" make (final price * 1.65) + 0.95; (raise all radiator support and hoods prices by 65% - BUT DO NOT APPLY THIS ON KITS/SETS)

For products with skus beginning "ARC001" make (final price * 1.45);

For products with skus beginning "CAM001" make (final price * 1.25);

For products with skus beginning "ARB004" make (final price * 1.20);

For products with skus beginning "ARG003" make (final price * 1.12);

For products with skus beginning "HL0001-|TEC001" make (final price * 1.10);

For products with skus beginning "FT0002-|BB0001-|V00001" make (final price * 1.05);

For products with skus beginning "F00001-" make (final price * 1.05) + 0.95; (raise all fender prices by 5%)

For products with partslink beginning "KIT-" and "SET-" make (final price * 1.10) + 0.95; (raise all KIT and SET prices by 10%)

Add 2% to DEPO-EC, DEPO-WC supplier prices

Add 2% to USAVA, USAIL, USANV, USATX, USACH, USAFL supplier prices

Subtract $3 from PBI, PVI-VA, PBI-TX (to counteract our markup on their $9 drop-ship fee which we build into their price

Set minimum product price to $4.95

ADD 8% TO ALL PRODUCT PRICES

Discount by 15% the products which have num sold < 1 (more than 180 days) in table goparts.non_selling_items AND have qty > 0 in stock (partscan_inventory).

Discount by 30% the products which have num sold < 1 (more than 365 days) in table goparts.non_selling_items AND have qty > 0 in stock (partscan_inventory).

Discount by 50% the products which have num sold < 1 (more than 730 days) in table goparts.non_selling_items AND have qty > 0 in stock (partscan_inventory).

Add custom % markups to product price based on values inserted in table 'product_markup_increase'

For products with skus beginning "ET0001-"|"TL0001-"|"ARC001-" always set stock = 0