Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12
  1. #1
    Junior Member
    Join Date
    Oct 2005
    Location
    GA
    Posts
    14
    Member #
    11505
    How do I allow the customer to select multiple items on a drop down list and be able to give different amounts for each item. Afterwards have that emailed. Right now I have the form to where the user can select one item and enter one amount but am having trouble with multiple. Im using a simple html form and php mail script.

    Thanks!

  2.  

  3. #2
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,717
    Member #
    5580
    Liked
    718 times
    Show us what you have now ... a link to the actual form page.


  4. #3
    Junior Member
    Join Date
    Oct 2005
    Location
    GA
    Posts
    14
    Member #
    11505

  5. #4
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,717
    Member #
    5580
    Liked
    718 times
    You can use "select multiple":
    http://www.w3schools.com/tags/att_select_multiple.asp

    But I think you're doing it the wrong way anyhow.

    You should have an inventory database with items, descriptions, cost, etc.
    Someone is going to have to maintain the list of items, costs, etc. You're going
    to need a MySQL database and an "admin" section for that.

    The user first enters their email and then is able to select from various catalog lists.
    Each thing they select is added to their "cart" so to speak (in a client database table).
    They can shop, add items .. leave and return later to add more or remove some.
    When they are finally ready to checkout, you get an email telling you about the order.
    Their contents is stored online in the database, so you can see what everyone has ordered.

    Anyone with the admin login can view all order requests, as well as the clients can view
    their own. Changes can be made until the order is "finalized". The client then can get
    an idea of how much of an item is in stock, in case something needs to be back ordered.

    I mention all of this because I buy building materials sometimes, and I would like to be
    able to "build" my list over a few days. As I see what materials I need and get ready to
    do my project ... it may take 4 days to figure out everything. I would like to build my
    list and when I'm finished, go ahead and place the order.

    Once the order is finalized, it gets an order number, and is moved to a different table.

    There are no emails other than some basic (order in progress), or confirmations.

    And this type of system is really important because you have items coming and going.
    How can a person get a quote if they are not sure whether the item is in stock or not?
    Your liquidation inventory changes every day?
    Some items may be "one of a kind".
    tag_man likes this.


  6. #5
    Junior Member
    Join Date
    Oct 2005
    Location
    GA
    Posts
    14
    Member #
    11505
    I have a list in xml but am new to parsing information to/from a database. Would I use something like this: http://www.w3schools.com/xml/xml_parser.asp or could you suggest a way for me.
    Setting up the mysql wont be a problem for me. You think it would be easier to have the admin page for the office staff to view orders instead of receiving an email with the info? (Somewhat computer illiterate people will be using this on the office end )

  7. #6
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,717
    Member #
    5580
    Liked
    718 times
    Emails is a bad idea ...
    Emails get moved, saved, forwarded, deleted, lost ... you'll never be able
    to manage who has seen them, what they did with them, which one to use, etc.

    Is your website based on ASP.net? On a windows server?
    Or can you use PHP/MySQL?

    Who is editing or creating the XML file?
    And why is there an XML file? Did someone else set that up?

    It's perfectly OK to use an XML file, but the reason for it might not be good.


  8. #7
    Junior Member
    Join Date
    Oct 2005
    Location
    GA
    Posts
    14
    Member #
    11505
    The server is Linux with php 5.2/mysql -dont know version. The xml file is just the exported inventory list with item codes. What do you suggest using to setup the "cart"? What area should I read into.

  9. #8
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,717
    Member #
    5580
    Liked
    718 times
    Where is the inventory coming from?
    You say it's exported, from what?


  10. #9
    Junior Member
    Join Date
    Oct 2005
    Location
    GA
    Posts
    14
    Member #
    11505
    The inventory list is coming from peachtree accounting software.

  11. #10
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,717
    Member #
    5580
    Liked
    718 times
    Does Peachtree automatically FTP that XML file into your website several times a day?

    I'm sort of thinking you will have a 1-way system going on here.

    You can serve the customers a list of items (from the XML file), they can
    pick things out, but there won't be any way to tell Peachtree what has been
    sold. So, after the customers place an order and pay, the person using Peachtree
    makes their changes, and later on, Peachtree sends a new XML file which shows
    the changes.

    But that 1-way system might be good enough. The customers will have to know that
    the quantities are not guaranteed until the order is processed.

    So, describe more how the XML files gets exported ... by hand, or by FTP (automatically)?

    Also, post a portion of the XML file so I can see how it's formatted.



Page 1 of 2 1 2 LastLast

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 05:00 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com