Order Export-Import module from Open Cart to MS Access

Budget N/A
Bids 16
Average Bid $603

I have an Open Cart eCommerce site and need a module to export orders, which can then be imported into a legacy MS Access application.

We have been quoted 20 hours by a local company, who built the original MS Access database.

At the moment I have to re-enter the order into the MS Access application whenever a new order is placed on the website. A new lookup table will need to be built within MS Access to map the product code from the website to a product within the MS Access database. The lookup table will also contain additional fields required to populate the Access database correctly. A view will need to be added within the Access application to allow the management of this mapping.

Some of the products on the website map to multiple products within the MS Access database and I believe hidden attributes within Open Cart will need to be added, one for each sub-product, so these can be matched to individual products in the MS Access database. We do not use the attributes feature within Open Cart so these can be utilised if necessary or additional fields created within the admin view.

A new module will need to be added to Open Cart to allow the download of orders by date range or since last export.

1) File Format

A csv file will be provided from the web site for each new order. The first field in each line of the csv file will be a line identifier and will be set to “H” for the order header details and “D” for each order line detail. In order for the import process to route data correctly all non-numeric fields should be enclosed in double quotes. Any double quotes keyed in by the customer should be removed programmatically when the csv file is created.

2) Import Routine

A new menu option will be added to the Access system labelled “Website Orders”. Selecting this will display a file import screen where the user can select the location of all csv files to be imported. This screen will default to a folder location set up in the administration area but users will be able to select a different folder if required.

When the location has been selected the system will import each valid csv file in the folder. For each file a verification routine will be performed to ensure that data is in an identifiable format. If the file is correct the import routine will be run and a new order will be created. Most information will be provided by the csv file, however there will be a number of lookups within Access to interpret and correctly map fields when necessary.

At the end of a successful import, each csv file will be flagged as imported and moved to an archive folder whose location will be set up in the administration menu.

When the import is completed the Import Details screen will be displayed with the new orders created listed. Where an error has occurred in the import routine the relevant file will be marked as not imported and an error reason given.

3) Import Details

A listing screen will be designed to display details of each import. Search parameters will allow users to list all files imported within a date range and the associated orders created. An option will be available to select an order and display the standard order screen.

4) Product Lookup

The web site file will provide an six to eight character alphanumeric code for each product detail line. This code will be different to the product code within Access and so to enable the import routine to create orders accurately the “Maintain Products” option will be amended to allow the user to record the Web Product Code against any existing products. Once this information is stored the import routine will be able to map to other fields.

Finally we are looking to build an ongoing relationship with a software company to assist us in future work. We have 3 Open Cart sites and are expanding.

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • GeoTec Profile Picture


    Quebec,  Canada

    Remote Sensing and GIS Specialist. Images classifications, interpretation.

    Python, Visual Basic, Translation, and Internet Marketing

  • techwelfare Profile Picture


    kolkata,  India

    Techwelfare A complete website development firm that provides high quality services for the clients all over the world. We are a team of highly experienced professionals in different areas of computer science. We work based on four main principles: Quality - the highest quality of products is guaranteed including free support. Time line - we provide our services in strong time deadlines. Communication - we try to be always online and free for communications. Security - All the information/transactions is highly secured.

    PHP, Javascript, XML, and Script Install

  • LRASTUDIO Profile Picture


    Sarajevo,  Bosnia and Herzegovina

    Experience: ++ VB6 ++ CRYSTAL REPORT ++ MSSQL ++ C#.NET ++ ASP ++ ASP.NET ++ ANDROID APP DEVELOPMENT ++ ...

    ASP, Visual Basic, .NET, and Copywriting

  • veltrod Profile Picture


    Chennai,  India

    Veltrod Software Services is a global management consulting, technology services and outsourcing company. Leveraging best-in-class people, processes, and technologies, Veltrod provides high-quality, high-value software development and business process outsourcing services to independent software vendors (ISVs) and enterprises. We are specialized in developing Mobile applications (iPhone, iPad, Android, Blackberry), Web designs, Social networking and ERP applications.

    Symbian, Oracle, CMS, and Volusion

  • outsourceviet Profile Picture


    Ha noi,  Vietnam

    Outsourceviet Team is Vietnam outsourcing Team of excellent programmers and designers whose products' quality is proved since our early stage. We are one of leading companies specified in web development, mobile & tab development, internet marketing in Vietnam

    PHP, ASP, C Programming, and Javascript

  • sujanon2it Profile Picture


    Dhaka,  Bangladesh

    Kiaora, welcome to on2itonline! on2itonline is a group composed of tech savvy individual's and marketing geniuses who banded together to get New Zealand, and the world, digitally engaged. We are about technology and how it can help you reach your maximum potential. We are a real company based in New Zealand. We use Freelancer to cherry-pick the best international projects, as well as projects of our local clients to build our online portfolio and stretch our software building muscles. We are always looking to build the next big thing - are you it? If so, we would make a successful team!\ n We develop websites, online stores, and Facebook pages (with stores too!) and much more. We are the 'go-to' guys for new software projects - anything goes at on2itonline! Your imagination is the limit. Not only we make innovative software, our hand-picked group of graphic artists make sure we produce classically beautiful, professionally attractive software, websites, Facebook pages, and Smartphone/iPhone applications. We produce quality work using responsive design technology to keep your website current well into the foreseeable mobile future. These are our technical areas of expertise and the technology we use: * CSS/CSS3 * HTML/HTML5 * JavaScript * JQuery * Ajax * Responsive Web Design * Wordpress (Custom theme and plugin development) * Blog design * Joomla * PHP/MySQL Development * CodeIgniter * Apache * Ecommerce * Magento * osCommerce * Facebook API * Twitter API * Flash * Web UI Design * Graphic Design * Logo Design * Banner Design * Adobe Photoshop * Adobe Illustrator * Adobe Fireworks Choosing us for your work ensures you a highly engaged team of professionals with exceptional English communication skills and high conceptualization ability which is important here at Freelancer due to the nature of how most projects are being discussed long distance. We welcome you to take a look at our portfolio, and contact us to discuss your project. **Operations & Production Agreement Contract On2ItOnline.Com** This Operation and Production Agreement Contract has been agreed upon by ON2ITONLINE.COM and ____________________________________ on this ______ day of _______, 2013. The client has agreed to provide the following after awarding the Project to ON2ITONLINE: o USD $800.00 OR 1/3 ( one third) of the Project Value Released as a deposit. o Contents (Images and Text Contents) o Reference Website (If applicable) o Server Login Details (If Applicable) o Website that On2It will work on (If project requires) The Production will only start once the above stated requirements are received. Please Note that the failure to provide the necessary documents and milestone will cause delay on production and On2ItOnline.Com is not liable for the delay.Days of Delay will be added on the final delivery date. Once WE, On2ItOnline received the complete requirements we will provide: o Our Project Manager's blueprint technical specifications and development guidelines. o Two sets of check points that should show the project progression. The same will be used as a payment and completion milestone. The client and On2ITONLINE has agreed upon: o The client will need to pay the next remaining milestonesonce checkpoints were completed by On2ItOnline.Com o The final payment should be released within 7 days upon completion of the project, as per the final checkpoint o Clients should note that delays in getting information requested by On2ItOnline.Com will result in project delays and will be recorded and accounted for. o Hourly jobs should be paid weekly and On2ItOnline.Com's Project Manager and Client should have a clear timeline for deliverables so they know what they pay for at each point.

    PHP, ASP, Javascript, and XML

  • SunFlowerBiz Profile Picture


    China,  China

    Services: Magento Development Joomla/Virtuemart Development Wordpress/Woocommerce Development Opencart Development Prestashop Development Responsive theme Html5 Development Module development ERP Integration API Integration Java/Jquery/Ajax Bigcommerce Development Interspire Development Oscommerce Development Cs-cart Deveopement X-cart Development Sunshop Development Smarty PHP/ Shopscript Drupal Development PHPBB/Jomcial/Vanilla We are a team of php/mysql experts with 10 years experience located in China. We will give fast response within 24 hours as we always do. We have got 5 star rating and 100% on time. Kindly check our reviews and you will find us a reliable and professional team who will never let you down.

    Javascript, Website Design, Graphic Design, and Joomla

  • fabest Profile Picture


    BOURGES,  France

    Dear all, Bonjour, Web-design company with French and US engineers. Access/Excel/VBA expert since 11 years. Web-design expert since 8 years. IOS / Android expert since 7 years. I always focus to have client 100% satisfied of the work. I always focus on user friendly interfaces. Regards, Fabrice

    PHP, Java, Javascript, and XML

  • sat12 Profile Picture


    Mumbai,  India

    Hi, I am joomla,virtuemart,wordpress,magento,prestashop,opencart expert having 5 years of experience.

    PHP, Javascript, Script Install, and Website Design

  • smileitsolu Profile Picture


    Noida,  India

    We are Smile IT Solutions, one of the leading web outsourcing companies. We have completed many projects so far in web design, development, graphics design, SEO, Web marketing, Email marketing, e-commerce development, content development, 3D designs, flash design and several other applications as well. Our design, development and SEO teams have been commended repeatedly for their strength in understanding the needs of the clients they work with. We amaze our clients time to time by our unprecedented performance and Over Expected Results with 100% quality. The teams work dedicatedly and provide consistent support to the clients all over the world.

    Graphic Design, Data Processing, Data Entry, and Photoshop