Released
Medium
BUG
· OPENED 18 MAY 2026
· 0 REPLIES
AeroCommerce / CSV / API product update fails when updating variant prices: unknown column prices.product_tax_group_id
SF
Stephen Fuller
· teclan Ltd
Public
Log in
to upvote, comment, or submit your own tickets.
Environment: api 0.10.1, core 0.52.2, csv 0.4.4
Steps to reproduce:
* Have existing product with variant and price row in prices table.
* PUT product update including variants.prices payload (CSV import does this automatically for existing Model).
* Observe SQLSTATE 42S22 unknown column product_tax_group_id in SET on prices update.
Expected:
* Variant price updates should not attempt to persist a non-existent prices column.
Actual:
* Update path writes product_tax_group_id and fails.
Code references:
* UpdatePrices.php:62
* UpdatePrices.php:106
* 2018_08_07_000036_create_prices_table.php:16