Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 13 of 13
  1. #1
    New Coder
    Join Date
    Aug 2012
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Question Please help me with some issues with PHP (data extraction)

    Hello,
    let me firstly introduce myself - I am Jane - a student of Graphic and Fashion University and with another 3 girls we are creating shirts and fashion jewellery. We would like to create ourselves a blog to propagate our works that we are currently offering only at our town. Well it is not a such big business but we would like to help with one issue. Well despite i have some lessons from informatics I am not able to solve one issue... and one friend told me that I should find some help on this forum, so I am asking you for help...

    Code:
    Note: please let me know if this issue needs to hire some IT specialist - if it is harder to solve than i thought...
    For our arts and fashion jewellery we mostly use swarovski beads which we buy from ebay. To this days we used excel as a feed to all informations we needed, but it works badly and it was also freezing so i was searching and found one script on google which we found as ideal...

    Code:
    you can look here: http://www.qualityunit.com/de/unitminer/web-daten-extraktion-beispiele/webextraktion-ebaycom/
    I know that it is possible to run php script stored on FTP so it would be for us much more easier than manually add data to excel.

    So If you will run that script above mentioned you will get a .csv file with this header:

    Code:
    Source URL;Category URL;Category Name;Expiration Time;Offer Name;Bid History;Current Bid;Image URL;Image Name;Image Alternative Text
    we just need only "Source URL, Offer Name, Current bid, and another four datas from product page. See on this image:



    The source will be: http://stores.ebay.com/Krustallos/Sw...=p4634.c0.m322 and we need all product from there (not just 5)


    I was trying to run this code (i have just copy it and paste it to three new created files .PHP), I did not change anything. I upload it on FTP, add adress to Safari and nothing happened( What I was doing wrong? Would be anyone so so kind to help us?

    We would appreciate any help. Thank you.

    Jane

    P.S.: hope that I explained it right xixi

  • #2
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,548
    Thanks
    8
    Thanked 1,094 Times in 1,085 Posts
    I'm really confused ...

    Are you selling your items on ebay, or are you buying
    items from ebay and selling them on some other website?

    What does that script called webextraktion have to do with anything?
    And what role does Excel play? I don't get it.

    Are you the buyer or the seller?

  • #3
    New Coder
    Join Date
    Aug 2012
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by mlseim View Post
    I'm really confused ...

    Are you selling your items on ebay, or are you buying
    items from ebay and selling them on some other website?

    What does that script called webextraktion have to do with anything?
    And what role does Excel play? I don't get it.

    Are you the buyer or the seller?
    I am sorry that I explained it wrongly, I am ebay buyer and I just need to extract data from ebay store written above. Those extracted data I use for choosing product I need to buy to create some art or fashion...

    Currently role of excel was to add there data (using "link to external data from URLs") but it was slow, making mistakes and my computer was freezing... So I have found above solution as better one, because it probably would create one file with only those datas I need. And in php I would add it to cron so actual data will be available without editing excel URLs when any auction ends or begins. So is that possible? Or I have just a dream?

    With thanks... Jane
    Last edited by Jana.Werid; 08-04-2012 at 11:30 PM.

  • #4
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,548
    Thanks
    8
    Thanked 1,094 Times in 1,085 Posts
    That link you gave has an RSS feed (XML file):
    http://www.ebay.com/sch/Krustallos/S...=1&_rssstore=1

    How about a PHP script that reads that XML file periodically and does
    something with the data? PHP can grab that XML file data anytime and
    you can do whatever you want with it.

    Also, for your information, you can use Google Docs Spreadsheet (which is free)
    instead of Excel. It's basically the same thing as Excel, but it's online, not on
    your PC. Something to think about.

  • #5
    New Coder
    Join Date
    Aug 2012
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts
    I also tried Google spreadsheet- but there is a limitation for max 50 import XML functions - and there is a 300+ products and i need some information from inside of product (as shown on image above), so that was not for me...

    I thought that soucre code on http://www.qualityunit.com/de/unitmi...ktion-ebaycom/ is PHP code, so I could use it... That was not right, was it?

  • #6
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,548
    Thanks
    8
    Thanked 1,094 Times in 1,085 Posts
    I don't know what that script is. Doesn't look like PHP to me.

    And when I view the RSS feed (the XML file), it displays 100 items.
    It looks like there are only 100. Do you think there should be 300?

    Anyhow, PHP can read that XML file and save a CSV file in your website.
    You can download that CSV file to your own Excel if you wish.

    But, as you say, the RSS feed doesn't have any item details.
    So, I guess you're sort of "out of luck".

    EDIT:
    There is an API that might be useful ... I have no experience with it using PHP:
    http://developer.ebay.com/DevZone/XM...ingSellerItems



    .
    Last edited by mlseim; 08-05-2012 at 12:39 AM.

  • #7
    New Coder
    Join Date
    Aug 2012
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Yep, there is currently 361 products (for this url: http://stores.ebay.com/Krustallos/Sw...=p4634.c0.m322 ) when i click to RSS feed I will get only 100 as you. If any PHP (as you wrote at the end of your reply) will fetch all product of that category, it would be much better solution than excel...

    Jane

  • #8
    New Coder
    Join Date
    Aug 2012
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Oh ok (I have just read your edit), anyway thank you for your help
    Maybe I will find some solution. So thank you for your time and help again

    Jane

  • #9
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,548
    Thanks
    8
    Thanked 1,094 Times in 1,085 Posts
    I guess you'll have to find someone with ebay API experience to write
    a PHP script to get "Seller Items". Sorry I can't be of more help on this.

  • Users who have thanked mlseim for this post:

    Jana.Werid (08-05-2012)

  • #10
    Senior Coder
    Join Date
    Apr 2011
    Location
    London, England
    Posts
    2,120
    Thanks
    15
    Thanked 354 Times in 353 Posts
    I don't know much about this, and perhaps I'm showing my ignorance, but if you add &_pgn=2 to the end of your link (or RSS feed link) it will provide data from a second page. You could repeat this until it errors out.
    "I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
    Validate your HTML and CSS

  • #11
    New Coder
    Join Date
    Aug 2012
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by AndrewGSW View Post
    I don't know much about this, and perhaps I'm showing my ignorance, but if you add &_pgn=2 to the end of your link (or RSS feed link) it will provide data from a second page. You could repeat this until it errors out.
    Unfortunatelly that did not work for me...

  • #12
    Senior Coder
    Join Date
    Apr 2011
    Location
    London, England
    Posts
    2,120
    Thanks
    15
    Thanked 354 Times in 353 Posts
    Quote Originally Posted by Jana.Werid View Post
    Unfortunatelly that did not work for me...
    No?

    http://stores.ebay.com/Krustallos/Sw...c0.m322&_pgn=3

    Ah well..
    "I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
    Validate your HTML and CSS

  • #13
    New Coder
    Join Date
    Aug 2012
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by AndrewGSW View Post
    Well it works for search, same URL I use in excel. But that does not work for rss and for solution for my problem to catch specific data which I wrote in my first post.

    Jane


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •