Samples Product Information Home Page Download Pricing

Data Structure

Consider this product from the sample page.

You can see that it has six distinct text or price fields so we know that we'll need at least six columns in the table to describe this product. The name of the photo needs to be recorded and we also want the products to be grouped into categories so a photo and category column makes eight.

Additionally, if you click the photos on the sample page, you'll see that sometimes it takes you to a larger view of the product but sometimes it takes you to a different page. If you hover over the images, you'll see that more descriptive text is displayed. These Link and Title columns are optional, but allowed by the software, so I'll include them in this example.

These ten columns are typical of what you might see in a spreadsheet which fully describes the product.

 

There are still a few more columns we'll need to create and now we'll go back to CleverCat to understand where they fit in.

 

This is a screenshot of the same data in CleverCat's Data View form. In addtion to the ten columns from the spreadsheet, there are Print and Sub Order number columns on the left side of the Data Window.

 

If you've viewed some of the other tutorials you may already know that these are used to set the printing order as well as create the Detail Tables.

Referring back to the sample page, you can see that the product is available in three sizes. On the Data View form, these three sizes are grouped together by a common Print Order number. You can see that each of the three lines has a Print Order number of 1 and a sequential Sub Order number from 1 to 3 which also defines the printing order within the table. The Print and Sub Order numbers are created automatically by CleverCat and this process is explained in other tutorials.

 

There is one extra column which you don't see but is also created automatically. CleverCat assigns a unique Index number to every record in the database and I'll create that column in the mySQL table as well. All together, there are thirteen columns that I'll import to create the sample pages.

The columns on the Data View form can be reorganized and resized to fit your data so the screenshot above may not match your own view. To reset the columns to their default numerical order, click Reset Columns in the Data Menu on the Menu Bar or Ribbon.

The numerical order of the columns will be important later when we get to the Data Uploading section.

 

Before leaving this form, you should take note of the column headers at the top of the Data Window. I'll make references to them in a few paragraphs so you need to understand a little about them.

Each category can have its own column headers. For the baseball gloves category, Size is a relevant heading but it would not make sense when describing power tools. In the next chapters, I'll give this column a generic name in the mySQL table and CSV file.
These headers are not uploaded into the database. Instead, they are included in the templates, so, regardless of the generic names given in the mySQL table, you can still have category-specific column header for your online catalog. You can change the column headers on this form or the Category Editor form.

 

Now that we know what columns need to be created, we can configure the utility which will create those columns in the mySQL table. Exit the Data View form and click the Configuration button on the Main Menu. Next, click the HTML configuration button.

 

Return to Tutorial Selection or Continue to the next chapter: Exporting Data from CleverCat