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.

Taidot: Koodaus, Excel, Excel Macros, Excel VBA, Ohjelmointi

Näytä lisää: 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

Tietoa työnantajasta:
( 8 arvostelua ) Kielce, Poland

Projektin tunnus: #15419341

Myönnetty käyttäjälle:


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 Lisää

288 zł PLN 1 päivässä
(82 arvostelua)

40 freelanceria on tarjonnut keskimäärin 427 zł tähän työhön


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 Lisää

277 zł PLN 3 päivässä
(163 arvostelua)

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.

500 zł PLN 3 päivässä
(204 arvostelua)

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 Lisää

400 zł PLN 1 päivässä
(171 arvostelua)

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

166 zł PLN 0 päivässä
(226 arvostelua)

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 Lisää

333 zł PLN 3 päivässä
(87 arvostelua)

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 Lisää

700 zł PLN 3 päivässä
(35 arvostelua)

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

500 zł PLN 3 päivässä
(31 arvostelua)

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 Lisää

90 zł PLN 1 päivässä
(13 arvostelua)

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 Lisää

350 zł PLN 5 päivässä
(59 arvostelua)

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 Lisää

750 zł PLN 3 päivässä
(20 arvostelua)

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 Lisää

300 zł PLN 3 päivässä
(22 arvostelua)

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 Lisää

466 zł PLN 3 päivässä
(10 arvostelua)

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 Lisää

200 zł PLN 2 päivässä
(43 arvostelua)

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 Lisää

600 zł PLN 2 päivässä
(9 arvostelua)

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 Lisää

750 zł PLN 3 päivässä
(6 arvostelua)

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

188 zł PLN 1 päivässä
(12 arvostelua)

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 Lisää

750 zł PLN 3 päivässä
(7 arvostelua)

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 Lisää

388 zł PLN 0 päivässä
(1 arvostelu)

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 Lisää

300 zł PLN 1 päivässä
(12 arvostelua)

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

200 zł PLN 1 päivässä
(8 arvostelua)