add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `product` (
`product_id` int(11) NOT NULL,
`model` varchar(64) NOT NULL,
`sku` varchar(64) NOT NULL,
`grup_id` varchar(128) NOT NULL,
`quantity` int(4) NOT NULL DEFAULT 0,
`stock_status_id` int(11) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`manufacturer_id` int(11) NOT NULL,
`shipping` tinyint(1) NOT NULL DEFAULT 1,
`price` decimal(15,4) NOT NULL DEFAULT 0.0000,
`weight` decimal(15,8) NOT NULL DEFAULT 0.00000000,
`weight_class_id` int(11) NOT NULL DEFAULT 0,
`length` decimal(15,8) NOT NULL DEFAULT 0.00000000,
`width` decimal(15,8) NOT NULL DEFAULT 0.00000000,
`height` decimal(15,8) NOT NULL DEFAULT 0.00000000,
`length_class_id` int(11) NOT NULL DEFAULT 0,
`subtract` tinyint(1) NOT NULL DEFAULT 1,
`minimum` int(11) NOT NULL DEFAULT 1,
`sort_order` int(11) NOT NULL DEFAULT 0,
`status` tinyint(1) NOT NULL DEFAULT 0,
`viewed` int(5) NOT NULL DEFAULT 0,
`date_added` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `product` (`product_id`, `sku`, `model`, `grup_id`, `quantity`, `stock_status_id`, `image`, `manufacturer_id`, `shipping`, `price`, `weight`, `weight_class_id`, `length`, `width`, `height`, `length_class_id`, `subtract`, `minimum`, `sort_order`, `status`, `viewed`, `date_added`) VALUES
(30545, 'а2827', 'R850X023', '17594', 5267, 5, NULL, 15, 1, '0.0000', '0.00000000', 0, '0.00000000', '0.00000000', '0.00000000', 0, 0, 1, 0, 1, 2, '2022-08-31 22:54:50'),
(30546, 'а2828', 'R850X024', '17594', 3020, 5, NULL, 15, 1, '0.0000', '0.00000000', 0, '0.00000000', '0.00000000', '0.00000000', 0, 0, 1, 0, 1, 4, '2022-08-31 22:54:50');

CREATE TABLE `product_attribute` (
`product_id` int(11) NOT NULL,
`attribute_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`text` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Records: 2  Duplicates: 0  Warnings: 0
Records: 30  Duplicates: 0  Warnings: 0
Records: 30  Duplicates: 0  Warnings: 0
Records: 15  Duplicates: 0  Warnings: 0
Records: 15  Duplicates: 0  Warnings: 0
Records: 15  Duplicates: 0  Warnings: 0
Records: 15  Duplicates: 0  Warnings: 0