Firmamızda aracınızda bulanan bütün yedek parça ve malzemelerin teminini gerçekleştirmekteyiz. Herhangi bir parça ihtiyaç duyduğunuz zaman sorununuzu bizlerle paylaşabilirsiniz. Bizleri tercih ettiğiniz için teşekkürler.
İnternet mağazamızdan oluşturduğunuz siparişleriniz, size Yurtiçi Kargo güvencesiyle ulaştırılmaktadır...
Alanında uzman çalışma ekibimiz ve en son teknolojik imkanlarımız ve çözüm ortaklarımızla birlikte her marka model oto yedek parça hizmetini vermekteyiz.
Hasarlı gelen paketleri teslim almayıp, kargo görevlisine paketin hasarlı olduğuna dair tutanak tutturmanız gerekmektedir. Daha sonra siparişinizle ilgili müşteri hizmetlerimizle iletişime geçebilirsiniz.
Siparişiniz adresinizde bulunmadığınız için size ulaştırılamadıysa, Yurtiçi Kargo belirtilen adrese ikinci bir uğrama yapmamaktadır. Bu durumda kargonuzun bulunduğu şubeyi ziyaret ederek kargonuzu teslim almanız gerekmektedir.
Sitemizden beğenmiş olduğunuz ürüne gelip satın aldığınız ürünün seçimi yaptığınızda sepete ekle bölümü altında teslimat tarih bilgisi yer almakta olup siparişleriniz konumunuza göre 1 ile 3 gün arasında teslim edilmektedir.
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3354') ORDER BY tr1.priority ASC
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3354') ORDER BY tr1.priority ASC
SELECT pl.*, (SELECT name FROM oc_mz_product_label_description pld WHERE pld.product_label_id = pl.product_label_id AND pld.language_id = '1') name FROM oc_mz_product_label pl LEFT JOIN oc_mz_product_label_customer_group pl2cg ON (pl2cg.product_label_id = pl.product_label_id) LEFT JOIN oc_mz_product_label_to_store pl2s ON (pl2s.product_label_id = pl.product_label_id) WHERE pl.status = 1 AND pl2cg.customer_group_id = '1' AND pl2s.store_id = '0' AND pl.customer <= 0 GROUP BY pl.product_label_id ORDER BY pl.sort_order ASC
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '123' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASCLIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASCLIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECTCOUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '3794' AND pd.language_id = '1' AND p.status <> '0' AND p.date_available <= NOW()
SELECT d.data_id, d.hook, d.sort_order, d.setting FROM `oc_mz_catalog_data` d LEFT JOIN `oc_mz_catalog_data_to_product` d2p ON (d.data_id = d2p.data_id) LEFT JOIN `oc_mz_catalog_data_to_store` d2s ON (d.data_id = d2s.data_id) WHERE d.page = 'product' AND (d.customer_group_id = '1' OR d.customer_group_id = 0) AND d.customer <= 0 AND d2p.product_id = '3794' AND d.is_filter = 0 AND d.status = 1 AND (d.date_start IS NULL OR d.date_start <= NOW()) AND (d.date_end IS NULL OR d.date_end > NOW()) AND d2s.store_id = '0' GROUP BY d.data_id ORDER BY d.sort_order ASC
SELECT d.data_id, d.hook, d.sort_order, d.setting FROM `oc_mz_catalog_data` d LEFT JOIN `oc_mz_catalog_data_to_manufacturer` d2m ON (d.data_id = d2m.data_id) LEFT JOIN `oc_mz_catalog_data_to_category` d2c ON (d.data_id = d2c.data_id) LEFT JOIN oc_category_path cp ON (cp.path_id = d2c.category_id AND d.sub_category = 1) LEFT JOIN `oc_mz_catalog_data_to_filter` d2f ON (d.data_id = d2f.data_id) LEFT JOIN `oc_product_filter` pf ON (pf.product_id = '3794' AND pf.filter_id = d2f.filter_id) LEFT JOIN `oc_mz_catalog_data_to_store` d2s ON (d.data_id = d2s.data_id) WHERE d.page = 'product' AND (d.customer_group_id = '1' OR d.customer_group_id = 0) AND d.customer <= 0 AND (d2m.data_id IS NULL OR d2m.manufacturer_id = '16') AND (d2f.data_id IS NULL OR pf.product_id IS NOT NULL) AND (d2c.data_id IS NULL OR d2c.category_id = '123' OR cp.category_id = '123') AND d.filter_special = 0 AND (d.filter_price_min IS NULL OR d.filter_price_min <= '98.7') AND (d.filter_price_max IS NULL OR d.filter_price_max >= '98.7') AND (d.filter_quantity_min IS NULL OR d.filter_quantity_min <= '0') AND (d.filter_quantity_max IS NULL OR d.filter_quantity_max >= '0') AND d.is_filter = 1 AND d.status = 1 AND (d.date_start IS NULL OR d.date_start <= NOW()) AND (d.date_end IS NULL OR d.date_end > NOW()) AND d2s.store_id = '0' GROUP BY d.data_id ORDER BY d.sort_order ASC
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '3794' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESCLIMIT 0,1
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout.2_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout.2_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout.2_g.shortcode_data_assets' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.2_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.2_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.2_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT * FROM oc_product_discount WHERE product_id = '3794' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC
SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '3794' AND od.language_id = '1' ORDER BY o.sort_order
SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '3794' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
SELECT * FROM oc_product_related pr LEFT JOIN oc_product p ON (pr.related_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '3794' AND p.status <> '0' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 3794 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.top_header.31_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.top_header.31_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.top_header.31_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_header.31_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_header.31_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_header.31_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_header.31_g.shortcode_data_assets' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_navigation.31_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_navigation.31_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_navigation.31_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.header_component.31_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.header_component.31_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.header_component.31_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT i.information_id, id.title, i.bottom FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.footer.14_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.footer.14_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732227835)
SELECT * FROM oc_mz_document d LEFT JOIN oc_mz_document_description dd ON (d.document_id = dd.document_id) WHERE d.status = 1 AND d.route = 'product/product' AND d.store_id = '0' AND dd.language_id = '1'
SELECT c.category_id FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '16' AND m2s.store_id = '0'
SELECT v.url, v.image, (SELECT vd.title FROM oc_mz_product_video_description vd WHERE vd.product_video_id = v.product_video_id AND vd.language_id = '1') title FROM oc_mz_product_video v WHERE v.product_id = '3794' ORDER BY v.sort_order ASC
SELECT a.url, (SELECT ad.title FROM oc_mz_product_audio_description ad WHERE ad.product_audio_id = a.product_audio_id AND ad.language_id = '1') title FROM oc_mz_product_audio a WHERE a.product_id = '3794' ORDER BY a.sort_order ASC
SELECTCOUNT(DISTINCT o.order_id) AS total FROM `oc_order` o LEFT JOIN `oc_order_product` op ON (o.order_id = op.order_id) WHERE op.product_id = '3794' AND o.order_status_id IN (15,2,3,1,5)