Completed

Shopify<>Sage300<>CRM Integration- Part 1A: Order Import Research and Proof of Concept

Create a new Access Database that links to a CSV file containing order data and perform an automated transformation into a table structure that can be imported into Sage300 successfully. This is intended to be a process of discovery and hopefully will be leveraged in Part1B of this project, however it may simply provide a proof of concept and a cognitive framework for the end product.

• Research and understand the current process in place to import orders from Magento2. Document findings along the way and document the process you create. Read the code, understand the data structure, forms, ask questions, and in a safe testing environment conduct trial end error experiments to develop a working knowledge base. Master the requirements of Sage300 to be able to successfully import orders including the default values required and the variability that may be needed. A limited list of examples to understand is listed below.

 Payment Types

 Terms Codes

 Tax groups

 Gift Cards

 Shipping Methods

 Amazon Order Number

 Optional Fields Arbor Scientific uses

 Default values required

• Create a dummy CSV file that reflects the expectation of what will be provided by our live Shopify site at launch.

o An example CSV file will be provided that reflects an export of orders from someone else’s Shopify website for reference and an expectation of what our data will ultimately look like.

o 3 or 4 Order confirmations will be provided from our current website to be used to populate data in the dummy CSV file.

o The CSV File will need to accommodate a few custom fields/metatags that will be unique to our website.

 Position

 Interest

 End User

 Purchase Order Number

• Although the intention is not build a complete User Interface with suggested lookups at this stage of the process, there will need to be a way to add a few data elements to the orders.

o Sage Customer Number

o Contact ID

o PID

• Run the transformation process and load into Sage and have it checked for accuracy

o Make modifications as needed

o Include the ability to rerun the process as needed and manually add an additional order to the process.

• Summarize your thoughts about the next steps and potential improvements to what we are currently doing.

Skills: Microsoft Access, SQL, Visual Basic

See more: magento crm integration, oscommerce xml order import, polycom crm integration, order import script oscommerce, oscommerce crm integration, crm integration voip vtiger, java siebel crm integration eclipse, google sites sugar crm integration, magento order import, quickbooks crm integration customer portal, virtuemart crm integration, order import cart, order import xcart, vicidial crm integration

About the Employer:
( 0 reviews ) Saline, United States

Project ID: #17920891

Awarded to:

markpashalis

Hi, my name is Mark. I have 20+ years of expertise with MS Access, Excel, VBA and SQL Server and will be happy to work on your project. I've designed, developed and maintained many Access applications and am well-verse More

$1000 USD in 10 days
(9 Reviews)
4.7

8 freelancers are bidding on average $1155 for this job

mingxiao2008

Hello , Dear How are you? I have read your project description and I have wondered that I have experienced in similar project. I have experienced in developing Microsoft Access, SQL, Visual Basic. I will work very More

$1250 USD in 20 days
(3 Reviews)
4.4
superbpartner

hello,dear. I have read all your requirements for 'Shopify<>Sage300<>CRM Integration- Part 1A: Order Import Research and Proof of Concept' and I fully understood it. I am confident and I am sure that I am able to finis More

$1125 USD in 6 days
(9 Reviews)
4.0
hawkscodeaus

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 8+ years in web design & development with good experience in following skills ... More

$1000 USD in 20 days
(1 Review)
4.2
symaticssolution

Dear Client, Greetings of the day !! After a careful & thorough review of your project requirements i understood what exactly you are looking for Shopify Expert .I can make my significant contribution to setup shop More

$1250 USD in 20 days
(1 Review)
3.2
BestPartner4You

Dear sir, I'm sure that I can complete your project 'Shopify<>Sage300<>CRM Integration- Part 1A: Order Import Research and Proof of Concept' as soon as possible. I am senior software developer and always provide fast s More

$1250 USD in 7 days
(1 Review)
2.8
gursukh

Hi I have 5 year experience I can show you my precious work. I'm Individual freelancer I have no timing issue I can do work any time day/nights. so can we discuss once thanks.

$1111 USD in 10 days
(0 Reviews)
0.0
naishodayo

Hi,dear! I am quite interested in your project - 'Shopify<>Sage300<>CRM Integration- Part 1A: Order Import Research and Proof of Concept'. :) I am a skillful software developer who has rich experience in this field. If More

$1250 USD in 7 days
(0 Reviews)
0.0