Buying need a small php program coded

Discussion in 'Programming' started by tyankee, Nov 16, 2016.

  1. #1
    i need a php program coded to do the following:

    read an Excel spreadsheet by item number and if the item number exists on my products table, update the price, if it doesn't exist, create a new product record from fields in the spreadsheet.

    after going through all the records on the spreadsheet, if an item exists on the database that is not in the spreadsheet (for a particular distributor), delete the product record.

    obviously there will be more particulars but this is the general concept.

    please PM me your bid, expertise, availability, and references.

    Thanks.
     
    tyankee, Nov 16, 2016 IP
  2. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Not really interested in the job, I would just tip you about using CSV instead of Excel files. Easier to use in PHP, no need for other libraries, and you can save as CSV directly from Excel.
     
    PoPSiCLe, Nov 16, 2016 IP
    tyankee likes this.
  3. tyankee

    tyankee Well-Known Member

    Messages:
    1,023
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    150
    As Seller:
    100% - 3
    As Buyer:
    100% - 0
    #3
    attached is an example of the CSV file in zipped format.
     

    Attached Files:

    tyankee, Nov 17, 2016 IP
  4. tyankee

    tyankee Well-Known Member

    Messages:
    1,023
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    150
    As Seller:
    100% - 3
    As Buyer:
    100% - 0
    #4
    thanks everyone. got this done..
     
    tyankee, Nov 25, 2016 IP