custom php works

[login to view URL] needs to be modified it copys data from amazon_mws_orders and orders tables into OrdersTBL when copying from amazon_mws_orders the quantity ordered field if this value is more than 1 then it needs to insert a row for each value. for example is value is 3 then three rows will be inserted the value will be 1 for each row. a lookup needs to be performed for each SKU before it is copied into the OrdersTBL if sku in inventoryTBL has a value of type=B then a prefix will be added as below. if not then no prefix will be added. also it will add a prefix to the order number field order number-B1 will be the first row order number-B2 for the second ordernuber-B3 for the third. the same will be for the other part of the script that copts from orders to ordersTBL. modify the following scripts so they don’t include orders with the -B prefix in results /[login to view URL] [login to view URL] royalmail sigle items only flagged