I'm helping client put theirs product in the 11 street online shopping cart , my facing problem is want to insert product description in the 11 street online shopping. How can I put the product description in the online shopping.
Below is my client company product details from their database , product details coding element is "description",for example "c8.value AS description":
<?php
include '../db_config/db_conn.php';
$sql = 'SELECT c1.entity_id AS product_id, c1.sku, c2.value AS prdNm,
c3.value AS product_price,
c5.value AS category_name, c6.value AS weight, c7.value AS image,
c8.value AS description,
c9.value AS price,c11.value AS shipment_type,c12.value AS
warranty,c13.value AS short_description
FROM catalog_product_entity c1
LEFT JOIN catalog_product_entity_varchar c2 ON c1.entity_id=c2.entity_id
AND c2.attribute_id=71
LEFT JOIN catalog_product_entity_decimal c3 ON c1.entity_id=c3.entity_id
AND c3.attribute_id=75
LEFT JOIN catalog_category_product c4 ON c1.entity_id=c4.product_id
LEFT JOIN catalog_category_entity_varchar c5 ON
c5.entity_id=c4.category_id AND c5.attribute_id=41
LEFT JOIN catalog_product_entity_decimal c6 ON c1.entity_id=c6.entity_id
AND c6.attribute_id=80
LEFT JOIN catalog_product_entity_varchar c7 ON c1.entity_id=c7.entity_id
AND c7.attribute_id=85
LEFT JOIN catalog_product_entity_text c8 ON c1.entity_id=c8.entity_id AND
c8.attribute_id=72
LEFT JOIN catalog_product_entity_decimal c9 ON c1.entity_id=c9.entity_id
AND c9.attribute_id=75
LEFT JOIN catalog_product_entity_int c11 ON c1.entity_id=c11.entity_id
AND
c11.attribute_id=127
LEFT JOIN catalog_product_entity_int c12 ON c1.entity_id=c12.entity_id
AND
c12.attribute_id=154
LEFT JOIN catalog_product_entity_text c13 ON c1.entity_id=c13.entity_id
AND c13.attribute_id=73
WHERE c1.entity_id = 190
';
Below is make the variables from the client database coding:
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
$product_id = $row['product_id'];
$product_sku = $row['sku'];
$product_name = $row['prdNm'];
$product_price = $row['product_price'];
$product_category_name = $row['category_name'];
$product_weight = $row['weight'];
$product_image = $row['image'];
$product_description = $row['description'];
$product_price = $row['price'];
$product_shipment_type = $row['shipment_type'];
$product_warranty = $row['warranty'];
$product_short_description = $row['short_description'];
}
Below is put the variables and call the client product's data from the database and insert product data into 11 street online shopping:
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => "https://api.11street.my/rest/prodservices/product",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => "<?xml version=\"1.0\" encoding=\"UTF-8\"
standalone=\"yes\"?>
<Product>
<selMthdCd>01</selMthdCd>
<dispCtgrNo>4932</dispCtgrNo>
<prdTypCd>01</prdTypCd>
<prdNm>$product_name</prdNm>
<prdStatCd>01</prdStatCd>
<prdWght>$product_weight</prdWght>
<minorSelCnYn>Y</minorSelCnYn>
<prdImage01>$product_image</prdImage01>
<htmlDetail>$product_description</htmlDetail>
<advrtStmt>9789792771251</advrtStmt>
<sellerPrdCd>815210</sellerPrdCd>
<selTermUseYn>N</selTermUseYn>
<selPrc>$product_price</selPrc>
<prdSelQty>9999</prdSelQty>
<cuponcheck>Y</cuponcheck>
<dscAmtPercnt>25</dscAmtPercnt>
<cupnDscMthdCd>01</cupnDscMthdCd>
<cupnIssStartDy>01/05/2019</cupnIssStartDy>
<cupnIssEndDy>30/05/2019</cupnIssEndDy>
<cupnUseLmtDyYn>Y</cupnUseLmtDyYn>
<pointYN>Y</pointYN>
<pointValue>100</pointValue>
<spplWyCd>02</spplWyCd>
The output is shown in below:
Error 400--Bad Request
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.4.1 400 Bad Request
The request could not be understood by the server due to malformed
syntax. The client SHOULD NOT repeat the request without modifications.
If I change (htmlDetail)$product_description(/htmlDetail) to example (htmlDetail)-(/htmlDetail), the code is work, but no product description shown in the 11 street online shopping website. The output pictures in the 11 street online shopping website is shown in the below: enter image description here
Product description if success insert, the details is shown in below:
Approved 3M system component
Designed to hold 3M Particulate Filter 5N11 and 5P71/07194 (AAD) (sold
separately)
Component works with 3M Respirator 5000 Series, 3M Cartridges 6000 Series
and 3M™ Filter Adapter 603
Color: Translucent white
Measures 4” high x 8.5” long x 4.5” wide
Used to hold 3M™ Particulate Filters 5N11 and 5P71/07194(AAD) in place on top of 3M™ Respirators 5000 Series and 3M™ Cartridges 6000 Series and 3M™ Filter Adapter 603
I just facing insert the product description problem, other insert product details should be no problem. Hope someone can help me solve this problem. Thanks.