Thread: 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

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

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

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

Originally Posted by stevek

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.

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?

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

Karen

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.

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

Originally Posted by Karen Mac

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....

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!

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

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!

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

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!

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

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.

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

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?

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