1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Auto filling out an excel sheet after receiving orders?

Discussion in 'General Programming Chat' started by phatzilla, Nov 2, 2011.

  1. phatzilla

    phatzilla Supreme Member

    Joined:
    Apr 9, 2009
    Messages:
    1,366
    Likes Received:
    1,017
    Let's say i have a shopping cart system like 2 checkout or something.

    After i receive a successful order through the checkout system, i want to have a program automatically save pertinent order information to an excel file (in the form of google documents spreadsheet), which will include some extra web scraping.

    Any tips will be appreciated
     
    Last edited: Nov 2, 2011
  2. hollinger

    hollinger Junior Member

    Joined:
    Apr 28, 2008
    Messages:
    189
    Likes Received:
    34
  3. phatzilla

    phatzilla Supreme Member

    Joined:
    Apr 9, 2009
    Messages:
    1,366
    Likes Received:
    1,017
    Hey i forgot to make a distinction to that

    It would be google documents spreadsheet, not excel!
     
  4. hollinger

    hollinger Junior Member

    Joined:
    Apr 28, 2008
    Messages:
    189
    Likes Received:
    34
  5. frozenocean

    frozenocean Junior Member

    Joined:
    Sep 30, 2011
    Messages:
    100
    Likes Received:
    11
    Location:
    both arctic
    What is the platform of your system which is handling your 2 checkout IPN....

    That can do your work too with less pain...but I am not sure...
     
  6. winordietrying

    winordietrying Junior Member

    Joined:
    Sep 10, 2011
    Messages:
    107
    Likes Received:
    195
    Occupation:
    IM/SEO
    Location:
    BHW
    OP did you find a solution to this?

    I' don't know about 2CheckOut buy Paypal allows CSV export of all info you want. Maybe 2Checkout has a similar feature.

    If not, you can do this in Excel Macros itself if you are familiar with programming in Visual Basic. When you open the excel sheet, you can have it scrape the order data you want to populate from any webpage using the XMLHttpRequest object.

    Similary, if you want to scrape the data off of emails, then you can use an SMTP object to download the emails and then scrape data from the same. VBA is a very powerful programming language.

    If you've installed a shopping cart with a database on your website, then use PHP to generate the file like others have suggested.

    Dunno about Google Doc though.