INSERT INTO documentation VALUES(DEFAULT,'View Products','Click on a product code to review or edit it. To delete a product, select the products radio button and click DELETE PRODUCT at the bottom of the page. One should note that this only closes a products timestamp. It does not actually delete it totally. Things like its image and colours will also be kept. All quantities within the quantity table will be removed as it is assumed that these are now invalid.'); INSERT INTO documentation VALUES(DEFAULT,'Add Product','The following is an explanation of each input field. Number of Colour Images: Select the number of colour images you are going to upload for the new product. When a new value is selected, it will change the amount of inputs for colour names and their colour files. Colour Name n/File n: The first box is for the colour name, e.g. BLACK or GREEN. The second box is for the image file of that colour. To obtain a colour image file, scan the sample fabric into the computer. Open the image up in Photoshop or The Gimp and do the following: - Crop the image to just contain a 500x500 pixel region of the colour - Scale the cropped image to 25x25 pixels and save it has .jpg in a directory with the product image. Upload this file along with its colour name. The file names do not have to be unique, the site will take care of this for colour images. Industry Code: This is the internal industry code used to identify a product, e.g. S11, MSB0601. Description: Enter a short description of the product, e.g. LADIES HEMP COTTON 3/4 PANTS. (Long descriptions can also be entered.) Unit Price: The price the product is going to be sold for on the web site. JPG Product Image File: Upload a photograph of the product. It should be a jpg image file, 72 dip, less than 500 pixels wide. Category: Select the category of the product. This will automatically dictate the sizes for the new product. Season: Select a season. Dimensions: The database holds some records for the Australia post bags used for shipping (their maximum input weight and volume). It uses this information along with a products approximate mean mass and volume to calculate the shipping cost for a given order.'); INSERT INTO documentation VALUES(DEFAULT,'Inventory Reconciliation','For Inventory Reconciliation a report of the current inventory levels is needed from Niche. To reconcile, generate a report from Niche with the current stock levels for products on the site. Export this report in Excel format and save it to disk. Open this new document in Excel and save it as XML SPREADSHEET format (not XML DATA format). Upload this .xml file to the site. If valid, i.e. the site knows how to read the document, it will process it an produce a table showing three categories; - Recognise: Products common between the site and the submitted document - Submitted, but unrecognised: Products that you have submitted, but the site does not have any record of - Not submitted: Products that the site has, but were not submitted in the XML document. At this point you can either click on a recognised product and start the reconciliation, or you can delete the `submitted, but unrecognised` products by selection, or you can click the `Begin reconciliation` link to use the wizard. If you use the reconciliation wizard, when page shows saying ` not found`, this corresponds to a product in the `submitted, but unrecognised` category. If you delete it, the site will remove the niche record (it will not delete any site products). If you ignore it, the wizard will take you to the next product. When the wizard comes to a recognised product, three tables of information will be shown. The first table corresponds to colours that you have submitted, but the site has no record of. If you would like to add this colour, this can be done in the Edit Product page accessible via the View Products page. The second table shows the sites current records for that products size, colour and quantity. The third table shows the submitted quantities. You should first verify that all the quantities in the third table are valid (valid with respect to the real stock levels or the stock levels you would like the site to sell). After any amendments, click UPDATE QUANTITY to submitted stock level to the sites stock levels. Once this is done, either click the Next Product link, or the Back to report link.'); INSERT INTO documentation VALUES(DEFAULT,'Site Content','The Site Content page shows the possible pages that you can edit. Click a page to edit its contents. Once you click a link, the page shown will allow you edit limited aspects of that page. You may embed HTML into the text. If you put and exclamation mark as the first character, the site will not do any formating of the text. However, if one is not there, the site will replace every new line character with a HTML new line character (br).'); INSERT INTO documentation VALUES(DEFAULT,'Add Dimensions','The numbers you enter must be positive and have a decimal point in them, e.g. 0.8 3.4. These are kilograms and liters respectively.'); INSERT INTO documentation VALUES(DEFAULT,'Users','The Users page shows a list of users and their attributes. To delete one, just select it and click DELETE USER. The site does not allow to delete the root user.'); INSERT INTO documentation VALUES(DEFAULT,'Add User','To add a new uses, just simply enter their username and password into the boxes provided. Select the permission level and click ADD USER. Someone who is in the admin group will be able to edit everything. Someone who is in the nobody group will be able to log into the administration console, view everything, but not be able to edit anything.'); INSERT INTO documentation VALUES(DEFAULT,'Edit Product','The Edit Product page allows a user to change any attribute of a product, except its industry code. The page is reasonable self explanatory, however, changing the category has some side effects on the quantities. If you change a products category from one size set to another, e.g. changing from Mens Pants (sizes 30-40) to Womens Tops (sizes 8-20), the site will not conserve the quantities (it will delete them). Whereas if you are changing category within size sets, e.g. Womens Tops to Specials Womens Tops, the site will conserve the quantities.'); INSERT INTO documentation VALUES(DEFAULT,'Froogle','The username and password are for the RSS server, these are not necessarily the same as the administration console. The exchange rate is the rate from converting from Australian dollars to US dollars. This is typically a number less than one (e.g. 0.76). We have to do this since Froogle is currently does not support AUDs. Once you have download the file, login to Google Base (http://www.google.com/base/). Here, you should Delete forever all the current items and then click the Bulk upload files link -> Register a new bulk upload file. This will take you to another screen where you should enter a unique File name. Choose the Item type to be Products and click the big register button at the bottom of the page. This will take you to a formating page, dont worry about this page, the rss server has done it all for you. Just click the continue button at the button of the page. This will take you to the next page where you can upload the file you download off the braintree site. Upload it and then check back in an hour or so to see whether the Google processing was successful. If there are any error, please contact the site administrator.');