Создать sql запрос

Good day! We are the official representative of the Swiss brand Midland in Ukraine (https://midland.ua). We are looking for an experienced developer or a small team to create a modern online store that will become the main online sales channel for our products in the future.Main requirements fully self-hosted solution (the website, source code, and all rights must belong to us); modern responsive design; catalog of about 300 products; user-friendly product catalog, search, filtering; shopping cart and order processing; customer personal account; integration with popular payment systems in Ukraine; integration with major delivery services in Ukraine; import of products from Excel; SEO readiness; high website performance; possibility of further functional expansion.What we ask you to specify in your response which platform you recommend and why; estimated development cost; estimated completion time; what is included in the cost; examples of online stores you have implemented; whether you work under a contract; whether phased payment is possible. We would also appreciate your recommendations regarding the implementation of the project or functionalities that you believe will help make the store more convenient, modern, and effective in terms of sales. After selecting a contractor, we plan further development of the project and implementation of additional functionalities. Thank you! We look forward to collaborating.

A developer is needed with experience specifically in CS-Cart Multivendor for two related modifications on an existing online store. Task 1 - broken product photos. On the pages of some products, they do not display. Some photos show a "broken" image icon. Self-diagnosis revealed two different types of causes: The original photo exists on the server, but a specific non-standard (non-square) size needed for full-screen viewing of the photo is not generated (this function is from the third-party module "AB: Advanced Image Viewers," AlexBranding). Square sizes of the same photos are generated without problems. The original photo is completely absent on the server - a specific example and link will be provided upon response. Task 2 - warming up the cache of new products. The site automatically parses and adds new products every night (a separate cron script). Page caching is already set up and working, the warming of the main page and categories has already been done - but the pages of the new products themselves are still not warmed up immediately after import, so the first real buyer who opens a new product directly experiences slow "cold" loading. It is necessary to add automatic warming (curl/wget for the list of new products) immediately after the completion of the nightly import. All necessary access will be provided to you after selection. Work format: two separate stages with separate or joint payment for each task. First, diagnostics/analysis with written confirmation of the approach for each task, then implementation. Respond if you have relevant experience with CS-Cart Multivendor - details and a test task will be provided in personal correspondence.

We are a custom printing production on clothing and DTF transfers. We use a specialized site on WooCommerce, where the cost of products (for example, custom film transfers) is often calculated per square inch or depends on the volume and does not have a fixed price per unit, but there are also physical products. We need an experienced specialist in GTM/GA4 to fix our tracking architecture and replace the current temporary solutions with full-fledged e-commerce tracking. Current tracking issues that need to be fixed: Broken "Add to Cart": The current setup is a temporary solution (a workaround), where the add_to_cart event triggers during the loading of the view_cart page, rather than upon the actual click of the button. Missing/Incorrect values: E-commerce data is not being sent properly (Data Layer sends false for e-commerce, and the product prices are displayed incorrectly, for example, 0.03 CAD instead of the dynamically calculated price). Bug with quantity in Meta Ads: Meta Pixel misinterprets our custom sizes. If a customer buys one print of 30x30 cm, Meta currently records this as 900 conversions instead of 1 unit of product. Language and Email synchronization: English-speaking users add products to the cart but receive automated abandoned cart emails in French. Lost conversions: Some successful purchases do not trigger the final conversion tags on the site. Scope of work and expected results: Data Layer optimization: Implement (or provide exact code for our developer) a reliable Data Layer that captures the correct dynamically calculated price (value) and actual product quantity (quantity), isolating print sizes into a custom parameter. GA4 e-commerce tracking: Fix the add_to_cart and purchase events to trigger exclusively on user action with accurate e-commerce array data. Google Ads: Fix the "Purchase" conversion tracking to ensure accurate ROAS calculation based on the actual cart value. Meta Ads Pixel and CAPI: Fix the purchase and add_to_cart tags so that Meta tracks 1 physical product as 1 conversion. Set up Meta Conversions API for greater accuracy. Audience creation: Create custom remarketing audiences in GA4 and Google Ads based on specific products and user language (FR and ENG). Fixing Email marketing triggers: Ensure that the active user language parameter (FR/ENG) is correctly passed through GTM to our email marketing platform for proper language flow.

Development of an Online Store on WordPress / WooCommerce An online store needs to be developed on WordPress (WooCommerce) using the WoodMart template, configure the necessary functionality, integrations, and deploy the site on hosting. Template: https://themeforest.net/item/woodmart-woocommerce-wordpress-theme/20264492Main Requirements installation and configuration of WordPress, WooCommerce, and the WoodMart template; hosting the site; importing products from Prom.ua (photos, names, descriptions); synchronization with CRM (stocks, articles, prices); installation and configuration of a free SEO plugin (Title, Description, Sitemap, SEO-friendly URLs); connecting delivery: Nova Poshta; Ukrposhta; setting up payment methods: cash on delivery; online payment (LiqPay or WayForPay); setting up promotional prices (displaying crossed-out old prices); setting up free shipping and/or discounts on shipping for orders over a specified amount; adaptive display of the site on mobile devices;Please Indicate in the Response examples of implemented online stores on WooCommerce; total project cost; estimated completion time;Important Do not include in the project cost: hosting; domain; SSL certificate; license for the WoodMart template; cost of paid plugins (if needed). Payment for the mentioned services and licenses will be made separately.

A strong specialist/team is needed to create a brand showcase website for the TM (not a classic marketplace). Product: household and beauty appliances (massage chairs, percussion massagers, stylers, straighteners, irrigators, electric toothbrushes, cordless vacuum cleaners). Catalog ≈20–30 SKUs (will grow later). Sales mainly through marketplaces and offline, but the site must support order placement and payment (full payment + installment through Ukrainian providers). Requirements / tasks: Design and layout on OpenCart Custom brand UI (desktop + mobile), pixel-perfect implementation. References: https://www.mi.com/ua, https://dreame.ua Structure: Home → categories → collections → product card (rich content). Product card: hero, photo + video gallery, how-it-works, tabs (specifications / configuration / instructions / FAQ), model comparison, "Where to buy" block (buttons to marketplaces + "Buy on site" button), reviews/UGC. CMS for products (~30 entries, scalability option), blog/guides. Functionality Dynamic product card templates, custom fields option (specs, metafields), filters/sorting. Order forms on the card and simplified checkout (mobile friendly). Integration Web-form → middleware → KeepinCRM (creating contact + deal/order; transferring SKU, qty, price, UTM, channel). Payment integration through Ukrainian aggregators (WayForPay / Fondy / LiqPay) with support for installment payments (through aggregator or middleware). Tracking: GA4, Facebook/Meta Pixel, event-tracking (view_item, add_to_cart, begin_checkout, purchase), UTM parameterization. SEO: optimization of cards, friendly URLs, meta, Open Graph, microdata product schema. Bulk filling: CSV import/export (products, categories). Performance & security: caching, image optimization, SSL, basic security measures (WAF/updates), backup scheme. Admin functions: simple panel for editing cards, managing orders, promo codes, login/access levels. Deliverables (what should be delivered) Ready OpenCart project on production host (or deployment instructions) + administrative accesses. Middleware (Node/PHP/Serverless) — source codes + deployment/instructions (form processing, payment creation, webhooks, integration with KeepinCRM). Documentation: how to edit CMS, instructions for working with orders, checklist of test scenarios. Administrator training: min. 4 hours online (working with admin panel, import/export, order processing). Support: bug fixes for 8 weeks after release (SLA conditions to be discussed). We provide Brand book/logos, examples of photos/videos (partially), SKU list with descriptions and technical data. Access to KeepinCRM (test API key upon request), access to hosting/domain after agreement. Requirements for the performer Portfolio: min. 2–3 live sites on OpenCart with custom product pages; examples of implemented integrations forms→CRM or payment integrations. Experience: OpenCart (modules, templates), middleware development/configuration (Node/PHP), working with APIs (KeepinCRM, WayForPay/Fondy/LiqPay), webhooks. Understanding of SEO, frontend performance, and security. Processes: regular updates (weekly), communication in Telegram/Slack, use of task tracker (Trello/Jira/Asana). In the application, indicate: a brief resume of the team/experience, links to cases, preliminary assessment of terms and costs. Willingness to complete a paid test task (layout of 1 card + integration of form → test endpoint). Terms and budget Estimated implementation time for MVP: 4–8 weeks (to be discussed). Estimated budget: preliminary assessment — to be indicated in the application. Additional technical clarification (to be discussed before hiring) What set of modules/version of OpenCart is proposed to be used; hosting plan; what backup/monitoring tools the performer provides; conditions for transferring source codes and accesses after completion.