Merge data from 2 seperate text files in an excel spreadsheet on a daily basis
- or -
Post a project like this2011
£100(approx. $124)
- Posted:
- Proposals: 30
- Remote
- #2142877
- Awarded
WordPress, shopify, WIX, Laravel, php,Flutter, react js, Java, magento, software development, App designing, graphic designing, logo designing
Islamabad
8197414494732413480153929518253542175080233011423477712363884240389623971382384956
Description
Experience Level: Intermediate
I have a bricks and mortar shop selling Cds and Vinyl i can produce a tab delimited file of all items in stock. (TABFILE.TXT)
I would like to compare this to an excel spreadsheet of items i sell overnight online to see which items i have in stock in my shop before ordering from our drop shippers. We can do this by "merging both spreadsheets matching by sku code.
(sample checkout report 17-9-18.xlsx)
I want this to be automated as we need to run this routine at least once or twice every day so it needs to be fully automated
the data can be matched using the field "Catalogue" in the TABFILE and "sku/item#" in the checkout report
The results need to show columns a b c d e from sample check out and all columns from the Tabfile all in one row
I would like to compare this to an excel spreadsheet of items i sell overnight online to see which items i have in stock in my shop before ordering from our drop shippers. We can do this by "merging both spreadsheets matching by sku code.
(sample checkout report 17-9-18.xlsx)
I want this to be automated as we need to run this routine at least once or twice every day so it needs to be fully automated
the data can be matched using the field "Catalogue" in the TABFILE and "sku/item#" in the checkout report
The results need to show columns a b c d e from sample check out and all columns from the Tabfile all in one row
Philip J.
100% (8)Projects Completed
10
Freelancers worked with
10
Projects awarded
24%
Last project
15 Mar 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Philip,
Some Catalogue are blank...
For ex. check Row 1,2 and 3.
Thanks
Sumit
SaS Technologies -
Philip
The script will be hosted on your server?
Is there room for increasing your budget
711426711213
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies