wp_ebay_orders
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) unsigned | NO |
| order_id | varchar(128) | YES |
| date_created | datetime | YES |
| total | float | YES |
| status | varchar(50) | YES |
| post_id | int(11) | YES |
| items | text | YES |
| details | text | YES |
| history | text | YES |
| buyer_userid | varchar(255) | YES |
| buyer_name | varchar(255) | YES |
| buyer_email | varchar(255) | YES |
| eBayPaymentStatus | varchar(50) | YES |
| CheckoutStatus | varchar(50) | YES |
| ShippingService | varchar(75) | YES |
| PaymentMethod | varchar(50) | YES |
| ShippingAddress_City | varchar(50) | YES |
| CompleteStatus | varchar(50) | YES |
| LastTimeModified | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_ebay_orders` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `order_id` varchar(128) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `total` float DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `post_id` int(11) DEFAULT NULL, `items` text, `details` text, `history` text, `buyer_userid` varchar(255) DEFAULT NULL, `buyer_name` varchar(255) DEFAULT NULL, `buyer_email` varchar(255) DEFAULT NULL, `eBayPaymentStatus` varchar(50) DEFAULT NULL, `CheckoutStatus` varchar(50) DEFAULT NULL, `ShippingService` varchar(75) DEFAULT NULL, `PaymentMethod` varchar(50) DEFAULT NULL, `ShippingAddress_City` varchar(50) DEFAULT NULL, `CompleteStatus` varchar(50) DEFAULT NULL, `LastTimeModified` datetime DEFAULT NULL, PRIMARY KEY (`id`) );
Safe to delete?
If you have uninstalled WP-Lister Lite for eBay, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_ebay_orders`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-Lister Lite for eBay