WordPress.org

Ready to get started?Download WordPress

Forums

Pull data from CSV file stored on Googledocs/Office 365 (2 posts)

  1. Paperman
    Member
    Posted 2 years ago #

    Hi Guys,

    Hope someone can help with my below question.

    I have a list of prices and shipment info for a list of clients stored on Excel - Office 365. This data is continuously updated.

    I want my customers to be able to track their purchase data. For example, one could enter their Purchase Order No. in a field on my WordPress site and it should pull the data concerning that order number from my spreadsheet, which is continuously updated by my team with the latest order information.

    For example (data on spreadsheet):

    Customer name: Order No: Payment received: Shipped date:
    Jack PVT ABC123 12/01/2012 18/01/2012
    Harry PVT DEF456 11/01/2012 18/01/2012

    The user Jack PVT on the site would enter their Order No. and the below date will be pulled from the spreadsheet:

    Customer name: Order No: Payment received: Shipped date:
    Jack PVT ABC123 12/01/2012 18/01/2012

    Is this possible? If so, please kindly explain how? Thank you.

    I have read many previous answers on a similar theme, but none have concentrated on this particular area.

    Kind regards

  2. Paperman
    Member
    Posted 2 years ago #

    I've had a good read up, it seems very easy to do this if using MYSQL databases and PHP to pull the necessary data.

    Problem is I can't give access to normal backend users to the databases. They currently already use an online share spreadsheet to do this, some use Google Docs and others are using Office 365.

    If anyone can think of a solution, it will save me a few grey hairs...

Topic Closed

This topic has been closed to new replies.

About this Topic