Đã Đóng

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.*

Kĩ năng: HTML, Javascript, PHP, Shopify, Bảng mẫu Shopify

Xem nhiều hơn: script compare xls files, compare excel files, export retail pro inventory files excel, compare 2 files in unix and print difference, unix compare two files and output differences, invalid central inventory location (cannot create), compare two files in linux and find the differences, compare two files in unix shell script, compare 2 files and output difference, shell script to compare two files line by line, how to find oracle central inventory location, 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

Về Bên Thuê:
( 36 nhận xét ) faridabad, India

ID dự án: #18811743

10 freelancer đang chào giá trung bình $200 cho công việc này

gurpreetchahal93

Hi employer Well, I am an independent web developer, with hands-on experience working with Python. For this task, I recommend a command line tool built using Python. No need for a GUI-tool, although it can be im Thêm

$224 NZD trong 3 ngày
(41 Nhận xét)
5.0
sku5551ed6fd9643

Dear Hiring Manager, I CAN STRAT NOW. i ll make both to wp I am expert in these fields wordpress,woocommerce, html, css/less, bootstrap, presatshop, shopify, joomla,responsive,html to wordpress, Buddypress, Bbpres Thêm

$277 NZD trong 3 ngày
(20 Nhận xét)
4.3
maryumakhter5

Hi dear, I am a professional Web developer and web designer with 4+ years of experience. I have successfully built 100+ websites and created designs that are unique and powerful in differentiating your brand in the m Thêm

$155 NZD trong 3 ngày
(4 Nhận xét)
3.3
anandpadia

Certifications & Achievements • Certified ScrumMaster® • Certified PRINCE2® Project Manager • ExStartup Founder with reasonable Exit Product/Project Management Experience • Agile Coach for cultivating Agile Cult Thêm

$250 NZD trong 3 ngày
(9 Nhận xét)
2.9
ZWXeno

I have 5+ years of experience in PHP, 7+ years of experience in VB .NET and 4+ years of experience in Excel. I can provide an application specific to your needs on the platform of your choosing and include any function Thêm

$150 NZD trong 2 ngày
(4 Nhận xét)
2.7
robwec

This sounds highly doable. First, I will look at the tables and write the logic to compare them. Then, I can ship the script as-is. If you would also like a quick draft of a web app which reads the uploaded files an Thêm

$222 NZD trong 2 ngày
(2 Nhận xét)
1.6
vladimir91216

Hi. I develop high-quality projects. I have over 6 years' working experience as web developer. I have an interest in your project. And i have previous experience of this type of work. You need to develop your pro Thêm

$222 NZD trong 3 ngày
(1 Nhận xét)
0.4
Syed23365

i have years of experience of php and am an experienced php developer and i expert in my skills. I will provide the best quality work bofore the time deadline and My work is surely acceptable i am new here but i Thêm

$155 NZD trong 3 ngày
(1 Nhận xét)
2.5
vikashshah

Hello Sir, I have read your requirement and understood that you are looking an iOS expert developer to develop an iOS application. We have 6+ years experienced developer team and we already built 180+ projects o Thêm

$194 NZD trong 15 ngày
(0 Nhận xét)
0.0
udawood880

Hi i have read your proposal i have experience of 11 years in this platform with team of 7 years experience we are new in this site so dont go on review we have software house with huge team and experts waiting for y Thêm

$155 NZD trong 3 ngày
(0 Nhận xét)
0.0