Categories lost when importing from Square

Resolved

(@germars)

If you go to the category links on our website, it shows that there is nothing there, yet we have many courses/workshops at the moment as well as a few dozen products. We synced our items from square yesterday and it seems to have removed the categories that are still in Square but now not in WooCommerce. We have done further syncs since then, but to no avail.
All of our plugins/themes/WP are up to date and the system status is below. Thank you.

WordPress Environment<br><br>WordPress address (URL): https://firingtimepottery.com<br>Site address (URL): https://firingtimepottery.com<br>WC Version: 9.0.2<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ✔ 3.7.4<br>Log Directory Writable: ✔<br>WP Version: 6.5.5<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: –<br>WP Cron: ✔<br>Language: en_US<br>External object cache: ✔ Server Environment<br><br>Server Info: Apache<br>PHP Version: 7.4.33<br>PHP Post Max Size: 32 MB<br>PHP Time Limit: 120<br>PHP Max Input Vars: 3000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.5.25-MariaDB-cll-lve<br>Max Upload Size: 32 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<br><br>WC Database Version: 9.0.2<br>WC Database Prefix: wp6o_<br>Total Database Size: 25.10MB<br>Database Data Size: 19.76MB<br>Database Index Size: 5.34MB<br>wp6o_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp6o_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_woocommerce_order_itemmeta: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>wp6o_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp6o_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp6o_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp6o_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp6o_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp6o_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_actionscheduler_actions: Data: 2.02MB + Index: 1.16MB + Engine InnoDB<br>wp6o_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_actionscheduler_logs: Data: 2.02MB + Index: 1.31MB + Engine InnoDB<br>wp6o_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_comments: Data: 0.14MB + Index: 0.05MB + Engine MyISAM<br>wp6o_easywpsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp6o_easywpsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp6o_em_bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_em_events: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp6o_em_locations: Data: 0.00MB + Index: 0.02MB + Engine MyISAM<br>wp6o_em_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_em_tickets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_em_tickets_bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_et_bloom_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp6o_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_mappress_maps: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_mappress_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_mapp_maps: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_ngg_album: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_ngg_gallery: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp6o_ngg_pictures: Data: 0.71MB + Index: 0.06MB + Engine MyISAM<br>wp6o_options: Data: 4.48MB + Index: 0.10MB + Engine MyISAM<br>wp6o_postmeta: Data: 2.37MB + Index: 0.87MB + Engine MyISAM<br>wp6o_posts: Data: 6.71MB + Index: 0.20MB + Engine MyISAM<br>wp6o_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wp6o_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp6o_term_relationships: Data: 0.01MB + Index: 0.02MB + Engine MyISAM<br>wp6o_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp6o_usermeta: Data: 0.07MB + Index: 0.02MB + Engine MyISAM<br>wp6o_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp6o_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wp6o_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>wp6o_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp6o_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp6o_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp6o_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp6o_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp6o_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_wc_product_meta_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp6o_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp6o_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp6o_yoast_indexable: Data: 0.11MB + Index: 0.09MB + Engine InnoDB<br>wp6o_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp6o_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp6o_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp6o_yoast_seo_links: Data: 0.03MB + Index: 0.01MB + Engine MyISAM<br>wp6o_yoast_seo_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM Post Type Counts<br><br>attachment: 253<br>custom_css: 1<br>display_type: 20<br>et_pb_layout: 19<br>event: 13<br>event-recurring: 1<br>location: 5<br>nav_menu_item: 18<br>ngg_album: 6<br>ngg_gallery: 37<br>ngg_pictures: 684<br>oembed_cache: 5<br>page: 26<br>post: 53<br>product: 45<br>product_variation: 39<br>project: 1<br>revision: 337<br>shop_order: 193<br>wpsc_cart_orders: 23 Security<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (13)<br><br>Bloom: by Elegant Themes – 1.3.12<br>Classic Widgets: by WordPress Contributors – 0.3<br>Divi Booster: by Dan Mossop – 4.6.0<br>Docket Cache: by Nawawi Jamili – 23.08.02<br>Easy WP SMTP: by Easy WP SMTP – 2.3.1<br>MapPress Google Maps and Leaflet Maps: by Chris Richardson – 2.90.6<br>NextGEN Plus: by Imagely – 1.16.2<br>NextGEN Gallery: by Imagely – 3.59.3<br>Simple Like Page Plugin: by Illia Online – 1.5.3<br>WooCommerce Square: by WooCommerce – 4.7.0<br>WooCommerce: by Automattic – 9.0.2<br>Yoast SEO: by Team Yoast – 23.0<br>WP Super Cache: by Automattic – 1.12.2 Inactive Plugins (0) Dropin Plugins ()<br><br>advanced-cache.php: advanced-cache.php<br>maintenance.php: maintenance.php<br>object-cache.php: Docket Cache Drop-in Must Use Plugins (1)<br><br>ET Support Center :: Must-Use Plugins Autoloader: by Elegant Themes – Settings<br><br>API Enabled: –<br>Force SSL: –<br>Currency: CAD ($)<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)<br>variation (variation)<br><br>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)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – Logging<br><br>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 1 KB WC Pages<br><br>Shop base: #2527 - /shop/<br>Cart: #2528 - /cart/<br>Checkout: #2529 - /checkout/<br>My account: #2530 - /my-account/<br>Terms and conditions: ❌ Page not set Theme<br><br>Name: Divi Child Theme<br>Version: 1.0.0<br>Author URL: http://www.johncharlton.ca/<br>Child Theme: ✔<br>Parent Theme Name: Divi<br>Parent Theme Version: 4.26.0<br>Parent Theme Author URL: http://www.elegantthemes.com<br>WooCommerce Support: ✔ Templates<br><br>Overrides: – Square<br><br>Environment: Production<br>Tokenization Enabled: –<br>Debug Mode: Off Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<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-custom-fields<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<br><br>Disabled Features: minified-js<br>new-product-management-experience<br>pattern-toolkit-full-composability<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>launch-your-store<br>product-editor-template-system<br><br>Daily Cron: ✔ Next scheduled: 2024-07-10 18:24:24 -04:00<br>Options: ✔<br>Notes: 192<br>Onboarding: completed Action Scheduler<br><br>Complete: 4,113<br>Oldest: 2024-06-08 16:41:49 -0400<br>Newest: 2024-07-09 15:14:32 -0400<br><br>Failed: 25<br>Oldest: 2023-02-15 00:30:49 -0500<br>Newest: 2024-06-17 15:18:53 -0400<br><br>Pending: 4<br>Oldest: 2024-07-09 16:14:29 -0400<br>Newest: 2024-07-10 08:56:34 -0400 Status report information<br><br>Generated at: 2024-07-09 16:08:14 -04:00<br>

The page I need help with: [log in to see the link]

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

carolm29 (woo-hc)
(@carolm29)

1 year, 4 months ago

Hey there, @germars! Thanks for contacting us. I’m happy to help you.

What you’re seeing is a bug, and our team is working on fixing it now.

While we don’t have an ETA at present, you can follow the progress of the fix here: https://github.com/woocommerce/woocommerce-square/issues/156

Apologies for the inconvenience; please let us know if we can assist with anything else!

Have a wonderful day!

Thread Starter germars
(@germars)

1 year, 4 months ago

Thanks for the prompt message. I see that there was an update today, but it doesn’t seem to have fixed anything. I’m currently importing everything again, but the screen is different and it says:

Your products are being imported in the background! This may take some time to complete.

But unlike before, it just sits there and it’s hard to know when it has finished. Is this bug fixed now? I was hesitant to “roll back” as I couldn’t find a good description and I don’t want to screw things up worse. Thank you.

ckadenge (woo-hc)
(@ckadenge)

1 year, 4 months ago

Hi @germars,

If I understand you correctly, you’re still facing the issue with the latest version of Square for WooCommerce?

In this case, I would recommend rolling back to version 4.6.2 and check if this would help solve the current issue you’re experiencing as we await on an update from our developers.

You can use the WPRollback plugin to rollback the Square plugin to version 4.6.2.

Thread Starter germars
(@germars)

1 year, 4 months ago

But it was WooCommerce that I had just updated to 9.1.0. You are suggesting I revert to an earlier version of WooCommerce Square. Should I rollback to a previous version of WooCommerce as well? It still doesn’t seem to have solved the issues of my uncategorized items.
Thank you.

ckadenge (woo-hc)
(@ckadenge)

1 year, 4 months ago

Hi @germars,

I would recommend rolling back only the Square plugin. Have you already rolled back and confirmed this?

Thread Starter germars
(@germars)

1 year, 4 months ago

yes, I have the square plugin as version 4.6.2 and the WooCommerce plugin as 9.1.0.

Luckily we can link to individual items, but the shopping cart and the menu item of categories doesn’t work at the moment.
Thanks for your help,

ckadenge (woo-hc)
(@ckadenge)

1 year, 4 months ago

Glad to hear you are now able to link to individual items @germars!

the shopping cart and the menu item of categories doesn’t work at the moment.

Are you able to demonstrate this for us on a screen recording so that we can understand the issue even further? Does this only happen to products synced through Square or each of your products?

Thread Starter germars
(@germars)

1 year, 4 months ago

Yes, I can do that, but how can I upload that recording here? Do I have to load it onto the website with a link? Sorry, not a fan of gutenburg.

I could always find the individual products, but the shopping cart and the menu which shows categories stopped working. So rolling back hasn’t actually fixed anything that I can tell. All of my products are synced through square. Just two categories.

Thread Starter germars
(@germars)

1 year, 4 months ago

Can you see this link? https://we.tl/t-C18eiykOkE

carolm29 (woo-hc)
(@carolm29)

1 year, 4 months ago

Hey, @germars!

I’m sorry about the misunderstanding.

Please note that the category bug with Square was not solved yet, it is still in progress.

The plugin that was updated this week was, as you mentioned WooCommerce, and the bug is with the Square plugin. As you can see here, it is still open.

As I understand, you are now facing a different issue, correct?

Since the issue you are facing is with the Square plugin, as per forum guidelines, please open a support thread here, as this forum is exclusive to WooCommerce core plugin, and we can’t assist with other plugins here (even if it is also ours). Please include the link to this thread in the new one so our team can check what was already shared here 🙂

Thank you!

Have a wonderful day!

Thread Starter germars
(@germars)

1 year, 4 months ago

Nope it is the category bug. Sorry I thought that the update was fixing that and that you know my issue. My mistake. I’ll keep on the lookout.

Thanks for the feedback!

carolm29 (woo-hc)
(@carolm29)

1 year, 4 months ago

Hey, @germars!

No worries! We are here to help and clarify things 😃

Please let us know if there’s anything else we can do to help or if you have any questions.

Have a wonderful day!

Thread Starter germars
(@germars)

1 year, 3 months ago

I can’t see any work on this, and it’s been a few weeks. Does anyone know if WooCommerce or Square are working on why the categories are stripped when imported from Square? It’s not helping our website or sales much.

Plugin Support Shameem – a11n
(@shameemreza)

1 year, 3 months ago

Hi @germars

Does anyone know if WooCommerce or Square are working on why the categories are stripped when imported from Square?

This is the limitation of the plugin. Nevertheless, when syncing/importing products from Square to WooCommerce, if a product belongs to multiple categories or sub-categories, only the first category assigned to it will be imported/synced. More info: https://woocommerce.com/document/woocommerce-square/sync-settings/#product-data-synchronization-1

I hope this clarifies your concern. If you have any other questions, feel free to ask.

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

The topic ‘Categories lost when importing from Square’ is closed to new replies.

Tags