Hello,

I'm helping a friend out by helping him set up a few internet shops. We are using oScommerce (a php open source shopping cart) and I would like to program a script that automates our product adding.

If I was to do this MANUALLY!!!!!!!!
Lets say we are going to have 500+ products for these websites, that means I'll have to manually:

  • goto each product url
  • start typing/copying pasting the descriptiong for product
  • insert price
  • save image/upload image
  • update product listing.

    Now if I made a perl script to automate process:

    Have LWP retrieve page by having product url ( a simple text file list with 100 different product urls, that way I can use a foreach statement and have LWp retrieve each url by url)
  • Parse description from product url page.
  • save image/uplaod image (*Is this possible?)
  • use DBI module to update mysql DB for each product listing (instead of having to use the oScommerce admin interface to add product info)

    Basically what im trying to do is make a script that automates this process I would have to go through If i was to add each product detail manually to the shopping cart DB.

    About the saving images, I wanted to save a product image from a another website to my server. Is that possible??
    When parsing the website with the product image I want to retrieve, it'll look for the image file name.

    Thank you,
    Anthony

    In reply to Adding Products automation by perleager

    Title:
    Use:  <p> text here (a paragraph) </p>
    and:  <code> code here </code>
    to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.