"hola"
SELECT p.id_product, pl.name, id_image, t.id_button, IFNULL(pcl.name, "Sin stock con fecha de entrada") as contact, p.id_product as id_od_outofstock FROM ps_product p LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product AND pl.id_lang = 1 LEFT JOIN ps_od_oosbutton t ON t.id_product = p.id_product LEFT JOIN ps_contact_lang pcl ON t.id_button = pcl.id_contact AND pcl.id_lang = 1 LEFT JOIN ps_image_shop i ON p.id_product = i.id_product AND i.cover = 1 WHERE (t.id_button IS NOT NULL) GROUP BY id_product
array:8 [
  0 => array:6 [
    "id_product" => "203"
    "name" => "Power supply 4 Amp. Single channel amplifier serie Tas 001 Triax"
    "id_image" => "2627"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "203"
  ]
  1 => array:6 [
    "id_product" => "204"
    "name" => "Triax TAS 050 Mono Amplifier TDT UHF 50 dB"
    "id_image" => "2632"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "204"
  ]
  2 => array:6 [
    "id_product" => "21818"
    "name" => "Tegui Dual camera B/W TC-70 Europa Series"
    "id_image" => "294910"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "21818"
  ]
  3 => array:6 [
    "id_product" => "28166"
    "name" => "Wisenet WAVE-VW-02 Video Wall License. Management of 2 monitors."
    "id_image" => "297649"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28166"
  ]
  4 => array:6 [
    "id_product" => "28225"
    "name" => "Risco RP512B00000A Polycarbonate box for ProSYS Plus control…"
    "id_image" => "297709"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28225"
  ]
  5 => array:6 [
    "id_product" => "28756"
    "name" => "Bticino 336803. Cable for connection to the installation of internal stations installed on a desktop support"
    "id_image" => "298287"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28756"
  ]
  6 => array:6 [
    "id_product" => "28758"
    "name" => "Hikvision pro DS-2CD3646G2/P-IZS(2.8-12MM) Cámara IP 4MP bullet…"
    "id_image" => "298289"
    "id_button" => "0"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28758"
  ]
  7 => array:6 [
    "id_product" => "28780"
    "name" => "Risco RVIM3A15000A / PFA150 Pole adapter for PFBx PFAx"
    "id_image" => "298428"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28780"
  ]
]
Conditions and information on returns, exchanges, repairs and guarantee.

Conditions and information on returns, exchanges, repairs and guarantee.

MANDATORY REQUIREMENTS for RMA processing

If you do not meet the following requirements, we will not be able to accept your request and could incur some expense for you. Entering here you have the general conditions in case you want to expand this information.

Withdrawal (return) summary.

  1. You must have completed the request within 14 calendar days after receiving the package. You have more information in the General Conditions.
  2. The product must be in perfect condition, without scratches, wear or breaks and with all accessories, packaging, boxes and seals, any product that does not meet these requirements may suffer a depreciation that will be discounted from its value.
  3. In the case of equipment with software / firmware it is essential that they have the original factory firmware.
  4. The cost of shipping the product to be returned to our facilities will be borne by the customer, we offer an optional home collection service only for customers from Spain Peninsula, it has a cost of 7.60 euros, which may be a higher value depending on the weight and / or volume.
  5. To request a return, you can do it by any means you want, email info@orbitadigital.com, postal letter, opening a Return (RMA) on our website or from the withdrawal form , provided that the content of the same has a clear statement that you want to return the product.
  6. These are the recommended steps to make a return:
    1. Through our website (recommended and faster method) click HERE to open and see the steps to carry out the return process through our website.
    2. Through the withdrawal form you can download the document HERE fill it out, sign it and scan it and send it to the address that appears on it
  7. Click HERE to see how I have to send the product.

Warranty repairs:

  1. You must have made the request within 2 years from delivery. You have more information in the General Conditions .
  2. The guarantee does not cover faults or damages caused by misuse of the product, surges, manipulation or blocking of software / firmware or any other that is not a defect or manufacturing failure.
  3. If a product is sent for repair and it does not present any operational problem, the customer would have to pay the shipping and return costs, as well as the technical service labor cost of 18 euros / hour.
  4. It is highly recommended that the product contain everything necessary to be reviewed by the technical department, such as the remote control, power supply, etc.
  5. Click HERE for steps to perform a warranty repair.
  6. Click HERE to see how I have to send the product.