Query time 0.00071
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.35"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_pages",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "2K"
},
"used_columns": [
"page_id",
"company_id",
"parent_id",
"id_path",
"status",
"page_type",
"position",
"timestamp",
"usergroup_ids",
"localization",
"new_window",
"use_avail_period",
"avail_from_timestamp",
"avail_till_timestamp",
"facebook_obj_type",
"abt__ut2_microdata_schema_type"
]
}
},
{
"table": {
"table_name": "cscart_page_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "3K"
},
"used_columns": [
"page_id",
"lang_code",
"page",
"description",
"meta_keywords",
"meta_description",
"page_title",
"link"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.35",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
Result
| page_id |
company_id |
parent_id |
id_path |
status |
page_type |
position |
timestamp |
usergroup_ids |
localization |
new_window |
use_avail_period |
avail_from_timestamp |
avail_till_timestamp |
facebook_obj_type |
abt__ut2_microdata_schema_type |
lang_code |
page |
description |
meta_keywords |
meta_description |
page_title |
link |
seo_name |
seo_path |
| 29 |
0 |
0 |
29 |
A |
T |
5 |
1603227600 |
0 |
|
0 |
N |
0 |
0 |
activity |
|
en |
Replacement and Returns Policy |
<p>We are committed to ensure smooth and satisfactory experience in all its details from ordering to receipt, we, in Alabdullatif Furniture Company, have been keen to provide a flexible and appropriate warranty, replacement, and return policy for everyone, according to the following:</p>
<ul>
<li>When requesting replacement or return, the customer submits an e-request through requests form and accordingly, the request status will be examined, taking into account that the conditions of replacement and return should be verified.</li>
<li>Original invoice shall be submitted in case of requesting replacement, return, or maintenance.</li>
<li>The customer shall be entitled to return goods within five (5) days from the date of the delivery in case of a manufacturing defect and non-conformity with specifications, provided that defect is apparent while purchasing and that the goods are not covered by offers, sales, last piece, or among goods that cannot be re-packed, wrapped, and return thereof to their original condition with carton.</li>
<li>If the customer requests a refund of the invoice, the value of the invoice shall only be paid to the person to whom the invoice was issued.</li>
<li>In case or return, the customer shall pay the costs of shipping and delivery and shall be deducted from the invoice.</li>
<li>Wooden furniture, if installed, will not be returned, and if the customer requested to return the sold wooden furniture before installing thereof, an amount of (500) Saudi riyals shall be deducted from the invoice against costs of shipping.</li>
<li>When there is an error from the customer in ordering the product, its correction shall be accepted if he informs us within (24 hours) from the time of ordering, and we will correct the error unless the customer has already received the product or obtained the service.</li>
</ul>
<p><strong>Cases where no return is accepted:</strong></p>
<ul>
<li>The customer shall have no right to request returning goods during the period of discounts or sales.</li>
<li>If the customer has purchased the last piece or the like and the customer has accepted thereof, then the customer shall have absolutely no right to request return or replacement.</li>
<li>Sold bed sheets, pillows, mattresses and accessories cannot be returned or replaced to maintain the public health.</li>
<li>No return for products which contain integrated items and cannot be returned to its original condition on which it was delivered.</li>
<li>If the product is a special order and customized with special design.</li>
</ul>
<p> <strong>Cases where no carpets products are returned:</strong></p>
<ul>
<li>Items sold after installation shall not be returned absolutely.</li>
<li>In the event that the customer purchased full rolls and found excessive quantity therein, the excess quantity less than 5 linear meters shall not be accepted by the Company.</li>
<li>The customer shall not be entitled to request changing the color of the sold goods after its invoice was issued.</li>
<li>Items sold prior to installation are returned in case of manufacturing defects.</li>
</ul>
<p> </p>
<strong><u>Refund policy shall be as follows: </u></strong><br />
<ul>
<li>The amount is refunded through the same bank account of the applicant after we receive and inspect the products.</li>
<li>In the event that the customer requested replacement, he will pay the cost of shipping to return the product to be replaced, the cost of shipping for the new product, and pay or receive the difference, if any.</li>
<li>If the order value was paid through credit card, the amount will be refunded to the card. In case you paid Cash on Delivery, the full amount will be refunded to the bank account specified by the customer in the return request at his own responsibility, and in all cases the bank commission will be deducted from the product value.</li>
<li>If the order value was paid through bank transfer, the full value will be refunded to the used card or the account. In case you paid Cash on Delivery, the full amount will be refunded to the bank account specified by the customer in the return request at his own responsibility.</li>
<li>Refunding the amount to the credit card or the bank account requires 14 days from the date of receiving the return request to reflect thereof in your bank statement, taking into account the delay in case of transfer from one bank to another.</li>
<li>Contact customer service if your return request is confirmed via the website chat, WhatsApp, or send us the request number through "Inquires and Suggestions" page.</li>
<li>We will arrange to collect the products from you at the same delivery address within 72 hours of the date on which the return request is approved.</li>
</ul> |
|
|
|
|
replacement-and-returns-policy-en |
|