SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    Design and Promotion Crimson77's Avatar
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    331
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Arrow Convert Database with calculator

    Hi Guys,

    I'm looking for some information.

    I'm looking into setting up a calculator that will convert a wholesale price list into a retail price list.

    So you'd have a price list as a database file or Excel doc then after filling in form fields such as your price mark up, taxes and additional service fees it converts the original price list into a new one relevant to the info you just entered.

    Finally, it would need to spit out a pdf or html page to be printed by the retailer.

    Does anyone know of where I can find more information about this sort of thing. I know a fair bit of flash, html, css and a little php, mysql. So hopefully the technology suggested would include these.

    Hope this makes sense. I'm looking forward to what you can suggest.

    Thanks.

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    you could easily do this in PHP, or with PHP and mysql. what kind of help are you looking for, specifically?

  3. #3
    Design and Promotion Crimson77's Avatar
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    331
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm after a tutorial or something along those lines that takes me through the steps needed for something like this.

    I could pay someone to do it for me. But I thought it might be worth learning myself.

  4. #4
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    we can help you write such an application, or possibly recommend a tutorial.

    but first, i need to know more about what you want to do. can you lay out some basic technical requirements for your application?

  5. #5
    Design and Promotion Crimson77's Avatar
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    331
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It's fairly open. PHP, MySQL to deal with the databases.

    Flash for the calculator interface or possibly a html page which I'll style with css.

    Approx, 20 tables (which are the pricelists) to be converted. Each table has about 10 rows by 10 columns, all with different pricing data.

    I want to use a form, with a number of fields.

    – minus wholesale discount
    – add profit margin
    – Add tax pecentage

    You would then select from 1 of the 20 price lists. (like 20 different submit buttons). Or perhaps a drop down with the price lists and 1 submit button.

    Then the form will be processed and the new price list will be displayed in a printable format, whether that is a pdf or a styled html page.

    I think that's it.

    Can't be much more specific without sending you the excel file.

    I hope that's enough. If you think there are better ways to achieve the task, please let me know.

    Thanks

  6. #6
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    will those 20 tables have the same 10 columns?

  7. #7
    Design and Promotion Crimson77's Avatar
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    331
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Unfortunately no. Each Price list is different.

  8. #8
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    can you post the price lists? or email them to me? i will PM you my email address.

  9. #9
    Design and Promotion Crimson77's Avatar
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    331
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It should arrive in your email shortly.


Bookmarks

Posting Permissions

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