Query time 0.00207
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.37"
},
"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",
"staff_notes",
"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": "6K"
},
"used_columns": [
"page_id",
"lang_code",
"page",
"description",
"meta_keywords",
"meta_description",
"page_title",
"link",
"page_sitemap",
"ab__custom_page_h1",
"custom_header",
"ab__emd_alternative_name"
]
}
},
{
"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.27",
"eval_cost": "0.10",
"prefix_cost": "0.37",
"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 |
staff_notes |
abt__ut2_microdata_schema_type |
lang_code |
page |
description |
meta_keywords |
meta_description |
page_title |
link |
page_sitemap |
ab__custom_page_h1 |
custom_header |
ab__emd_alternative_name |
seo_name |
seo_path |
| 61 |
0 |
0 |
61 |
A |
T |
0 |
1566507600 |
0 |
|
0 |
N |
0 |
0 |
activity |
|
|
en |
Cancellation Policy |
<h4 class="page_heading"><img src="https://www.stock2cart.com/images/Cancellation%20Policy.jpg?1569925120114" alt="Cancellation%20Policy.jpg?1569925120114" /><br /></h4><h4 class="page_heading">Cancellations</h4><p>Order can be cancelled before the shipment. After shipment it can be only RTO. Once order get cancelled amount will be refunded for 'prepaid orders'.
</p><ol><li>You can cancel your order (completely or partially) at any time before it is dispatched from our warehouse by sending an e-mail from your registered e-mail ID to care@nowpurchasse.com (or call us at +91-9073738181) with your complete order details.</li>
<li>In case of prepaid orders where payment was made online, (credit card/debit card/e- wallet/net banking) refund will be initiated in the same payment mode as originally used for placing the order. Generally, refund amount gets credited to you in 24 hours of refund initiation.</li>
<li>In case of payment mode being bank transfer (NEFT/IMPS/RTGS) or Cheque or COD (Cash on Delivery), please send us an image of cancelled cheque of the account in which you wish your refund, along with the cancellation request.</li>
<li>If cancelled cheque is not available, please send us following details:
<ol><li>Account Holder’s Name</li>
<li>Bank Name</li>
<li>IFSC Code</li>
</ol></li>
</ol><h4 class="page_heading">Cancelation Criteria</h4><p>Stock2cart reserves the right to cancel any order under the following circumstances:
</p><ol><li>You provide wrong or incomplete details (complete address including PIN code, phone number, etc.) while placing the order.</li>
<li>You do not re-confirm COD orders.</li>
<li>Wrong product listing on our website (error in price, specification, quantity etc.)</li>
<li>Delivery service not available at your specified address (Pincode)
</li>
<li>In case of wrong product price or specification mentioned on Stock2cart.com.</li>
<li>Unavailability of products - in exceptional cases, if a product runs "out of stock" with the vendor, the product will be cancelled or Product unavailability with us.</li>
<li>If area falls under "Non Serviceable zone" or "out of delivery area" by our Logistic Courier Partner even after placing the order in that case order can be cancelled.</li>
<li>If area falls under "Non Serviceable zone" or "out of delivery area" by our Logistic Courier Partner even after placing the order in that case order can be cancelled.</li>
</ol> |
Cancellation & Return Policy @stock2cart.com |
Cancellation & Return Policy @stock2cart.com |
Cancellation & Return Policy |
|
|
|
|
|
cancellation-and-return |
|