Category query oscommercetrabajos

...have a feature that I want to optimize. This function specifically includes: a. The basic information input is simplified into: [Industry] (filled in by the user), [Recommended indicator categories] (users can add or delete them themselves), and [Core indicators] (filled in by the user, multiple are allowed) b. The returned mind map: the root node is [industry], the primary category is [recommended indicator category]+[core indicator], and the lower level nodes are the given data and the model's own judgment of drilling down results. c. The user inputs the analysis case enterprise, the system searches for relevant content based on the brain map structure, and generates an analysis report. The user can download the report. Note: This step can refer to calling the d...

I need help with the creation of a MongoDB view on a basic array collection. This is a personal project. Here's what I expect: - You need to be experienced with MongoDB, particularly with creating views. - The task will only involve creating the MongoDB view, no data import or query optimization. - The complexity of the task is on the simple side, dealing with basic operations. Required Skills: - MongoDB - Database management - Basic understanding of array collections

I am looking to develop a custom application to manage my financial transactions securely and efficiently. The main idea is to ensure that each transaction is verified by an anti-fraud microservice before updating its status. This application will simplify my financial life by providing clear tracking of each transaction made. Key Features: Transaction V..."Guid", "transferTypeId": 1, "value": 120 } Resource for Retrieving Transactions: Implementation of an endpoint to retrieve transaction details, with the following format: { "transactionExternalId": "Guid", "transactionType": { "name": "" }, "transactionStatus": { "name": "" }, "value": 120, ...

...will require you having “good taste”. One last thing you may be doing is engaging with comments section. I will be creating at least a dozen TikTok pages. All with their own different category. The goal would be to have you work on at least 3 channels. Posting at least 2 or 3 videos a day. And you’ll get to pick your category!! So this may be fun for you. Example categories can include: tech, sports, humor, news, motivation, cars, travel, and much more! If all goes well this can be a full time looking for affordable bidders. Key Responsibilities: - Finding viral TikTok videos to category - Downloading, repurposing, and reposting - Engaging with Commenters - Learning to Livestream long format videos Skills and Experience: - You’ve ...

I am in need of a skilled developer with PHP/Laravel to make modifications to my educational courses platform. Based on a script from Codecanyon, the site requires adjustments in three key areas: the course card, header, and category card. I have the designs ready for each one.

...Product page (title, rating, product details, reviews) d) User to create account before writing review (to provide option to login via FB and Gmail for user’s convenience) e) Consumer dashboard: select product to write reviews, add photos f) Reviews to be approved before posting g) Product brand owner to create account to reply to review h) Admin to have ability to edit info on webpage (adding category, product, putting up advertisement) i) Security (SSL, Bugsnag) j) Database storage k) Analytical tool (Google) l) Transactional mail (mailgun?) – sign up notification, review approved notification m) Google Ads n) Cookies I would like to know how much is estimated cost above to develop and subsequently monthly cost maintenance (fix bugs, software pricing, security)? W...

I am seeking a proficient freelancer who is experienced in SQL Server to assist with writing a query. Single table. Need to return all rows that fulfill certain specific condition. Also, need help with the 'return type' for passing the query data retrieved. Language I am working on is c#. Amount: $10

I am a seasoned SQL professional, demonstrating mastery in Structured Query Language and database management systems. Proficient in crafting intricate queries, I am expert in optimizing data retrieval and expertise spans database schema design, normalization, and indexing, ensuring data integrity and system performance. With a keen eye for detail, he adeptly manages stored procedures, triggers, and views, contributing to the creation of robust and scalable database solutions tailored to diverse business requirements.

...Business Address Phone number Website URL Email address Facebook URL (wherever possible) Hours of Operation Other social media account information (where possible) When you do a category in a location, you will need to add the appropriate 'tag' to each record. So for cafes in Kep, the tags of "cafe" and "kep" would need to be included against each record. If a business is in multiple categories eg. Car, motorbike and bicycle hire, just include them the single time and put the three tags against that record. I am happy for this to be done over the coming week, with data provided as completed; as you do an area or category just send it through and I'll tick it off the list. Moving on... Please only bid if: You have a rating of 4.8 o...

i need to LINK the ADMINISTRATORS table to the STORES_CONFIG to restrict what certain users see when logged in. Example suppose we have 3 administrators or users then we might have a setup as:- 1. MASTER ADMIN (ME) - linked to "configuration" > SEES TOTAL SALES FOR ALL STORES 2. STORE 1 ADMIN - li...in place this will involve STORES_ID join each config table has a STORES_ID and that is recorded in the stores table also we have stores_config_table stores_id e.g store config name stores ID config_tomsdiner 1 config_pizzashop 2 then any data which is CALLED using MYSQL queries we need to add some sort of JOIN or WHERE CLAUSE or AND condition e.g QUERY....................... bla bla WHERE stores_id = 2 etc NO TIME WAST...

...Stripe. Direct experience with Payretailers is a huge plus. - **API Integration:** Capable of creating and managing connections between our WordPress site and external services via their APIs. You should be able to handle data securely and efficiently, ensuring user data protection while maintaining high performance. ### Additional Notes: - Although not a specific requirement from the initial query, considering the integration of a payment gateway, it is implicit that the developer should ensure the system is secure and complies with relevant financial data protection standards. - The ability to add new functionalities (like Refund and cancellation features, or Real-time reporting and analytics) in future updates would be appreciated, even if it's not an immediate req...

Send buyers to my Affiliate link at Fiverr Pro category, at least 5 buyers

Find buyers to my Affiliate link on Fiverr Pro category, at least 5 buyer

Send buyers to my Affiliate link at Fiverr Pro category, at least 5 buyers

I'm on the hunt for a skilled WordPress developer to craft a series of engaging and functional website templates for diverse needs. These templates will cater to businesses, portfolios, and blogs, each designed to showcase content beautifully and effectively. **What I Need:** - A Homepage template that serves as a launching pad for any website's mission and content. - Product Category templates that organize and display items or services cleanly, making navigation seamless for visitors. - Individual Product templates tailored to highlight the unique features and details of products, providing all the necessary information at a glance, and a buy now button, with options for choosing an available date which is linked to my live calendar. Outline sketches of the content of...

I'm on the hunt for a skilled WordPress developer to craft a series of engaging and functional website templates for diverse needs. These templates will cater to businesses, portfolios, and blogs, each designed to showcase content beautifully and effectively. **What I Need:** - A Homepage template that serves as a launching pad for any website's mission and content. - Product Category templates that organize and display items or services cleanly, making navigation seamless for visitors. - Individual Product templates tailored to highlight the unique features and details of products, providing all the necessary information at a glance, and a buy now button, with options for choosing an available date which is linked to my live calendar. Outline sketches of the content of...

i need to LINK the ADMINISTRATORS table to the STORES_CONFIG to restrict what certain users see when logged in. Example suppose we have 3 administrators or users then we might have a setup as:- 1. MASTER ADMIN (ME) - linked to "configuration" > SEES TOTAL SALES FOR ALL STORES 2. STORE 1 ADMIN - li...in place this will involve STORES_ID join each config table has a STORES_ID and that is recorded in the stores table also we have stores_config_table stores_id e.g store config name stores ID config_tomsdiner 1 config_pizzashop 2 then any data which is CALLED using MYSQL queries we need to add some sort of JOIN or WHERE CLAUSE or AND condition e.g QUERY....................... bla bla WHERE stores_id = 2 etc NO TIME WAST...

A website similar to Ebay Where one of us can sell an item as a promotion and others can bid on it, there are different choices of auction duration there are different chargeable options for the actions for example Top category Gallery Homepage XXL pictures Category 2 the users receive various e-mails automatically etc budge ist 600 US Dolla

...in Yii2:** Must be capable of efficient backend development, specifically with experience in working with multiple tables and extracting specific columns. - **React.js Proficiency:** Should have a strong grip on React.js to create a dynamic and responsive frontend display for the data fetched from the backend. - **Database Skills:** Deep understanding of database management, with the ability to query multiple tables and fetch specific data sets without impacting performance. - **Frontend Display:** Ability to incorporate various file types in the frontend display, ensuring a seamless user experience for displaying text and other data like files uploaded. **Ideal Skills and Experience:** - Experience in developing complex applications with Yii2 and React.js - Solid understanding...

I'm in need of a skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - *Resolve the current error*: To continue our operations without disruptions. - *Enable new data analysis capabilities*: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers.

I'm looking for a marketing professional to come up with an engaging and strategic proposal that primarily targets youths and young adults. The aim of the proposal should be to help increase brand visibility and strengthen customer loyalty through the WhatsApp platform. To add context, the brand falls under the Fast-Moving Consumer Goods (FMCG) category where competition for attention and loyalty is tight. The proposed messaging should thus be creative, youth-relevant, and memorable. Key Deliverables: - A short strategic plan to maximize the use of WhatsApp channel as a marketing channel that can be used as channel to promote campaign promos, offer customer education and as a way to drive customer engagement and loyalty. Ideal Skills and Experience: - Proven experience in...

Ruchome rendery okien drewnianych, Źródło do wykonania w załączniku oraz efekt końcowy - wykadrowany render. Jeśli ktoś potrafi zrobić to w tej formie: ;A - proszę o propozycję. Proszę o cenę za 3 wykadrowania każdego okna w formie zdjęć. Przypominam mamy 10 okien. Ruchome rendery jak z linku - proszę o informację. Proszę przesłać swoje poortfolio.

...project will focus on integrating a robust user system, search capabilities, and a review mechanism. Here are the key features and requirements: **Key Features:** - **User Registration and Login:** Users should be able to register and log in to access personalized features. - **Search Functionality:** The directory should offer advanced search options, allowing users to find businesses by location, category, or keyword. This function needs to be fast and accurate, optimizing user experience. - **Review and Rating System:** Incorporation of a star rating system where users can rate businesses. This will help others in making informed decisions based on community feedback. -**Social Share** -**Blog System** - blog landing page, blog single post design, **Ideal Skills and Experi...

- Must know PHP and MYSL - Must know Oscommerce - Must know BOOTSTRAP (responsive admin) This is ongoing development (long term) for the right suitable candidate. Must be fun and enjoyable to work with. My motto is: If i like you i hire you if i dont like you i fire you. My bootstrap admin is great out of the box but now i want to tweak it and tailor it to my specific clients. I will be the MASTER ADMIN as i currently am. However i am the only admin able to login. To make things easier for you to understand, my clients have stores. I have each store in my db with a store ID. Each store has an ID, name, opening hours etc etc so they all have their own settings... I have been using oscommerce classic admin for many years but it is NOT mobile friendly and will take much tim...

- Must know PHP and MYSL - Must know Oscommerce - Must know BOOTSTRAP (responsive admin) This is ongoing development (long term) for the right suitable candidate. Must be fun and enjoyable to work with. My motto is: If i like you i hire you if i dont like you i fire you. My bootstrap admin is great out of the box but now i want to tweak it and tailor it to my specific clients. I will be the MASTER ADMIN as i currently am. However i am the only admin able to login. To make things easier for you to understand, my clients have stores. I have each store in my db with a store ID. Each store has an ID, name, opening hours etc etc so they all have their own settings... I have been using oscommerce classic admin for many years but it is NOT mobile friendly and will take much tim...

I am in need of a marketer to help increase downloads of my mobile gaming app specifically targeting young professionals via Google Ads. - Your goal: Increase app downloads targeting young professionals. - Expectation: A strategized Google Ad campaign to reach the target demographic. - Ideal skills: Experience with mobile app marketing, particularly in the gaming category, and proficiency with Google Ads. Experience marketing to young professionals would be beneficial. - You must be adept at interpreting analytical data to continuously optimize the campaign for the best results.

I'm in need of a skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - **Resolve the current error**: To continue our operations without disruptions. - **Enable new data analysis capabilities**: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers. **Required Skills and Experience**: - Proficiency in Google BigQuery (Standard SQL) - Experience wi...

I am seeking a skilled Oracle and SQL database specialist who can efficiently assist me with database management tasks. This will include database design, data modeling, and query optimization. Ideal skills and experience you should bring include: - Expertise in Oracle and SQL database - Knowledge in data modeling and database design - Troubleshooting and performance optimization skills - Proven ability to deliver high-quality work under deadlines The main purpose of the project is to enhance database proficiency that encompasses data storage and management, application development, and optimization of performance. The end goal will be to achieve a streamlined, fully-optimized, user-friendly database system. Deadline: 2 days Fix budget mode

Hello, I am Frédéric, head and founder of B2C Advisors, a small boutique firm, helping FMCG players in margin optimization I am looking for my "analytical" and "workshop" lieutenant in an assignement to be done in Portugal for a brand, that will, as category captain , make recos to a top retailer in developing an optimized assortment that boosts overall performance. This person, a data scientist / statistician by education with an exposure to consultant and based in portugal, will have to use a well established analytical method to compute key KPIs including elasticity and present the results in a compelling slides, in PPT and under time constraints. So this person has to have experience in "fixed" duration project (not just...

I'm looking to transition out of selling on Amazon and am in need of a reliable wholesaler to purchase my entire inventory, which falls under the home and kitchen category. Due to a strategic shift in business focus, I've decided that it's time for this change. I would like this process to be as smooth and efficient as possible, while ensuring that all parties involved benefit from the transaction. **Ideal Skills and Experience:** - Proven track record in wholesale purchasing, specifically for home and kitchen items. - Strong negotiation skills to ensure a fair price is agreed upon. - Experience with Amazon seller accounts and understanding of the logistical aspects of transferring inventory. - Excellent communication skills for clear and effective discussions. **Ke...

I urgently require a detailed and complete Bill of Materials (BOM) for a diverse array of construction aspects, including: - Civil works - Electrical works - Plumbing works - Iron works - Glass works - ACP sheets work The freelancer I choose for this task needs to deliver not just a list of materials but also outline the specific quantities required for each category. The ideal candidate will have a background in civil engineering or quantity surveying, with proven experience in preparing comprehensive and effective BOMs for large-scale construction projects. Immediate availability and ability to deliver the project promptly will be highly advantageous.

I am in urgent need for a creative and versatile copywriter to produce engaging ad copy for a multitude of categories. Ranging from foo...candidate. Ideal Skills and Experience: - Proficiency in writing persuasive ads for radio - Ability to create effective copy across a wide range of industries - Experience in tailoring messages for diverse audiences - Strong understanding of various categories including but not limited to retail, technology, hospitality, and career development. Your task will be to capture the essence of each category and convey it effectively in our ad copy. The scope of the task requires a talent who can think broadly and adapt their writing style to accommodate diverse subjects. Previous experience in writing for such a wide variety of sectors is highly ...

I have an issue with my enfold theme is creating a query tag behind the videos hence the vidoes are not getting cached as i would like to be. I need someone who knows exactly what this issue is and fix it. I dont want a generic expert. I am looking for specifically this issue only when u bid, write "yes i know how to fix query issue in video enfold theme" so i know u know

Application features : with explanations categorised year wise & subject wise & topic wise mode : user can see explanation after each and every question based test : Result and explanation will be shown after finishing the test. can bookmark questions. 5. Login restriction on single device Admin panel : 1. Admin can upload the papers subject wise ,category wise,topic wise 2. Import option for questions integration for app subscription 4. Html+text editor so that admin can upload study material

I'm seeking expertise for product research tailored for Amazon FBA wholesale, common products/brands such avon, gillette, colgate, axe, nivea... products available in costco or any wholesaler in USA. product in top-selling categories, with high Sales demand with highest reviews, 4 or above review rating , high Sales Velocity , High Search volume , Good Profit Margin and ROI Category: Baby, Health & Household ,Home & Kitchen, Industrial & Scientific, Kitchen & Dining ,Pet Supplies, Arts, Crafts & Sewing , Office Products, Patio Lawn & Garden , Spots & Outdoors, Tools & Home Improvements , Toys & Games BSR 1 to 50000 or less - preferable : Average BSR of last 90 days Amazon should not be selling or Out of Stock Reviews - More than 100 Rating...

I'm in need of a skilled developer to enhance my Shopify store's blog page by introducing a sophisticated sidebar filtering system. This project is critical for improving user experience, allowing visitors to seamlessly navigate through content according to their interests. **Requirements:** - Implement a category filter in the sidebar that supports multiple selections. This means users should be able to refine their search results by selecting more than one category at a time. - Integrate a fully functional search bar within the sidebar. This search mechanism is intended for users to find specific blog posts easily and should be optimized to not affect the overall page loading speed. **Ideal Skills and Experience:** - Proficiency in Shopify platform development, ...

You need to save the Home page, service pages, policy pages (20 pages to save) etc from my old Blocksy theme website as Elementor Templates. Then you need to install the Woodmart theme on my staging site. Then you will upload those saved templates on the new website using the Woodmart theme. You will then need to customise the Woodmart e-commerce pages (shop, product, category, cart etc) pages to have the same look and feel (fonts, colors and branding) as the old blocksy website.

I want you to use Elementor and Woocommerce on the Blocksy theme to recreate the following pages from the Woodmart theme (): Shop Home Product Category Product Cart Basket Checkout You will need to recreate these pages and make sure they have my look and feel, including my fonts, colours, logos, etc.

I require an engineered plan for water demand in my medium-sized RV park. This park is comprised of 50-100 RV spaces, and incorporates on-site laundry facilities. Here are the specifics: - Size of the RV Park: The park falls under the medium category with 50-100 RV spaces. - Additional Water Features: The park features laundry facilities which would require additional water supply planning. - Water Source: The water supply for the park will be from groundwater wells. The ideal candidate for this job would have a substantive background in civil or environmental engineering with the ability to estimate water demands considering facilities and ground water supply sources. Experience with designing water supply systems for similar-scale projects would be greatly preferred. Furthermore...

...a more streamlined, automated method is imperative. We're focused initially on basic expense tracking—total and categorized expenses—laying the groundwork for future financial clarity and control. **Key Responsibilities:** - Evaluate current spreadsheet-based tracking system - Implement a more efficient, possibly software-based, expense tracking method - Ensure total expenses and expenses by category are easily identifiable and up-to-date - Provide monthly reports summarizing categorized expenses **Ideal Skills and Experience:** - Proven experience in bookkeeping, particularly in expense tracking - Proficiency in spreadsheet software and familiarity with bookkeeping software - Strong analytical skills for categorizing expenses accurately - Ability to suggest an...

As a pub owner hosting recurring quiz night, I need a PowerPoint presentation covering General Knowledge. This presentation will form the basis of our pub quiz, aimed for engaging and entertaining our patrons. Details of the Project: - Creating a general knowledge category featuring 10 questions - Incorporating multimedia elements such as animations, sound effects and video clips into the presentation The ideal freelancer for this project should have: - Excellent knowledge of PowerPoint. - Experience with multimedia editing (animations, sound effects, video clips) - Creative mindset for curating engaging General Knowledge questions - Prior experience in designing similar quizzes will be an advantage.

SQL Query Optimization Expert Needed ASAP Skills: - Strong knowledge and expertise in SQL - Proficient in query optimization techniques - Advanced understanding of SQL database complexity Project Requirements: - Immediate assistance required for query optimization - Deadline: Within 24 hours Please only apply if you have the necessary skills and can deliver within the specified timeframe. This is an urgent project that requires an expert in SQL optimization.

I'm seeking a talented freelancer to embark on an exciting project that involves generating 190 blog articles aimed at elevating our website's traffic and improving our SEO rankings. This project is not just about writing; it's about leveraging AI to deliver content that resonates with our audience and adheres to our business goals. Ideal Skills and Experience: - Proficiency in...to make our Shopify store not just a shopping destination but a valuable resource for our customers. So we have 190 URL in sitemap and we need to generate 1 blog article for each URL with GPT 4 and post it on our blog store. We tested and average time is around maximum 5 minutes to copy the URL / replace in our prompt / copy the generate blog - add it as a new blog - add the image - select the ...

i have a php script with some mysql queries and joins by DEFAULT there is no filter or condition on the STORE ID as when the script is loaded the first time no store id is selected so ALL data will be loaded for all stores now to filter the data for a specific store i added a WHERE clause to my query where o.orders_stores_id = '" . (int)$_GET['store_id_dd'] . "' '" . (int)$_GET['store_id_dd'] . "' is determined once i select a store from the dropdown filter. then it registers once i press submit however this only works if i add that WHERE clause the issue with that WHERE CLAUSE is that the DEFAULT or NULL case will not work and nothing will be returned as the code is treating it as NOTHING i.e its expecting a store id...

I'm currently experiencing performance notifications and policy violations on my Amazon account. I have indeed received warnings from Amazon concerning these issues. The main category of the products I list is autoparts. I need a freelancer with the following skills and experiences: - Extensive knowledge of Amazon's policies and procedures - Past experience in resolving Amazon account health issues, particularly pertaining to performance notifications and policy violations - Knowledge in the autoparts category listed on Amazon - Proven track record in restoring the health of Amazon accounts Your responsibility would be to understand the exact issues causing these warnings and to produce a clear strategy that will resolve them effectively.

I need the search results page (when searching based on vehicle criteria or any other search) to show a page that matches the "shop" page or "category results" pages.

HEllo, I'm looking for anybody that provide me the SQL query that inserts the answers to the questions about the products from this module: The reply should be some thing like "INSERT ..."

...for engaging with our site's visitors by allowing them to easily get in touch with us, so it should be both functional and user-friendly. This forms should be in such a manner that if we are creating a page/blog page/product and selecting category, automatically those category webform should be attached with that new page All categories are already at our website and fully functional. ### The form must include: - **Fields for user input:** There should be dedicated fields for a Name, Email, Phone Number, Main Category, Sub-category of the Main Category, and a Description box. - **File Upload Option:** Users should be able to attach documents or images as part of their inquiry. - **CAPTCHA Verification:** To prevent spam, I want a CAPTCHA system...

...performance and reliability - Strong understanding of data security and integrity measures - Familiarity with the demands of various industries, enabling a flexible and adaptable approach to design **Project Goals:** - **Storage Efficiency:** Implement compact, yet expandable, storage mechanisms to handle growing data volumes without compromising performance. - **Retrieval Speed:** Design indexing and query optimization strategies that minimize access times and facilitate swift data retrieval. - **Data Integrity:** Ensure robust mechanisms are in place for data validation, error handling, and recovery to maintain high-quality data standards. Database Design Documents/ Deliverables: UML Class Diagram: Visual representation of the entities, attributes, and relationships. ERD (E...

...following information from each email: - Sender’s email address - Email subject - Body text of the email - Store the extracted information in a specified database. **Ideal Skills and Experience:** - Familiarity with different email service providers and their IMAP configurations. - Strong understanding of secure authentication methods for email retrieval. - Proficient in SQL or similar database query language. - Previous experience in email parsing projects. **Platform Used** AlmaLinux 8 64bit with cPanel ** Do Not ** -Ask us to install a framework -Provide code with outside (off server) calls to 3rd parties for any processing The goal is to provide a reliable and efficient way of processing emails into manageable data for our business operations. Freelancers bidd...