slimx91

I love the way you worded that lmao.
Dude you are a legend. Thank you so much.

hey when i run it i get an error unfortunately :(:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘o.option_id > dups.option_id’ at line 1

Of course ?? I’m still surprised you hvaen’t began charging for it. Always willing to pay for something this good.

Omg something so simple! ?? lol
Okay – we will try again once our site is ready to launch and live.

Report number: QHEYKDUE
Report date: 03/22/2022 14:31:05

Regarding this comment:
Domain > Settings > tap “Having troubles connecting the LSCWP plugin with QUIC.cloud?” link to reveal the Domain Key.

Because the domain has never been connected to litespeed i cant access that menu

Thank you for that. Re-installing worked for me ??

I have the same issue.

However, mine only seems to FAIL when I’m LOGGED IN it’s driving me insane.

Google’s Dev Console shows a bunch of JQUERY errors: (when i click the year model)
https://prnt.sc/26m2azw

Oh I see, so this is pretty much an auto-generated code on anything without tax? – Yeah, no it’s not a big priority, manually removing it is safer. ??

Thank you so much for doing the research, strange though I googled around a lot and did not come across anything

There are no Errors in my error log :))

ie.
This order was generated today. It is adding a CUSTOM FIELD ENTRY by itself. I DON’T WANT IT to add “isvatexempt” as a custom entry. I just want it to leave it blank.
https://snipboard.io/MJZQ2p.jpg

Of course.

### WordPress Environment ###

WordPress address (URL): ######################
Site address (URL): ##################
WC Version: 6.0.0
REST API Version: ? 6.0.0
WC Blocks Version: ? 6.3.3
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 2.9.4
Log Directory Writable: ?
WP Version: 5.8.3
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_AU
External object cache: ?

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.26
PHP Post Max Size: 30 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.29.0
NSS/3.53.1

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.12-MariaDB-log
Max Upload Size: 30 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.0.0
WC Database Prefix: wp_
Total Database Size: 59.61MB
Database Data Size: 34.90MB
Database Index Size: 24.71MB
wp_woocommerce_sessions: Data: 2.02MB + Index: 0.08MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.13MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.52MB + Index: 5.86MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.34MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
vosl_people: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.08MB + Index: 0.13MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_asl_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_asl_configs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_asl_countries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_asl_markers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_asl_storelogos: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_asl_stores: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_asl_stores_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_blog_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.17MB + Index: 0.09MB + Engine InnoDB
wp_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_duplicator_pro_packages: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_famiau_listings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_litespeed_img_optm: Data: 2.52MB + Index: 0.75MB + Engine InnoDB
wp_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_litespeed_url: Data: 0.11MB + Index: 0.14MB + Engine InnoDB
wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_field_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_njt_fastdup_entities: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_njt_fastdup_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 3.22MB + Index: 0.30MB + Engine InnoDB
wp_postmeta: Data: 11.52MB + Index: 9.02MB + Engine InnoDB
wp_posts: Data: 4.52MB + Index: 0.70MB + Engine InnoDB
wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_internal_links: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_registration_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides: Data: 2.08MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_serial_numbers: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_serial_numbers_activations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_site: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sitemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.11MB + Index: 0.11MB + Engine InnoDB
wp_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 4.52MB + Index: 5.03MB + Engine InnoDB
wp_users: Data: 0.31MB + Index: 0.23MB + Engine InnoDB
wp_vosl_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_vosl_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_vosl_store_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_vosl_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_vosl_tags_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_vostore_locator: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.25MB + Index: 0.19MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.13MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.13MB + Index: 0.19MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_category_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_circles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpgmza_datasets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_maps: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_maps_has_custom_fields_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_markers_has_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_markers_has_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_nominatim_geocode_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_polygon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_polylines: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpgmza_rectangles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 1700
azirspares_mapper: 3
customize_changeset: 2
custom_css: 3
famiau: 26
footer: 2
gp_elements: 7
mc4wp-form: 1
megamenu: 13
nav_menu_item: 18
nf_sub: 2
oembed_cache: 2
page: 27
post: 3
product: 883
revision: 176
seedprod: 1
shop_coupon: 3
shop_order: 619
shop_order_refund: 24
wp_show_posts: 3
ziss: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (14) ###

Code Snippets: by Code Snippets Pro – 2.14.3
GenerateBlocks: by Tom Usborne – 1.4.0
GP Premium: by Tom Usborne – 2.1.1
LiteSpeed Cache: by LiteSpeed Technologies – 4.4.6
Ninja Forms: by Saturday Drive – 3.6.7
WooCommerce Product Filter: by Mihajlovic Nenad – 6.6.3
Rank Math SEO: by Rank Math – 1.0.80
User Role Editor: by Vladimir Garagulya – 4.61
WooCommerce Stripe Gateway: by WooCommerce – 6.0.0
WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.11.3
WooCommerce Table Rate Shipping: by WooCommerce – 3.0.21
WooCommerce: by Automattic – 6.0.0
WP Google Maps - Pro Add-on: by WP Google Maps – 8.1.17
WP Google Maps: by WP Google Maps – 8.1.19

### Inactive Plugins (3) ###

WooCommerce Cart popup premium: by XootiX – 1.3
Woo Discount Rules: by Flycart – 2.3.11
Woo Discount Rules PRO 2.0: by Flycart – 2.3.11

### Dropin Plugins (1) ###

object-cache.php: object-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: AUD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
famiau (famiau)
grouped (grouped)
simple (simple)
variable (variable)
woosb (woosb)
zanpb (zanpb)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #3582 - /shop/
Cart: #10 - /cart/
Checkout: #11 - /checkout/
My account: #12 - /my-account/
Terms and conditions: #1995 - /term-and-conditions/

### Theme ###

Name: GeneratePress
Version: 3.1.0
Author URL: https://tomusborne.com
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build
personally we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 163
Oldest: 2021-12-12 01:42:18 +0000
Newest: 2022-01-09 02:55:45 +0000

### Status report information ###

Generated at: 2022-01-09 15:43:06 +10:00

Excellent, I’ve seem to have figured it out now.
I took a good look at the file – so basically it stores data PER SKU…

Product 1 > TOYORA > LANDCRUISER
Product 2 > TOYOTA > LANDCRUISER

I think that’s the mistake , iwas making so now im just gonna spend some time cleaning that up. thank you.