[protect ADMIN,[lookup db=prefs.db&lookinfield=PREF&value=ADMIN&returnfield=value],[lookup db=prefs.db&lookinfield=PREF&value=GROUPS&returnfield=value]] [SETMIMEHEADER name=Pragma&value=no-cache] [SETMIMEHEADER name=Expires&value=Thu, 01 Dec 1994 16:00:00 GMT] [SETMIMEHEADER name=Cache-Control&value=max-age=0] [!][include vars.inc][/!] [include body_tag.inc] [text]page_title=View Products[/text] [text]helpid=products_view[/text] [include banner.inc] [Text]SelectOne=No Graphic[/Text]
Show All Home Page Specials
SKU/Title/Description:

[text]success=T[/text] [!]---------------------------------------------------------------------[/!] [!] Decide which mode this page got called [/!] [!]---------------------------------------------------------------------[/!] [Showif [origAction]=New] [Text]action=Add[/Text] [/Showif] [Showif [origAction]=Edit] [hideif [action]=Delete] [Text]action=Update[/Text] [/hideif] [/Showif] [showif [action]=Add] [text]sku_found=F[/text] [search db=products.db&eqSKUdatarq=[url][__SKU][/url]] [showif [numfound]>0][text]sku_found=T[/text][text]success=F[/text] Product not Added!
SKU "[__sku]" already exists. Please back up and enter a different SKU.[/showif] [/search] [showif [__CANEMAIL]=F] [showif [__CANSHIP]=F] Product not Added!
Please back up and mark the product as Physical and/or Electronic. [text]sku_found=T[/text][text]success=F[/text] [/showif] [/showif] [hideif [sku_found]=T] [append db=products.db][hideif [include file=protection.inc&owner=]^A]OWNER=[url][uppercase][username][/uppercase][/url]&VISIBLE=F&[/hideif]SECTIONS=[search db=related.db&eqR_SKUdatarq=[url][sku][/url]&eqR_CTYPEdatarq=S][founditems][url][R_NAME][/url][/founditems][/search]&[formvariables name=__&exact=F][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables][/append] [showif [__BIG_PICTURE]=[SelectOne]] [replace db=products.db&eqSKUdatarq=[url][sku][/url]]BIG_PICTURE=[/replace] [/showif] [showif [__PICTURE]=[SelectOne]] [replace db=products.db&eqSKUdatarq=[url][sku][/url]]PICTURE=[/replace] [include update_option.inc] [/showif] Product Added
[include generate_page.inc] [commitdatabase db=products.db] [replace db=related.db&eqR_SKUdatarq=[url][sku][/url]]R_SKU=[url][__SKU][/url][/replace] [commitdatabase db=related.db] [text]find_one=T[/text] [/hideif] [/showif] [showif [action]=Update] [text]the_OWNER=[/text] [search db=products.db&eqSKUdatarq=[url][sku][/url]][founditems] [text]the_OWNER=[OWNER][/text] [/founditems][/search] [hideif [include file=protection.inc&owner=[url][the_OWNER][/url]]^N] [text]sku_found=F[/text] [search db=products.db&eqSKUdatarq=[url][__SKU][/url]] [hideif [url][sku][/url]=[url][__sku][/url]] [showif [numfound]>0][text]sku_found=T[/text][text]success=F[/text] Product not Updated!SKU "[__sku]" already exists. Please back up and enter a different SKU.[/showif] [/hideif] [/search] [showif [__CANEMAIL]=F] [showif [__CANSHIP]=F] Product not Updated!
Please back up and mark the product as Physical and/or Electronic. [text]sku_found=T[/text][text]success=F[/text] [/showif] [/showif] [hideif [sku_found]=T] [replace db=products.db&eqSKUdatarq=[url][sku][/url]][formvariables name=__&exact=F][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables][/replace] [showif [__BIG_PICTURE]=[SelectOne]] [replace db=products.db&eqSKUdatarq=[url][sku][/url]]BIG_PICTURE=[/replace] [/showif] [showif [__PICTURE]=[SelectOne]] [replace db=products.db&eqSKUdatarq=[url][sku][/url]]PICTURE=[/replace] [/showif] [include update_option.inc] [commitdatabase db=products.db] [replace db=related.db&eqR_SKUdatarq=[url][sku][/url]]R_SKU=[url][__SKU][/url][/replace] [commitdatabase db=related.db] Product Updated
[include generate_page.inc] [text]find_one=T[/text] [/hideif] [/hideif] [/showif] [showif [action]=Delete] [text]the_OWNER=[/text] [search db=products.db&eqSKUdatarq=[url][sku][/url]][founditems] [text]the_OWNER=[OWNER][/text] [/founditems][/search] [hideif [include file=protection.inc&owner=[url][the_OWNER][/url]]^N] [delete db=products.db&eqSKUdatarq=[url][sku][/url]] Product Deleted
[commitdatabase db=products.db] [delete db=related.db&eqR_SKUdatarq=[url][sku][/url]] [commitdatabase db=related.db] [text]success=T[/text] [/hideif] [/showif] [!]---------------------------------------------------------------------[/!] [!] If user hit add option or delete option, go back to edit [/!] [!]---------------------------------------------------------------------[/!] [Text]GoBackToEdit=[/Text] [formvariables name=DELOPTION_&exact=f] [Text]GoBackToEdit=T[/Text] [/formvariables] [formvariables name=ADDOPTION_&exact=f] [Text]GoBackToEdit=T[/Text] [/formvariables] [Showif [GoBackToEdit]=T] [redirect products.tpl?sku=[sku]&action=Edit] [/Showif] [!]---------------------------------------------------------------------[/!] [!] If user wants to select category... [/!] [!]---------------------------------------------------------------------[/!] [formvariables name=Select_&exact=f] [Showif [name]=Select_Category] [redirect pick_cat.tpl?sku=[sku]&callerurl=[ThisURL]&currCat=[currCat]] [/Showif] [/formvariables] [!]---------------------------------------------------------------------[/!] [!] If file upload was requested... [/!] [!]---------------------------------------------------------------------[/!] [formvariables name=Upload_&exact=f] [Showif [name]=Upload_Graphic] [redirect upload_file.tpl?graphicpurpose=Product&sku=[sku]&callerurl=[ThisURL]] [/Showif] [/formvariables] [!]---------------------------------------------------------------------[/!] [!] If Simple data update - send them back to edit screen [/!] [!]---------------------------------------------------------------------[/!] [showif [action]=Update] [redirect products.tpl?action=Edit&sku=[url][sku][/url]] [/showif] [Showif [sortby]=[raw][sortby][/raw]] [Text]sortBy=SKU[/Text] [Text]sortDir=as[/Text] [/Showif] [Showif [startat]=[raw][startat][/raw]] [Text]startat=1[/Text] [/Showif] [search db=products.db&max=15&startat=[startat]&[sortBy]sort=1&[sortBy]type=[sortType]&[sortBy]sdir=[sortDir]&[formvariables name=--&exact=f][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables][showif [find_one]=T]eqSKUdatarq=[url][__sku][/url][/showif]] [hideif [success]=F] [Showif [--WAP_ENABLEDdata]=[raw][--WAP_ENABLEDdata][/raw]] [Showif [--H_P_SPECIALdata]=[raw][--H_P_SPECIALdata][/raw]] [Showif [--woGROUP1data]=[raw][--woGROUP1data][/raw]] [Showif [--neSKUdata]=[raw][--neSKUdata][/raw]] [Text]--neSKUdata=find_all[/Text] [Text]sortDir=de[/Text] [/showif] [showif [sortdir]=[raw][sortdir][/raw]] [Text]sortDir=as[/Text] [/showif] [/showif] [/showif] [/showif] [hideif [--woGROUP1data]=[raw][--woGROUP1data][/raw]] [showif [sortdir]=[raw][sortdir][/raw]] [Text]sortDir=as[/Text] [/showif] [/hideif] [hideif [--H_P_SPECIALdata]=[raw][--H_P_SPECIALdata][/raw]] [showif [sortdir]=[raw][sortdir][/raw]] [Text]sortDir=as[/Text] [/showif] [/hideif] [hideif [--WAP_ENABLEDdata]=[raw][--WAP_ENABLEDdata][/raw]] [showif [sortdir]=[raw][sortdir][/raw]] [Text]sortDir=as[/Text] [/showif] [/hideif] [showif [numfound]=0] [/showif] [founditems] [!]---------------------------------------------------------------------[/!] [!] If user change currency from Merchant page, it will update [/!] [!] automatically. WC [/!] [!]---------------------------------------------------------------------[/!] [search db=prefs.db&eqPREFdatarq=CURRENCY] [founditems] [text show=f]Currency=[value][/text][/founditems] [/search] [/founditems]
Click the SKU to edit the product. [showif [numfound]>0] [numfound] products found! [/showif]
SKU[showif [sortBy]=SKU][/Showif] Title[showif [sortBy]=TITLE][/Showif] Price[showif [sortBy]=PRICE][/Showif] Home Page Special[showif [sortBy]=H_P_SPECIAL][/Showif] Cell Phone Special[showif [sortBy]=WAP_ENABLED][/Showif]SKU[showif [sortBy]=SKU][/Showif] Title[showif [sortBy]=TITLE][/Showif] Price[showif [sortBy]=PRICE][/Showif] Home Page Special[showif [sortBy]=H_P_SPECIAL][/Showif] Cell Phone Special[showif [sortBy]=WAP_ENABLED][/Showif]SKU[showif [sortBy]=SKU][/Showif] Title[showif [sortBy]=TITLE][/Showif] Price[showif [sortBy]=PRICE][/Showif] Home Page Special[showif [sortBy]=H_P_SPECIAL][/Showif] Cell Phone Special[showif [sortBy]=WAP_ENABLED][/Showif]SKU[showif [sortBy]=SKU][/Showif] Title[showif [sortBy]=TITLE][/Showif] Price[showif [sortBy]=PRICE][/Showif] Home Page Special[showif [sortBy]=H_P_SPECIAL][/Showif] Cell Phone Special[showif [sortBy]=WAP_ENABLED][/Showif]
No products found that match your search request.
[hideif [include file=protection.inc&owner=[url][OWNER][/url]]^N] [sku] [/hideif] [showif [include file=protection.inc&owner=[url][OWNER][/url]]^N] [sku] [/showif] [title][Currency][format thousands .2f][price][/format] [showif [h_p_special]=T]Yes[/showif][hideif [h_p_special]=T]No[/hideif] [showif [wap_enabled]=F]No[/showif][hideif [wap_enabled]=F]Yes[/hideif]
[/hideif] [shownext position=end&max=1]
[formvariables name=--&exact=f] [/formvariables] [formvariables name=sort&exact=f] [/formvariables] [Math show=F]Next=[end]-[start]+1[/Math] [showif [Next]<10] [/showif] [hideif [Next]<10] [/hideif]
[/shownext] [/search]