Merge data from 2 seperate text files in an excel spreadsheet on a daily basis

  • Posted:
  • Proposals: 35
  • Remote
  • #2142877
  • Awarded
James M.
Momina Q.Unicorn ByteHasan J.Mahmoud A. + 30 others have already sent a proposal.
  • 15

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






New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

  • SUMIT A.

    Hi Philip,

    Some Catalogue are blank...
    For ex. check Row 1,2 and 3.

    Thanks
    Sumit
    SaS Technologies

  • TSOLUTIONS

    Philip

    The script will be hosted on your server?

    Is there room for increasing your budget