Find Jobs
Hire Freelancers

Create order status and returns system for Shift4Shop website (formerly 3dCart) that pulls data from offsite MS SQL database

$750-1500 USD

Closed
Posted 8 months ago

$750-1500 USD

Paid on delivery
We have an exististing Shift4Shop site, but would like to have the order status/ returns system pull directly from an MS SQL database that is stored at our warehouse (computer is accessible via static ip address and open port). From a page on Shift4Shop site, customer would enter their order number and email address. That information is then looked up on remote SQL database to then return order information (customer name, shipping address, items ordered, specific order and item status, and possible tracking information). For items that have already shipped and are still within the returns window of 45 days, the customer should be able to select items to return. Return information to be collected is the product sku (from order status information), reason for return, if they want the item exchanged or returned for credit, and if an exchange, what item they would like as a replacement. This information should then be emailed to customer and merchant along with an RMA number (a combination of the date and the order number). Return data should also be written back to same SQL database as order status information was pulled from. Attached pictures show current system as an example. New work does not need to be exactly like existing site.
Project ID: 37194637

About the project

75 proposals
Remote project
Active 6 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
75 freelancers are bidding on average $1,239 USD for this job
User Avatar
Dear Client, my name is Raman and I am part of the team responsible for developing your order status and returns system for Shift4Shop website. We understand that you would like us to create an order status and returns system that pulls data from an offsite MS SQL database stored at your warehouse that is accessible via a static IP address and open port. From a page on your site, a customer would enter their order number and email address to find order information such as customer name, shipping address, items ordered, specific order and item status as well as possible tracking information. With our expertise in PHP, WordPress and WooCommerce development as well as data scraping we are confident that we can build a system that meets your needs exactly how you want it. Our services include specialized knowledge in JavaScript, PHP and Website Design which allows us to achieve ambitious projects on time and within budget. If you choose us for this project we guarantee to deliver exceptional results within the timeframe agreed upon while ensuring communication is effective throughout the process so there are no doubts or misunderstandings about what is expected from both sides.
$1,125 USD in 7 days
4.9 (619 reviews)
9.0
9.0
User Avatar
Hey Good afternoon , Just finished reading the brief details and currently going through attached files . I see you have been looking for someone who has experience with these tech stacks JavaScript, Website Design, PHP and Microsoft SQL Server. I will request you to review my profile, skills, projects and customer feedbacks to confirm that I will be good fit for this job. I would like you to start the chat so we can discuss the project in detail and we will see how it goes. Questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Thanks and regards, Awais
$1,500 USD in 10 days
4.9 (118 reviews)
8.5
8.5
User Avatar
Hi there! My name is Kishore and I work at GlobalTechnosys. We understand that you are looking for someone to create an order status and returns system for your Shift4Shop website that pulls data from an offsite MS SQL database stored at your warehouse. We have a team of highly skilled professionals who have the necessary expertise to create a system that meets your needs. Our services include Zend, CodeIgniter, Cake PHP, OpenCart, Joomla, WordPress, OsCommerce and more. Additionally we specialize in Award-Winning Websites Design, Content Management Systems, E-Commerce Solutions, Online Marketing and Print and Identity Designs for businesses and individuals. We can help you create a system that is exactly what you want it to be without any delays or issues. We look forward to hearing from you soon!
$1,125 USD in 7 days
4.9 (325 reviews)
8.3
8.3
User Avatar
Hello, Greetings! I have read your project description and am confident that I can complete this project to your satisfaction. However, I do have a few queries. Please leave a message in the chat so that we can discuss these and I can also share my previous work that aligns with your requirements. Thank you for your time! I look forward to hearing from you soon. Best Regards,
$1,500 USD in 21 days
4.9 (131 reviews)
7.6
7.6
User Avatar
Dear Jim N, I'm excited to propose a streamlined solution for your Shift4Shop site, enabling real-time order status and returns management via an MS SQL database. I'll establish a secure connection between your Shift4Shop site and the remote MS SQL database hosted on your warehouse computer. This connection will allow for seamless data retrieval and updates. For eligible returns within the 45-day window, customers can select items, specify reasons, and indicate if they want an exchange or credit. An automated RMA number will be generated (combining date and order number) and emailed to the customer and merchant. Return information will be securely written back to the same SQL database, ensuring data accuracy and consistency. I possess the technical expertise to implement this solution effectively, with a track record of similar successful projects. Let's empower your customers and improve operational efficiency. I look forward to discussing further details and getting started on this project. Best regards, A.R
$1,125 USD in 7 days
5.0 (173 reviews)
7.6
7.6
User Avatar
Hi, I have read the details I believe I can do this job. While I believe I have some queries which need to be clarified. For that I would request you to start the chat so we could clarify those I have good experience with Website Design, Microsoft SQL Server, JavaScript and PHP. We can discuss the timeline and budget after that. You can see all my skills, experience, customer reviews and relevant jobs from my profile. My portfolio: https://www.freelancer.com/u/AITSoft Shamshad
$1,500 USD in 26 days
5.0 (19 reviews)
6.8
6.8
User Avatar
" I am a Senior Web & Mobile App developer and ready to get started " Hello, Greetings of the Day!! Yes, I will surely create order status and returns system for Shift4Shop website. I already worked on a similar project and will perform the following tasks perfectly. * Can we have a quick chat, so that we can discuss further details and I can show you my previous/recent work ? * I have full-time and required skills to carry out your project with high quality on time. My expertise is well-matched with your requirements. I am working on UI/UX design/development, Frontend development, Backend development, Database development, API Integration/Development, CMS/CRM development, E-Commerce development, Server development, Flutter/React native app development, SEO/Digital Marketing Expert, AI/ChatGPT, All payment gateways integration/setup. Let's get in touch via chat, Waiting for your positive response. Rekha Thakur
$1,500 USD in 25 days
4.5 (105 reviews)
7.6
7.6
User Avatar
Hello, my name is Qaseem and I am an expert in CMS and Custom Website development. I have a great hand in Graphic design as well as PHP and JavaScript so you can rest assured that your project will be taken care of. I understand your need for an order status/returns system that pulls data from an offsite Microsoft SQL database that is stored at your warehouse to be accessible via a static IP address and open port. From a page on your Shift4Shop site, a customer can enter their order number and email address to access information about their order such as customer name, shipping address, items ordered, specific order and item status as well as possible tracking information. With my services you can count on me to create an order status/returns system that pulls data from the offsite Microsoft SQL database that is stored at your warehouse (computer is accessible via static IP address and open port) so that you can have the order status/returns system on your Shift4Shop site without needing to physically be there to manage it.
$1,125 USD in 7 days
5.0 (46 reviews)
7.0
7.0
User Avatar
I am excited to learn more about your project and help bring order status and returns system for Shift4Shop website (formerly 3DCart) to life. With over 15 years of experience in software development, I am confident that my skillset is the best fit for this project. I have extensive knowledge in JavaScript, Microsoft SQL Server, PHP and website design that will be needed to create the order status and returns system for Shift4Shop website (formerly 3DCart). Additionally, I provide 24/7 support for all my clients so they can feel confident in my work as well as have peace of mind knowing they can reach out if there are any issues during development. I believe that together we can create a successful project that meets your goals for functionality and user interface. Please feel free to reach out if you would like further information on my services or need any additional feedback on how my sales pitch might fit into the context of the project description.
$1,600 USD in 10 days
5.0 (25 reviews)
6.6
6.6
User Avatar
Hello there! My name is Pllavi and I am a full-time web and mobile app developer working as a freelancer. I understand you are looking for someone to create an order status and returns system for your Shift4Shop website that pulls data from an offsite Microsoft SQL database stored at your warehouse. With more than 10 years of experience in this field, I am confident that I can provide the best solution for this project. My services include ecommerce websites, responsive template landings page WordPress website real-estate websites corporate websites graphics design logo design PSD to HTML SEO Service Mobile Apps Node js php vue js laravel CMS Bootstrap Angular.js React.js ExpressJs NextJs I have worked with many big companies creating various high tech mobile and web apps for them.
$800 USD in 15 days
4.7 (145 reviews)
7.1
7.1
User Avatar
Hey Jim N., I have over 7 years of experience in JavaScript and Website Design, making me well-equipped to handle this project. I have carefully read the requirements for creating an order status and returns system for your Shift4Shop website, pulling data from an offsite MS SQL database. To achieve this, I propose developing a PHP and JavaScript solution that integrates with your Shift4Shop site. When a customer enters their order number and email address, the system will query the remote SQL database to retrieve relevant order information such as customer name, shipping address, items ordered, order and item status, and tracking information. For items that are eligible for returns, customers will be able to select the items they wish to return. The system will collect the product SKU, reason for return, and whether they want an exchange or credit. If an exchange is requested, customers can specify the replacement item. An email will be sent to the customer and merchant, containing the return details and an RMA number generated based on the date and order number. Additionally, the return data will be written back to the same SQL database. In addition to this project, I offer web and mobile app development, business automation, AI/ML, DevOps, and UI/UX services. However, I will only charge you once you are completely satisfied with the work. I kindly request you to initiate a chat to discuss the project in further detail. Sincerely,
$1,400 USD in 7 days
5.0 (9 reviews)
6.1
6.1
User Avatar
Hello there! My name is Khursheed and I am a qualified professional WordPress and Website developer with more than 6th years experience in the design industry. I understand you are looking for someone to create an order status and returns system for your Shift4Shop website that pulls data from an offsite MS SQL database stored at your warehouse. From a page on the site, customers will be able to enter their order numbers and email addresses to get order information (customer name, shipping address, items ordered, specific order and item status). For items that have already shipped and are within the 45-day return window, customers can select items to return. This return information should then be collected and emailed to the customer along with an RMA number (a combination of the date and order number). We would be delighted to discuss this project further with you and help bring your vision for creating an order status and returns system for Shift4Shop to life. Please let us know if you would like us to discuss this project further or any other queries you may have regarding our services. Regards Khursheed Ahmed
$750 USD in 3 days
4.9 (99 reviews)
6.3
6.3
User Avatar
Hi. Experienced web developer with expertise in database integration here with 8+ years of hands-on experience. I can assist you in implementing a system that pulls order status and returns data from your MS SQL database to your Shift4Shop site. To proceed further, I kindly request the following information: 1. Can you provide access details to your MS SQL database, including the necessary credentials? 2. Are there specific data fields or tables in the SQL database that need to be integrated with the Shift4Shop site? 3. Do you have any design preferences or requirements for the customer interface on the Shift4Shop site? 4. What is the expected timeline and budget for this project? Please initiate a chat so we can discuss the project thoroughly. I look forward to collaborating with you on creating a seamless order status and returns system for your Shift4Shop site, ensuring a smooth customer experience.
$1,125 USD in 7 days
5.0 (16 reviews)
6.0
6.0
User Avatar
Dear Sir, Are you looking for a solution to have your existing Shift4Shop site's order status/ returns system pull directly from an MS SQL database stored in your warehouse? If so, I can help you with this project. I have the necessary skills and expertise in JavaScript, Microsoft SQL Server, PHP and Website Design to complete this task. I will first create a page on the Shift4Shop site where customers can enter their order number and email address. This information will then be looked up on the remote SQL database and return the relevant order information. For items that have already shipped and are still within the returns window of 45 days, customers will be able to select items to return. The return information to be collected will include the product sku, reason for return, desired exchange or credit and a replacement item for exchange. This information will be emailed to the customer and merchant along with an RMA number. The return data will also be written back to the same SQL database. I am confident that I can deliver a successful solution for this project. As a demonstration of my skills, I am willing to provide a free demonstration of the solution even before the project is awarded. I look forward to hearing from you. Best regards, Smith
$1,125 USD in 7 days
4.7 (5 reviews)
6.0
6.0
User Avatar
Hello, my name is Shikha and I am a senior web and mobile app engineer with extensive development skills. I understand that you are looking for someone to create an order status and returns system that pulls data from an offsite MS SQL database stored at your warehouse and is accessible via static IP address and open port. From the Shift4Shop website, customers would be able to enter their orders number and email address to get order information (customer name, shipping address, items ordered, specific order and item status). For items that have already shipped and are still within the returns window of 45 days, the customer should be able to select items to return. Return information to be collected includes the product sku from order status information as well as if they want the item exchanged or returned for credit. This information is then emailed to customer and merchant along with an RMA number. My expertise includes Android/IOS app development (Swift 5/4/3/2,Objective-C), React Native, Angular.js, Firebase/Bac4app and Web Service(Node.js, Python), so I believe I am the right person for this project. Please let me
$1,500 USD in 20 days
4.6 (23 reviews)
6.3
6.3
User Avatar
Key Features: Order Status Lookup: Customers can enter their order number and email address, enabling real-time access to the MS SQL database stored at your warehouse. This will display order information, including customer name, shipping address, items ordered, order status, and tracking information. Returns Management: For orders within the 45-day returns window, customers can initiate returns. They will provide product SKU, reason for return, and specify exchange or credit preference. If an exchange is requested, they can select a replacement item. RMA Generation: An RMA number, combining the date and order number, will be automatically generated for each return request. This RMA, along with return details, will be emailed to both the customer and merchant. Data Synchronization: Return data will be written back to the MS SQL database, ensuring consistency and accuracy between order status and returns information. Our team has extensive experience in e-commerce system integration and SQL database management. We are committed to delivering a solution that meets your specific requirements while adhering to the highest standards of security and usability.
$1,125 USD in 4 days
5.0 (25 reviews)
5.4
5.4
User Avatar
Hello. Dear Client. I have enough experience in eCommerce, Shift4Shop system. I can customize existing Shift4Shop website or make additional features using third party api or additional interface. I can manage database of the store and collect, select, handle products and store. Looking forward to discuss more details. Thanks. Ng :)
$1,000 USD in 10 days
5.0 (12 reviews)
5.6
5.6
User Avatar
Dear Client, Thank you for considering N&T Negocios y Tecnologias s.r.l. for your project requirements. We are a trusted IT development company with over 20 years of experience in the industry, specializing in web, mobile, blockchain, and AI projects. Our team of experts has successfully delivered numerous projects, achieving client satisfaction through innovative solutions and advanced technologies. Regarding your project titled "Create order status and returns system for Shift4Shop website (formerly 3dCart) that pulls data from offsite MS SQL database," we understand the need for a seamless and efficient order management system. Our proposed solutions for this project include: 1. Integration with MS SQL Database: We will develop a secure integration system that pulls data directly from your offsite MS SQL database. This will enable real-time access to order information, customer details, and tracking information. 2. User-friendly Web Interface: Our team will design and develop a user-friendly web interface that allows customers to enter their order number and email address. The system will then retrieve the relevant data from the SQL database, including customer name, shipping address, items ordered, specific order and item status, and possible tracking information. 3. Returns Management: We will implement a comprehensive returns management system within the website. Customers will be able to select items to return, specify the reason for return, and indicate whether they want an exchange or refund. Additionally, they can choose the replacement item if opting for an exchange. An RMA number will be generated and emailed to the customer and merchant. All return data will also be written back to the same SQL database for seamless tracking and management. After a thorough analysis, we have identified the best architecture and technologies for this project. Our team proposes the use of a microservices architecture, ensuring scalability and flexibility in the long run. We will leverage the power of .NET and utilize C# for backend development. For the frontend, we will design a responsive and intuitive user interface using HTML5, CSS3, and JavaScript. Additionally, we will utilize SQL Server for smooth integration with the existing MS SQL database. Please note that the budget for this project is approximate and will be determined based on the specific requirements and scope of work. Kindly reach out to us for further discussions and a detailed breakdown of the cost estimates. We look forward to your favorable response to this proposal. Should you have any questions or require any additional information, please do not hesitate to contact us. Thank you for considering N&T
$3,000 USD in 45 days
5.0 (4 reviews)
5.8
5.8
User Avatar
Greetings, Leveraging my experience in web development and database integration, I can help you create a seamless solution that allows customers to check their order status and initiate returns efficiently. The proposed system will enable customers to input their order number and email address, which will be used to query the remote SQL database for order information. This information, including customer details, shipping address, ordered items, order status, and tracking information, will then be displayed to the customer. For eligible returns, customers can select items, specify reasons, and choose between exchanges or credit. An RMA number will be generated, and return data will be saved to the SQL database. I am committed to delivering a robust and user-friendly solution tailored to your specific needs, ensuring that your customers have a smooth and efficient experience while handling order status inquiries and returns. Please let me know if you would like to discuss this project further. Sincerely, Moiz.
$1,199 USD in 7 days
4.8 (6 reviews)
5.6
5.6
User Avatar
Hello, nice to meet you. I just read your job posting. I have lots of experience in this field, so you don't need found another one. If you give me a chance, I'll provide you with the perfect result. I want to more discuss with you via chat, Thank you. Tomas
$2,000 USD in 10 days
5.0 (5 reviews)
5.5
5.5

About the client

Flag of UNITED STATES
FLANDERS, United States
0.0
0
Member since Sep 15, 2023

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.