Tax status not imported and intermittent rounding error
-
Hello,
I am testing your plugin with a catalog of about 180 items, some of which have 10-20 variations. The server has plenty of memory and seems to handle the sync fairly quickly.
However, about 6 products have imported with incorrect pricing, e.g. 74.98 instead of 74.99. I can only guess this is some kind of rounding error when syncing to the database.
The other issue is the Square catalog has a mix of taxable and non-taxable items. Unfortunately all items are imported as taxable.
I’m happy to help diagnose this issue in any way I can.
SYSTEM REPORT
` WordPress Environment WordPress address (URL): https://wordpress-416598-4230835.cloudwaysapps.com<br>Site address (URL): https://wordpress-416598-4230835.cloudwaysapps.com<br>WC Version: 8.5.1<br>REST API Version: ? 8.5.1<br>WC Blocks Version: ? 11.8.0-dev<br>Action Scheduler Version: ? 3.7.1<br>Log Directory Writable: ?<br>WP Version: 6.4.2<br>WP Multisite: –<br>WP Memory Limit: 256 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_US<br>External object cache: ? Server Environment Server Info: Apache/2.4.58 (Debian)<br>PHP Version: 7.4.33<br>PHP Post Max Size: 20 MB<br>PHP Time Limit: 300<br>PHP Max Input Vars: 2500<br>cURL Version: 7.64.0<br>OpenSSL/1.1.1n SUHOSIN Installed: –<br>MySQL Version: 5.5.5-10.4.20-MariaDB-1:10.4.20+maria~buster-log<br>Max Upload Size: 20 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database WC Database Version: 8.5.1<br>WC Database Prefix: wp_<br>Total Database Size: 21.71MB<br>Database Data Size: 14.94MB<br>Database Index Size: 6.77MB<br>wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 1.52MB + Index: 0.89MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 1.52MB + Index: 0.38MB + Engine InnoDB<br>wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_bv_ip_store: Data: 0.28MB + Index: 0.17MB + Engine InnoDB<br>wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gf_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_icwp_wpsf_at_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_icwp_wpsf_at_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_icwp_wpsf_botsignal: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_icwp_wpsf_crowdsec_signals: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_icwp_wpsf_event: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_icwp_wpsf_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_icwp_wpsf_ips: Data: 0.27MB + Index: 0.17MB + Engine InnoDB<br>wp_icwp_wpsf_ip_rules: Data: 1.52MB + Index: 0.33MB + Engine InnoDB<br>wp_icwp_wpsf_malware: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_icwp_wpsf_mfa: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_icwp_wpsf_reports: Data: 0.11MB + Index: 0.02MB + Engine InnoDB<br>wp_icwp_wpsf_req_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_icwp_wpsf_resultitems: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_icwp_wpsf_resultitem_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_icwp_wpsf_scans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_icwp_wpsf_snapshots: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_icwp_wpsf_user_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_options: Data: 2.16MB + Index: 0.08MB + Engine InnoDB<br>wp_postmeta: Data: 1.52MB + Index: 1.95MB + Engine InnoDB<br>wp_posts: Data: 2.52MB + Index: 0.28MB + Engine InnoDB<br>wp_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_rg_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_rg_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_rg_lead: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_rg_lead_detail: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_rg_lead_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_rg_lead_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_shortpixel_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_shortpixel_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_shortpixel_postmeta: Data: 0.06MB + Index: 0.08MB + Engine InnoDB<br>wp_shortpixel_queue: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.09MB + Index: 0.13MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yoast_indexable: Data: 0.03MB + Index: 0.09MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB Post Type Counts acf-field: 50<br>acf-field-group: 1<br>attachment: 236<br>gblocks_global_style: 3<br>gblocks_templates: 55<br>nav_menu_item: 13<br>page: 14<br>post: 1<br>product: 181<br>product_variation: 336<br>revision: 9<br>wp_global_styles: 1<br>wpgae_click_event: 2 Security Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (3) Advanced Custom Fields PRO: by WP Engine – 6.2.5<br>WooCommerce Square: by WooCommerce – 4.4.1<br>WooCommerce: by Automattic – 8.5.1 Inactive Plugins (17) Breeze: by Cloudways – 2.1.3<br>Cachebuster: by Albert Peschar – 1.5<br>Custom Admin Interface Pro: by Martin Gibson – 1.51<br>GenerateBlocks: by Tom Usborne – 1.8.2<br>GenerateBlocks Pro: by Tom Usborne – 1.6.0<br>GP Premium: by Tom Usborne – 2.4.0<br>Gravity Forms: by Gravity Forms – 2.8.2<br>MalCare WordPress Security Plugin - Malware Scanner, Cleaner, Security Firewall: by MalCare Security – 5.42<br>ManageWP - Worker: by GoDaddy – 4.9.19<br>Shield Security: by Shield Security – 18.5.10<br>ShortPixel Image Optimizer: by ShortPixel - Convert WebP/AVIF & Optimize Images – 5.5.3<br>Simple Image Sizes: by Rahe – 3.2.2<br>Site Kit by Google: by Google – 1.118.0<br>Waka Bulk Page: by Waka – 1.0.3<br>WooCommerce Remove All Products: by Gabriel Reguly<br>Erik Golinelli – 8.1.0 WordPress Importer: by wordpressdotorg – 0.8.2<br>Yoast SEO: by Team Yoast – 21.8.1 Dropin Plugins (1) object-cache.php: Object Cache Pro (Drop-in) Must Use Plugins (1) Object Cache Pro (MU): by Rhubarb Group – 1.20.2 Settings API Enabled: –<br>Force SSL: –<br>Currency: USD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5) Connected to Woo.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature screen enabled: ?<br>HPOS feature enabled: ?<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: – WC Pages Shop base: #35387 - /shop/<br>Cart: #35388 - /cart/<br>Checkout: #35389 - /checkout/<br>My account: #35390 - /my-account/<br>Terms and conditions: ? Page not set Theme Name: Add Client Name in style.css<br>Version: 1.0<br>Author URL: https://www.comminternet.com/<br>Child Theme: ?<br>Parent Theme Name: GeneratePress<br>Parent Theme Version: 3.3.1<br>Parent Theme Author URL: https://tomusborne.com<br>WooCommerce Support: ? Templates Overrides: – Admin Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>product-virtual-downloadable<br>product-external-affiliate<br>product-grouped<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-linked<br>settings<br>async-product-editor-category-field Daily Cron: ? Next scheduled: 2024-01-19 19:52:33 -05:00<br>Options: ?<br>Notes: 66<br>Onboarding: skipped Action Scheduler Complete: 2,543<br>Oldest: 2024-01-16 14:54:01 -0500<br>Newest: 2024-01-19 12:59:41 -0500 Failed: 1<br>Oldest: 2024-01-16 17:22:40 -0500<br>Newest: 2024-01-16 17:22:40 -0500 Pending: 3<br>Oldest: 2024-01-19 13:59:40 -0500<br>Newest: 2024-01-23 17:13:33 -0500 Status report information Generated at: 2024-01-19 13:03:16 -05:00<br>`
Viewing 10 replies - 1 through 10 (of 10 total)
Viewing 10 replies - 1 through 10 (of 10 total)
- The topic ‘Tax status not imported and intermittent rounding error’ is closed to new replies.