Akina,
в таблице "ven_jshopping_products" 1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
CREATE TABLE IF NOT EXISTS `ven_jshopping_products` (
`product_id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL,
`product_ean` varchar(64) NOT NULL,
`product_quantity` decimal(12,2) NOT NULL,
`unlimited` tinyint(1) NOT NULL,
`product_availability` varchar(1) NOT NULL,
`product_date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modify` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`product_publish` tinyint(1) NOT NULL,
`product_tax_id` tinyint(3) NOT NULL,
`currency_id` int(4) NOT NULL,
`product_template` varchar(64) NOT NULL DEFAULT 'default',
`product_url` varchar(255) NOT NULL,
`product_old_price` decimal(14,4) NOT NULL,
`product_buy_price` decimal(14,4) NOT NULL,
`product_price` decimal(18,6) NOT NULL,
`min_price` decimal(12,2) NOT NULL,
`different_prices` tinyint(1) NOT NULL,
`product_weight` decimal(14,4) NOT NULL,
`image` varchar(255) NOT NULL,
`product_manufacturer_id` int(11) NOT NULL,
`product_is_add_price` tinyint(1) NOT NULL,
`add_price_unit_id` int(3) NOT NULL,
`average_rating` float(4,2) NOT NULL,
`reviews_count` int(11) NOT NULL,
`delivery_times_id` int(4) NOT NULL,
`hits` int(11) NOT NULL,
`weight_volume_units` decimal(14,4) NOT NULL,
`basic_price_unit_id` int(3) NOT NULL,
`label_id` int(11) NOT NULL,
`vendor_id` int(11) NOT NULL,
`access` int(3) NOT NULL DEFAULT '1',
`name_en-GB` varchar(255) NOT NULL,
`alias_en-GB` varchar(255) NOT NULL,
`short_description_en-GB` text NOT NULL,
`description_en-GB` text NOT NULL,
`meta_title_en-GB` varchar(255) NOT NULL,
`meta_description_en-GB` text NOT NULL,
`meta_keyword_en-GB` text NOT NULL,
`name_ru-RU` varchar(255) NOT NULL,
`alias_ru-RU` varchar(255) NOT NULL,
`short_description_ru-RU` text NOT NULL,
`description_ru-RU` text NOT NULL,
`meta_title_ru-RU` varchar(255) NOT NULL,
`meta_description_ru-RU` text NOT NULL,
`meta_keyword_ru-RU` text NOT NULL,
`extra_field_1` text NOT NULL,
`extra_field_2` text NOT NULL,
`extra_field_3` text NOT NULL,
`extra_field_4` text NOT NULL,
`extra_field_5` text NOT NULL,
`extra_field_7` text NOT NULL,
`extra_field_8` text NOT NULL,
`extra_field_9` text NOT NULL,
`extra_field_10` text NOT NULL,
`extra_field_11` text NOT NULL,
`extra_field_12` text NOT NULL,
`extra_field_13` text NOT NULL,
`extra_field_14` text NOT NULL,
`extra_field_15` text NOT NULL,
`extra_field_16` text NOT NULL,
`extra_field_17` text NOT NULL,
`extra_field_18` text NOT NULL,
`extra_field_19` text NOT NULL,
`extra_field_20` text NOT NULL,
`extra_field_21` text NOT NULL,
`extra_field_22` text NOT NULL,
`extra_field_23` text NOT NULL,
`extra_field_24` text NOT NULL,
`extra_field_25` varchar(100) NOT NULL,
`extra_field_26` varchar(100) NOT NULL,
`extra_field_27` varchar(100) NOT NULL,
`extra_field_28` varchar(100) NOT NULL,
`extra_field_29` varchar(100) NOT NULL,
`extra_field_30` varchar(100) NOT NULL,
`extra_field_31` varchar(100) NOT NULL,
`extra_field_32` varchar(100) NOT NULL,
`extra_field_33` varchar(100) NOT NULL,
`extra_field_34` varchar(100) NOT NULL,
`extra_field_35` varchar(100) NOT NULL,
`extra_field_36` varchar(100) NOT NULL,
`extra_field_37` varchar(100) NOT NULL,
`extra_field_38` varchar(100) NOT NULL,
`extra_field_39` varchar(100) NOT NULL,
`extra_field_40` varchar(100) NOT NULL,
`extra_field_41` varchar(100) NOT NULL,
`extra_field_42` varchar(100) NOT NULL,
`extra_field_43` varchar(100) NOT NULL,
`extra_field_44` varchar(100) NOT NULL,
`extra_field_45` varchar(100) NOT NULL,
`extra_field_46` varchar(100) NOT NULL,
`extra_field_47` varchar(100) NOT NULL,
`extra_field_48` varchar(100) NOT NULL,
`extra_field_49` varchar(100) NOT NULL,
`extra_field_50` varchar(100) NOT NULL,
PRIMARY KEY (`product_id`),
KEY `product_manufacturer_id` (`product_manufacturer_id`),
KEY `parent_id` (`parent_id`),
KEY `product_ean` (`product_ean`),
KEY `unlimited` (`unlimited`),
KEY `product_publish` (`product_publish`),
KEY `product_tax_id` (`product_tax_id`),
KEY `currency_id` (`currency_id`),
KEY `product_price` (`product_price`),
KEY `min_price` (`min_price`),
KEY `add_price_unit_id` (`add_price_unit_id`),
KEY `average_rating` (`average_rating`),
KEY `reviews_count` (`reviews_count`),
KEY `delivery_times_id` (`delivery_times_id`),
KEY `hits` (`hits`),
KEY `basic_price_unit_id` (`basic_price_unit_id`),
KEY `label_id` (`label_id`),
KEY `vendor_id` (`vendor_id`),
KEY `access` (`access`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=71339 ;
есть строка product_ean в таблице "ven_jshopping_products", в которую записывается коллекция товара, допустим название Adagio. Условно product_id этого товара 447. Есть и другие товары той же коллекции (Adagio), c product_id 448,449,450 и т.д.
И далее в таблице ven_jshopping_products_relations
1.
2.
3.
4.
5.
6.
7.
8.
9.
CREATE TABLE IF NOT EXISTS `ven_jshopping_products_relations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`product_related_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`,`product_related_id`),
KEY `product_id_2` (`product_id`),
KEY `product_related_id` (`product_related_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19999 ;
Записываю по такому запросу, в ручную на каждый product_id - product_related_id (сопутствующие товары по коллекции, условно пример с того же "Adagio") как тут:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
INSERT INTO `ven_jshopping_products_relations` (`id`, `product_id`, `product_related_id`) VALUES
(19909, 447, 448),
(19910, 447, 449),
(19911, 447, 450),
(5922, 448, 447),
(5918, 448, 449),
(5919, 448, 450),
(5903, 449, 447),
(5904, 449, 448),
(5905, 449, 450),
(5412, 450, 447),
(5413, 450, 448),
(5414, 450, 449);
|
