Custom Inventory Script for Microsoft CSV Files

Befejezett Kiadva: 6 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

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.

Kódolás Excel Excel Macros Excel VBA Programozás

Projektazonosító: #15419341

A projektről

37 ajánlat Távolról teljesíthető projekt Utoljára aktív: 6 évvel ezelőtt

Odaítélve:

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 Továbbiak

zł288 PLN 1 napon belül
(144 értékelés)
6.8

37 szabadúszó tett átlagosan 409zł összegű árajánlatot erre a munkára

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 Továbbiak

zł277 PLN 3 napon belül
(315 vélemény)
7.9
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 3 napon belül
(481 vélemény)
8.0
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 Továbbiak

zł700 PLN 3 napon belül
(96 vélemény)
7.5
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 Továbbiak

zł400 PLN 1 napon belül
(319 vélemény)
7.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 Továbbiak

zł300 PLN 1 napon belül
(236 vélemény)
7.1
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 0 napon belül
(262 vélemény)
6.6
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 Továbbiak

zł333 PLN 3 napon belül
(114 vélemény)
6.5
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 3 napon belül
(46 vélemény)
6.6
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 Továbbiak

zł350 PLN 5 napon belül
(165 vélemény)
6.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 1 napon belül
(35 vélemény)
5.9
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 Továbbiak

zł466 PLN 3 napon belül
(21 vélemény)
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 Továbbiak

zł90 PLN 1 napon belül
(38 vélemény)
5.3
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 Továbbiak

zł200 PLN 2 napon belül
(64 vélemény)
5.3
TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html Relevant Skills and Experience Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expe Továbbiak

zł736 PLN 3 napon belül
(2 vélemény)
4.9
rIbrarahmed

Concerned, I am skilled and experienced professional. I have 5 to 6 years of working experience in an organization. I feel fit for your project. please feel free to contact with me. Thank you. Relevant Skills and Expe Továbbiak

zł577 PLN 3 napon belül
(26 vélemény)
5.1
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 Továbbiak

zł300 PLN 3 napon belül
(34 vélemény)
4.9
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 Továbbiak

zł600 PLN 2 napon belül
(12 vélemény)
4.3
AhmedHassan1122

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

zł466 PLN 3 napon belül
(16 vélemény)
4.5
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 Továbbiak

zł750 PLN 3 napon belül
(6 vélemény)
4.0
dsasoftware

Regards! I work with an ETL tool that allows me to manipulate the documents, and generate a script in Java. Habilidades y experiencia relevante I have already done data migrations and data integrations using the tool. Továbbiak

zł277 PLN 5 napon belül
(1 Visszajelzés)
3.4