wp_amazon_listings
StaticStores amazon listings data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) unsigned | NO |
| asin | varchar(64) | YES |
| sku | varchar(64) | YES |
| listing_title | varchar(255) | YES |
| listing_type | varchar(255) | YES |
| date_created | datetime | YES |
| date_published | datetime | YES |
| price | float | YES |
| quantity | int(11) | YES |
| quantity_sold | int(11) | YES |
| status | varchar(50) | YES |
| details | text | YES |
| attributes | text | YES |
| history | text | YES |
| url | varchar(255) | YES |
| description | text | YES |
| post_id | int(11) | YES |
| profile_id | int(11) | YES |
| fees | float | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_amazon_listings` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `asin` varchar(64) DEFAULT NULL, `sku` varchar(64) DEFAULT NULL, `listing_title` varchar(255) DEFAULT NULL, `listing_type` varchar(255) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `date_published` datetime DEFAULT NULL, `price` float DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `quantity_sold` int(11) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `details` text, `attributes` text, `history` text, `url` varchar(255) DEFAULT NULL, `description` text, `post_id` int(11) DEFAULT NULL, `profile_id` int(11) DEFAULT NULL, `fees` float DEFAULT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET
Safe to delete?
If you have uninstalled WP-Lister Lite for Amazon, 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_amazon_listings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-Lister Lite for Amazon