Please Validate the Store Catalog Product Solar Query V3 and Console // *************************************** V3.shopview.net************* select SPC.catalog_id,SPC.store_id, (select store_name from netshopv_V3.store_login_details where store_id = SPC.store_id) as store_name, SPC.catalog_description,Cast(SPC.sell_price as DECIMAL(15,2)) as sell_price, Cast(SPC.offer_price as DECIMAL(15,2)) as offer_price, CAST(CONCAT('http://v3.shopview.net/image','/',catalog_image) AS CHAR(10000) CHARACTER SET utf8) as catalog_image from netshopv_V3.store_product_catalog as SPC where SPC.del_status = 1 GROUP BY SPC.catalog_id // *************************************** console.shopview.net************* select SPC.catalog_id,SPC.store_id, (select store_name from netshopv_console.store_login_details where store_id = SPC.store_id) as store_name, SPC.catalog_description,Cast(SPC.sell_price as DECIMAL(15,2)) as sell_price, Cast(SPC.offer_price as DECIMAL(15,2)) as offer_price, CAST(CONCAT('http://console.shopview.net/image','/',catalog_image) AS CHAR(10000) CHARACTER SET utf8) as catalog_image from netshopv_console.store_product_catalog as SPC where SPC.del_status = 1 GROUP BY SPC.catalog_id product-catalog POST {"mod":"CATALOG_CREATE","data_arr":{ "store_id":"1", "catalog_image":"1", "sell_price":"32.00", "description":"sfhjsds", "offer_price":"23.00" }} Output 16 product-catalog POST {"mod":"CATALOG_UPDATE","data_arr":{"store_id":"1", "catalog_id":"1", "sell_price":"32.00", "description":"sfhjsds", "offer_price":"23.00" }} Output 17 product-catalog POST {"mod":"CATALOG_DELETE", "data_arr":{ "store_id":"1", "catalog_id": "1" }}