Custom Inventory Script for Microsoft CSV Files
zł90-750 PLN
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.
Projektazonosító: #15419341
A projektről
Odaítélve:
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
37 szabadúszó tett átlagosan 409zł összegű árajánlatot erre a munkára
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
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.
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
hi there, I have a case experience in Excel and VBA and will be happy to help you on the project. Best regards, Eugene
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
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
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
Hello sir I create this script using excel vba Relevant Skills and Experience Excel dashboard programming vba excel Proposed Milestones zł188 PLN - script
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
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
Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones zł466 PLN - Full Price
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