SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id 
  AND cscart_seo_names.type = 'a' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  cscart_pages.page_id = 51 
  AND cscart_page_descriptions.lang_code = 'en' 
  AND (
    cscart_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, cscart_pages.usergroup_ids) 
    OR FIND_IN_SET(1, cscart_pages.usergroup_ids)
  ) 
  AND cscart_pages.page_type IN ('T', 'L', 'B', 'F', 'P')

Query time 0.00112

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
51 0 0 51 A T 0 1566507600 0 0 N 0 0 activity en FAQ's <div class="policy_pages_align"> <h5 class="page_heading"><img src="https://www.stock2cart.com/images/FAQ.jpg?1570004103964" alt="FAQ.jpg?1570004103964" /><br /></h5><h5 class="page_heading">How can I track my order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">Once shipped, customer receives an SMS and E-mail on registered contact number and e-mail id containing courier company name and tracking number. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">Or maybe you can simply go to the “Track now” option available on our website. </p> <h5 class="page_heading">I am unable to see my order details in my account What should i do? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">This usually happens when you place an order as a Guest without creating an account on our website. If you first create an account and then place the order, it will reflect under your account. However, you can still track your order status by following the below mentioned step: </p> <ol><li>Click on SIGN IN ACCOUNT on the top right corner of the website. </li> <li>Select Track Order</li> <li>Enter your details</li> </ol><h5 class="page_heading">How long it takes to deliver the Order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">It takes 4-7 days to ship an order. Once shipped, a product should be delivered to you within 5 days. However, there might be some delay in delivery due to below mentioned reasons: </p> <ol><li>If the area where you live is very interior in the region. </li> <li>Natural calamities like heavy rain, earthquake etc. </li> <li>Political disturbance, National and Regional holidays etc. </li> </ol><h5 class="page_heading">I missed the delivery of my order today so what can I do now? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">We have you covered! We will call you and confirm your availability and reschedule the delivery for you. </p> <h5 class="page_heading">Can I accept the package after checking the contents inside it? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Sorry, as per company policy, a package can’t be opened before delivery is accepted. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">But you can accept the package & get in touch with us later in case you have any concerns. </p> <h5 class="page_heading">Will the delivery be re-attempted if I’m not able to collect my order the first time? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">Yes, we’ll make sure that the delivery is re-attempted the next working day if you can’t collect your order the first time. </p> <h5 class="page_heading">Can I change the delivery time for my order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">Sorry about this. Delivery time for an order cannot be changed yet. </p> <h5 class="page_heading">Can I prepone or postpone the date of delivery? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">Sorry, this option is not available yet. </p> <h5 class="page_heading">I found the package open and the product seal broken. What should I do? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">You can request for the item to be replaced or returned by sending us a mail on care@istock2cart.com or calling our helpline number +91 450 12354 between 9 AM and 8 PM. </p> <h5 class="page_heading">What should I do if a service centre denied my request to repair the product? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">Please contact our Customer Support with the service centre details so that we can look into this. </p> <h5 class="page_heading">Will I receive a call before stock2cart attempts to deliver package at my place? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">The courier person will call you before delivery only if he cannot find your location with the address shared. </p> <h5 class="page_heading">I have a complaint about the courier guy who came to deliver my order. </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">Please let us know the details by contacting our Customer Support & we’ll look into this for you. </p> <h5 class="page_heading">How can I cancel my order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">You can cancel an order using any of the below mentioned methods: </p> <p style="margin:0cm 0cm .0001pt 21.3pt;text-indent:-18pt;background-color:#FFFFFF;vertical-align:baseline;">By contacting us on our helpline number - +91 44 450 12354 (9 AM - 8 PM). </p> <p style="margin:0cm 0cm .0001pt 21.3pt;text-indent:-18pt;background-color:#FFFFFF;vertical-align:baseline;">By writing to us at <a href="mailto:Care@stock2cart.com">Care@stock2cart.com</a>. </p> <h5 class="page_heading">When can i can cancel my Order ? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">Order can be cancelled only before dispatch. Once cancelled, complete amount will be refunded. </p> <h5 class="page_heading">How long does it take to cancel an Order? </h5> <ol><li>It takes 24hrs to cancel the order once the request is received on call. </li> <li>Request received through mails will be fulfilled within 48hrs. </li> <li>orders will be cancelled immediately if done via my accounts section </li> </ol><h5 class="page_heading">Can stock2cart.com cancel any order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Yes, stock2cart.com reserves the right to cancel any order under the following circumstances: </p> <ol><li>Incorrect or Incomplete information regarding Customer’s address (Street number, Landmark etc.) etc. </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; however, remaining products of the order will be delivered. </li> <li>If the area in which customer is residing is not served by us or made Out of Delivery area by Logistic Courier Partner even after placing the order. </li> <li>Suspected fraudulent information.</li> </ol><h5 class="page_heading">Can I return the product delivered to me? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Of course, a product can be returned but only under the following circumstances: </p> <ol><li>Product is physically damaged/defective</li> <li>Varies from the description on the website </li> <li>Wrong item delivered</li> </ol><h5 class="page_heading">How do i know if my order is eligible for return? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Mentioned below are the criteria for Return </p> <ol><li>Customer should intimate us within 7 days of receiving the order </li> <li>For damaged product customer should intimate us within 48 hours of delivery </li> <li>Product should be unused. Not even once</li> <li>Brand packing should remain intact</li> <li>Invoice should be available</li> <li>All the tags/labels should be available</li> <li>Exempted/non-returnable items – electronic items such as Printers, cartages, tablets, testing/lab instruments, custom made products also those product which are mentioned as non-returnable in that product’s catalogue are not accepted for returns. </li> </ol><h5 class="page_heading">What is the procedure to return a product? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Customer should follow the below mentioned steps in order to Return any item. </p> <ol><li>Customer should intimate us through call/email within 7 days of receiving the order. Customer has to make sure that </li> <li>A. The product is unused. Not even once</li> <li>B. Brand packaging should remain intact. </li> <li>C. Invoice should be available</li> <li>D. All the tags/labels should be available</li> <li>We will raise a request for Reverse pickup and try to arrange it from our end. Once arranged our courier boy will come to collect the product within 2 business days. </li> <li>Customer has to make sure that he packs the product in proper manner and paste the invoice on it. It should in logistic friendly manner. </li> <li>Customer will have to handover the product to the courier boy. </li> <li>Once picked up product will be sent to us by the courier partner. </li> <li>Upon receiving the product a Quality inspection would be performed over the product. It will take 2 days time. </li> <li>If any damage/defect is found from Stock2cart end, we will try to arrange a replacement; however, it depends on the availability of the product. </li> <li>In case of refund, money will be refunded to the customer. </li> </ol><p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">In some cases where our Logistic Service Provider doesn’t provide reverse pickup facility, customer will have to send the product on his own to us only through India postat the below mentioned address once the request for reverse pickup is raised: </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">GEESYS Technologies India Private Limited., </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">No.33, Alandur Road,Sadiapet, Chennai - 600015. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Tamil Nadu, India </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Once sent, customer needs to share the Courier slip along with the following bank details at Care@stock2cart.com: </p> <ol><li>Account number</li> <li>Account holder name (Same as registered with stock2cart.com) </li> <li>IFSC Code</li> <li>Upon receiving the product a Quality inspection would be performed over the product. It will take 2 days time. </li> <li>If any damage/defect etc is found from Stock2cart end, we will try to arrange a replacement; however, it depends on the availability of the product. </li> <li>In case of refund, money will be refunded to the customer. </li> <li>Incase, product doesn’t clear Quality inspection, we will re-ship the product to the customer and he will have to bear the courier charges for re-shipment in order to receive the product. No courier charges to send the product to us will be re-imbursed. </li> </ol><h5 class="page_heading">Can I return the order if the size of the product doesn’t fit me? </h5> <p style="margin:0cm 0cm .0001pt;background-color:#FFFFFF;vertical-align:baseline;">In order to justify supply chain cost, we don’t encourage returns for those products worth less than 1000. </p> <h5 class="page_heading">Can I return the order if I received a different color of the product ? </h5> <h5 class="page_heading"></h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">If you receive the product in a different color, however, specifications are same then return will not be done. </p> <h5 class="page_heading">What should I do if I find the package open or tampered on delivery? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">Sorry about that. Please get in touch with our customer care team at care@stock2cart.com or call us on our helpline number +91 99625 12354 between 9 AM and 8 PM. </p> <h5 class="page_heading">What should I do if there are hardware or component or functional related issues with the device I bought from stock2cart? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;">If the problem has occurred during delivery then please get in touch with our customer care team. If it is a manufacturing complaint, you can get in touch with the authorised service centre of the brand for help. </p> <h5 class="page_heading"></h5> <h5 class="page_heading">Cancellation and Returns: </h5> <h5 class="page_heading"></h5> <h5 class="page_heading">How can I cancel my order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">You can cancel an order using any of the below mentioned methods: </p> <p style="margin:0cm 0cm .0001pt 21.3pt;text-indent:-18pt;background-color:#FFFFFF;vertical-align:baseline;">By contacting us on our helpline number - +91 8448449073 (9 AM - 8 PM). </p> <p style="margin:0cm 0cm .0001pt 21.3pt;text-indent:-18pt;background-color:#FFFFFF;vertical-align:baseline;">By writing to us at <a href="mailto:Care@stock2cart.com">Care@stock2cart.com</a>. </p> <h5 class="page_heading">When I can get refund of my Cancelled order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Once cancelled, full amount will be refunded to the customer based on the payment mode chosen by the customer at the time of placing the order. </p> <ol><li>Credit/Debit Card/Net Banking/Wallets – 2 business days </li> <li>If you have made the payment by NEFT and Cheque you need to share the below mentioned details at care@stock2cart.com from your registered e-mail id. </li> </ol><p style="margin:0cm 0cm .0001pt 21.3pt;background-color:#FFFFFF;vertical-align:baseline;">Account number </p> <p style="margin:0cm 0cm .0001pt 21.3pt;background-color:#FFFFFF;vertical-align:baseline;">Account Holder name </p> <p style="margin:0cm 0cm .0001pt 21.3pt;background-color:#FFFFFF;vertical-align:baseline;">IFSC Code </p> <p style="margin:0cm 0cm .0001pt 21.3pt;background-color:#FFFFFF;vertical-align:baseline;">Upon receiving the information, your refund will be processed in 2 business days and same will reflect in your account in another 2 business days. </p> <ol><li>For EMI payment, refund will be credited in 6-8 business days after cancellation. </li> </ol><h5 class="page_heading">When I can get my refund once the order has been returned? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Once the order has successfully passed the Product Inspection, refund will be done according to the payment mode chosen by the customer at the time of placing the order . </p> <p style="margin:0cm 0cm .0001pt 21.3pt;text-indent:-18pt;background-color:#FFFFFF;vertical-align:baseline;">Credit/Debit Card/Net Banking/Wallets – 2 business days </p> <p style="margin:0cm 0cm .0001pt 21.3pt;text-indent:-18pt;background-color:#FFFFFF;vertical-align:baseline;">If you have made the payment by NEFT and Cheque you need to share the below mentioned details at care@stock2cart.com from your registered e-mail id. </p> <p style="margin:0cm 0cm .0001pt 21.3pt;background-color:#FFFFFF;vertical-align:baseline;">Account number </p> <p style="margin:0cm 0cm .0001pt 21.3pt;background-color:#FFFFFF;vertical-align:baseline;">Account Holder name </p> <p style="margin:0cm 0cm .0001pt 21.3pt;background-color:#FFFFFF;vertical-align:baseline;">IFSC Code </p> <p style="margin:0cm 0cm .0001pt 21.3pt;background-color:#FFFFFF;vertical-align:baseline;">Upon receiving the information, your refund will be processed in 2 business days and same will reflect in your account in another 2 business days. </p> <p style="margin:0cm 0cm .0001pt 21.3pt;text-indent:-18pt;background-color:#FFFFFF;vertical-align:baseline;">For EMI payment, refund will be credited in 4-7 business days after product inspection. </p> <h5 class="page_heading">How can I know the status of my refund? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">You will be notified via email once your refund has been processed </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">The following is the timeline for refunds </p> <ol><li>For cancellation before shipping, refunds are processed immediately </li> <li>If the order has been returned due to any other issue, we refund after we receive the item back at our warehouse and checked. </li> </ol><h5 class="page_heading">Under what circumstances are cancellations done? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Cancellations are accepted by stock2cart for the following reasons. </p> <ol><li>If the order is not serviceable by us due to non-availability of the product among any of our vendors </li> <li>If your pin code is not serviced by any of our courier partners </li> <li>If the procurement is taking longer than 7 working days and you are not willing to wait further </li> </ol><p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">You can always check My Orders page to see the status of your order. </p> <h5 class="page_heading">What is stock2cart's Replacement Guarantee? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">If you have received a product in a damaged or defective condition or it is not as described, you can return it to get a brand new replacement at no extra cost! </p> <h5 class="page_heading">If I request for a replacement, when will I get it? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">The replacement order is initiated after the originally delivered item is picked up and received back at our warehouse. Please check the SMS & email we send you for your replacement request for more details. </p> <h5 class="page_heading">I have requested a replacement, when will I get it? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">You can check the email & SMS we send you as soon as a replacement request is approved for details of your pickup & replacement. </p> <h5 class="page_heading">If I have ordered many items, can I return one or more items or do I have to return the entire order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Return of an entire order is not necessary in this case. You can return one or many items in your order. </p> <h5 class="page_heading">What is stock2cart's Returns policy? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">In case the product you received is 'Damaged', 'Defective' or 'Not as Described', our Return policy has got you covered. If you are not fully satisfied with what you ordered, you can easily request to return by contacting us at care@stock2cart.com or call us on our helpline number +91 8448449073 between 9 AM and 8 PM. </p> <h5 class="page_heading">Can I return part of my order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Yes, you can return an item or items in your order if you have ordered multiple items. </p> <h5 class="page_heading">Can I return the items after the policy period? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;vertical-align:baseline;">Sorry, returns are not possible after the policy period. </p> <h5 class="page_heading">What should I do if I have an issue with my product after the return policy period? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">You can get in touch with the brand or an authorised service centre of the brand to claim the warranty for your product if applicable. </p> <h5 class="page_heading">Do I have to return the free gift when I return a product? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Yes, the free gift has to be returned along with the originally delivered product. </p> <h5 class="page_heading">I have requested for a return of my item. When will it happen? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Our customer care team will get in touch with you immediately once you request a return </p> <h5 class="page_heading">Payment:</h5> <h5 class="page_heading"></h5> <h5 class="page_heading">My payment process was interrupted. What should I do? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">No need to worry! You can contact us to check if you’ve paid for the order. If you did successfully pay, the order will be placed for you by our team. </p> <h5 class="page_heading">How can I pay for an order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">You can choose to pay for an order with any of the below methods: </p> <ol><li>Cash on Delivery</li> <li>Net Banking</li> <li>Visa, MasterCard, Maestro and American Express Credit or Debit cards issued in India and 21 other countries </li> <li>NEFT/RTGS</li> <li>Cheque/DD</li> </ol><h5 class="page_heading">Can I use Credit/Debit card or Netbanking to pay on stock2cart through my mobile? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Certainly! You can use your Debit/Credit card or Netbanking to shop on our mobile website. </p> <h5 class="page_heading">How do I pay using a credit or debit card? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">It’s easy & simple to pay using your Credit or Debit card! </p> <ol><li> Keep your card number, expiry date, three-digit CVV number ready (found on the backside of your card) </li> <li>For extra security, you’ll need to use your card’s online password (Verified by Visa, MasterCard SecureCode etc.) </li> </ol><p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Enter the details when you are prompted to & your order will be successfully placed. </p> <h5 class="page_heading">Can I pay with any Credit card? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">You can choose to pay on stock2cart with any Visa, MasterCard or American Express Credit cards issued in India. </p> <h5 class="page_heading">Can I use any Debit card to pay? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">You can choose to pay on stock2cart with any Visa, MasterCard or Maestro Debit card. </p> <h5 class="page_heading">What all card information does stock2cart store? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">We currently do not store any card information and all transactions happen through authorized and secure payment gateways. </p> <h5 class="page_heading">Is it safe to use my credit or debit card on stock2cart? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Absolutely! At stock2cart, we use the highest possible security (256-bit encryption) to protect your card details. All credit card and debit card payments with us are also processed through secure and trusted payment gateways which are managed by leading banks. Also, banks now use the 3D Secure password service for online transactions and they provide an extra layer of security through identity verification. </p> <h5 class="page_heading">Can I use Cash on Delivery (CoD) payment option for every product I buy on stock2cart? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">COD is not available in all Pin Codes. Please enter your Pin Code on the product page to see if your Pin Code is covered. COD orders are also not available for high value orders currently. We might also inform you when an order is not serviceable by COD and ask to convert it to a prepaid order. </p> <h5 class="page_heading">What steps does stock2cart take to prevent card fraud? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Fraud detection and prevention are very important for us as we want to make sure that all transactions with us are genuine and authorized. We take many steps to keep our customers’ details completely secure. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Online payments are monitored continuously for suspicious activity and some transactions are verified manually if we feel that it’s not authorized by the owner of the card. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">When we’re not able to rule fraud out in rare cases, the transaction is kept on hold and we ask the shopper to share ID proof. This is done to make sure that the transaction is genuine. </p> <h5 class="page_heading">Can I buy something by paying part of the amount by Wallet? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">You can buy by paying part of the amount from your Paytm, PayU or MobiKwik Wallet and paying the rest using any other prepaid method of payment such as Credit/Debit Card or NetBanking. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Please note that Cash-on-Delivery cannot be combined with a Wallet payment. </p> <h5 class="page_heading">How can I order for large quantities of the product as part of a corporate order? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">You can write to sales@stock2cart.com for your corporate requirements. </p> <h5 class="page_heading">How can I get the 3D Secure password for my Credit/Debit card? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">You can get a 3D Secure password by registering your Credit/Debit card from your bank's website. </p> <h5 class="page_heading">How does the 3D Secure password add security to my online transactions? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">The 3D Secure password is known only to you & this makes sure that only you can use the card for shopping online. </p> <h5 class="page_heading">What is a 3D Secure password? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">A 3D Secure password is a security measure from VISA & MasterCard that adds an extra layer of security through identity verification for your online Credit & Debit card transactions. </p> <h5 class="page_heading">What is Stock2cart’s EMI payment option? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Stock2cart’s EMI scheme is available for American Express, Citi & HDFC credit card holders only. You may choose to pay in 3, 6, 9 or 12 month instalments. The minimum order value to avail the EMI payment option is Rs 3,000. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">There is NO processing fee charged for availing Stock2cart's EMI payment option. On return or exchange, interest charged by the bank till that time will not be refunded by Stock2cart. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">You may check with the respective bank/issuer on how a cancellation, refund or pre-closure could affect the EMI terms, and what interest charges would be levied on you for the same. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">The Bank charges annual interest rates are calculated according to the reducing monthly balance. In the monthly reducing cycle, the principal is reduced with every EMI and the interest is calculated on the balance outstanding. </p> <h5 class="page_heading">How do I make a payment using Stock2cart credit card EMI option? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Once you've added the desired items into your cart, proceed to checkout as usual. When prompted to choose a 'Payment Option', select EMI. Choose the bank and plan (3, 6, 9 or 12-month) of your choice and enter your credit card details. Once the payment is authorized, your order will be processed and shipped. You will need to pay the total amount, in the pre-determined number of instalments, as per your credit card billing cycles. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">The minimum order value to avail the EMI payment option is Rs 3,000. </p> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Please note that the full amount will be charged on your card the day of the transaction. Within 7 days, you will see a credit for the full amount. The first EMI charge will occur subsequently. If your card's billing date falls within those 7 working days, you need to pay only the EMI amount to the bank. Such EMI transactions are at the discretion of your credit card issuing bank. If you have any queries about the EMI plan, we suggest you get in touch with your bank. </p> <h5 class="page_heading"></h5> <h5 class="page_heading">Shopping:</h5> <h5 class="page_heading">Can I order a product that is 'Out of Stock' or ‘Temporarily Unavailable’? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Unfortunately, products listed as 'Out of Stock' or ‘Temporarily Unavailable’ are not available for sale. </p> <h5 class="page_heading">What does ‘Out of Stock’ mean? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">It means that the stock for the product is not available with our vendors at the moment & so, you can’t buy it now. </p> <h5 class="page_heading">Is it necessary to have an account to shop on stock2cart? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">No, It's not. You can checkout as a guest but you will have to provide us with a valid e-mail, phone number and address for us to send you the goods. </p> <h5 class="page_heading">What does 'Preorder' or 'Forthcoming’ mean? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Such items are expected to be released soon and you can pre-book them. The item will be shipped to you on the day of its official release and will reach you within the delivery time mentioned by the seller. The Preorder duration varies from item to item. </p> <h5 class="page_heading">Why do I see COD Charges?
</h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Stock2cart.com charges a minimal fee for orders placed by using COD payment mode. COD charges will be added to your total order amount. </p> <h5 class="page_heading">Warranty:</h5> <h5 class="page_heading">Is warranty applicable to products I buy on stock2cart.com? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">All products bought on stock2cart come with manufacturer warranty. You can check with the manuals provided with the product or the manufacturer's website for information about a service centre close to you. </p> <h5 class="page_heading">The warranty card is not sealed on the product I bought. How do I claim warranty? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">Most service centres accept a proof of purchase( i.e. original invoice ) as proof to provide warranty service. If you face any trouble please contact us for help at <a href="mailto:care@stock2cart.com">care@stock2cart.com</a> </p> <h5 class="page_heading">Why is the warranty card on my product not sealed? </h5> <p class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;background-color:#FFFFFF;vertical-align:baseline;">We will have to open the box to seal a warranty card and most consumers don't accept items if the box has been opened. Hence as a policy we don't seal on warranty cards. All manufacturers accept the purchase invoice as proof to provide warranty. Please keep it safe. </p> <h5 class="page_heading">What is the warranty for the replacement I got? Will it be the same as the initial product? </h5> <p>Yes, the warranty for your replacement will be the same as your initial product. </p> </div> FAQ FAQ FAQ faq