[QUOTE]
Евгений Жуков написал:
Скрипт нужно писать. Делаете выборку по таблице цен, ищете записи, у которых совпадают поля
PRODUCT_ID
CATALOG_GROUP_ID
QUANTITY_FROM
QUANTITY_TO
Если находите - какую-то удаляете (например, с меньшим ID)
Еще вариант - сделать csv-выгрузку данных (цен), убрать дубликаты, загрузить обратно - ненужные удалятся.[/QUOTE]
Выгрузка через csv не помогла, там дубликатов нет. А с выборкой цен, я что-то затупил. Я через CIBlockElement::GetList выбрал все товары. В массиве есть те у которых ID совпадает, например вот ответ:
[CODE]
Array
(
[0] => Array
(
[ID] => 156711
[IBLOCK_ID] => 8
[NAME] => Оверлок Singer MyLock 674D
[CODE] => overlok-singer-mylock-674d
[CATALOG_PRICE_ID_1] => 326116
[CATALOG_GROUP_ID_1] => 1
[CATALOG_PRICE_1] => 12336.00
[CATALOG_CURRENCY_1] => RUB
[CATALOG_QUANTITY_FROM_1] =>
[CATALOG_QUANTITY_TO_1] =>
[CATALOG_EXTRA_ID_1] =>
[CATALOG_GROUP_NAME_1] => Москва
[CATALOG_CAN_ACCESS_1] => Y
[CATALOG_CAN_BUY_1] => Y
[CATALOG_QUANTITY] => 80
[CATALOG_QUANTITY_TRACE] => N
[CATALOG_QUANTITY_TRACE_ORIG] => D
[CATALOG_WEIGHT] => 6.8
[CATALOG_VAT_ID] =>
[CATALOG_VAT_INCLUDED] => Y
[CATALOG_CAN_BUY_ZERO] => N
[CATALOG_CAN_BUY_ZERO_ORIG] => D
[CATALOG_PURCHASING_PRICE] =>
[CATALOG_PURCHASING_CURRENCY] =>
[CATALOG_QUANTITY_RESERVED] => 0
[CATALOG_SUBSCRIBE] => Y
[CATALOG_SUBSCRIBE_ORIG] => D
[CATALOG_WIDTH] =>
[CATALOG_LENGTH] =>
[CATALOG_HEIGHT] =>
[CATALOG_MEASURE] => 5
[CATALOG_TYPE] => 1
[CATALOG_AVAILABLE] => Y
[CATALOG_BUNDLE] => N
[CATALOG_PRICE_TYPE] => S
[CATALOG_RECUR_SCHEME_LENGTH] =>
[CATALOG_RECUR_SCHEME_TYPE] => D
[CATALOG_TRIAL_PRICE_ID] =>
[CATALOG_WITHOUT_ORDER] => N
[CATALOG_SELECT_BEST_PRICE] => N
[CATALOG_NEGATIVE_AMOUNT_TRACE] => N
[CATALOG_NEGATIVE_AMOUNT_TRACE_ORIG] => D
[CATALOG_VAT] =>
)
[1] => Array
(
[ID] => 156711
[IBLOCK_ID] => 8
[NAME] => Оверлок Singer MyLock 674D
[CODE] => overlok-singer-mylock-674d
[CATALOG_PRICE_ID_1] => 327884
[CATALOG_GROUP_ID_1] => 1
[CATALOG_PRICE_1] => 10260.00
[CATALOG_CURRENCY_1] => RUB
[CATALOG_QUANTITY_FROM_1] =>
[CATALOG_QUANTITY_TO_1] =>
[CATALOG_EXTRA_ID_1] =>
[CATALOG_GROUP_NAME_1] => Москва
[CATALOG_CAN_ACCESS_1] => Y
[CATALOG_CAN_BUY_1] => Y
[CATALOG_QUANTITY] => 80
[CATALOG_QUANTITY_TRACE] => N
[CATALOG_QUANTITY_TRACE_ORIG] => D
[CATALOG_WEIGHT] => 6.8
[CATALOG_VAT_ID] =>
[CATALOG_VAT_INCLUDED] => Y
[CATALOG_CAN_BUY_ZERO] => N
[CATALOG_CAN_BUY_ZERO_ORIG] => D
[CATALOG_PURCHASING_PRICE] =>
[CATALOG_PURCHASING_CURRENCY] =>
[CATALOG_QUANTITY_RESERVED] => 0
[CATALOG_SUBSCRIBE] => Y
[CATALOG_SUBSCRIBE_ORIG] => D
[CATALOG_WIDTH] =>
[CATALOG_LENGTH] =>
[CATALOG_HEIGHT] =>
[CATALOG_MEASURE] => 5
[CATALOG_TYPE] => 1
[CATALOG_AVAILABLE] => Y
[CATALOG_BUNDLE] => N
[CATALOG_PRICE_TYPE] => S
[CATALOG_RECUR_SCHEME_LENGTH] =>
[CATALOG_RECUR_SCHEME_TYPE] => D
[CATALOG_TRIAL_PRICE_ID] =>
[CATALOG_WITHOUT_ORDER] => N
[CATALOG_SELECT_BEST_PRICE] => N
[CATALOG_NEGATIVE_AMOUNT_TRACE] => N
[CATALOG_NEGATIVE_AMOUNT_TRACE_ORIG] => D
[CATALOG_VAT] =>
)
[2] => Array
(
[ID] => 158350
[IBLOCK_ID] => 8
[NAME] => Чехол Prym для швейной машины (сумка) (ВО)
[CODE] => chekhol-prym-dlya-shveynoy-mashiny-sumka-vo
[CATALOG_PRICE_ID_1] => 322683
[CATALOG_GROUP_ID_1] => 1
[CATALOG_PRICE_1] => 3860.00
[CATALOG_CURRENCY_1] => RUB
[CATALOG_QUANTITY_FROM_1] =>
[CATALOG_QUANTITY_TO_1] =>
[CATALOG_EXTRA_ID_1] =>
[CATALOG_GROUP_NAME_1] => Москва
[CATALOG_CAN_ACCESS_1] => Y
[CATALOG_CAN_BUY_1] => Y
[CATALOG_QUANTITY] => 0
[CATALOG_QUANTITY_TRACE] => N
[CATALOG_QUANTITY_TRACE_ORIG] => D
[CATALOG_WEIGHT] => 0
[CATALOG_VAT_ID] =>
[CATALOG_VAT_INCLUDED] => N
[CATALOG_CAN_BUY_ZERO] => N
[CATALOG_CAN_BUY_ZERO_ORIG] => D
[CATALOG_PURCHASING_PRICE] =>
[CATALOG_PURCHASING_CURRENCY] =>
[CATALOG_QUANTITY_RESERVED] => 0
[CATALOG_SUBSCRIBE] => Y
[CATALOG_SUBSCRIBE_ORIG] => D
[CATALOG_WIDTH] =>
[CATALOG_LENGTH] =>
[CATALOG_HEIGHT] =>
[CATALOG_MEASURE] => 5
[CATALOG_TYPE] => 1
[CATALOG_AVAILABLE] => Y
[CATALOG_BUNDLE] => N
[CATALOG_PRICE_TYPE] => S
[CATALOG_RECUR_SCHEME_LENGTH] =>
[CATALOG_RECUR_SCHEME_TYPE] => D
[CATALOG_TRIAL_PRICE_ID] =>
[CATALOG_WITHOUT_ORDER] => N
[CATALOG_SELECT_BEST_PRICE] => N
[CATALOG_NEGATIVE_AMOUNT_TRACE] => N
[CATALOG_NEGATIVE_AMOUNT_TRACE_ORIG] => D
[CATALOG_VAT] =>
)
)
[/CODE]
И я на этом этапе не могу понять, какой функцией или как в цикле найти дубли товаров с одним ID но разными ценами?