Shopify<>Sage300<>CRM Integration- Part 1A: Order Import Research and Proof of Concept
$750-1500 USD
Selesai
Disiarkan lebih dari 5 tahun yang lalu
$750-1500 USD
Dibayar semasa penghantaran
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.
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-versed in most every aspect of database application development.
My work ethic: "Performance No Excuses - Exceed Expectations - Communication is Key"
$1,000 USD dalam 10 hari
5.0 (9 ulasan)
4.7
4.7
8 freelancers are bidding on average $1,155 USD for this job
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 hard and best for you.
Best Regards
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 finish this project. Please come in contact with me, so that we can discuss any details via chat:)
Skills:
Microsoft Access, SQL, Visual Basic
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.
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 you contact me, you and I will be happy. Thank you in advance.
Skills:
Microsoft Access, SQL, Visual Basic