Trouble Syncing Variable Product from Woo to Square

Hello there, I am working on a site for a client where there is a variable product that needs to sync between Woo and Square. On the Woo side, the product has 32 variations all built from 2 attributes (a size and a color). The variations are set up like so: “4XL Navy,” “M Light Blue,” etc. there are no variations that have only one of the two attributes, they’re all a combo of both. WooCommerce is the system of record for this site.

I read in other threads and help docs that Square will only sync 1 variation level, so the variations in Square are all set up to be listed as one option “4XL Navy” instead of built from two options/attributes.

Every variation in both systems has a SKU, and all the SKUs match between the two systems. Yet when I attempt to sync from Woo to Square, I receive the following error: [BAD_REQUEST] Expected ItemVariation to have 1 Item Option Values, got 0.

Here’s my system report:

`
### WordPress Environment ###

WordPress address (URL): ---
Site address (URL): ---
WC Version: 8.7.0
REST API Version: ? 8.7.0
Action Scheduler Version: ? 3.7.2
Log Directory Writable: ?
WP Version: ? 6.4.3 - There is a newer version of WordPress available (6.5)
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: nginx/1.25.2
PHP Version: 8.1.27
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 10000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 10.11.6-MariaDB-1:10.11.6+maria~ubu2004
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 8.7.0
WC Database Prefix: wp_
Total Database Size: 46.01MB
Database Data Size: 29.36MB
Database Index Size: 16.65MB
wp_woocommerce_sessions: Data: 0.08MB + Index: 0.02MB + 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.05MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.23MB + Index: 0.17MB + 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.02MB + 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.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 2.02MB + Index: 3.39MB + 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: 1.02MB + Index: 2.03MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 5.28MB + Index: 0.23MB + Engine InnoDB
wp_postmeta: Data: 10.38MB + Index: 7.88MB + Engine InnoDB
wp_posts: Data: 8.33MB + Index: 0.77MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.34MB + Index: 0.14MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + 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.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_mnm_child_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.22MB + Index: 0.16MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.20MB + Index: 0.47MB + 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_woocommerce_square_customers: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

acf-field: 25
acf-field-group: 1
attachment: 525
custom_css: 2
customize_changeset: 4
cwginstocknotifier: 11
feedback: 740
nav_menu_item: 13
page: 15
pdr_product_base: 16
pewc_field: 131
pewc_group: 37
pewc_product_extra: 69
post: 2
product: 49
product_variation: 1742
revision: 128
shop_coupon: 13
shop_order: 93
shop_order_refund: 2
wp_global_styles: 1

### Security ###

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

### Active Plugins (37) ###

ManageWP - Worker: by GoDaddy – 4.9.19
ACF Content Analysis for Yoast SEO: by Thomas Kr?ftner
ViktorFroberg
marol87
pekz0r
angrycreative
Team Yoast – 3.1

Advanced Access Manager: by AAM  – 6.9.23
Advanced Custom Fields PRO: by WP Engine – 6.2.7
WooCommerce Product Add-Ons Ultimate Image Preview: by Plugin Republic – 1.0.5.1
WooCommerce Product Add-Ons Ultimate Text Preview: by Plugin Republic – 1.1.8
Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.2.2
?? Built Mighty Kit: by Built Mighty – 1.4.0
Bulk Discounts for WooCommerce: by Plugify – 2.0.1
Classic Editor: by WordPress Contributors – 1.6.3
Classic Widgets: by WordPress Contributors – 0.3
Fluid Checkout Address Book: by Fluid Checkout – 2.0.1
Google Address Autocomplete for WooCommerce - By Fluid Checkout: by Fluid Checkout – 1.2.4
Fluid Checkout for WooCommerce - PRO: by Fluid Checkout – 2.1.5
Fluid Checkout for WooCommerce - Lite: by Fluid Checkout – 3.1.6
Hide Category by User Role for WooCommerce: by ThemeSupport – 2.0.1
Jetpack: by Automattic – 13.2.1
WooCommerce Product Add-Ons Ultimate: by Plugin Republic – 3.19.0
Product Visibility by User Role for WooCommerce: by WP Wham – 1.8.1
Safe SVG: by 10up – 2.2.2
User Menus: by Code Atlantic – 1.3.2
User Role Editor: by Vladimir Garagulya – 4.64.2
Video User Manuals: by Video User Manuals Pty Ltd – 2.5.13
WooCommerce Product Add-Ons Ultimate Advanced Uploads: by Plugin Republic – 1.2.3
Cart All In One For WooCommerce: by VillaTheme – 1.1.13
Woo Min/Max Quantities: by Woo – 4.2.1 (update to version 4.2.2 is available)
WooCommerce Mix and Match Products: by Kathy Darling – 2.6.1
WooPayments: by Automattic – 7.3.0 (update to version 7.4.0 is available)
WooCommerce Stamps.com API integration: by WooCommerce – 2.0.0
WooCommerce USPS Shipping: by WooCommerce – 4.8.3
WooCommerce Square: by WooCommerce – 4.5.1 (update to version 4.6.0 is available)
Tax Exempt for WooCommerce: by Addify – 1.8.1
WooCommerce: by Automattic – 8.7.0
Yoast SEO: by Team Yoast – 22.2
WP Migrate: by WP Engine – 2.6.12
Perfect Images (Optimize, Rebuild, Replace, Thumbnails, Retina): by Jordy Meow – 6.5.3
Zakeke Interactive Product Designer: by Zakeke – 3.8.2

### Inactive Plugins (0) ###


### Must Use Plugins (2) ###

Kinsta Must-use Plugins: by Kinsta Team – 3.0.1
ManageWP - Worker Loader: by GoDaddy – 1.0.0

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
mix and match (mix-and-match)
simple (simple)
variable (variable)

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 Woo.com: ?
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

### Logging ###

Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 9 MB

### WC Pages ###

Shop base: #6 - /shop/
Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #44 - /terms-and-conditions/

### Theme ###

Name: HarrysButtons
Version: 0.1.0
Author URL: https://www.wondersphere.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: –

### WooPayments ###

Version: 7.3.0
Connected to WPCOM: Yes
WPCOM Blog ID: 217030812
Account ID: acct_1OzJU5C5Ixy38rqy
Payment Gateway: ? Needs setup
Test Mode: Disabled
Enabled APMs: card
WooPay: Disabled
WooPay Incompatible Extensions: No
Apple Pay / Google Pay: Enabled (product,cart,checkout)
Fraud Protection Level: basic
Multi-currency: Enabled
Public Key Encryption: Disabled
Auth and Capture: Enabled
Documents: Disabled
Logging: Disabled

### Product Visibility by User Role Settings ###

Product Visibility by User Role: 
Hide catalog visibility: 
Make non-purchasable: 
Modify query: 
Hide menu items: 
Hide product categories/tags: 
Redirect: 
Enable Redirect URLs per product: 
Replace description: 
Content to replace with, e.g.: Log in to see the product description.: 
Replace short description: 
Content to replace with, e.g.: Log in to see the product description.: 
User roles to display in settings: 
Admin products list column: 
Product quick edit: 
Products bulk edit: 
Bulk settings for role guest: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role administrator: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role editor: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role author: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role contributor: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role subscriber: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role customer: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role shop_manager: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role wpseo_manager: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role wpseo_editor: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 
Bulk settings for role employee: not set
Enable/Disable: 
Hide all: 
Products: 
Invisible: 
Product categories: 
Invisible: 
Product tags: 
Invisible: 

### Mix and Match Products ###

Version: 2.6.1
Database Version: 2.6.1
Template Overrides: –

### Square ###

Environment: Production
Tokenization Enabled: ?
Debug Mode: Off

### Cash App Pay (Square) ###

Environment: Production
Debug Mode: Off

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
product-linked
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: customize-store
minified-js
new-product-management-experience
product-pre-publish-modal
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-04-04 13:51:35 -05:00
Options: ?
Notes: 51
Onboarding: completed

### Action Scheduler ###

Complete: 2,661
Oldest: 2024-03-29 14:30:01 -0500
Newest: 2024-04-03 14:22:13 -0500

Failed: 10
Oldest: 2023-03-21 08:54:37 -0500
Newest: 2024-03-19 13:28:10 -0500

Pending: 5
Oldest: 2024-04-03 14:27:13 -0500
Newest: 2024-04-04 04:30:01 -0500


### Status report information ###

Generated at: 2024-04-03 14:23:30 -05:00
`

• This topic was modified 12 months ago by kreigd.