Find Jobs
Hire Freelancers

Custom Inventory Script for Microsoft CSV Files

zł90-750 PLN

Completed
Posted over 6 years ago

zł90-750 PLN

Paid on delivery
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.
Project ID: 15419341

About the project

37 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 Experience I am a vb.net programmer, I create programs for file transformation, data manipulation etc. Most programs are ready within 1-2 days. Proposed Milestones zł288 PLN - Final program
zł288 PLN in 1 day
5.0 (144 reviews)
6.8
6.8
37 freelancers are bidding on average zł409 PLN for this job
User Avatar
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étences appropriées Excel/VBA Étapes proposées zł277 PLN - m
zł277 PLN in 3 days
5.0 (315 reviews)
7.9
7.9
User Avatar
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
5.0 (481 reviews)
8.0
8.0
User Avatar
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 formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.) Also, I have experience in accounting, Financial Report Tools. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation. I offer you 35+ years of experience working on a variety of companies including, VC's, privet investors, entrepreneurs, startups, retailers, power plants, farms, insurance, universities, constructions, medical equipment manufacturer companies, among others.
zł700 PLN in 3 days
4.9 (96 reviews)
7.5
7.5
User Avatar
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 relevante VBA Htos propuestos zł400 PLN - final delivery
zł400 PLN in 1 day
5.0 (319 reviews)
7.4
7.4
User Avatar
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 code that will compare the SKU between the two files and update when a match is found. Proposed Milestones zł300 PLN - Macro enable workbook to update data as per your requirements
zł300 PLN in 1 day
4.9 (236 reviews)
7.1
7.1
User Avatar
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 day
5.0 (262 reviews)
6.6
6.6
User Avatar
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 Macro Proposed Milestones zł333 PLN - Milestone I understand your requirement. My question is can we do this in excel?
zł333 PLN in 3 days
4.9 (114 reviews)
6.5
6.5
User Avatar
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
5.0 (46 reviews)
6.6
6.6
User Avatar
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 could discuss better your project. Kind regards, Luis Romero
zł350 PLN in 5 days
5.0 (165 reviews)
6.0
6.0
User Avatar
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
5.0 (35 reviews)
5.9
5.9
User Avatar
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 PLN - Default
zł466 PLN in 3 days
4.9 (21 reviews)
5.5
5.5
User Avatar
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. Regards, Sheik
zł90 PLN in 1 day
4.9 (38 reviews)
5.3
5.3
User Avatar
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 Experience Zajmuję się pisaniem makr w VBA, zrealizowałem liczne projekty dotyczące manipulacji danych w plikach CSV. Proposed Milestones zł200 PLN - Makro gotowe i przetestowane
zł200 PLN in 2 days
5.0 (64 reviews)
5.3
5.3
User Avatar
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 expert in many different frameworks such as CodeIgniter, Laravel, Spring and jQuery. Proposed Milestones zł736 PLN - milestones
zł736 PLN in 3 days
5.0 (2 reviews)
4.9
4.9
User Avatar
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 Experience Excel, Data entry, Analysis skills. Proposed Milestones zł300 PLN - At start zł277 PLN - At complition
zł577 PLN in 3 days
4.9 (26 reviews)
5.1
5.1
User Avatar
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 message so I can show a trial of what I offer.
zł300 PLN in 3 days
5.0 (34 reviews)
4.9
4.9
User Avatar
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 examples of Document 1 and Document 2.
zł600 PLN in 2 days
5.0 (12 reviews)
4.3
4.3
User Avatar
Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones zł466 PLN - Full Price
zł466 PLN in 3 days
4.9 (16 reviews)
4.5
4.5
User Avatar
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 Experience I have experience coding in VB, VBA and have done a lot of Excel Macros Proposed Milestones zł150 PLN - Inital zł450 PLN - Draft Version zł150 PLN - Final Additional Services Offered zł750 PLN - I could also provide a more complicated tool for managing your stock
zł750 PLN in 3 days
5.0 (6 reviews)
4.0
4.0
User Avatar
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. Htos propuestos zł277 PLN - IT ETL Service
zł277 PLN in 5 days
5.0 (1 review)
3.4
3.4

About the client

Flag of POLAND
Kielce, Poland
4.9
32
Payment method verified
Member since Nov 19, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.