Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Price Conflicts with Tax Class ID in Product Overview #2564

Open
bennyborn opened this issue Feb 11, 2025 · 0 comments
Open

Price Conflicts with Tax Class ID in Product Overview #2564

bennyborn opened this issue Feb 11, 2025 · 0 comments

Comments

@bennyborn
Copy link

When assigning a price to a product that coincidentally matches the ID of a tax class, the product overview in the backend incorrectly attempts to use the fully rendered price as an ID for foreign key resolution on the price field.

Steps to Reproduce

  1. Set a product price to 3.00.
  2. Ensure a tax class exists with the ID 3 (e.g., Standard 19% (ID 3)).
  3. In the backend product overview, the system executes an incorrect query:
SELECT name AS value FROM tl_iso_tax_class WHERE id = '3.00 (Standard 19%)' LIMIT 0,1
  1. In the product overview the price will now be missing and the (most likely) incorrect tax class will be shown instead:

Image

This is due to a fix from PR #2341 where DC_ProductData tries to resolve the foreignKey set on the price field in tl_iso_products.
See 0fa4462#diff-89b47cb2c0f1f23a7fb8bfbdf7bb203e94fa8cef702e9ec3afca305fe1cc4a02R1616-R1629

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant