wp_amazon_fulfillment_feed_items
StaticStores amazon fulfillment feed items data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| feed_id | int(11) | NO |
| order_id | varchar(64) | NO |
| order_item_id | varchar(64) | NO |
| quantity | int(11) | NO |
| ship_date | datetime | NO |
| carrier_code | varchar(64) | NO |
| carrier_name | varchar(128) | NO |
| tracking_number | varchar(128) | NO |
| ship_method | varchar(128) | NO |
| ship_from_address_name | varchar(255) | NO |
| ship_from_address_line1 | varchar(255) | NO |
| ship_from_address_line2 | varchar(255) | NO |
| ship_from_address_city | varchar(128) | NO |
| ship_from_address_state | varchar(128) | NO |
| ship_from_address_postal | varchar(64) | NO |
| ship_from_address_country | varchar(128) | NO |
| date_added | datetime | NO |
CREATE TABLE Statement
CREATE TABLE `wp_amazon_fulfillment_feed_items` ( `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `feed_id` int(11) NOT NULL, `order_id` varchar(64) NOT NULL, `order_item_id` varchar(64) NOT NULL, `quantity` int(11) NOT NULL, `ship_date` datetime NOT NULL, `carrier_code` varchar(64) NOT NULL, `carrier_name` varchar(128) NOT NULL, `tracking_number` varchar(128) NOT NULL, `ship_method` varchar(128) NOT NULL, `ship_from_address_name` varchar(255) NOT NULL, `ship_from_address_line1` varchar(255) NOT NULL, `ship_from_address_line2` varchar(255) NOT NULL, `ship_from_address_city` varchar(128) NOT NULL, `ship_from_address_state` varchar(128) NOT NULL, `ship_from_address_postal` varchar(64) NOT NULL, `ship_from_address_country` varchar(128) NOT NULL, `date_added` datetime NOT NULL );
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_fulfillment_feed_items`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-Lister Lite for Amazon