Does this exist?

Discussion in 'IT & Internet' started by swankypants69, Jul 29, 2019.

  1. swankypants69

    swankypants69 UKBF Regular Free Member

    491 103
    So, I am pretty much a novice in terms of anything computer related

    I can use a computer obviously, I order a lot of stock for my shops online for instance, but I know nothing about programming etc

    I end up spending a huge amount of time each week checking from website to website price wise when I am placing orders, to make sure I am buying at the best price I can

    So, say for instance each week I have 100 individual items which I need to buy, I might have to sit there and check up to 3 different websites and also against a price list of another supplier that we have as a PDF. The variance in price can be as little as 50p per item, but it can also run to £8-10 (items roughly cost me £15-30 ish as a guide)

    Not all products are available from all suppliers obviously

    Is there a piece of software that can be developed to do the hard work for me?

    It can take an hour or two a week (and it is pretty tedious: three web browsers open plus a PDF document control F and search etc)

    Any thoughts? Prices change, or certainly may change, so may need something quite live and reactive

    Is it possible/feasible/cost effective?

    Cheers
     
    Posted: Jul 29, 2019 By: swankypants69 Member since: May 4, 2012
    #1
  2. TargetICT

    TargetICT UKBF Contributor Free Member

    58 10
    A simple python script can scrape all three sites and the pdf at specified intervals for your 100 products and generate a csv with the cheapest products of each shop (it can even be further configured to make purchases though it’s advisable you review manually)
     
    Posted: Jul 29, 2019 By: TargetICT Member since: Feb 26, 2018
    #2
  3. swankypants69

    swankypants69 UKBF Regular Free Member

    491 103
    Cool sounds simple

    How would I go about making that happen? Ha ha
     
    Posted: Jul 29, 2019 By: swankypants69 Member since: May 4, 2012
    #3
  4. TargetICT

    TargetICT UKBF Contributor Free Member

    58 10
    Good question. Lol. Do the websites need a login? Also how do you get the pdf? Is it emailed or generated from a site?
     
    Posted: Jul 29, 2019 By: TargetICT Member since: Feb 26, 2018
    #4
  5. intheTRADE

    intheTRADE UKBF Contributor Free Member

    74 12
    There are chrome extensions (Shoptimate I think one of them is called) that can compare prices for you. Maybe worth looking at them to see if it can give you what you need
     
    Posted: Jul 29, 2019 By: intheTRADE Member since: Apr 14, 2019
    #5
  6. swankypants69

    swankypants69 UKBF Regular Free Member

    491 103
    Yes the websites require a trade log in to access wholesale pricing, which obviously I have

    PDF is emailed to me from a supplier
     
    Posted: Jul 29, 2019 By: swankypants69 Member since: May 4, 2012
    #6
  7. swankypants69

    swankypants69 UKBF Regular Free Member

    491 103
    Thanks I will have a look at this, obviously this wouldn't be able to take into account the PDF I guess
     
    Posted: Jul 29, 2019 By: swankypants69 Member since: May 4, 2012
    #7
  8. Mr D

    Mr D UKBF Legend Free Member

    15,606 1,719
    You could copy the content?
     
    Posted: Jul 29, 2019 By: Mr D Member since: Feb 12, 2017
    #8
  9. zigojacko

    zigojacko I say it how it is Full Member - Verified Business

    3,557 1,131
    There is software and various apps out there already that do this but I don't have first-hand experience of using them myself. Check out Prisync for example... Not sure if that would be any good and saves trying to get something developed yourself.
     
    Posted: Jul 30, 2019 By: zigojacko Member since: Dec 7, 2009
    #9
  10. TopSpek

    TopSpek UKBF Contributor Free Member

    31 3
    Scraping is such a crude solution. The output may change format. Field names and/or values may change. String patterns that your scrapers rely on may change.

    It could be helpful if you could tell us which suppliers you are using so that maybe some bridging software could be found. I would imagine that if your suppliers are fairly specialised, then there wouldn't be any bridging software available and so you would have to go bespoke. But for suppliers such as Amazon, Ebay, etc. I would imagine they have well developed APIs, and this is what any good bridging software developer should be using.

    So, my first thought would be to find out whether your suppliers have public APIs. If you can find bridging software that uses these, then great - all the software development and maintenance will be carried out by their software developers. But a supplier may not provide public APIs for fear of their competitors using it to automate their own pricing. You could always contact them of course - if you're a trusted customer and they can verify you from their database, then they might just listen to you.

    David
     
    Posted: Jul 30, 2019 By: TopSpek Member since: Jul 15, 2019
    #10