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

Tietoa työnantajasta:
( 14 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ää

zł288 PLN 1 päivässä
(105 Arvostelua)

39 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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ää

zł277 PLN 3 päivässä
(234 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.

zł500 PLN 3 päivässä
(272 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ää

zł400 PLN 1 päivässä
(201 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ää

zł333 PLN 3 päivässä
(106 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ää

zł700 PLN 3 päivässä
(56 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

zł166 PLN 0 päivässä
(244 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

zł500 PLN 3 päivässä
(40 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ää

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

Hello, and thanks for the opportunity to bid on your project. Relevant Skills and Experience Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expe Lisää

zł736 PLN 3 päivässä
(1 arvostelu)

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

zł200 PLN 2 päivässä
(54 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

zł188 PLN 1 päivässä
(17 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ää

zł350 PLN 5 päivässä
(85 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ää

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

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

zł300 PLN 1 päivässä
(35 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ää

zł750 PLN 3 päivässä
(20 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ää

zł600 PLN 2 päivässä
(11 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ää

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

Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones zł466 PLN - Full Price

zł466 PLN 3 päivässä
(16 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ää

zł750 PLN 3 päivässä
(6 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ää

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