Store file database jobs

I'm looking for a seasoned merchandiser to help me enhance the layout of our large hardware store in Oakland, CA. The store is over 5,000 square feet in size and caters primarily to DIY enthusiasts. Our product lines include tools, home improvement products, and housewares. Key tasks include: - Suggesting product placement strategies to maximize visibility and sales - Developing a merchandising plan that creates a logical flow for customers - Designing eye-catching displays for featured products - Sourcing or recommending display materials that fit our clientele Experience in hardware store merchandising is a must. Being familiar with the Oakland market and its DIY community would be a big plus. The goal is to create an intuitive shopping experience that appe...

I am looking for a skilled professional to set up an Odoo community on a virtual server, and customize it to meet the following requirements: -Background info: We are a decorative concrete company seeking a tech solution that will aid in our growth, utilizing automations to ease workload, store and organize data, keep associates and clients up to date, organize data in an easy to digest format, track and report project status and details. The solution shall be hosted on a virtual server. In order to be considered for this project the freelancer shall submit, in detail their proposed solution, including how they would deliver it, what they would require in order to get it done, data safety protocol, secure development, timeline, budget, ongoing/maintenance cost, training on system, ...

I need three graphics, they can be the same but one must be sized A4 for an email blast, one must be sized for Instagram and one 1920px X 450. They can be the same design, just reconfigured for the three sizes. This is for National Police Week May 12th - May 18th. Our entire store is on sale. I am including sample images as well as our contact information. I really like the sample image titled Police-Week. You can use that, size it according and include our logo and contact information. I am looking for a clean design. Again, I need three sizes, in JPG, PNG, and PSD.

...financial tracking, and user access control. Responsibilities: - Customize the UltimatePOS web app to include the following functionalities: - **Inventory Management:** Adapt system to handle items via IMEI, serial numbers, or without identifiers. - **Sales Management:** Enhance system to process sales using item identifiers. - **Customer and Supplier Management:** Develop capabilities to store detailed records, including transaction history and preferred payment methods. - **Payment Processing:** Integrate various payment options with specific validation for bank transfers. - **Financial Tracking:** Add features to track all transactions, manage expenses, and handle payments to suppliers and customers. - **User Management:** Implement a role-based access control sys...

We are launches a brand called PCS Supplies. The slogan is Protect Collect Store We will be selling products for the protection and storage of collectables (comics, trading cards, baseball, footballs) We are looking for a logo to be created using the initials PCS We are going to be using the logo on products and on social etc. We also need insert/wrapper document styling which can be applied consistently across our products. On some products the logo needs to be black and white so needs to work in that colour option too. We are looking for a clean/modern look and the document styling to be distinguished. So if you see it from far you know they are our range.

I'm in need of a skilled photo editor who can enhance my product shots. Requirements: - Background Removal: The images require clean, professional backgrounds to make the products stand ...enhance my product shots. Requirements: - Background Removal: The images require clean, professional backgrounds to make the products stand out. - Color Correction: Ensuring the product colors are accurate and vibrant. - Retouching: Light retouching is needed to make the product look its best, without over-editing. The job involves editing a batch of 50-100 photos, which will be used for my online store and social media platforms. The ideal candidate should have experience in product photography editing and a keen eye for detail. Your work will be key in presenting my products in the best ...

I'm in need of a skilled Full-stack Developer to build a social network website from scratch. This site will serve as a communication platform and online store focused on community interaction and user engagement. Key Responsibilities: - Design and develop an interactive and user-friendly front end. - Implement a robust, secure, and efficient back end. - Integration of data storage solutions and ensuring high performance. Ideal freelancer's skills and expertise: - Extensive experience in full-stack development, including both front-end and back-end tech stacks. - Proficient understanding of web markup, including HTML5, CSS3, and JavaScript. - Strong knowledge of server-side MVC frameworks. - Experience in user authentication and authorization between multiple systems ...

I'm looking for an experienced Shopify store designer to help me create an engaging and effective online store for my physical products. Main requirements for this project: Brand: - I have already decided on some elements such as color and logo. Your task will be to use them as a basis for the remaining design elements. Shopify Store Design: - Create elegant, seamless navigation that provides clear paths to purchase. - Promote trust in our brand across all website touchpoints. Required integrations: -E-Commerce Integration -Invoicing system -Payment system -Dropshipping -Whatsap Chatbot Integration - Email marketing integration - Inventory management system - Integration with social media sales channels (Facebook, Instagram, etc.) Ideal Skills and Experience...

I'm searching for a Metashop next js react woocommerce headless theme for my new e-commerce storefront. I need this theme If anyone has it please bid.

...software compatible with Windows and Mac - Strong understanding of calendar integration and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Include searc...

I'm searching for a Metashop next js react woocommerce headless theme for my new e-commerce storefront. If anyone has it please bid.

...expert on building website with prestashop and deeply know SEO. 1. Installing caching system as below and configure them to get my website speed faster. Memcached via PHP::Memcache Memcached via PHP::Memcached They can be found at advanced parameters/performance/caching 2. Develop a pricing module to set the retail price. There is a installed module to import the product xml to my prestashop store. From those xml, there are two prices, cost price and retail price. The installed module has its own price rule but I want a individual module to override the pricing part of that module. The main requirement should be like this. • A friendly UI to set variables and fetch and list all brands with checkbox • The price will be calculated on below basis. a. a reference price fr...

A web page that, when you access it, activates your mobile or tablet camera. to take a picture from which the algorithm can read the text and add the data they want to the database. The read pages are road maps for AWB couriers that have many different shapes, sizes and layouts in the package. The algorithm must learn what data we need and store only those data in the database. The data is stored individually for each AWB read. To accept your collaboration, you must write to me that you understand what it is about and explain to me how you can do it. I do not respond to those who try to participate without the following information: To accept your collaboration, you must write to me that you understand what it is about and explain to me how you can do it.

...for a skilled individual with extensive experience in managing and optimizing ads for eCommerce stores, specifically to drive sales. The project entails focusing on platforms such as Facebook/Instagram, Google, and TikTok. The target audience for these ads are individuals aged between 25-44 years. Key Responsibilities: - Create, manage and optimize ad campaigns to increase sales on my eCommerce store. - Tailor the ads for platforms such as Facebook/Instagram, Google, and TikTok. - Identify and target the right audience within the 25-44 age group. Ideal Skills and Experience: - Proven track record in managing eCommerce ads, with a focus on increasing sales. - In-depth knowledge and hands-on experience with Facebook/Instagram, Google, and TikTok advertising platforms. - Understan...

...retail audit. The ideal candidate should have good communication skills. You will have to own an android mobile device to be eligible for this project. For this project, you will have to go to 15 stores and assess products for defects. The number of stores will decrease to 10, if the products' availability is more than 90% after the first 10 stores. The set fee for this project is €200. In each store you will have to assess the product, take photos of the defects, and assess the production code. Training material will be provided. Specific requirements for the project include: - Conducting a retail audit in Athens - Collecting data on an app - Must have an android device Skills and experience needed for this project: - Strong analytical skills - Excellent communica...

I need a ...user-friendly layout. - Full integration of my eBay store with the website, allowing products listings to synchronize between both platforms. The ideal freelancer must have: • Proficiency in website design that encourages user-engagement, enhancing visual aesthetics, and reorganising the layout. • Experience in eBay API integration would be an asset as it's crucial to upload products from eBay to the website and ensure that newly posted items on the website are also posted on eBay. • Good understanding of ecommerce best practices to optimize the site structure for better usability and effective product presentation. In summary, the project is about redesigning the existing website, integrating eBay, and setting up cross-posting for new store...

...from 14 to 30 years old. What is our value/concept? Our concept lies in offering an experience based on direct communication with our Clients, with a literary narrative in the genre of fables. For this reason, the 3 rabbits we have have direct communication with the customer, according to the selected product segment, which makes interacting with us tell a story. Our added value focuses on our store prototype which promotes an urban, pleasant, fresh, modern lifestyle and encourages us to enter a parallel world full of surreal imagination covered by art and music that generates cultural identification with our clients. , always based on the 3 rabbits. Our main purposes lie in 3 pillars that meet the needs of supplying non-conventional pet food, human food and household appliances...

I need help with a personal project. I have a logo file in PNG format, and I need specific wording removed. The wording is "Towing and Recovery". This is the only change I need; no layout or color adjustments are necessary. Ideal candidates will have experience in design software and be capable of editing PNG files, with particular skills in text removal. Precision in maintaining the original design while removing the text would be much appreciated. And providing Vector file/png/jpeg

...Colombia Rama Judicial file analysis system from Infolaftsearch. 2. Functionality to upload files downloaded from the Colombia Rama Judicial website. 3. Processing of uploaded files to extract and structure the required information*. 4. Visualization and filtering of the list of processes. 5. Detailed view of specific process information. 6. Temporary storage of uploaded files in the browser. 7. Functionality to delete data being processed and start a new analysis. 8. Automatic process to delete old records from the database. 9. Recording of deletions for audit and regulatory compliance purposes. Technical Requirements: - Development in Java, NodeJs, or Python languages. - Implementation of API for file processing and database access. - Data sto...

I'm seeking an individual to launch an Etsy store and start making passive monthly income from the store's earnings. This part-time job is totally online and doesn't take up much time. Initially, the responsibilities involve registering the store on the Etsy platform, and later down the line checking the monthly financial statements. We operate the store on your behalf, selling our handmade crafts and custom products. Guidance will be provided to setup the store, making it the perfect opportunity for those looking to make extra income with minimal time commitment and no experience required. If you're interested, please provide the following information: Age and Country/Location Do you have any experience using the Etsy platform (as a buye...

I'm seeking an individual to launch an Etsy store and start making passive monthly income from the store's earnings. This part-time job is totally online and doesn't take up much time. Initially, the responsibilities involve registering the store on the Etsy platform, and later down the line checking the monthly financial statements. We operate the store on your behalf, selling our handmade crafts and custom products. Guidance will be provided to setup the store, making it the perfect opportunity for those looking to make extra income with minimal time commitment and no experience required. If you're interested, please provide the following information: Age and Country/Location Do you have any experience using the Etsy platform (as a buye...

We need call WebServices/SAP with basic authentication, with xml format, set cokkies using SQLServer Store procecudure to call Webservices.

I'm experiencing issues with an Excel file that shows as 'We found a problem with some content...' when trying to open it. The file is 99.7 MB, which may be the issue. File is mainly contact details, text and photos. I've tried Excel's 'Open and Repair' tools with no success. I am aiming to work with an Excel expert who can recover the data without loss, if possible. The freelancer should have: - Intensive experience with Excel - A deep understanding of Excel file structures and experience in fixing corrupted Excel files - Familiarity with various recovery methods beyond just 'Open and Repair' I am looking forward to saving my data with your expertise. Let's discuss a potential solution ASAP. Please include...

I'm looking for an Excel expert to repair my medium-sized spreadsheet which is currently corrupted and crashes upon trying to open. Key tasks include: - Diagnosing why the file is crashing upon opening - Recovering both crucial data and restoring the original structure The success of this project is crucial as there is vital information that needs to be salvaged from the corrupted Excel file. Ideal freelancer should have: - Extensive experience working with large Excel datasets - Proven ability to recover corrupted files - Strong attention to detail to ensure all data and structure is accurately restored

As an entrepreneur diving into the e-commerce industry, I'm looking for an expert who can build me a profitable general Shopify store. The focus will be on drop shipping, and your role will play a significant aspect in determining the success of this venture. Your key responsibilities will include: - Comprehensive store setup: Your job is to build a fully functional, user-friendly Shopify store from scratch with a professional, appealing design. - Product sourcing: I need you to research, source, and negotiate suppliers for a wide range of profitable products. Ideally, I want a variety of options spread across various industries such as fashion, electronics, home decor, and more. - Fulfillment process: Ensure seamless order fulfillment that includes a thorough p...

I am in need of a WordPress developer who can design and create two types of websites for me. For the online store, I require specific features like a payment system, inventory management, and a live chat function. For the corporate site, I'd like a few additional features such as a contact form, service pages, and an image gallery. Ideal Skills: - Proficient in WordPress development - E-commerce website development experience - Familiarity with payment gateways - Ability to create user-friendly admin interfaces for inventory management - Experience with incorporating and customizing live chat features in a website - Strong understanding of modern web design and user experience trends - Proven track record in creating visually appealing and functional corporate websites -...

I'm in need of a proficient coder who specializes in regular expressions (regex). The goal is to extract specific data from a log file. Here are the task details: - Develop a regex expression to parse a log file - Specifically, I need to retrieve software name, version and install date Ideal Skills: - Strong experience with regex expressions - Understanding of log file structures - Attention to detail In your proposal, please include examples of previous similar projects.

I am seeking an experienced developer proficient in creating complex, feature-rich applications and websites. The desired pl...system for customer convenience. - The inclusion of an AI upselling feature tailored to client interests. - Click & Collect option for alternative product acquisition. - Open source data and web scraping capabilities for refined data category management. Design: The aesthetic should be minimalistic and clean, placing emphasis on functionality and ease of navigation without sacrificing style. Store based on Grocery - food & drink products. It is essential you have previous experience with e-commerce, AI implementation and open-source data technologies within app and web development. I look forward to viewing examples of past projects that demonst...

...plans for a farm shop/family retreat. Essentially a barn with weekend living quarters. This will be a Farm shop/barn. with 2 offices, 1 full bathroom, 1 kitchen, 1 machine room. All inputs are appreciated. We have a pretty good idea of what we want to build, but are open to suggestions with functionality, esthetics, materials, finishes, etc. This building will function as a farm building to store our tractor and other farm equipment in one lean-to and have bathroom/offices on the other lean-to. The center building will be open for family gathering, wood stove, couches (pull out), TV, long dining table to seat as many as 14. etc..... We will be using this building as a family retreat on the weekends. We have a builder. Specializes in barns and garages. Metal exterio...

I'm seeking a designer to create a minimalist landing page reminiscent of popular dating apps like Tinder, Bumble, or Hinge. The design should strike a bala...mobile phone screens, a popular design concept for showcasing key features akin to a real app experience (e.g., background image reminiscent of the Tinder website). Space allocated for 2-3 videos or images featuring couples or testimonials. 2-3 prominent links to essential pages such as Terms & Conditions, Cookies, About Us, and Help. Convenient links for downloading the app from the Play Store and Apple Store. Social media links for easy access. The goal is to create a visually engaging and user-friendly landing page that effectively communicates the essence of the dating app while providing necessary informat...

I am looking for a Shopify developer to help me build my online store. My goal is to sell fashion jewelleries to my audience, so the site should reflect that demographic. Key Requirements: - Product listing and catalog: I need a well-organized, user-friendly way to display my products. - Payment gateway integration: It is crucial that the site can accept online payments securely. - Customizable design: The site should be visually appealing to the young adult demographic. The ideal candidate will have: - Extensive experience in developing and customizing Shopify websites - A good understanding of ecommerce and user experience design - Strong attention to detail and the ability to work to tight deadlines Please provide examples of previous Shopify websites you have worked on. Lo...

...cafe. Some of the modules required but not limited to the followings: - [ ] Ecommerce - [ ] CRM an Loyalty System - [ ] VOIP ans SMS integration - [ ] Marketing campaign design - [ ] Mobile & Online Ordering - [ ] POS - [ ] product add-ons when taking orders - [ ] barcode scanners and mobile printers - [ ] customised print designs per store - [ ] multi-tenant - [ ] Table Service, reservation, pr-eorder, pre-payment - [ ] Delivery, In-Store pickup, integration to other delivery platforms - [ ] Staff Management, time sheets - [ ] Digital Menu Management, View the menu on mobile and make order and payment - [ ] Reporting & Analytics - [ ] Kitchen Management - [ ] Inventory Control - [ ] BOM creation - [ ] BOM’s in progress and duration - [ ...

I'm in need of a seasoned expert to clean up a distorted, noisy MP3 music file I possess. Key objectives: - Remove at least most of distortion and noise in the music file. - Ensure output quality is of standard level. Ideal freelancer would have: - Profound expertise in using music editing software. - Past experience in restoring distorted or noisy music files. - Ability to provide standard fidelity in output.

...experienced ASP.NET Blazor developer with a strong background in C#. The project is a web application that focuses on customer and document management. Key Features: - User Authentication: The application should have secure user authentication mechanisms in place. - Database Integration: Extensive experience with integrating databases into ASP.NET Blazor applications is a must. - Real-time Updates: The app should be capable of implementing real-time updates for a seamless user experience. - Bulk File Upload: A feature for bulk file upload will be required for the document management aspect. - Tabular Input: Incorporating tabular input for customer data management. - Chat Window: A real-time chat window to facilitate communication within the application. - Email Not...

I need a comprehensive angel investor list for North America in an Excel spreadsheet. The list should cover all the necessary details for each investor, including but not limited to: - Name and contact information - Investment preferences - Industry expertise - Geographic preferences - Industry preferences - Investment stage - Average Investment Amount - Membership model - Membership fees There are additional questions we would like answered. PLEASE READ THE ATTACHED DOCUMENT FOR ALL INFORMATION SOUGHT. The ideal freelancer should have experience in compiling such lists and should be able to deliver a well-structured and detailed Excel spreadsheet. The list should be easily navigable and professional, making it easier for me to reach out to potential investors. Given that I'm ta...

I am looking for a professional to incorporate a Non-OTP payment gateway into my online store. Even though I am uncertain of a specific Non-OTP gateway, I am open to suggestions for secure, user-friendly, and reliable options. Key job tasks: - Suggest trusted Non-OTP payment gateways. - Integrate the chosen gateway into my online store. - Test purchases to ensure the gateway is functioning properly. Ideal qualifications: - Experience in setting up payment gateways on various online store platforms. - Knowledgeable about Non-OTP payment gateways. - Proven track record of delivering similar projects. Note: I have not specified the platform that my online store is built on, and it's not disclosed whether I have PayPal, Stripe, or Braintree setup. Please ...

I am seeking for a skilled web scraper who can effectively extract product information from online catalogs on a website. The aim here is quite straightforward; we need to gather and download catalogs to enrich our store's database. To further specify, the data in question include: - Product Images - Product Descriptions - Pricing Information - Category Details You will be tasked to focus on all categories available on the website. As such, proficiency in navigating various website blockades is a must. Your ability to deliver comprehensive, detailed, and accurate information in a well-structured format is crucial to this job. Prior experience in similar e-commerce web scraping projects would be a great advantage. Look forward to your bids. Thanks in advance!

I'm seeking a professional with expertise in Ecwid and payment gateway integrations, particularly with Affirm. The project involves integrating Affirm with my existing Ecwid store. This is in order to offer financing options to customers and improve overall customer experience. - **Key Deliverables**: - Integration of Affirm with the Ecwid store - Customization of payment options to include: - Promotional messaging - Dynamic pricing - Monthly payment options - **Skills & Experience**: - Proficiency in Ecwid and payment gateway integrations - Prior experience with Affirm integration is highly preferred - Strong understanding of e-commerce customer behavior and user experience - Excellent attention to detail to ensure ...

I have a text file as the language file for my Spanish learning game, which targets beginner level learners. I'm looking for a skilled professional to help me improve it. The main task will be to expand the vocabulary list. Key Requirements: - Expand the existing vocabulary list in the text file - Ensure the new vocabulary is suitable for beginners Additional Information: - The quality of the vocabulary is crucial as it forms the backbone of the game - The aim is to help the users gradually improve their Spanish skills from scratch. Therefore, the vocabulary needs to be tailored to the beginner level - Experience in language file creation or game development would be an advantage, especially if you've worked with educational games Please bid only if...

Account and code is ready. UPload app as update.

We have a Figma design for a Shopify store, we want to transfer it to HTML/css. Below is the Figma homepage design file to transfer to HTML and CSS. Please pay attention to small details as it will be critical for candidate selection. Figma Design:

...proficient in EtherCat and C programming for a project involving firmware updates via an EtherCat network. Mainly dealing with binary files, it's crucial that you know your way around them. Key Responsibilities: - Develop a C code for file reading and writing. - Transfer firmware updates between EtherCat-enabled devices (specific device details will be shared later). - Monitor file changes post firmware update on an EtherCat network. Ideal freelancer would have: - Proficiency in C programming especially dealing with EtherCat network. - Understanding of binary file handling. - Experience with firmware update processes. - Expertise in network-enabled device communication. So, if you have hands-on experience with EtherCat, firmware updates and a will for so...

I am looking for an experienced Prestashop developer to resolve an ongoing issue with my Prestashop 1.7 store. The primary issue is that my website Often spikes server CPU usage to 100%. Ideal Skillset: - Extensive experience with Prestashop 1.7 - Proficiency in diagnosing and resolving performance issues - Strong knowledge of server-side troubleshooting The freelancer should be adept at problem-solving and have a high level of attention to detail. The project involves: - Investigating and identifying the root cause of the issue - Implementing necessary changes to optimize performance - Providing recommendations to prevent similar issues in the future As I'm unsure of the specific changes that might have led to this situation, the successful candidate should have a proacti...

In my Shopify pet-focused store, I seek a developer with a proficiency in custom field integration. This project involves adding unique fields to the registration and customer profile section. These custom fields are: - Pet's Name - Pet's Age - Dog or Cat - If Cat, What Breed? - If Dog, What Breed? The addition of these specified fields will ultimately help us personalize customer experiences, providing them with more tailored product suggestions. Therefore, it is critical for these fields to be functional, efficient and user-friendly. To qualify for this task, you should have: - Extensive experience in Shopify development - Proven track record of integrating custom fields - An understanding of user interface and experience A love for pets wouldn't hurt either! L...

I'm looking for a proficient web designer who specializes in Shopify theme development. This project is about bringing to life an aesthetic that is minimalistic yet elegant. Key requirements to be included: - This design should radiate a feeling of simplicity and sophistication, appealing to our target audience, adults aged 26-50. - An integrated online store function is a must-have. It needs to be user friendly, smooth and intuitive. Ideal candidates should possess a portfolio of past work that aligns with this aesthetic. Skills desired are not only limited to design but also user experience to ensure optimal customer journey within our website. Mastery in Shopify’s Liquid, HTML, CSS, and JavaScript is critical. Please provide examples of similar work done previously ...

I need an expert who can implement a protocol for sending the saved logged data files (about 200MB, on SD card, in .txt format) over two ESP8266s without connection to the internet in the shortest possible time. It is better if the protocol is FTP, but others are accepted, too.

I have a vibrant Shopify store which serves as a platform for selling unique products and services. Despite good traffic, understanding my conversion metrics remains a challenge. To gain more views and better sales analytics, I need someone skilled in: - Ecommerce analytics - Shopify platform - Goal setup and tracking. The goal here is to set up various conversion goals effectively on my store. These include: - Add to Cart events - Begin Checkout - Final purchase/sale conversions - Individual page views

I'm seeking a talented writer for the creation of a 500 to 1,000 word article. The topic is file cabinets. A nuanced and engaging article that speaks to a general audience is the end goal. The article should be engaging and informative, providing insight into the uses and types of file cabinets available on the market. Specifics to cover in the content: - Diverse types of file cabinets - Benefits garnered from using file cabinets - Practical organizational tips for file cabinets usage. -At least three references from authoritative sources such as Madison Liquidators or Office Furniture Inc. -SEO optimization utilizing top keywords for the subject matter Experience writing Home or Office Organization articles is a definite plus, but not strictly ne...

As a thriving online clothing store, I'm in need of a skilled t-shirt designer to help create captivating graphic designs for my line of t-shirts. Here's what the job entails: - Graphic Design: Your main task will be to create graphic designs based on our brief. As an experienced designer, you should be comfortable translating ideas into visually stunning designs. The ideal candidate for this job should have the following skills and experience: - Exceptional graphic design skills - Experience designing graphics for apparel, particularly t-shirts - Strong portfolio of graphic design work - Ability to work independently and adhere to deadlines Please note that while I'm open to creative direction, the overall style of the designs should be within the "graphic&q...

...optimizing our app listings on the Google Play Store. Responsibilities: 1. Utilize the Google Play Console to upload new app versions, including APK files, screenshots, descriptions, and other necessary assets. 2. Ensure compliance with Google Play policies and guidelines to prevent app rejection or suspension. 3. Manage app metadata, including titles, descriptions, keywords, and categories, to optimize visibility and searchability. 4. Monitor app performance metrics, including downloads, ratings, and reviews, and implement strategies to improve user engagement and retention. 5. Collaborate with the development team to troubleshoot any technical issues related to app publishing. 6. Stay updated on the latest trends and best practices in app store optimization (ASO) and i...