Hi Community,
I am building a multinational e-commerce platform that requires individual product data depending on a customer's shipping country (input). There will be a
- different total price,
- a different tax rate, and
- a different currency
for each country.
I am wondering what the best approach is and why. These are my current thoughts/options:
1. Different tables for price, tax and currency, which will be linked to product variants?
2. One product variant table with different columns for each country (e.g. price_de, price_uk, tax_de, tax_uk, etc.).
3. One product variant table with different rows (entries) for each combination of tax/currency/price (one column for tax, currency, price). In the frontend, I'd then filter by country and only show available options.
Not sure which approach is the best and why.
For background: I only have about 30 different products and will ship to about 10 different countries. Thanks for helping.