Woo Products SKU not keeping value

[Jackie]

Woo Products does not show up in my locations when I go to add or edit a location, but if I export the locations to a CSV it shows up in the file. I’m trying to add SKU’s to the woo_products column in a CSV, but when I upload the sheet then re-download it, the values are reset to 0. I have SLP, Experience, Power, and Premier, all updated to current versions (5.0.1).

[Cici]

Please provide plugin environment, i.e did you also update WP and Woo?

 

[Jackie]

Yes everything is currently up to date.

Plugins:
ManageWP – Worker
Gravity Forms
LayerSlider WP
Buy Here For WooCommerce
CallTrackingMetrics
Google Tag Manager for WordPress
Fusion Builder
Fusion Core
Gravity Forms Duplicate Prevention
Gravity Forms GetResponse Add-On
Heartbeat Control
Max Mega Menu – Pro Addon
Max Mega Menu
Popup Maker – Exit Intent Popups
Popup Maker
Redirection
Search Exclude
Store Locator Plus® – Experience
Store Locator Plus – Janitor
Store Locator Plus® – Power
Store Locator Plus® – Premier
Store Locator Plus®
WooCommerce Product Feed
WooCommerce Authorize.Net AIM Gateway
WooCommerce PayTrace Payment Gateway
WooCommerce Google Merchant Center Feed
WooCommerce Menu Cart
WooCommerce Shipment Tracking
WooCommerce Shortcodes
WooCommerce
WordPress Importer
Yoast SEO
wp_mail return-path
WP-Optimize

[Cici]

Ok, Thats not what is meant by the Plugin environment, that view shows your plugins but not versions of SLP, addons, WP.

the Plugin environment and info needed. 

 

double check your csv file.  you mentioned you exported. When you export each location line now has sl_id. If you are not updating that precise exact id that was assigned then you would delete that column.

The sl_id has to be exact and it can change. If you are adding new locations and you want to update you need to click on what to do with the csv file duplicate add, skip , etc. it is a setting under the Import function.

Info on the headers for the woo-commerce fields and how to associate the sku here:

https://docs.storelocatorplus.com/blog/associating-woocommerce-products-with-locations/

 

 

[Jackie]

Store Locator Plus®:5.0.3
Experience:5.0.1
Power:5.0.1
Premier:5.0.3
Buy Here for WooCommerce:4.4 Version 4.4.0 in production
Janitor:4.9
Site URL:https://groundsmart.staging.wpengine.com
This Info Cached:1548264391
Network Active:No
WordPress Version:5.0.3
PHP Version:7.2.13-1+ubuntu18.04.1+deb.sury.org+1
MySQL Version:5.6.42
PHP Limit:512M
WordPress General Limit:40M
WordPress Admin Limit:512M
PHP Peak RAM:2 MB
PHP Post Max Size:100M

So like I mentioned, the Woo Products field doesn’t even show up in the GUI, it only shows up when I do a CSV export. Also when  I was testing I wiped the store database when I was re-importing a CSV file so there would be no conflicting issues with sl_id.

• This reply was modified 5 years, 9 months ago by Jackie.

[Cici]

Buy Here for WooCommerce has not been updated or tested with current versions of WP or SLP. I will ask the developer if he has any ideas. I do not believe you need it but I will ask the developer.

[Jackie]

I was able to resolve the issue by going into Janitor and clicking delete on “woo_data_version”. It had an older version listed even though I had updated.

[Cici]

Thanks for letting us know.

 

[Author]

Posts