Completed

Custom Inventory Script for Microsoft CSV Files

The Problem:

We have an online store and every 7 days our supplier sends us a new stock sheet (Document 1) which contains all unique identification numbers for each product (SKU) and also the quantity available. We have a second CSV file (Document 2) which represents the products on the store. We need to update the quantities on the Document 2 with information from Document 1. Currently we have to manually go through the store and adjust the inventory.

The Solution:

We are looking for programmer to write a basic script which updates the quantities of each SKU in document 2 with the quantities shown in document 1.

Document 1 has two columns "SKU" and "Qty"

Document 2 has many columns but also contains "SKU" and "QTY"

SKU's match in each document only QTY is changing and requires synchronization regularly.

Skills: Coding, Excel, Excel Macros, Excel VBA, Programming

See more: script graphs csv files, php script import csv files, custom export script magento csv, driverquery windows 10, shopify update inventory csv, shopify inventory csv, driverquery driver version, shopify update inventory api, driverquery sort by date, shopify inventory update, driverquery link date, excel, visual basic for apps, csv, microsoft excel, php script convert csv files xml, script consolidate csv files, perl script upload csv files mysql, python script parse csv files, unix shell script edit csv files

About the Employer:
( 8 reviews ) Kielce, Poland

Project ID: #15419341

Awarded to:

Attractionnet

Hi. I will write a simple program in vb.net to do this. You will just have to put both files into a folder, open the program and press a button. Then the changes will be done automatically. Relevant Skills and Experie More

zł288 PLN in 1 day
(82 Reviews)
5.7

40 freelancers are bidding on average zł427 for this job

bouslimi1979

Hi, I ll code a VBA macro where you wil upload the 2 excel files, and after that will update the quatities based on SKU match. You can send me the 2 file samples and I m ready to start. Thanks Expérience et Compétence More

zł277 PLN in 3 days
(163 Reviews)
7.1
P0L

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

zł500 PLN in 3 days
(204 Reviews)
6.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia More

zł400 PLN in 1 day
(171 Reviews)
6.7
watersev

hi there, I have a case experience in Excel and VBA and will be happy to help you on the project. Best regards, Eugene

zł166 PLN in 0 days
(226 Reviews)
6.3
rohitpithisaria

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. Will send samples if required. Rgds Rohit Relevant Skills and Experience Excel csv Mac More

zł333 PLN in 3 days
(87 Reviews)
5.9
dgled

I am a professional financial and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced form More

zł700 PLN in 3 days
(35 Reviews)
5.8
axiomswb

I have expertise in Excel vba. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you.. Relevant Skills and Experience excel vba Proposed Milestones zł500 PLN - full

zł500 PLN in 3 days
(31 Reviews)
5.5
sheikDev

Hi, I have been developed similar windows based application in C# where can sync the data in single button click. I will be completed in 2 hours. Expecting sample file for development. Thanks for your message. Rega More

zł90 PLN in 1 day
(13 Reviews)
4.7
beltran0404

Hello, I am Luis from Venezuela and I understand your issue. I will provide you a solution with visual basic language (script) to automatically search SKU and add quantities. Please contact me by chat and then we cou More

zł350 PLN in 5 days
(59 Reviews)
4.8
doublebc

Hello, If you have a Windows PC I can create you a simple desktop application where you can select both documents then press a button to update document 2 QTY. Brian Relevant Skills and Experience Software Developme More

zł750 PLN in 3 days
(20 Reviews)
4.5
selopezr

Hell! I've developed a similar solution for a cosmetics company integrating it's phisical inventory with their stocks in Magento and Amazon. I'd be glad to collaborate if you will. Please share details through messag More

zł300 PLN in 3 days
(22 Reviews)
4.3
aanvikm

Hello Sir, I can help you here with this CSV project. May I please request a sample csv file for review (Actually both doc1 and doc2). Thanks Aanvik Relevant Skills and Experience CSV, .Net Proposed Milestones zł466 More

zł466 PLN in 3 days
(10 Reviews)
4.4
Taisho

Dzień Dobry, chętnie napiszę takie makro, które będzie działało natychmiastowo nawet dla bardzo dużej ilości danych. Zrobię równiez wszystko, żeby było jak najwygodniejsze w użyciu. Pozdrawiam Relevant Skills and Ex More

zł200 PLN in 2 days
(43 Reviews)
4.5
logos104

Hi. I can create a utility, which will do automatic update of Excel file. Relevant Skills and Experience Excel, Software development, Office automation. Proposed Milestones zł600 PLN - Full project Please send me ex More

zł600 PLN in 2 days
(9 Reviews)
4.0
hieutc

I will create a script which: Update the SKU in document 2 with info from document 1 Generate a report consist of all the SKU being changed and their quantity before and after (optional). Relevant Skills and Experienc More

zł750 PLN in 3 days
(6 Reviews)
4.0
mohamedrdait

Hello sir I create this script using excel vba Relevant Skills and Experience Excel dashboard programming vba excel Proposed Milestones zł188 PLN - script

zł188 PLN in 1 day
(12 Reviews)
4.1
laurajiannaras

Proposed solution: provide an Excel workbook that will open two CSV files (documents 1 & 2), updating the Qty from document 1 into document 2. Automatic or semi-automatic, depending on preference. Relevant Skills an More

zł750 PLN in 3 days
(7 Reviews)
3.7
tom19468

I will modify my existing MS Excel VBA scripts to read Document 1 for "SKU" and "Qty" and update the appropriate cells in Document 2. Relevant Skills and Experience I have been coding in basic & MS Office (Word, Excel More

zł388 PLN in 0 days
(1 Review)
3.4
aubrey03

My bid is to provide you with a macro that will automatically update the quantities of your products. Relevant Skills and Experience I am an experienced Excel programmer. Your requirement can be done by creating a VB More

zł300 PLN in 1 day
(12 Reviews)
3.4
mpunn2007

I have done similar file to file update projects successfully in recent time. and I m pretty sure I can crack this one within 6 hrs. pls pm to discuss further. thanks mandeep

zł200 PLN in 1 day
(8 Reviews)
3.0