SKU Search and Database Update Webpage
Budget: $30 – $250 USD
I need a simple webpage where I can search for a sku in my sql database ,select it ,then update its data on that page
So lets say I have a product sku called LUX01768N that I want to update
I would go to my website URL.The URL would need to be password protected requiring a user and password to continue. Once logged on I envision I would enter ‘LUX01768N’ in a search box and hit enter. The SKU would search a sql table that has all the data. Its results would display
The SKU LUX01768N (Not Editable) and its Fields to be updated.. Currently these are the fields below
The database table already exist.It is called . dbo_mip-product-combined-coins I will grant you user permissions to that table
Some fields need a multiple choice answer Others just answer. Example [Mint Location] can be Denver, San Francisco, Philadelphia, New Orleans, Carson City, WestPoint .The bullets are the fields that need dropdown, Most need an other option The ~ shows what fields need multiple choice
Certification
~Un-Certified
~Certified
~Other
Circulated/Uncirculated
~Circulated
~Uncirculated
~Unknown
~Other
Year
Strike Type
~Business
~Circulation
~Special Mint
Mint Location
~Carson City
~Denver
~New Orleans
~Philadelphia
~San Francisco
~WestPoint
~Other
Fineness
~40%
~80%
~90%
~925%
~999%
~Other
KM Number
Denomination
~½ Penny
~Penny
~3 Cents
~Nickel
~Dime
~Quarter
~Half $1
~$1
~$2 ½
~$5
~$10
~$20
~$50
~$100
~Other
Grade
~Fair
~Good
~Very Good
~Fine
~VF
~XF
~AU
~MS/PF 60
~MS/PF 61
~MS/PF 62
~MS/PF 63
~MS/PF 64
~MS/PF 65
~MS/PF 66
~MS/PF 67
~MS/PF 68
~MS/PF 69
~MS/PF 70
~Other
Composition
~Copper
~Gold
~Silver
~Platinum
~Palladium
~Other
Variety
Certification Number
Country/Region of Manufacture
~USA
~Mexico
~Britain
~France
~China
California Prop 65 Warning
Coin
~Indian Head
~Wheat
~Lincoln
~V Nickel
~Buffalo
~Jefferson
~Barber
~Mercury
~Roosevelt
~Washington
~Walking Liberty
~Franklin
~Morgan
~Peace
~Eisenhower
~American Eagle
Features
Face Value
GradingService
~ICG
~NGS
~PCGS
~Other
Diameter
ProductNotes
After I updated the data the
There should be two options
update and continue and update and return to search
That's it very simple
So lets say I have a product sku called LUX01768N that I want to update
I would go to my website URL.The URL would need to be password protected requiring a user and password to continue. Once logged on I envision I would enter ‘LUX01768N’ in a search box and hit enter. The SKU would search a sql table that has all the data. Its results would display
The SKU LUX01768N (Not Editable) and its Fields to be updated.. Currently these are the fields below
The database table already exist.It is called . dbo_mip-product-combined-coins I will grant you user permissions to that table
Some fields need a multiple choice answer Others just answer. Example [Mint Location] can be Denver, San Francisco, Philadelphia, New Orleans, Carson City, WestPoint .The bullets are the fields that need dropdown, Most need an other option The ~ shows what fields need multiple choice
Certification
~Un-Certified
~Certified
~Other
Circulated/Uncirculated
~Circulated
~Uncirculated
~Unknown
~Other
Year
Strike Type
~Business
~Circulation
~Special Mint
Mint Location
~Carson City
~Denver
~New Orleans
~Philadelphia
~San Francisco
~WestPoint
~Other
Fineness
~40%
~80%
~90%
~925%
~999%
~Other
KM Number
Denomination
~½ Penny
~Penny
~3 Cents
~Nickel
~Dime
~Quarter
~Half $1
~$1
~$2 ½
~$5
~$10
~$20
~$50
~$100
~Other
Grade
~Fair
~Good
~Very Good
~Fine
~VF
~XF
~AU
~MS/PF 60
~MS/PF 61
~MS/PF 62
~MS/PF 63
~MS/PF 64
~MS/PF 65
~MS/PF 66
~MS/PF 67
~MS/PF 68
~MS/PF 69
~MS/PF 70
~Other
Composition
~Copper
~Gold
~Silver
~Platinum
~Palladium
~Other
Variety
Certification Number
Country/Region of Manufacture
~USA
~Mexico
~Britain
~France
~China
California Prop 65 Warning
Coin
~Indian Head
~Wheat
~Lincoln
~V Nickel
~Buffalo
~Jefferson
~Barber
~Mercury
~Roosevelt
~Washington
~Walking Liberty
~Franklin
~Morgan
~Peace
~Eisenhower
~American Eagle
Features
Face Value
GradingService
~ICG
~NGS
~PCGS
~Other
Diameter
ProductNotes
After I updated the data the
There should be two options
update and continue and update and return to search
That's it very simple