| Chapter |
Summary |
Links |
Tables |
| 1 -
Introduction |
eCommerce Architecture |
|
|
| 1.1
Technology |
Technical Overview |
|
|
| 1.2
Database |
Database Design |
|
|
| 1.3
Editor |
Generic Cohesion Editor |
|
|
| 1.4
Reports |
Generic Query Reporter |
|
|
| 1.5
Caching |
Advanced Record Level Cache |
|
|
| 1.6
Security |
Ground-Up Access Controls |
|
|
| 2 -
Directory |
Contact Directory |
|
|
3 |
| 2.1 Reports |
|
|
|
| 2.2 Tables |
|
|
|
| 2.2.1
Addresses |
Contact Address Records |
|
|
| 2.2.2
Contacts |
Contact Directory Records |
|
|
| 2.2.3
Phones |
Contact Phone Records |
|
|
 |
| 3 -
Orders |
Order Fulfillment Manager |
|
6 |
2 |
| 3.1 Reports |
|
|
|
| 3.1.1
Daily |
Daily Order Vitals |
|
|
| 3.1.2
Payment |
Pending Payments on Processed Orders |
|
|
| 3.1.3
Sessions |
Current Site Activity |
|
|
| 3.2 Tools |
|
|
|
| 3.2.1
Fulfillment |
Automatically Advance Orders |
|
|
| 3.2.2
Pending |
Pending Order Manager |
|
|
| 3.2.3
Returns |
Return Requisition Manager |
|
|
| 3.3 Tables |
|
|
|
| 3.3.1
Orders |
Customer Order Records |
|
|
| 3.3.2
Returns |
Item Return (RMA) Records |
|
|
| 4 -
Profit |
Sales Profit History |
|
3 |
|
| 4.1 Reports |
|
|
|
| 4.1.1
Regions |
Orders by Geographic Regions |
|
|
| 4.1.2
Sales Tax |
California Sales Tax |
|
|
| 4.1.3
Volume |
Products Shipped Revenue |
|
|
 |
| 5 -
Inventory |
Inventory Manager |
|
3 |
1 |
| 5.1 Tools |
|
|
|
| 5.1.1
Inventory |
Adjust Current Inventory |
|
|
| 5.1.2
Labels |
Print Bar Coded Stock Labels |
|
|
| 5.1.3
Order Levels |
Order Stocking Levels |
|
|
| 5.2 Tables |
|
|
|
| 5.2.1
Warehouses |
Inventory Locations |
|
|
| 6 -
Purchasing |
Purchasing/Receiving Manager |
|
3 |
2 |
| 6.1 Tools |
|
|
|
| 6.1.1
Drop Ships |
Create Drop Ship Requisitions |
|
|
| 6.1.2
Purchasing |
Issues Purchase Orders |
|
|
| 6.1.3
Receiving |
Receive Inventory |
|
|
| 6.2 Tables |
|
|
|
| 6.2.1
Requisition Items |
|
|
|
| 6.2.2
Requisitions |
Purchase Order Requisitions |
|
|
| 7 -
Suppliers |
Supplier Profile Manager |
|
5 |
2 |
| 7.1 Reports |
|
|
|
| 7.1.1
Contacts |
Supplier Contact Directory |
|
|
| 7.2 Tools |
|
|
|
| 7.2.1
Exporter |
Supplier Catalog Export |
|
|
| 7.2.2
Importer |
Import Supplier Catalogs |
|
|
| 7.2.3
Nuke!!! |
Remove Obsolete Catalog Items |
|
|
| 7.2.4
Pictures |
Supplier Picture Loader |
|
|
| 7.3 Tables |
|
|
|
| 7.3.1
Brands |
Product Suppliers/Vendors |
|
|
| 7.3.2
Suppliers |
Product Supplier Records |
|
|
 |
| 8 -
Catalog |
Catalog Manager |
|
4 |
2 |
| 8.1 Reports |
|
|
|
| 8.1.1
Catalog |
View Online Catalog |
|
|
| 8.1.2
Pictures |
Missing Item Pictures |
|
|
| 8.2 Tools |
|
|
|
| 8.2.1
Kits |
Catalog Item Kit Manager |
|
|
| 8.2.2
Organize |
Catalog Item Organizer |
|
|
| 8.3 Tables |
|
|
|
| 8.3.1
Items |
Available Catalog Items |
|
|
| 8.3.2
Lines |
Product Line Categories |
|
|
| 9 -
Pricing |
Catalog Pricing Manager |
|
4 |
3 |
| 9.1 Reports |
|
|
|
| 9.1.1
Auto Price |
|
|
|
| 9.1.2
Profit |
Items Sorted by Profit |
|
|
| 9.2 Tools |
|
|
|
| 9.2.1
Margins |
Brand Profile Pricing |
|
|
| 9.2.2
Pricing |
Catalog Pricing |
|
|
| 9.3 Tables |
|
|
|
| 9.3.1
Profiles |
|
|
|
| 9.3.2
Rules |
|
|
|
| 9.3.3
Sales |
|
|
|
| 10 -
Variants |
Catalog Grouping Manager |
|
3 |
|
| 10.1 Reports |
|
|
|
| 10.1.1
Variants |
Variant Validation Checker |
|
|
| 10.2 Tools |
|
|
|
| 10.2.1
Explode |
Duplicates an Item Into Related Groups |
|
|
| 10.2.2
Groups |
Group Related Items |
|
|
 |
| 11 -
Shipping |
Shipping Services Manager |
|
6 |
7 |
| 11.1 Reports |
|
|
|
| 11.1.1
Activity |
Tracking Packages In Transit |
|
|
| 11.1.2
Addresses |
Shipping Address Verification |
|
|
| 11.1.3
Compare |
Shipping History Comparison |
|
|
| 11.1.4
Expenses |
Shipping Expenses |
|
|
| 11.2 Tools |
|
|
|
| 11.2.1
Quote |
Quote Shipping Charges |
|
|
| 11.2.2
Tracking |
Track Packages |
|
|
| 11.3 Tables |
|
|
|
| 11.3.1
Boxes |
Standard Shipping Box Records |
|
|
| 11.3.2
Carriers |
Shipping Carrier Profile Records |
|
|
| 11.3.3
Dazzles |
Dazzle Terminal Package Records |
|
|
| 11.3.4
Methods |
Shipping Method Records |
|
|
| 11.3.5
Packages |
Package Tracking Number Records |
|
|
| 11.3.6
World Ships |
UPS Terminal Package Records |
|
|
| 11.3.7
Zones |
Ground Freight Zone Records |
|
|
 |
| 12 -
Commerce |
Electronic Commerce |
|
4 |
4 |
| 12.1 Reports |
|
|
|
| 12.1.1
Processed |
Revenue Received |
|
|
| 12.2 Tools |
|
|
|
| 12.2.1
Payments |
Record Payments Manually |
|
|
| 12.2.2
Pending |
Pending Transactions |
|
|
| 12.2.3
Terminal |
Payment Processing Terminal |
|
|
| 12.3 Tables |
|
|
|
| 12.3.1
Chargebacks |
Chargeback Tracking Records |
|
|
| 12.3.2
Credit Cards |
Customer Credit Cards |
|
|
| 12.3.3
Merchants |
Merchant Accounts |
|
|
| 12.3.4
Payments |
Payment Transaction Records |
|
|
 |
| 13 -
Customers |
Customer Relationship Manager |
|
3 |
1 |
| 13.1 Reports |
|
|
|
| 13.1.1
Customer |
Customer Profile |
|
|
| 13.1.2
History |
Call Log History |
|
|
| 13.1.3
Pending |
Customer Scheduled Followups |
|
|
| 13.2 Tables |
|
|
|
| 13.2.1
Logs |
Contact Call Log Records |
|
|
 |
| 14 -
Amazon |
Amazon Interface Manager |
|
1 |
5 |
| 14.1 Reports |
|
|
|
| 14.1.1
Documents |
Amazon Document Queue |
|
|
| 14.2 Interfaces |
|
|
|
| 14.3 Tables |
|
|
|
| 14.3.1
Definitions |
Data Attribute Schema Mapping |
|
|
| 14.3.2
Reports |
Amazon Generated Report Records |
|
|
| 14.3.3
Shadow Items |
Amazon Item Sync Detail Record |
|
|
| 14.3.4
Shadow Orders |
Amazon Order Sync Detail Record |
|
|
| 14.3.5
Uploads |
Pending Uploads Awaiting Report ID |
|
|
| 15 -
Auctions |
Auction Interface Manager |
|
10 |
12 |
| 15.1 Reports |
|
|
|
| 15.1.1
Account |
Account Summary, Auth & Auth |
|
|
| 15.1.2
Categories |
Listing Category to Catalog Lines |
|
|
| 15.1.3
Profit |
Auction Net Profit |
|
|
| 15.1.4
Transactions |
Completed Auction Orders |
|
|
| 15.2 Tools |
|
|
|
| 15.2.1
Disputes |
Non Paying Bidder Disputes |
|
|
| 15.2.2
Scheduler |
Listing Submission Scheduler |
|
|
| 15.3 Monitor |
|
|
|
| 15.3.1
Listings |
Active/Cancelled Listings |
|
|
| 15.3.2
Pending |
Pending Listings Queue |
|
|
| 15.3.3
Revisions |
Pending Revision Queue |
|
|
| 15.3.4
Usage |
Complete API Call Logging |
|
|
| 15.4 Tables |
|
|
|
| 15.4.1
Accounts |
eBay Account Profile Record |
|
|
| 15.4.2
Api Calls |
API Call Tracking Record |
|
|
| 15.4.3
Api Errors |
API Call Error Record |
|
|
| 15.4.4
Disputes |
Bidder Dispute Records |
|
|
| 15.4.5
Listings |
Listing Shadow Records |
|
|
| 15.4.6
Order Payments |
|
|
|
| 15.4.7
Products |
Auction Listing Profile Records |
|
|
| 15.4.8
Shipping Services |
Shipping Method Mapping Records |
|
|
| 15.4.9
Store Templates |
|
|
|
| 15.4.10
Templates |
Listing Type Profile Records |
|
|
| 15.4.11
Transactions |
Auction Order Shadow Records |
|
|
| 15.4.12
Users |
Bidder User Name Records |
|
|
| 16 -
Channels |
Sales Channels Manager |
|
1 |
3 |
| 16.1 Reports |
|
|
|
| 16.1.1
Feeds |
Channel Feeds Summary |
|
|
| 16.2 Tables |
|
|
|
| 16.2.1
Aliases |
|
|
|
| 16.2.2
Feeds |
Feed Profile Records |
|
|
| 16.2.3
Filters |
|
|
|