Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Create Product Catalog - Database Preset

Create Product Catalog - Database Preset

Thread began 8/09/2012 8:44 am by elevy388997 | Last modified 8/09/2012 11:04 am by Jason Byrnes | 707 views | 3 replies |

8/09/2012 8:44 am | #1 elevy388997Beta Tester

Create Product Catalog - Database Preset

I am starting to create a dynamic site and in the very first window that opens up with the DataAssist: Create Pages wizard, I chose Product Catalog and it says the products table I currently have selected doesn't contain all the columns as the Product Catalog preset.

I am wondering which columns the Application Type Product Catalog preset has, that I do not. I imported the free eCommerce database.

8/09/2012 9:12 am | #2 Jason ByrnesWebAssist

If you select the option to have the wizard create the table for you, then go to the Manage pages tab and edit the Configure Field Settings, you can see a listing of the database columns for the preset.

8/09/2012 9:51 am | #3 elevy388997Beta Tester

Starting from ProductRetailPrice to the bottom, I added to the eCommerce Database match the preset database. I just want to check that the datatypes and default values are correct:

(attached)

8/09/2012 11:04 am | #4 Jason ByrnesWebAssist

here is the SQL used to create the table:

CREATE TABLE `Products` (
  `ProductID` int(12) NOT NULL AUTO_INCREMENT,
  `ProductSKU` varchar(50) DEFAULT NULL,
  `ProductName` varchar(100) NOT NULL,
  `ProductPrice` float(12,2) NOT NULL,
  `ProductRetailPrice` float(12,2) DEFAULT NULL,
  `ProductShipping` float(12,2) DEFAULT NULL,
  `ProductWeight` float(12,2) DEFAULT NULL,
  `ProductCartDesc` varchar(250) DEFAULT NULL,
  `ProductShortDesc` varchar(1000) DEFAULT NULL,
  `ProductLongDesc` text,
  `ProductThumb` varchar(100) NOT NULL,
  `ProductImage` varchar(100) NOT NULL,
  `ProductUpdateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ProductStartDate` datetime DEFAULT NULL,
  `ProductEndDate` datetime DEFAULT NULL,
  `ProductStock` float(12,2) DEFAULT NULL,
  `ProductLive` tinyint(1) DEFAULT '0',
  `ProductUnlimited` tinyint(1) DEFAULT '1',
  `ProductDigital` varchar(250) DEFAULT NULL,
  `ProductMaxDownloads` int(12) DEFAULT NULL,
  `ProductNonTaxable` int(1) DEFAULT '0',
  `ProductTitle` varchar(100) DEFAULT NULL,
  `ProductMetaKeywords` varchar(255) DEFAULT NULL,
  `ProductMetaDescription` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ProductID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.