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.

Habilidades: Coding, Excel, Excel Macros, Excel VBA, Programming

Ver mais: 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, script graphs csv files, php script import csv files, custom export script magento csv, php script convert csv files xml, script consolidate csv files, perl script upload csv files mysql, python script parse csv files

Acerca do Empregador:
( 8 comentários ) Kielce, Poland

ID do Projeto: #15419341

Premiar a:


Hi. I will write a simple program in 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 Mais

zł288 PLN em 1 dia
(82 Avaliações)

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


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 Mais

zł277 PLN in 3 dias
(163 Comentários)

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 dias
(204 Comentários)

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 Mais

zł400 PLN em 1 dia
(171 Comentários)

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 dias
(226 Comentários)

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 Mais

zł333 PLN in 3 dias
(87 Comentários)

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 Mais

zł700 PLN in 3 dias
(35 Comentários)

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 dias
(31 Comentários)

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 Mais

zł90 PLN em 1 dia
(13 Comentários)

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 Mais

zł350 PLN in 5 dias
(59 Comentários)

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 Mais

zł750 PLN in 3 dias
(20 Comentários)

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 Mais

zł300 PLN in 3 dias
(22 Comentários)

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 Mais

zł466 PLN in 3 dias
(10 Comentários)

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 Mais

zł200 PLN in 2 dias
(43 Comentários)

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 Mais

zł600 PLN in 2 dias
(9 Comentários)

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 Mais

zł750 PLN in 3 dias
(6 Comentários)

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 em 1 dia
(12 Comentários)

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 Mais

zł750 PLN in 3 dias
(7 Comentários)

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 Mais

zł388 PLN in 0 dias
(1 Comentário)

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 Mais

zł300 PLN em 1 dia
(12 Comentários)

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 em 1 dia
(8 Comentários)