Bonus ng larong bingo sa casino registration.Claim Your Free 999 Pesos Bonus Today

Resolved Steve D
(@awdsteve)

4 years, 3 months ago

I am not sure why, but we have woocommerce set as our store of record (and syncing works fine), but we are ending up with duplicate products (exact same SKU) on the squareup side…as many as 7 products I see currently! So are indented too under the main product…same name and same SKU…I don’t really know where to go to begin to troubleshoot why this is happening.

Any help is much appreciated.

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Support

Aashik P – a11n

(@aashik)

4 years, 2 months ago

Hi there!

Just to reconfirm, did you manually add products in your WooCommerce store after setting up the Square connection?

If you’re selling on multiple locations, you’d want to set up Square as the SOR, and then add new products to Square as per Square for WooCommerce Documentation

Also, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status.
Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

Thread Starter

Steve D

(@awdsteve)

4 years, 2 months ago

WooCommerce existed before square was setup. All products are added in WC which is why we have it as our source of record. The locations are the website (90% of volume) and then a square terminal/POS in the art gallery accounts for the remaining sales. Are you saying if we delete the duplicates on the square side they should not return? Below is a copy of the system report:


### WordPress Environment ###

WordPress address (URL): https://sedonaartscenter.org
Site address (URL): https://sedonaartscenter.org
WC Version: 4.3.3
REST API Version: ? 1.0.10
WC Blocks Version: ? 2.7.3
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.3.1
Log Directory Writable: ?
WP Version: ? 5.4.2 - There is a newer version of WordPress available (5.5)
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.6
PHP Post Max Size: 100 MB
PHP Time Limit: 3600
PHP Max Input Vars: 10000
cURL Version: 7.58.0
OpenSSL/1.1.1

SUHOSIN Installed: –
MySQL Version: 5.7.29-32-log
Max Upload Size: 50 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 4.3.3
WC Database Prefix: wp_
Total Database Size: 422.20MB
Database Data Size: 251.51MB
Database Index Size: 170.69MB
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.50MB + Index: 0.22MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 3.52MB + Index: 5.03MB + 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.03MB + Index: 1.27MB + 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: 2.08MB + Index: 1.30MB + Engine InnoDB
wp_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 4.52MB + Index: 5.86MB + Engine InnoDB
wp_facetwp_index: Data: 0.23MB + Index: 0.30MB + Engine InnoDB
wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_fooevents_check_in: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_entry: Data: 3.52MB + Index: 0.45MB + Engine InnoDB
wp_gf_entry_meta: Data: 9.52MB + Index: 10.58MB + Engine InnoDB
wp_gf_entry_notes: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_meta: Data: 0.30MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form_view: Data: 0.28MB + Index: 0.23MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mclean_refs: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_mclean_scan: Data: 1.52MB + Index: 0.23MB + Engine InnoDB
wp_mgmlp_folders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 4.42MB + Index: 0.27MB + Engine InnoDB
wp_pantheon_sessions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.52MB + Index: 0.33MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 57.59MB + Index: 55.19MB + Engine InnoDB
wp_posts: Data: 6.52MB + Index: 3.63MB + Engine InnoDB
wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_redirection_404: Data: 1.02MB + Index: 0.56MB + Engine InnoDB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_redirection_logs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_swp_cf: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_swp_index: Data: 8.52MB + Index: 8.00MB + Engine InnoDB
wp_swp_log: Data: 1.52MB + Index: 2.13MB + Engine InnoDB
wp_swp_tax: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_swp_terms: Data: 1.52MB + Index: 1.03MB + Engine InnoDB
wp_termmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.33MB + Index: 0.27MB + Engine InnoDB
wp_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_usermeta: Data: 68.59MB + Index: 59.22MB + Engine InnoDB
wp_users: Data: 8.52MB + Index: 7.55MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + 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.13MB + Index: 0.09MB + Engine InnoDB
wp_wc_deposits_payment_plans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_deposits_payment_plans_schedule: Data: 0.02MB + Index: 0.02MB + 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.16MB + Index: 0.16MB + Engine InnoDB
wp_wc_order_stats: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.22MB + Index: 0.42MB + 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.25MB + Index: 0.00MB + Engine InnoDB
wp_woo_square_integration_deleted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woo_square_integration_logs: Data: 49.59MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 5.52MB + Index: 4.22MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.14MB + Index: 0.22MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.11MB + Index: 0.11MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_yoast_seo_meta: Data: 2.52MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acf-field: 130
acf-field-group: 19
attachment: 2727
custom_css: 1
elementor_library: 3
event_magic_tickets: 2330
mgmlp_media_folder: 14
nav_menu_item: 42
oembed_cache: 9
page: 53
people: 219
post: 16
product: 1728
product_variation: 19
revision: 63
shop_coupon: 11
shop_order: 3791
shop_order_refund: 309
tribe_events: 81
tribe_organizer: 4
tribe_venue: 25

### Security ###

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

### Active Plugins (49) ###

The Events Calendar: by Modern Tribe
Inc. – 5.1.5

Gravity Forms: by Gravity Forms – 2.4.20
Admin Columns Pro - WooCommerce: by AdminColumns.com – 3.5.1
Admin Columns Pro: by AdminColumns.com – 5.2.3
Advanced Cron Manager: by BracketSpace – 2.4.0
Advanced Custom Fields PRO: by Elliot Condon – 5.9.0
Autoptimize: by Frank Goossens (futtta) – 2.7.6
Classic Editor: by WordPress Contributors – 1.6
Elementor Pro: by Elementor.com – 2.10.3
Elementor: by Elementor.com – 2.9.14
Enhanced Media Library: by wpUXsolutions – 2.7.2
The Events Calendar PRO: by Modern Tribe
Inc. – 5.1.4

FacetWP: by FacetWP
LLC – 3.5.10

Featured Image by URL: by Knawat Team – 1.1.6
FooEvents Calendar: by FooEvents – 1.5.19
FooEvents for WooCommerce: by FooEvents – 1.11.44
FooEvents Custom Attendee Fields: by FooEvents – 1.4.19
FooEvents Multi-Day: by FooEvents – 1.2.11
Gravity Forms Mailchimp Add-On: by Gravity Forms – 4.7
JetElements For Elementor: by Crocoblock – 2.3.2
Mailchimp for WooCommerce: by Mailchimp – 2.4.5
Mailgun: by Mailgun – 1.7.1
Manage Notification E-mails: by Virgial Berveling – 1.5.1
Media Cleaner (Pro): by Jordy Meow – 6.0.1
Multiple Roles: by Florian TIAR – 1.3.1
Redirection: by John Godley – 4.8
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.3
SearchWP WooCommerce Integration: by SearchWP – 1.3.4 – Installed version not tested with active version of WooCommerce 4.3.3
SearchWP: by SearchWP
LLC – 3.1.14

Theme My Login: by Theme My Login – 7.1.1
User Switching: by John Blackbourn & contributors – 1.5.5
Product Customer List for WooCommerce: by Kokomo – 2.9.2 – Installed version not tested with active version of WooCommerce 4.3.3
WebP Express: by Bj?rn Rosell – 0.17.5
WooCommerce Extended Coupon Features PRO: by Soft79 – 2.6.3 – Installed version not tested with active version of WooCommerce 4.3.3
WooCommerce Create Customer on Order: by cxThemes – 1.36 – Installed version not tested with active version of WooCommerce 4.3.3
WooCommerce Deposits: by WooCommerce – 1.5.2 – Installed version not tested with active version of WooCommerce 4.3.3
Multi-Carrier Shipping Plugin for WooCommerce: by PluginHive – 1.8.0
WooCommerce POS: by kilbot – 0.4.24 – Installed version not tested with active version of WooCommerce 4.3.3
WooCommerce Product Add-ons: by WooCommerce – 3.0.38 – Installed version not tested with active version of WooCommerce 4.3.3
WooCommerce Square: by WooCommerce – 2.1.6
WooCommerce Waitlist: by Neil Pie – 2.1.24
WooCommerce: by Automattic – 4.3.3
WooSquare Pro: by wpexperts.io – 5.6
Yoast SEO: by Team Yoast – 14.8
WP Image Zoom: by SilkyPress – 1.43
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.1.2

WP Rocket: by WP Media – 3.6.3
Smush: by WPMU DEV – 3.6.3
WP Engine Advanced Cache Options: by Ethan Kennedy
Steven Word – 1.3.3

### Inactive Plugins (1) ###

Async JavaScript: by Frank Goossens (futtta) – 2.20.03.01

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (4) ###

Force Strong Passwords - WPE Edition: by Jason Cosper – 1.6.4
WP Engine Seamless Login Plugin: by WP Engine – 1.5.5
WP Engine Security Auditor: by wpengine – 1.0.9
WP Engine System: by WP Engine – 4.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)
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 WooCommerce.com: ?

### WC Pages ###

Shop base: #75 - /shop/
Cart: #76 - /cart/
Checkout: #77 - /checkout/
My account: #78 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Sedona Arts Center
Version: 1.0.0
Author URL: https://mind.sh/are/
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: sedona/woocommerce/checkout/form-checkout.php
sedona/woocommerce/content-product.php version 3.4.0 is out of date. The core version is 3.6.0
sedona/woocommerce/content-product_cat.php
sedona/woocommerce/content-single-product.php version 3.4.0 is out of date. The core version is 3.6.0
sedona/woocommerce/emails/email-addresses.php version 3.2.1 is out of date. The core version is 3.9.0
sedona/woocommerce/emails/email-customer-details.php
sedona/woocommerce/emails/email-downloads.php
sedona/woocommerce/emails/email-footer.php version 2.3.0 is out of date. The core version is 3.7.0
sedona/woocommerce/emails/email-header.php version 2.4.0 is out of date. The core version is 4.0.0
sedona/woocommerce/emails/email-order-details.php version 3.3.1 is out of date. The core version is 3.7.0
sedona/woocommerce/emails/email-order-items.php version 3.4.0 is out of date. The core version is 3.7.0
sedona/woocommerce/emails/email-styles.php version 3.3.0 is out of date. The core version is 4.0.0
sedona/woocommerce/loop/add-to-cart.php
sedona/woocommerce/loop/loop-end.php
sedona/woocommerce/loop/loop-start.php
sedona/woocommerce/myaccount/form-login.php version 3.4.0 is out of date. The core version is 4.1.0
sedona/woocommerce/myaccount/my-address.php
sedona/woocommerce/single-product/related.php version 3.0.0 is out of date. The core version is 3.9.0

Outdated Templates: ?
					
					
						Learn how to update

### Square ###

Environment: Production
Tokenization Enabled: –
Debug Mode: Off

### Action Scheduler ###

Canceled: 1
Oldest: 2020-08-06 08:39:47 -0700
Newest: 2020-08-06 08:39:47 -0700

Complete: 4,409
Oldest: 2020-07-18 08:49:14 -0700
Newest: 2020-08-18 07:34:20 -0700

Failed: 34
Oldest: 2019-01-18 14:54:41 -0700
Newest: 2020-02-28 10:53:40 -0700

Pending: 2
Oldest: 2020-08-18 08:34:20 -0700
Newest: 2020-08-24 14:48:52 -0700

Plugin Support

Aashik P – a11n

(@aashik)

4 years, 2 months ago

Thank you for the System Status Report. I’m not seeing anything obvious that could be causing this behavior.

The locations are the website (90% of volume) and then a square terminal/POS in the art gallery accounts for the remaining sales

As per the docs, it is still recommended to set up Square as the SOR if you’re selling outside of your WooCommerce store. Can you please cross-check and confirm if that makes a difference?