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 &ldquo;H&rdquo; for the order header details and &ldquo;D&rdquo; 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 &ldquo;Website Orders&rdquo;. 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 &ldquo;Maintain Products&rdquo; 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.
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
Remote Sensing and GIS Specialist. Images classifications, interpretation.
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.
Sarajevo, Bosnia and Herzegovina
Experience: ++ VB6 ++ CRYSTAL REPORT ++ MSSQL ++ C#.NET ++ ASP ++ ASP.NET ++ ANDROID APP DEVELOPMENT ++ ...
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.
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
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.
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
Hi, I am joomla,virtuemart,wordpress,magento,prestashop,opencart expert having 5 years of experience.
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.