Database Editor Help
Edit By Send To Excel Database Tables

Notes
          It is very important in editing data in a database to not use single quotes any more than possible. The single quote is used by the query language to mark off the fields. We have tried to help by programming to catch it when we can, but if you are having any problems entering your data you might try not using quotes.
Edit By
          Choosing any of the edit by items changes to that style of editing affecting any tables you choose to edit after making a choice.
Item Multi Line Full Set
Edit By Item
          The edit by item area gives a list of items in the table in their specific columns. By clicking on a certain column heading you can reorder the data. Once the data is reordered any operation after that uses that ordering.
          If you want to add items using this format simply choose the Add Item button on the botom of this screen.
          To edit any data row simply click on the item in the first field. This takes you into an editor where you can adjust the items.
Screen Shot
 
 
Edit By Multi Line
          The edit by multi line area gives a list of items in a table already in edit mode with the fields all editable. By clicking on a certain column heading you can reorder the data. Once the data is reordered any operation after that uses that ordering.
          If you want to add items using this format simply choose the Add Items button on the botom of this screen.
Screen Shot
 
 
Edit By Full Set
          The edit by full set area gives you one text box with all of the items in it. The colums of data are separated by the pipe | symbol. (This is usually on the keyboard above the backslash.) By clicking on a certain column heading you can reorder the data. Once the data is reordered any operation after that uses that ordering.
          If you want to add items using this format simply type in the text box at the bottom, making sure you separate the columns by the pipe symbol.
          The biggest advantage to this editing is you can add a whole store at one time. All you have to do is edit the data in any editor keeping the appropriate form then cut and paste it into the text box.
          One thing many people like to do to update their data is to do it in a spreadsheet. This form makes it easy to do that. In order to do your store with a spreadsheet do the following:
  1. Enter all of your data in the colums of the spreadsheet, keeping the same order as listed in this form.
  2. Save your data as a text file. In many of your spreadsheet programs you can choose the delimeter and if you choose the pipe symbol it will pretty well be set up for you.
  3. Load the saved text file into some simple editor like Notepad or Wordpad and cut off any titles. If you didn't save it delimeted by the pipe symbol you may need to do a search and replace to do it. If you saved it tab delimeted the easiest way to pick up the tab in the search and replace is to highlight the tab area and do a copy (ctrl-c usually) then go into the search and replace and paste (ctrl-v usually) into the "search for" line.
  4. Once the data looks like it needs to for the Edit By Full Set form copy it then paste it into the form.
          The table options at the top Just Replace Duplicates and Clear Table First are very important.

Just Replace Duplicates - Takes any the data that is entered into the form and, using the first field as the key, replaces any data in the table with the same first field with the new data. Thus if you had hundred items in the table and only need to replace ten you can simply put those ten in the form and only those will be replaced.

Clear Table First - This totally clears the table and fills it only with the data you have in the form.

Screen Shot
Send To Excel
          This tool is mainly for backup purposes. Due to the nature of computers and the problems related to them you should always keep the data for your store backed up. iGOshopping will not be responsible for backups of your data.
Tables
          There are only two tables you have to maintain to run your store, Categories and Products.
Categories Products
Categories
          The categories table only has one field and that is the category. Any product can be part of more than one category (see below).
 
 
Products
          The products table is the one that has the list of items and and their data that you have for sale.
The fields are:
  1. SKU - The SKU field is the identifier you use to distinguish one product from another. Very much like a barcode in a store. This is the primary key of the table.
  2. Short_Description - This is the short description that shows up in your store.
  3. Long_Description - This is the long description that shows up when you click on an item in the store for more information.
  4. Price - This is the price of the item.
  5. Shipping - This is the shipping charge for the first item of this type ordered.
  6. Shipping2 - This is the shipping charge for additional items of this type ordered. (Items past the first one.)
  7. Handling - This is the handling charge for this item.
  8. Is_Available - This is a field that keys to the programs whether or not this item is available for sale. If you want to keep it in the database but not have it show to potential buyers just put a 0 in this field. Otherwise put any other number.
  9. Categories - This is the categories you want this item to show up under. Any item can show up in as many categories as you would like, just separate them by a comma. For example if I want an item to show up under both Cakes and Deserts I would put Cakes,Deserts in this field.
  10. Picture - If the item has a picture this is where you put the name. The program looks for the small pictures in the directory smallimages in your web site and the big images in images in your web site. Thus if my mainstore is http://www.igohosting.com and I put LilacsScript.jpg in this field it would go to http://www.igohosting.com/smallimages/LilacsScript.jpg for the small image for the store and http://www.igohosting.com/images/LilacsScript.jpg for the big image when more information is asked for. Leaving this field blank leaves the pictures blank in the store. If your store is compiled with images off the small picture will not show, but the big one still will when more information is asked for, if you fill in this field.