Database Format Break Down:

id|   =   Your databases record number.

product-codes|   =   These are where the product search codes go!
i.e.
p30b → Price Range Category,  - Note: Reqiured
c118t → Main Category, - Note: Reqiured you can add 2 more related categories here also!
h15o → Sub Category,   - -    Note: Optional Can be used for Holidays or ?
d92a → Arrival Date Category,  - Note: Optional
s44l → Sale Category,     - - - -    Note: Optional

Note: The field should look like below and each should be separated by a comma,

i.e. |p30b,c118t,c139t,c484t,h15o,d92a,s44l,|  ← These can be edited in the Admin Product Console!
* * See Database Search Codes below for more info! * *

price|   =   Product Unit Price.

item-number|   =   Products Manufacturers or Order Number.

product-name|   =   Product Name (40 Char max.)

image|   =   Product Image Name and Location i.e. /images/imagename.jpg

description|   =   Product Description, you can use some html here and related product links here as well!

color|   =   Products Available Colors, if more than one separate with commas, i.e. |Red,Blue,Green,Black,|

Note: By putting a comma after each Color name will tell the program to generate a Select drop down box for the Color field in the template !COLOR!

size|   =   Products Available Sizes, if more than one separate with commas,   i.e. |Sm,Med,Lg,XLg,|

Note: By putting a comma after each Size name will tell the program to generate a Select drop down box for the Size field in the template !SIZE!

wt|   =   Product Unit Weight   i.e. |1.25| ← Equals 1 and 1/4 pounds

dropship-email|   =   This is the drop shippers email Address (replace @ with - in address i.e. sales-thedot.com) if you decide to use this feature or leave it blank but the field must remain.

template|   =   This is the name of the HTML Template page you are going to use to display this product from the database, located in the templates directory!

Note: Sample search link: "/cgi-bin/acart/apple-search.pl?&prodcodes=c01t,c196t" etc...
You can use one or many codes as you want to show items.


Note: This is the best part, you can create a different display templates for each product or use the same one, or for that special product that requires additional information, etc..!
In any case you have the freedom to do what you want with the display of each product....
As well as having Product html pages for the search engines!

Note: You can locate the template directory anywhere on your site, as long as you edit the location in the configuration section!!

Database Search Codes: Located in codes.pl file ← These can be edited in the Admin Product Console!

##### Database Search Codes
#
##### price_codes Search Codes
%price_codes = (
"p30b" => "Under 10.00",
"p35b" => "Over 10.01 to 15.00",
"p40b" => "Over 15.01 to 20.00",
"p45b" => "Over 20.01 to 25.00",
"p50b" => "Over 25.01 to 50.00",
"p55b" => "Over 50.01 and above"
);
### end price_codes
#
##### category_codes Search Codes
%category_codes = (
"c01t" => "African American",
"c04t" => "Alien’s",
"c07t" => "Americana Sweetheart Collection",
"c100t" => "Collectibles",
"c103t" => "Compasses",
"c106t" => "Cork Creations",
"c109t" => "Country Decor",
"c10t" => "Anastasia Collection",
"c112t" => "Cows",
"c115t" => "Coyotes",
"c118t" => "Cut Glass",
"c121t" => "Diamonds",
"c124t" => "Disney Products",
"c127t" => "Divine Inspirations",
"c130t" => "Dogs",
"c172t" => "Fine Jewelry",
"c175t" => "For the Fisherman",
"c178t" => "Flowers",
"c181t" => "Water Fountains",
"c184t" => "Frogs",
"c187t" => "Frosted Creations",
"c190t" => "Garden Collection",
"c193t" => "Gargoyles",
"c196t" => "Gift",
"c199t" => "Gift Accessories",
"c19t" => "Ballerina’s",
"c202t" => "Gift Certificate",
"c205t" => "Gift Sets (Baby)",
"c208t" => "Glass Creations",
"c274t" => "Lady's Wear",
"c277t" => "Lamps",
"c313t" => "Mango Collection",
"c316t" => "Men's Jewelry",
"c319t" => "Men's Rings",
"c31t" => "Bird Collection",
"c322t" => "Merlin Collection",
"c325t" => "Message in a Bottle",
"c328t" => "Medieval Legends",
"c331t" => "Michael Jordan",
"c334t" => "Miniatures Collection",
"c58t" => "Butterflies",
"c61t" => "Camping",
"c64t" => "Candle Collection",
"c67t" => "Candleholders",
"c70t" => "Carousels",
"c73t" => "Cats",
"c76t" => "Catalog-WP",
"c79t" => "Cherubs",
"c82t" => "Chess Sets",
"c85t" => "Christmas Decor",
"c88t" => "Christmas Angels",
"c91t" => "Cigarette Lighter Jackets",
"c94t" => "Classic Wheels",
"c97t" => "Clocks"
);
### end category_codes
#
##### scategory_codes Search Codes
%scategory_codes = (
"h00o" => "New Years",
"h05o" => "Valentines",
"h10o" => "Easter",
"h15o" => "Mothers Day",
"h20o" => "Fathers Day",
"h25o" => "Fourth of July",
"h30o" => "Grandparents Day",
"h35o" => "Halloween",
"h40o" => "Thanksgiving",
"h45o" => "Christmas",
"h50o" => "Wedding",
"h55o" => "New Baby",
"h60o" => "Any Occasion",
"h65o" => "Religious"
);
### end holiday_codes
#
##### arrival_codes Search Codes
%arrival_codes = (
"d00a" => "January",
"d01a" => "February",
"d02a" => "March",
"d03a" => "April",
"d04a" => "May",
"d05a" => "June",
"d06a" => "July",
"d07a" => "August",
"d08a" => "September",
"d09a" => "October",
"d10a" => "November",
"d11a" => "December"
);
### end arrival_codes
#
##### sale_codes Search Codes
%sale_codes = (
"s44l" => "Spring Sale",
"s45l" => "Super Sale",
"s46l" => "Close Out",
"s47l" => "Weekly",
"s48l" => "Daily",
"s49l" => "Blue Light Special"
);
### end sale_codes
#
############ The End ############
1;

Database Operation Codes: Located in select_codes.pl file ← These can be edited in the Admin Product Console!

Note: You should only edit what the user will see, like Select Titles and Select Values !

##### Database Operation Search Codes
#
# Search Hash Names
##
@codenames = ("price_codes", "category_codes", "scategory_codes", "arrival_codes", "sale_codes");
##
# Above the Drop down - the Displayed Search Title Names
@selecttitles = ("SHOP BY PRICE RANGE", "GIFTS & COLLECTIBLES", "HOLIDAY GIFT IDEAS", "NEW ARRIVALS", "SALE ITEMS");
##
# Search Select Drop down field names
@selectnames = ("price_code", "category_code", "scategory_code", "arrival_code", "sale_code");
##
# Select Drop down Selected - Category displayed Names
@selectvalues = ("Price Range", "Category", "Holidays", "Arrival Date", "Sales");
##
#
############ End Select Codes ############
1;