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.
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.
40 freelancers are bidding on average zł427 for this job
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 sir I create this script using excel vba Relevant Skills and Experience Excel dashboard programming vba excel Proposed Milestones zł188 PLN - script
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