In Progress

Build a utility to compare two inventory files and present the output

We use a physical point of sale (ERPLY) and an ecommerce platform (SHOPIFY).

We need the ability to take the product table exports from each system and then compare them on 4-5 different fields, then output the results for each of those scenarios.

Here are the scenarios:

Products that should be online but are not:

ERPLY Show In Webshop = Yes

AND

SHOPIFY visible online = No

Products that are online but should not be:

ERPLY Show In Webshop = No

AND

SHOPIFY visible online = Yes

Products that are have inaccurate sale pricing on Shopify

Shopify Price <> ERPLY Web Price List

OR

Shopify Compare at Price <> ERPLY Net sales price

Products Out Of Stock Online That Are In Stock In Store

Shopify On Hand <= 0

AND

ERPLY > 0 on hand

The output would display a table with the following fields (field from ERPLY unless noted as SH- which is Shopify field):

Code

UPC Code

Name

Product Group

Net Sales Price

SH - Compare At Price

Web Price

SH - Shopify Price

Brand

Show in webshop

SH - Visible online

In Stock

SH - On Hand

The user can filter on:

UPC - text box entry, live search

Name - text box entry, live search

Product Group (ERPLY Field) - drop down, alphabetical ascending order

Brand (ERPLY Field) - drop down, alphabetical ascending order

The user can select the different scenarios to reduce the output list down.

*We are requesting a basic mockup of the app before we select a freelancer. This can be done in Paint/drawn on paper, as long as we know you have an idea of what we are trying to create.*

Skills: HTML, Javascript, PHP, Shopify, Shopify Templates

See more: unix compare two files and output differences, python list all files in directory and subdirectories, compare 2 files in unix and print difference, shell script to compare two files line by line, python open file directory path, unix compare two files side by side, python loop through files in directory recursively, linux compare two files, script compare xls files, compare excel files, export retail pro inventory files excel, compare report files, code compare excel files find similar items, code compare excel files aspnet, compare csv files using, program compare excel files, excel files import output php, program compare csv files, compare csv files vba, compare csv files sql

About the Employer:
( 35 reviews ) Woodstock, United States

Project ID: #18796145

Awarded to:

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$30 USD in 4 days
(44 Reviews)
5.9

13 freelancers are bidding on average $162 for this job

seemasit

Hi there, I've gone through the post description carefully and ready to start work on this project. Requirements are very clear but please come over the chat so that i can get more requirements if remaining. Plea More

$155 USD in 3 days
(75 Reviews)
7.0
einnovention

Hello Sir/Madam!! I read your requirements, I can handle it and have already done this type of jobs. It will be my pleasure to work with you. Please give me an opportunity to work on your project. WHY US? I re More

$150 USD in 3 days
(138 Reviews)
6.8
androidc

Hello, I have a few questions regarding your shared requirement. Please open the chat so we can discuss. I have 8 years of experience in PHP, Wordpress, YII Framework, Python, Django, Codeigniter, Laravel, JS & A More

$200 USD in 10 days
(130 Reviews)
6.7
lightingdavid

Hello. How are you? I am highly interested to work on the "Build a utility to compare two inventory files and present the output". I am a full stack Shopify website developer. I have more than 7 years experience in More

$140 USD in 2 days
(107 Reviews)
6.1
brightstar928

⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ Hi I read your job description carefully and I can do your job perfectly. I have developed many websites So I can know what you mean and I am ready for you now. If you hire me, I will finish your job A More

$150 USD in 3 days
(39 Reviews)
5.9
thelastsummer

I am expert in Web designing/developing.I believe that I can be the best productive candidate for this requirement. My skills include : * PHP, CMS, Word Press, Magento, Joomla, Ecommerce, HTML * Branding and Cre More

$200 USD in 3 days
(26 Reviews)
5.7
aswadakdas

Customer's satisfaction is my goal *** *** Also 100% Completion is happy of me and client. *** *** Rest is my creative idea and honest effort. *** Looking to be your Good Venture along with your project! Best More

$155 USD in 3 days
(17 Reviews)
4.7
QutubHaider

Hello Sir, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. We are the team of 15 members and over past 2 years we have completed 400+ projects in web More

$155 USD in 3 days
(10 Reviews)
3.9
avto35217

HI there. How are you doing? I am a full stack web developer who has decent experience with most of the javascript frameworks and libraries, and also the php frameworks like CI and Laravel. I am also used to work on ag More

$222 USD in 3 days
(8 Reviews)
3.7
imagicsoft

Hello sir. I have just read your job description and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. Please contact me. Thanks in More

$150 USD in 3 days
(11 Reviews)
3.6
HoneyApplePie

Hello Dear I am expert in PHP ,codeignitor, Mysql , HTML , CSS , Javascript , Jquery , AJAX , web development. My recent work in WordPress development :- [login to view URL] [login to view URL] http: More

$155 USD in 14 days
(4 Reviews)
2.1
leyli19982010

Hey I can help you with your project. I have 6 years of experience in Web and App Development I’ve true passion & skills on what I do for my clients with a unique & creative approach towards every project I undertak More

$244 USD in 3 days
(0 Reviews)
0.0