Import/Sync Not Working
-
Hello,
I have tried to import/sync products on my site for a while now and it doesn’t appear to be working at all.Today I have re-authenticated with Square and made sure that the product system of record is set to square (as I sell online as well as offline) but the importing just isn’t happening – it’s not updating product inventories at all.
Please can you help.
The page I need help with: [log in to see the link]
-
Hi there!
As a first step, could you send us your **System Status Report**, it would help us to understand your site setup a bit better. 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 reply.
### WordPress Environment ### WordPress address (URL): https://jbartisancrafts.co.uk Site address (URL): https://jbartisancrafts.co.uk WC Version: 4.0.1 REST API Version: ✔ 1.0.7 WC Blocks Version: ✔ 2.5.14 Action Scheduler Version: ✔ 3.1.4 WC Admin Version: ✔ 1.0.3 Log Directory Writable: ✔ WP Version: 5.4 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_GB External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.5 PHP Post Max Size: 128 MB PHP Time Limit: 300 PHP Max Input Vars: 2500 cURL Version: 7.65.0 OpenSSL/1.0.2k-fips SUHOSIN Installed: – MySQL Version: 5.5.5-10.2.26-MariaDB-log Max Upload Size: 128 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 4.0.1 WC Database Prefix: wp_ Total Database Size: 16.95MB Database Data Size: 14.03MB Database Index Size: 2.92MB wp_woocommerce_sessions: Data: 0.02MB + 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.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.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: 1.52MB + Index: 0.44MB + 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.31MB + Index: 0.27MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 2.23MB + Index: 0.33MB + Engine InnoDB wp_postmeta: Data: 0.48MB + Index: 0.25MB + Engine InnoDB wp_posts: Data: 1.52MB + Index: 0.06MB + Engine InnoDB wp_queue: Data: 0.02MB + Index: 0.00MB + 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.02MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + 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.02MB + Index: 0.03MB + 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.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_meta_lookup: Data: 0.02MB + Index: 0.09MB + 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_wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfConfig: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfFileMods: Data: 3.52MB + Index: 0.00MB + Engine InnoDB wp_wfHits: Data: 0.08MB + Index: 0.05MB + Engine InnoDB wp_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfKnownFileList: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfLogins: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfNotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfStatus: Data: 0.14MB + Index: 0.09MB + Engine InnoDB wp_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 95 custom_css: 1 customize_changeset: 4 et_pb_layout: 6 nav_menu_item: 3 page: 8 post: 4 product: 43 revision: 66 shop_coupon: 4 shop_order: 2 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (13) ### ManageWP - Worker: by GoDaddy – 4.9.6 GDPR Cookie Consent: by WebToffee – 1.8.7 Facebook for WooCommerce: by Facebook – 1.10.2 Jetpack by WordPress.com: by Automattic – 8.4.2 Klarna Order Management for WooCommerce: by klarna krokedil – 1.5.1 Klarna Payments for WooCommerce: by krokedil klarna automattic – 2.0.7 Mailchimp for WooCommerce: by Mailchimp – 2.3.6 Really Simple SSL: by Rogier Lankhorst Mark Wolters – 3.3.1 WooCommerce Admin: by WooCommerce – 1.0.3 WooCommerce Royal Mail Shipping Calculator Pro: by WPRuby – 2.4.2 WooCommerce Square: by WooCommerce – 2.1.1 WooCommerce: by Automattic – 4.0.1 Wordfence Security: by Wordfence – 7.4.6 ### Inactive Plugins (0) ### ### Must Use Plugins (3) ### ET Support Center :: Must-Use Plugins Autoloader: by Elegant Themes – ManageWP - Worker Loader: by ManageWP – StackCache: by Stack CP – ### Settings ### API Enabled: – Force SSL: – Currency: GBP (£) 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: #205956 - /products/ Basket: #205887 - /basket/ Checkout: #205888 - /checkout/ My account: #205889 - /my-account/ Terms and conditions: ❌ Page not set ### Theme ### Name: Divi Version: 4.4.3 Author URL: http://www.elegantthemes.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: – ### Square ### Environment: Production Tokenization Enabled: ✔ Debug Mode: Off ### Action Scheduler ### Canceled: 5 Oldest: 2020-04-08 11:13:59 +0100 Newest: 2020-04-08 11:31:39 +0100 Complete: 1,112 Oldest: 2020-03-17 11:15:30 +0000 Newest: 2020-04-17 11:44:00 +0100 Pending: 3 Oldest: 2020-04-17 12:39:20 +0100 Newest: 2020-04-17 14:11:26 +0100Hi @christaylortf. Thank you for sharing the system report.
Can you please confirm that your products have the same SKU on Square and WooCommerce? This is necessary for the sync to work correctly.
Please try these steps
- Enable Square logging in WooCommerce > Settings > Square
- Import new products from Square from WooCommerce > Settings > Square. This will not only create new products in WooCommerce but will also ensure that the correct products are synced.
Please let us know if the issue persists afterwards. If it does, please copy and paste the Square log in WooCommerce > Status > Logs. Click on the dropdown to locate the log. Also, share a screenshot of your settings in WooCommerce > Settings > Square. I recommend following the instructions at https://snipboard.io/ and sharing the link after upload to easily share screenshots.
Hi,
Yes the SKU codes are the same. I did the steps you asked and it hasn’t resolved the issues.Image of settings here: https://snipboard.io/q2pW6X.jpg
Square log here:
04-22-2020 @ 15:22:56 – Request
Request
method:
uri: listLocationsWithHttpInfo
user-agent: WooCommerce-Square/2.1.1 (WooCommerce/4.0.1; WordPress/5.4)
headers: Array
(
)
body:
duration: 0.47786s04-22-2020 @ 15:22:56 – Response
Response
code: 200
message:
headers: Array
(
[0] => HTTP/1.1 200 OK
[Content-Type] => application/json
[Square-Version] => 2019-08-14
[Vary] => Origin, Accept-Encoding
[X-Content-Type-Options] => nosniff
[X-Download-Options] => noopen
[X-Frame-Options] => SAMEORIGIN
[X-Permitted-Cross-Domain-Policies] => none
[X-Xss-Protection] => 1; mode=block
[Date] => Wed, 22 Apr 2020 14:22:56 GMT
[Content-Length] => 741
[Strict-Transport-Security] => max-age=631152000; includeSubDomains; preload
)
body: {
“locations”: [
{
“id”: “23C73RN7NWWSF”,
“name”: “JB Artisan Crafts Limited”,
“address”: {
“address_line_1”: “5 Crofters Bank”,
“locality”: “Rossendale”,
“postal_code”: “BB48FH”,
“country”: “GB”
},
“timezone”: “Europe\/London”,
“capabilities”: [
“CREDIT_CARD_PROCESSING”
],
“status”: “ACTIVE”,
“created_at”: “2019-05-07T11:45:55Z”,
“merchant_id”: “QMMB7RH5GMRVX”,
“country”: “GB”,
“language_code”: “en-GB”,
“currency”: “GBP”,
“business_name”: “JB Artisan Crafts Limited”,
“type”: “PHYSICAL”,
“website_url”: “www.jbartisancrafts.co.uk”,
“business_hours”: {},
“description”: “”,
“instagram_username”: “jbartisancrafts”,
“facebook_url”: “facebook.com\/jbartisancrafts”,
“logo_url”: “https:\/\/d1g145x70srn7h.cloudfront.net\/files\/e9334cee04869e662298e0f2cb92e7c36eaf5dd8\/original.png”
}
]
}04-22-2020 @ 15:22:56 – Request
Request
method:
uri: listLocationsWithHttpInfo
user-agent: WooCommerce-Square/2.1.1 (WooCommerce/4.0.1; WordPress/5.4)
headers: Array
(
)
body:
duration: 0.44864s04-22-2020 @ 15:22:56 – Response
Response
code: 200
message:
headers: Array
(
[0] => HTTP/1.1 200 OK
[Content-Type] => application/json
[Square-Version] => 2019-08-14
[Vary] => Origin, Accept-Encoding
[X-Content-Type-Options] => nosniff
[X-Download-Options] => noopen
[X-Frame-Options] => SAMEORIGIN
[X-Permitted-Cross-Domain-Policies] => none
[X-Xss-Protection] => 1; mode=block
[Date] => Wed, 22 Apr 2020 14:22:56 GMT
[Content-Length] => 741
[Strict-Transport-Security] => max-age=631152000; includeSubDomains; preload
)
body: {
“locations”: [
{
“id”: “23C73RN7NWWSF”,
“name”: “JB Artisan Crafts Limited”,
“address”: {
“address_line_1”: “5 Crofters Bank”,
“locality”: “Rossendale”,
“postal_code”: “BB48FH”,
“country”: “GB”
},
“timezone”: “Europe\/London”,
“capabilities”: [
“CREDIT_CARD_PROCESSING”
],
“status”: “ACTIVE”,
“created_at”: “2019-05-07T11:45:55Z”,
“merchant_id”: “QMMB7RH5GMRVX”,
“country”: “GB”,
“language_code”: “en-GB”,
“currency”: “GBP”,
“business_name”: “JB Artisan Crafts Limited”,
“type”: “PHYSICAL”,
“website_url”: “www.jbartisancrafts.co.uk”,
“business_hours”: {},
“description”: “”,
“instagram_username”: “jbartisancrafts”,
“facebook_url”: “facebook.com\/jbartisancrafts”,
“logo_url”: “https:\/\/d1g145x70srn7h.cloudfront.net\/files\/e9334cee04869e662298e0f2cb92e7c36eaf5dd8\/original.png”
}
]
}04-22-2020 @ 15:22:56 – Request
Request
method:
uri: listLocationsWithHttpInfo
user-agent: WooCommerce-Square/2.1.1 (WooCommerce/4.0.1; WordPress/5.4)
headers: Array
(
)
body:
duration: 0.46165s04-22-2020 @ 15:22:56 – Response
Response
code: 200
message:
headers: Array
(
[0] => HTTP/1.1 200 OK
[Content-Type] => application/json
[Square-Version] => 2019-08-14
[Vary] => Origin, Accept-Encoding
[X-Content-Type-Options] => nosniff
[X-Download-Options] => noopen
[X-Frame-Options] => SAMEORIGIN
[X-Permitted-Cross-Domain-Policies] => none
[X-Xss-Protection] => 1; mode=block
[Date] => Wed, 22 Apr 2020 14:22:56 GMT
[Content-Length] => 741
[Strict-Transport-Security] => max-age=631152000; includeSubDomains; preload
)
body: {
“locations”: [
{
“id”: “23C73RN7NWWSF”,
“name”: “JB Artisan Crafts Limited”,
“address”: {
“address_line_1”: “5 Crofters Bank”,
“locality”: “Rossendale”,
“postal_code”: “BB48FH”,
“country”: “GB”
},
“timezone”: “Europe\/London”,
“capabilities”: [
“CREDIT_CARD_PROCESSING”
],
“status”: “ACTIVE”,
“created_at”: “2019-05-07T11:45:55Z”,
“merchant_id”: “QMMB7RH5GMRVX”,
“country”: “GB”,
“language_code”: “en-GB”,
“currency”: “GBP”,
“business_name”: “JB Artisan Crafts Limited”,
“type”: “PHYSICAL”,
“website_url”: “www.jbartisancrafts.co.uk”,
“business_hours”: {},
“description”: “”,
“instagram_username”: “jbartisancrafts”,
“facebook_url”: “facebook.com\/jbartisancrafts”,
“logo_url”: “https:\/\/d1g145x70srn7h.cloudfront.net\/files\/e9334cee04869e662298e0f2cb92e7c36eaf5dd8\/original.png”
}
]
}04-22-2020 @ 15:23:15 – Request
Request
method:
uri: listLocationsWithHttpInfo
user-agent: WooCommerce-Square/2.1.1 (WooCommerce/4.0.1; WordPress/5.4)
headers: Array
(
)
body:
duration: 0.43862s04-22-2020 @ 15:23:15 – Response
Response
code: 200
message:
headers: Array
(
[0] => HTTP/1.1 200 OK
[Content-Type] => application/json
[Square-Version] => 2019-08-14
[Vary] => Origin, Accept-Encoding
[X-Content-Type-Options] => nosniff
[X-Download-Options] => noopen
[X-Frame-Options] => SAMEORIGIN
[X-Permitted-Cross-Domain-Policies] => none
[X-Xss-Protection] => 1; mode=block
[Date] => Wed, 22 Apr 2020 14:23:15 GMT
[Content-Length] => 741
[Strict-Transport-Security] => max-age=631152000; includeSubDomains; preload
)
body: {
“locations”: [
{
“id”: “23C73RN7NWWSF”,
“name”: “JB Artisan Crafts Limited”,
“address”: {
“address_line_1”: “5 Crofters Bank”,
“locality”: “Rossendale”,
“postal_code”: “BB48FH”,
“country”: “GB”
},
“timezone”: “Europe\/London”,
“capabilities”: [
“CREDIT_CARD_PROCESSING”
],
“status”: “ACTIVE”,
“created_at”: “2019-05-07T11:45:55Z”,
“merchant_id”: “QMMB7RH5GMRVX”,
“country”: “GB”,
“language_code”: “en-GB”,
“currency”: “GBP”,
“business_name”: “JB Artisan Crafts Limited”,
“type”: “PHYSICAL”,
“website_url”: “www.jbartisancrafts.co.uk”,
“business_hours”: {},
“description”: “”,
“instagram_username”: “jbartisancrafts”,
“facebook_url”: “facebook.com\/jbartisancrafts”,
“logo_url”: “https:\/\/d1g145x70srn7h.cloudfront.net\/files\/e9334cee04869e662298e0f2cb92e7c36eaf5dd8\/original.png”
}
]
}04-22-2020 @ 15:23:38 – Request
Request
method:
uri: listLocationsWithHttpInfo
user-agent: WooCommerce-Square/2.1.1 (WooCommerce/4.0.1; WordPress/5.4)
headers: Array
(
)
body:
duration: 0.46646s04-22-2020 @ 15:23:38 – Response
Response
code: 200
message:
headers: Array
(
[0] => HTTP/1.1 200 OK
[Content-Type] => application/json
[Square-Version] => 2019-08-14
[Vary] => Origin, Accept-Encoding
[X-Content-Type-Options] => nosniff
[X-Download-Options] => noopen
[X-Frame-Options] => SAMEORIGIN
[X-Permitted-Cross-Domain-Policies] => none
[X-Xss-Protection] => 1; mode=block
[Date] => Wed, 22 Apr 2020 14:23:37 GMT
[Content-Length] => 741
[Strict-Transport-Security] => max-age=631152000; includeSubDomains; preload
)
body: {
“locations”: [
{
“id”: “23C73RN7NWWSF”,
“name”: “JB Artisan Crafts Limited”,
“address”: {
“address_line_1”: “5 Crofters Bank”,
“locality”: “Rossendale”,
“postal_code”: “BB48FH”,
“country”: “GB”
},
“timezone”: “Europe\/London”,
“capabilities”: [
“CREDIT_CARD_PROCESSING”
],
“status”: “ACTIVE”,
“created_at”: “2019-05-07T11:45:55Z”,
“merchant_id”: “QMMB7RH5GMRVX”,
“country”: “GB”,
“language_code”: “en-GB”,
“currency”: “GBP”,
“business_name”: “JB Artisan Crafts Limited”,
“type”: “PHYSICAL”,
“website_url”: “www.jbartisancrafts.co.uk”,
“business_hours”: {},
“description”: “”,
“instagram_username”: “jbartisancrafts”,
“facebook_url”: “facebook.com\/jbartisancrafts”,
“logo_url”: “https:\/\/d1g145x70srn7h.cloudfront.net\/files\/e9334cee04869e662298e0f2cb92e7c36eaf5dd8\/original.png”
}
]
}Hi @christaylortf. Could you please manually do an import to update the log and share the new log with me? I’m looking for any information about import, but unfortunately, I didn’t find any such info in the previous log.
Also, when you say the import is not happening, could you please provide more details. Are new products from Square not being created in WooCommerce or are existing products not updated with data and stock?
Please share an example of one affected product set up in Square so I can search for it in the new log.
Hi,
Sorry is there something else we can do here? I followed the steps again and I’ve got the same sort of output again but I don’t think that’s what you’re looking for.We are trying to make sure that the existing products in Woo are being updated with the stock (stock held in square), but this doesn’t seem to happen.
What can we do?
Thanks in advance!
Cheers,
ChrisHi Chris. To summarize, you’re using Square as your system of record. Your products in WooCommerce are not being updated with the inventory from Square.
You’ve run an import from WooCommerce > Settings > Square (note that this needs to be done every time you create new products).
You’ve confirmed that the SKUs for the products are the same in WooCommerce and Square.
For the next steps, I recommend the following:
- Double check that your products in Square are assigned to the location set up in the plugin’s settings, which is “JB Artisan Crafts Limited” according to your screenshot.
- Confirm with your host that background processing/loopback connections are enabled (as required by Square)
Please let us know how that goes.
Hi there @christaylortf,
We haven’t heard back from you in a while, so I’m going to mark this as resolved.
If you’re still seeing issues with stock sync please contact us at WooCommerce.com > My Account > Tickets. You may need to create an account before you can access that page.
Please include a link to this forum thread, so that we can keep track of what’s already been done.
We will be able to help you further there.
Enjoy the rest of your day and stay safe!
The topic ‘Import/Sync Not Working’ is closed to new replies.