Sale, Webstore, Wholeale, and Quotation Database Creation/Modification for Electronics Parts Business, Web Retail Store, Wholesale Store, With Web Intergrate Product Search Database - repost 2

Accounting, Web Retail Store, Wholesale Store, Product Lookup, Database Format: Microsoft Access Design: Clean Web Layout Functionality: Web Based Store Linkup, Set Pricing and Credit Terms. REPORTS Product Reporting Product Shrinkage, Stock on Hand, Slow Movers, Average Days on Hand Based on Historical Sales, Allocated, Backorders. Sales: Invoice, Top Sellers, GP Analysis, Daily, Monthly, Yearly, Set Date Range Customers: Statements, Top Customers, Overdue, Customer List, Shipping Label. Filterable Lists Customer List, Shippers List, Suppliers List, Product List, Packaging List, Barcode (Include SKU, Barcode), Description Label, Wholesale Price List (Wholesale Price and Margin based on Retail Price), Retail Price List, Active Orders, Back Orders. FORMS Customer Details, Shippers Details, Suppliers Details, Product Details, Packaging Details, Purchase Order. MACROS Auto Generate Pick List Auto Generate Customer Shipping Label to Designated Printer Auto Contact Shipping Company Auto Email Customer Confirmation of Order Dispatch to Contact Email ice to Accounts EmaiAuto Email Customer Invol When Receiving Stock Prompt for Generation of Barcode and Description Labels for Quantity Received Selected Products. Sales and Tracking, Sales Reporting, Pick List Generation SUGGESTED TABLES I suggest these tables as I believe this will be an easy way to lookup the stock. If you think that is will be better to manage the stock another way I am happy to go with your professional advice. Categories ID, Category, Description Sub Categories (Relate to Each Category) ID, Lookup: Category, Sub Category, Description Customer ID, Business Name, Contacts Name, Contacts Email, Contacts Landline, Contacts Mobile, Contacts Fax, Accounts Name, Accounts Email, Accounts Landline, Accounts Mobile, Accounts Fax, Ship Address, Billing Address, Website Employees ID, First Name, Last Name, Password, Pay Rate, Pay Type, Tax Free Threshold (Y/N), Super Rate (% of pay), Super Fund, Annual Sick Leave (0.03846 hours per hour worked OR 0.2923 hours per day worked), Holiday (0.076 per hour) Shrinkage ID, Lookup: SKU, Quantity, Reason, Received Invoice Number, Store Stock (Y/N) Port ID, Port Name, Lookup: Supplier ID (Caption: Freight Agent), Usual Days to Deliver Supplier Company, Contact, Address, Suburb, Sate/Province, Country, Receiving Currency, Post Code, Port, Website, Type (Freight Agent, Services, Packaging, Stock, Printing, Fitting), Email, Skype, WeChat, MSN, Preferred Payment Method ([Multiple Values]T.T, Western Union, PayPal) Port Inventory ID, Lookup: [login to view URL], Reorder Level, Target Level, Minimum Reorder Quantity, Received Quantity, On Order, Shrinkage, Shipped, Allocated, Backordered, Initial Level, On Hand, Available, Current Level, Below Target Level, Reorder Quantity, Lookup: [login to view URL] Packaging ID, Packaging SKU, Packaging Style (Plastic Retail Box, Cardboard Retail Box, Disposable Counter Display, Reusable Counter Display, Hangsell Bag with Header, Hangsell Bag no Header, Plastic Hangsell, Cardboard Hangsell), Packaging Description, Lookup: Supplier / Port, Ordered Separately (Y/N), Prompt For Barcode Generation (Y/N), Prompt For Description Generation(Y/N). Product ID, Lookup: Category, Lookup: Sub Category, SKU, Barcode, Description, Variant/Colour, Fitting required (Y/N), Retail Price Inc GST ($), Wholesale Price Ex GST ($), Landed Price Ex GST ($), (USD $) FOB Inc VAT, Discontinued (Y/N), Safety Certificate (Attachment), Inspection Certificate (Attachment), Picture 1 (Attachment), Picture 2 (Attachment), Long Description, Lookup: Packaging SKU, Lookup: SKU (Caption: Linked Stock), Lookup: [login to view URL] [Multiple Values] Compatible ID, Brand, Make, Model --------- I am happy to use a teplate, or another pice of ready made software which will give me all this functionality. I feel it is critically important for this to be adaptble as businesess needs change. ------------------