Results 1 to 20 of 20

Thread: Adding Database to Soholaunch site
      
   

  1. #1
    stevek is offline Private First Class
    Join Date
    Jul 2009
    Posts
    7

    Default Adding Database to Soholaunch site

    username: snbuzcnd
    How would I add my products to a site I've created in soholaunch in multiple pages as there are many items? Can I create a database and import it in some way?
    thanks, Steve K

  2. #2
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,353

    Default Re: Adding Database to Soholaunch site

    Go to the shopping icon and create your categories.. and add one product to be listed in each category.

    now go to the database tables and download the products table and the category table.

    Now import these to excel and you can see how to format your database and import it back to the store.

    Karen

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    07031847328 / United Kingdom

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  3. #3
    stevek is offline Private First Class
    Join Date
    Jul 2009
    Posts
    7

    Default Re: Adding Database to Soholaunch site

    I downloaded as you said but the file is full of semicolons and very hard to figure out. Am I doing something wrong?

  4. #4
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,353

    Default Re: Adding Database to Soholaunch site

    Yes.. you import it to Excel as a data file. That seperates it to columns etc.

    you must have a working knowledge of databases, and excel spreadsheets to do this.

    Also see the soholaunch online manual for more details.

    Karen

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    07031847328 / United Kingdom

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  5. #5
    mustard20 Guest

    Default Re: Adding Database to Soholaunch site

    Quote Originally Posted by stevek View Post
    I downloaded as you said but the file is full of semicolons and very hard to figure out. Am I doing something wrong?

    I had the exact problem and found this and was able to open and view the data. It is very easy once you understand but very difficult until you understand and you are not alone.

    Follow these exact steps and you will be fine.

    Open Excel to a blank worksheet Select DATA -> GET EXTERNAL DATA -> IMPORT TEXT FILE... Select the name of the CSV file you downloaded from the system. (Note: You may have to set windows to look for CSV files) Follow the on-screen wizard and set your "delimiter" to a "Semi-Colon" (;) Once import is complete, you can save your data as an XLS file or some other format for your use.

  6. #6
    mustard20 Guest

    Default Re: Adding Database to Soholaunch site

    I have a question about once the data is open and on Excel.

    There are columns for SUB_CAT1, VARIANT_NAME1 and VARIANT_PRICE1

    But there are only six columns for each. Is there a way to add more as I have some products that have as many as 20 variations?

  7. #7
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,353

    Default Re: Adding Database to Soholaunch site

    Yes you can add more in the shopping cart icon for those that need them.

    Karen

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    07031847328 / United Kingdom

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  8. #8
    mustard20 Guest

    Default Re: Adding Database to Soholaunch site

    I am putting real effort in trying to learn but have hit a stumbling block.

    It seems that once I have the data table open its is straight forward on loading my data until I get to subs or variables.

    The columns have SUB_CAT1, VARIANT_NAME1 and VARIANT_PRICE1 which looks like I would just type in my information and Im done. Except none of the products that I loaded manually that use these have any data there.

    But farther to the right on the spread sheet there is sub_cats, variant_names and variant_prices which is full of data but in some kind of code that looks hard to learn.

    When using a spread sheet to load products which column do you use for the subs and variants?

    I cant believe that the form would be so easy until you get there and then need code so does it convert it for you after you load it back online or do you have to use that code to use subs and variants?

    I am trying to explain this correct so please forgive me if I have not.

  9. #9
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,353

    Default Re: Adding Database to Soholaunch site

    yes it converts once you reload it.. or it should...i havent tried with that many variants..again.. go put that many on a product and redownload the database and you will see where it adds them.

    Karen

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    07031847328 / United Kingdom

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  10. #10
    mustard20 Guest

    Default Re: Adding Database to Soholaunch site

    Quote Originally Posted by Karen Mac View Post
    yes it converts once you reload it.. or it should...i havent tried with that many variants..again.. go put that many on a product and redownload the database and you will see where it adds them.

    Karen
    Thank you, To Be Continued....

  11. #11
    Join Date
    Aug 2006
    Location
    Chicago suburbs
    Posts
    304

    Question Re: Adding Database to Soholaunch site

    Glad I found this thread, I have some questions about databases in Soholaunch (even after watching a lot of the Soho video tutorials):

    1) Does Soho automatically create the mySQL database(s) for me--I hope so--or do I need to create database(s) before creating tables in Soho?

    2) Will all the tables I create in Soho "reside" on a single mySQL database? If not, why not?

    3) Are all purchases made on my (Soho-based) site automatically recorded in a database, or do I need to create a database to make that happen?

    4) Instead of selling physical products, my site will sell a recurring service provided on-site at the customer's business. What's the best way for me to enable these customers to do the following on my (Soho-based) site:

    a) create an account for themselves (if possible, rather than me creating it for them)

    b) request one or more dates on which the service would be provided, and the specifics of what's to be done (each specific service could be listed as a "product")

    c) view their history of purchases, including dates when the service was provided, specific services provided, and the $ amount billed for that day's work done.

    d) change or cancel an "order" for service that they previously placed on the site (and have the change e-mailed to the same address the initial request was, based on customer's state).

    5) Once a customer places an order, can I make the notification e-mail (not the customer receipt, but a notification to my company) about that order go to a particular e-mail address based on the state where the customer lives?

    Hope I'm not asking too much here . . . THANK YOU!

  12. #12
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,353

    Default Re: Adding Database to Soholaunch site

    1. yes
    2. you dont create the tables.. but.. you can.. usually also done for you
    3. yes.. it is already set to do this
    4. a. membership auto registration addon is available for this.
    4b. Yes you can add a form to the product that requires additional info..such as this.
    4c. you would have to create this table for their membership.. but it could be done or you could have it done.
    4d... canceling would be a manual process..
    5. You get notification to an email.. but its for all orders.. it would take customizing to get it specified by address

    Also... rebilling is done thru your payment processor and not the sitebuildr itself... so if you were also billing more than once or billing monthly...you would in most cases have to STOP this manually.

    Karen

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    07031847328 / United Kingdom

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  13. #13
    Join Date
    Aug 2006
    Location
    Chicago suburbs
    Posts
    304

    Smile Re: Adding Database to Soholaunch site

    Karen, thanks so much for your prompt reply! Some followup questions/comments, which more or less correspond to my earlier ones:

    1 and 2: I'm VERY glad to see I don't have to create mySQL databases, or even tables! I assume that for most of my site needs, it's better to let Soho create the tables for you?

    3. How would I access the database that automatically records purchases made on my site?

    4a. How can I get the membership auto registration addon that you mentioned? Is that a piece of HTML code?

    4b. Cool

    4c. Would I create that table using the Table Manager tool (is that the right name of it?) on the Soho control panel?

    4d. By "manual" process do you mean I (or an authorized individual) would have to log into one of my Site Data Tables and delete or modify the order? No biggie to do once in awhile, just wondering.

    5. Any idea what tool(s) I'd need to get a copy of the order sent to an e-mail address based on the customer's location (such as zip code)?

    THANK YOU, again!

  14. #14
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,353

    Default Re: Adding Database to Soholaunch site

    1, 2 yes..
    3. Its called view orders..
    4. its an addon at addons.soholaunch.com
    4c.. yes
    4d. yes or login to your cc processor
    5... the email goes to the customer as a reciept automatically when they purchase.. if you mean a paper reciept then.. youd have to generate this yourself.

    Karen

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    07031847328 / United Kingdom

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  15. #15
    Join Date
    Aug 2006
    Location
    Chicago suburbs
    Posts
    304

    Question Re: Adding Database to Soholaunch site

    Excellent, thanks for all that, Karen. Re #5: What I mean is, if the customer placing the order is in Cleveland, OH, is it possible (and if so, what tool do I use) to have a copy of that order automatically e-mailed to:

    - the company's primary e-mail address, as entered by the webmaster (easy to do)
    - an e-mail address for my company's Cleveland office (or a manager in charge of Cleveland-area accounts)

    These e-mails would be in addition to the receipt that's automatically e-mailed to the cust.

    THANKS!

  16. #16
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,353

    Default Re: Adding Database to Soholaunch site

    Yes, just add a second email seperated by a coma in the required fields... will it sort EMAILS BY STATE.. NO.. all orders will be emailed to whatever you enter.

    Karen

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    07031847328 / United Kingdom

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  17. #17
    Join Date
    Aug 2006
    Location
    Chicago suburbs
    Posts
    304

    Question Re: Adding Database to Soholaunch site

    OK, new question, I think it's related (enough) to the title theme of this thread: In the tutorial video, "Using the Database Table Manager," near the end it says, "Select the data table that you wish to use as your authenticated user data."

    I don't understand this. If all I'm trying to do is simultaneously add multiple users to my secure users area by batch authenticating (as the video specifically says I can do), why do I need to select a data table to use as my authenticated user data? That is, if they are brand-new names and related data being added to the table, why (or how can they possibly) authenticate them against any data already in any of my tables? THANK YOU.

  18. #18
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,353

    Default Re: Adding Database to Soholaunch site

    lmao.. without watching the video to figure out what you are on about.. id have to guess that you might have MORE than ONE table for users.. by group for instance.

    Karen

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    07031847328 / United Kingdom

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  19. #19
    Join Date
    Aug 2006
    Location
    Chicago suburbs
    Posts
    304

    Question Re: Adding Database to Soholaunch site

    Um . . . not clear on what you mean. To clarify . . . this video shows how to create a table and add users (one at a time) to it:
    http://www.vodahost.com/vodatalk/soh...ure-users.html

    This other video, near the end, says that "batch authenticating" is the way to add many users to your secure users area (which is what I want to do, instead of the 1-at-a-time method):
    http://www.vodahost.com/vodatalk/soh...e-manager.html

    But, as they are brand-new names and related data being added to the table, why (or how can I possibly) authenticate them against any data already in any of my tables? Shouldn't it simply be a matter of uploading an Excel (or similar, data-formatted) file containing the new records?

  20. #20
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,353

    Default Re: Adding Database to Soholaunch site

    well you need sohos format..

    If you look at soho users area you can see you can make members part of a GROUP, so that only certain pages are available for that GROUP. Public.. is default.. meaning its open to everyone who views the site.

    You could for instance make available users only in the state of OHIO.. and certain products availble only to theml Or california, or lets say.. men over 50 etc etc.

    Karen

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    07031847328 / United Kingdom

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49