I was surprised that no update of the Database was required when updating the Commerce Pricelist. Usually it requires one on our other sites. However now when updating the Pricelist element via Feeds (we had no problems before doing it) errors are thrown like:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'commerce_product_variation-1-148-1.00-BGN' for key 'price_list_purchasable_currency': INSERT INTO "commerce_pricelist_item" ("type", "uuid", "uid", "price_list_id", "purchasable_entity", "quantity", "list_price__number", "list_price__currency_code", "price__number", "price__currency_code", "status", "changed") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11); Array ( [:db_insert_placeholder_0] => commerce_product_variation [:db_insert_placeholder_1] => 3da466ec-6ab0-4d01-bb12-6d876f8a0b59 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 148 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 4.00 [:db_insert_placeholder_7] => BGN [:db_insert_placeholder_8] => 4.8 [:db_insert_placeholder_9] => BGN [:db_insert_placeholder_10] => 1 [:db_insert_placeholder_11] => 1711114341 )
When downloading a sample CSV from the pricelist interface and filling it different data after the import we receive the alert message: Skipped 1 price during import. No prices are updated.
Closed: works as designed
2.11
Miscellaneous