Backend Node.js application improvement for e-commerce

200.0 USD

200.0 USD peopleperhour Technology & Programming Overseas
1 days ago

Description

Hello, and thank you for reading. We have an e-commerce affiliate platform. Now this platform is switching from the WP to Next.js + Strapi.
To fill in the product information (create/update/delete) products in DB that is used for the e-commerce platform we have a Node.js (Express) application with a simple (2 pages) React app.
Application functionality for today:1. Get the uploaded csv file from front-end with the list of affiliate products2. Check each product for the next categories: * exist and no changes in price/description/availability from partner * exist and there are changes in price/description/availability, so it has to be updated * not exist in DB - need to be created * product from DB not in the provider list anymore - needs to be hidden on the platform and then deleted3. Make the logical matching of the fields from the provider according to the settings json that we create for each provider into the fields in DB4. Send the API call to update the products in the e-commerce5. For new products, an app is adding them to DB to the temporary table6. There is a cron job that gathers the new products, sends them to the AI engine API and gets the response with additional data, then marks the products as ready to be sent to the API7. Send new products already after AI polishing to e-commerce API
The app is running locally.
What should be done:1. Clear code and make some refactoring2. Change the connection from MongoDB to PostgreSQL and organize the repository to be a single DB related module3. Change the logic from working with csv files to working with API calls and getting data in XML format (data input on step 1)4. Add 2 providers based on the settings that I will give you (probably already in json files ready to use), but some logical operations need to be coded according to the previous providers logic-matching templates5. Small changes in AI request logic: change one call to the set of two consistent calls (all prompts are ready)
We treat this task as a fixed price. But we want to find a reliable developer who will handle the requests with this application in the future.
Please, let me know what do you think.

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Looking for a long-term partner whether with a company or an individual To help tweak our current Zoho and help with data, below I have put together a job description I think 1st few weeks will be 30 hours per week, then will be 10 hours to 20 hours per week We are seeking a highly skilled Zoho CRM Consultant to configure and customize Zoho CRM to meet the specific needs of our business. The consultant will be responsible for simplifying workflows, creating effective reports, and ensuring the CRM helps manage company data, monitor employee performance, and streamline sales processes. This role will also cover configuration requirements based on insights gathered and ensure that the system supports our overall business strategy. The consultant will also be responsible for entering data themselves and working closely with team members to ensure data is entered correctly, as we recognize that inaccurate data will negatively impact the efficiency and usefulness of the CRM. Key Responsibilities: Zoho CRM Customization: Configure Zoho CRM modules (Accounts, Contacts, Deals, Quotes) to match our business processes. Simplify and streamline sales workflows, ensuring an easy-to-use system for team members. Customize fields, modules, and layouts to ensure all business data is captured effectively. Integrate CRM with other Zoho tools and third-party applications as needed. Territory and Performance Management: Implement and configure territory management within Zoho CRM to align with company structure and sales strategy. Set up systems for tracking employee performance, ensuring the CRM captures relevant performance metrics. Ensure the sales team has clarity on territory assignments, with automatic data management and record assignment. Sales and Pipeline Optimization: Create and configure deal pipelines that reflect the company’s sales stages and opportunities. Set up a structured system for managing quotes, ensuring they are linked (or not) to opportunities based on the business’s needs. Automate workflows and triggers to assist the sales team in managing deals efficiently. Data Entry and Accuracy: Take responsibility for entering data directly into the CRM and ensuring accuracy. Collaborate with other team members to ensure that data entered into the system is correct and up-to-date. Provide guidance on best practices for data entry, as accurate data is critical for reporting and decision-making. Advanced Reporting and Analytics: Develop custom reports and dashboards to track key metrics such as sales performance, deal conversion rates, and territory success. Create forecasts based on sales data, opportunities, and quotes to provide the business with accurate future revenue estimates. Enable management to access actionable insights and performance overviews from simplified, data-driven reports. Training and Documentation: Provide training to staff on how to use the configured Zoho CRM effectively. Develop training materials and CRM documentation for future reference. Offer ongoing support for Zoho CRM users, troubleshooting issues, and making adjustments as the business evolves. Ongoing Optimization: Continuously monitor and improve the CRM configuration to keep pace with evolving business needs. Recommend additional Zoho products, integrations, or third-party solutions to enhance overall efficiency. Requirements: Proven experience in configuring and customizing Zoho CRM. Strong understanding of sales processes and CRM best practices. Experience with setting up territory management, sales forecasting, and pipeline management. Ability to design and build custom reports and dashboards for data analysis and performance management. Knowledge of Zoho’s suite of applications and integration tools. Excellent communication skills for training and support. Attention to detail and commitment to accurate data entry. Problem-solving skills and ability to simplify complex processes. Understanding of workflow automation and CRM efficiency practices. Preferred Qualifications: Zoho CRM certification. Experience working with small and medium-sized businesses. Familiarity with the specific requirements discussed today, including sales reporting, quote management, and territory-based CRM setup.
516.0 GBP Technology & Programming peopleperhour Overseas
1 days ago