modyfikujesz tabelę
ps_product attribute
przykładowy kod
INSERT INTO `ps_product_attribute` (`id_product_attribute`, `id_product`, `reference`, `supplier_reference`, `location`, `ean13`, `upc`, `wholesale_price`, `price`, `ecotax`, `quantity`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) VALUES (46, 33, '', '', '', '', NULL, 0.000000, 0.000000, 0.000000, 10, 0.000000, 0.00, 1, 1, '2013-07-17'); INSERT INTO `ps_product_attribute` (`id_product_attribute`, `id_product`, `reference`, `supplier_reference`, `location`, `ean13`, `upc`, `wholesale_price`, `price`, `ecotax`, `quantity`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) VALUES (47, 33, '', '', '', '', NULL, 0.000000, 20.000000, 0.000000, 10, 0.000000, 0.00, 0, 1, '2013-07-17'); INSERT INTO `ps_product_attribute` (`id_product_attribute`, `id_product`, `reference`, `supplier_reference`, `location`, `ean13`, `upc`, `wholesale_price`, `price`, `ecotax`, `quantity`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) VALUES (48, 33, '', '', '', '', NULL, 0.000000, 40.000000, 0.000000, 10, 0.000000, 0.00, 0, 1, '2013-07-17'); INSERT INTO `ps_product_attribute` (`id_product_attribute`, `id_product`, `reference`, `supplier_reference`, `location`, `ean13`, `upc`, `wholesale_price`, `price`, `ecotax`, `quantity`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) VALUES (49, 33, '', '', '', '', NULL, 0.000000, 190.000000, 0.000000, 10, 0.000000, 0.00, 0, 1, '2013-07-17'); INSERT INTO `ps_product_attribute` (`id_product_attribute`, `id_product`, `reference`, `supplier_reference`, `location`, `ean13`, `upc`, `wholesale_price`, `price`, `ecotax`, `quantity`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) VALUES (577, 33, '', '', '', '', NULL, 0.000000, 260.000000, 0.000000, 10, 0.000000, 0.00, 0, 1, '2013-07-17'); INSERT INTO `ps_product_attribute` (`id_product_attribute`, `id_product`, `reference`, `supplier_reference`, `location`, `ean13`, `upc`, `wholesale_price`, `price`, `ecotax`, `quantity`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) VALUES (578, 33, '', '', '', '', NULL, 0.000000, 290.000000, 0.000000, 10, 0.000000, 0.00, 0, 1, '2013-07-17'); INSERT INTO `ps_product_attribute` (`id_product_attribute`, `id_product`, `reference`, `supplier_reference`, `location`, `ean13`, `upc`, `wholesale_price`, `price`, `ecotax`, `quantity`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) VALUES (579, 33, '', '', '', '', NULL, 0.000000, 360.000000, 0.000000, 10, 0.000000, 0.00, 0, 1, '2013-07-17');
następnie tabelę ps_product_attribiute_combination
INSERT INTO `ps_product_attribute_combination` (`id_attribute`, `id_product_attribute`) VALUES (11, 46);
jeśli są zdjęcia to również tabelę ps_product_attribute_image
oczywiście u Ciebie będzie inne id produktu i inne id atrybutu