Order Export-Import module from Open Cart to MS Access

Closed

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.

Skills: Microsoft Access, MySQL, Open Cart, PHP

See more: export import module details, set import module access, open an microsoft access file on line, ms lookup, ms access work, ms access with php, ms access administration, module archive, microsoft access administration, legacy format website, import administration, from quotes, access database module, ms access web database, microsoft access for website, site web d import export, order process, ms access to web, ms access 2013, in process access, export import, ecommerce populate, download some files from, d mapping, application microsoft access

Project ID: #4487792

16 freelancers are bidding on average $603 for this job

SunFlowerBiz

Hi, please check PM for our portfolio. Regards,

$651 USD in 10 days
(70 Reviews)
7.1
ithinksolutions

Thanks for inviting us to bid on this project. We have a team of highly qualified and creative professionals. Give us a chance to show our talents and we assure you quality.

$618 USD in 10 days
(74 Reviews)
7.1
techwelfare

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$665 USD in 14 days
(43 Reviews)
5.9
sat12

plz check PMB.

$525 USD in 3 days
(55 Reviews)
5.2
ystech

hi we are ready to do your job. thanks

$550 USD in 7 days
(47 Reviews)
4.9
MarlinSoftware

Hi, I have 12 years experience developing MS Access applications and have a lot of experience linking MS Access with eCommerce websites. Please view my portfolio for some examples of my work.

$750 USD in 20 days
(10 Reviews)
4.5
ufologo22

I'm a Microsoft certified Access developer and I also work as a website developer/programmer. I'm familiar with both shopping cart/fulfillment systems export. I envision building a simple page (in PHP since you are More

$400 USD in 6 days
(18 Reviews)
4.3
smileitsolu

"This is not genric message we have properly read your project and intrested for that " we are a Team of professionals having good experience of various projects. I will really appreciate if you can share your query More

$882 USD in 12 days
(17 Reviews)
3.9
fabest

Dear, I am Expert in Access/VBA/SQL automation since 11 years. I can build your Access DB Tool within 6 days. Could you send me example of CSV file ? I will be available as support after development. Regards, Fab More

$440 USD in 6 days
(3 Reviews)
2.8
outsourceviet

Read and understood We have gone through your project description and we are really very interested about the job and want to start the job as soon as possible.We are sending you some links of our previous Opencard Job More

$385 USD in 3 days
(1 Review)
2.6
Gurbachan

I am ready to work with it.please review me more details. If you wanna a quality work i will provide you.

$630 USD in 10 days
(2 Reviews)
2.3
veltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$721 USD in 28 days
(2 Reviews)
0.7
GeoTec

I'm expert in MS Access and VBA (15 year). I'm ready to do your job for you.

$333 USD in 10 days
(0 Reviews)
0.0
HIGRO

Hello , we are expert in developing management software . We also have developed QuickBooks integration inventory management software . For more details , please ssee PMB

$772 USD in 3 days
(0 Reviews)
0.0
LRASTUDIO

Team are experienced programmers in Microsoft technology. We're ready to take your job.

$555 USD in 5 days
(0 Reviews)
0.0
sujanon2it

Kia ora! On2itonline.com are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$772 USD in 21 days
(0 Reviews)
0.0