When importing orders into WooCommerce, handling order totals and taxes correctly is important. Here are some key things to consider:
1. Preserve original order totals: It's generally best to import the original order totals as-is, rather than recalculating them. This ensures the imported data matches the original orders[1][4].
2. Import tax data: Make sure to import the tax totals and tax items associated with each order. This includes the tax_total, shipping_tax_total, and any line item taxes[2].
3. Disable tax recalculation: When importing, it's recommended to disable the "Recalculate taxes & totals" option. This prevents WooCommerce from overriding the imported tax values[3].
4. Use tax exemption flags: If certain orders should be tax-exempt, make sure to import the appropriate meta data (e.g. meta:is_vat_exempt) to mark them as such[2].
5. Handle different tax rates: If importing orders from multiple jurisdictions, ensure the correct tax rates are associated with each order. You may need to import tax items with specific tax codes[2].
6. Consider order currency: Make sure the imported tax and total amounts match the order currency[2].
7. Verify tax settings: Ensure your WooCommerce tax settings are configured correctly for your store's location and the jurisdictions you sell to.
8. Test thoroughly: After import, verify that order totals, taxes, and other amounts are correct across different order scenarios.
If you encounter issues with taxes not calculating correctly on imported orders, it may be due to how the tax data is being imported or mapped. In some cases, you may need to adjust your import process or use custom code to ensure taxes are handled correctly for imported orders[1][4].
Remember that tax handling can be complex, especially for multi-jurisdictional sales. It's important to consult with a tax professional to ensure compliance with relevant tax laws and regulations.
Citations:[1] https://stackoverflow.com/questions/78108296/woocommerce-import-orders-tax-calculation
[2] https://woocommerce.com/document/import-and-export-of-woocommerce-orders/
[3] https://woocommerce.com/document/customer-order-csv-import-suite/
[4] https://www.wpfloor.com/import-woocommerce-orders/
[5] https://www.reddit.com/r/Netsuite/comments/z23f9t/correcting_sales_tax_on_web_orders_imported_from/