Query time 0.00066
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 |
| 47 |
0 |
0 |
47 |
A |
T |
0 |
1566507600 |
0 |
|
0 |
N |
0 |
0 |
activity |
|
|
en |
Return Center |
<h5>Returns
</h5>
<p>In case, if you received a damaged product, it must be reported to us through Register email ID and sent it to via email at <a href="mailto:(care@stock2cart.com)">(care@stock2cart.com)</a> within 48 hours of delivery with an image of the damaged product along with the packaging pictures.
</p>
<h5>Guidelines for Returns & Replacement:
</h5>
<ol><li>Product is damaged/defective.</li>
<li>Differ from the description on the website.</li>
<li>Wrong item delivered/Wrong Colour/Wrong Size/Wrong Quantity.</li>
<li>Missing parts/accessories.</li>
</ol><h5>Return Eligibility
</h5>
<ol><li>In case of returning the product, customer needs to inform us within 7 days of receiving the order. In case, if you received a damaged product, it must be reported to us within 48 hours of delivery.</li>
<li>If the product is delivered defective or damaged, in that case, customer needs to inform us through Register email ID and sent it to <a href="mailto:(care@stock2cart.com)">(care@stock2cart.com)</a> or Call us at +91 9962512354 (Helpline Number) within 48 hours from the time of delivery.</li>
<li>Products shoold be unused.</li>
<li>All items must be returned in their original condition, with price tags intact, user manual, warranty cards, original accessories and in the original manufacturer’s box/packaging as delivered to you.</li>
<li>Invoice shoold be available.</li>
<li>Products marked as "non-returnable" on the product detail page cannot be returned such as Electronics, Cartridges, Safety, Tyres, Electricals & Car-care.</li>
</ol><h5>Returning a Product
</h5>
<p>There are 2 ways to Return the product. One is to return the product from our side where we send the courier partner and get the product picked up from customers. However, in some cases if we cannot provide return service then customer needs to send the product to us through India Post only. Once, the product is received by us, then we will reverse the courier charges.
</p>
<h5>Steps to follow to Return a Product
</h5>
<ol><li>Customer needs to inform us through call/email within 7 days of receiving the order.</li>
<li>Product shoold be unused.</li>
<li>Invoice shoold be available.</li>
<li>We will raise a request for Reverse pickup and try to arrange it from our end. Once the pickup is arranged our courier partner will collect the product within 2-3 business days.</li>
<li>Customer needs to pack the product with Brand packing & paste the invoice on it.</li>
<li>Customer will handover the product to the courier boy.</li>
<li>Once the pick up is done, product will be sent to us by the courier partner.</li>
<li>After receiving the product, quality check will be done over the product by our team which takes 2 days time.</li>
<li>If product is found damage/defective by our team, We will try to arrange a replacement; however, it depends on the availability of the product.</li>
<li>In some cases, where our Logistic Service Provider doesn’t provide reverse pickup facility, customer will have to send the product on his own only through India post at the below mentioned address after the request for reverse pickup is raised:</li>
</ol>GEESYS Technologies India Pvt. Ltd., No.33,
<p>Alandur Road, Saidapet, Chennai – 600015. Tamil Nadu, India.
</p>
<p>Once sent, customer needs to share the
</p>
<p>Courier slip along with the following bank details at <a href="mailto:Care@stock2cart.com">Care@stock2cart.com</a>:
</p>
<p>Account number
</p>
<p>Account holder name (Same as registered with Industrybuying.com)
</p>
<p>IFSC Code
</p>
<p>In case, after receiving the product if we found any discrepancy by our Quality inspection team, we will re-ship product to the customer and in that case customer will have to bear the courier charges for re-shipment in order to receive the product. No courier charges for sending the product will be reimbursed.
</p>
<ol><li>Products marked as "non-returnable" on the product detail page cannot be returned such as Electronics, Cartridges, Safety, Tyres, Electricals & Car-care.</li>
<li>Product Purchase under clearance sale will not be covered under Return policy.</li>
<li>Products sold as combo can’t be returned individually</li>
</ol> |
|
|
|
|
|
|
|
|
return-center |
|