Adendum
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
I didn’t rebuild but exported all products using the non-native plugin (!!!) and split the spreadsheet into the different categories so I could better manage the import process.
I then deleted all products in a category, deleted all but the original category/product images from the media library and then imported the category products from the spreadsheet (using the non-native import!!!) and repeated for each category. Everything is now as it should be.
I have already migrated and the nameserver change is underway – so everything is in order now.
HOWEVER – none of this would have been necessary had the native import/export worked correctly. So I am hopeful that the WC team will be fixing this sooner rather than later.
Thanks for staying with me on this.
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
Last one for you today…I just installed Webtoffee’s Product CSV Import Export (BASIC) and tried the same 4 product import and that worked perfectly. It imported the 4 products correctly and used the same image….so no duplication.
Pretty clear then that the native export/import facility is the problem.
So I am going to export all products from the rsh123 dev site, edit the CSV, and then import to a test site to confirm no duplication across the 300+ products.
I’ll probably rebuild rsh123 into the test site as well so I have a clean migration file for Friday. That really sucks but that’s updates for you I guess…… 🙁
- This reply was modified 7 years, 1 month ago by Adendum.
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
FYI – the test site (multisite, WC 3.6.2) Handpicked block OK, Feaured block OK and all products (after the import) – OK but duplicated product images…
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
So one ‘fix’ for me is to create a brand new site and import all my pages and posts, install WC and then those two blocks will work. The product import however requires an extensive manual edit of the database to remove all the duplicate images. Bear in mind it’s not just the duplicated main image it’s all the different sizes too. So where I should have one main image and say 3 smaller sizes I have 300+ main images and 900+ smaller images….
What do you reckon?
- This reply was modified 7 years, 1 month ago by Adendum. Reason: typo
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
Yes I had previously deactivated all plugins except WC – and did again just now – no change, the blocks both say no products.
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsForum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
I created one product and copied the image URL and then updated the same small CSV file we used previously, ensured all IDs were removed and imported the for products. Import worked fine but I now have 5 products and 5 identical images.
So the import is definitely NOT working.
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
Brand new site (multisite), new WC 3.6.2 install, manually created one product, edited a page to use handpicked block – 1 product seen. Same positive result for the featured block. So that’s progress.
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
As I am in a multisite environment it is easy for me to create a whole new website and play around with importing etc – that’s what I am doing right now. I am trying to reset all the products so they all point to the original single image (not the -1, -2…-247 versions) and testing handpicked and featured.
But no way to do a test migration because the client is with Weebly and he has not yet signed up with SiteGround.
Let me finish up with this test website and report back on [a] images issue and [b] the blocks issue. Won’t be long….
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
I had previously tried clearing transients and tables and it had no effect but I did it again just now and sadly no change of status.
I have rolled back to WC 3.5.8, installed Woo Blocks and …. no change! Arghh!
I do have backups of the site but I can’t roll back because it’s in a multisite setup. I have several other development sites that I have been working on at the same time, so if I roll back on this I lose the work on the other ones…silly me huh!
What about if I do the following…
1. Export all products
2. Export all settings (is that even possible?)
3. Uninstall WC
4. Via PHPMYADMIN totally remove all traces of WC (tables, wp_options etc)
5. Install WC latest version
6. Import products (with no ID #s) and settings (or manually reset each one)
7 Hope that works?But I still have the duplicate product images issue as well….
Added pressure…the site is slated for migration to a new live host on Friday 4th May.
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHanah,
No, there is no result from a search within the Handpicked or Featured product blocks; even if I copy and paste a product name in full it reports no products.
You may have hit on the problem. I already had WooCommerce Block plugin installed as I have been developing this site since before the last 3 WC updates. I thought I was using this plugin and wasn’t aware that it was integral to WC now.
So…I uninstalled the plugin…but that made no difference. I tried creating a new page and using Handpicked but it still reports zero products. I reinstalled the plugin again but I am not seeing any way to enforce the use of the extra plugin instead of the integral blocks and within a page I can’t tell which one I am using but my gut feel is that the integral one overrides the plugin version.
What next?
Forum: Plugins
In reply to: [WooCommerce] Duplicated Product Images after native CSV importHannah,
Apologies for the snippet error – my bad. I had just copied from the CSV file. Here is a snippet copied from the text version of the same files….
1159,”simple, downloadable, virtual”,,Improvisational Skills Part I,1,0,visible,,,,,taxable,,1,,,0,0,,,,,1,On receipt of payment you will be able to log into your account and download a PDF file containing simple instructions to enable access.,,10,”Webinars > Lesson, Webinars”,,,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/product-ronnies-webinar.jpg,-1,-1,,,,,,,0,Level,Advanced,1,1,,,,,,,,,10000000000000,10000000000000,,,,,,,,,,Webinar-013-Improvisational-Skills-Part-I-Wednesday-5-20-15.pdf,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/Webinar-013-Improvisational-Skills-Part-I-xxxxxx.pdf
1160,”simple, downloadable, virtual”,,Improvisational Skills Part II,1,0,visible,,,,,taxable,,1,,,0,0,,,,,1,On receipt of payment you will be able to log into your account and download a PDF file containing simple instructions to enable access.,,10,”Webinars > Lesson, Webinars”,,,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/product-ronnies-webinar.jpg,-1,-1,,,,,,,0,Level,Advanced,1,1,,,,,,,,,10000000000000,10000000000000,,,,,,,,,,Webinar-012-Improvisational-Skills-Part-II-Friday-5-29-15.pdf,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/Webinar-012-Improvisational-Skills-Part-II-xxxxxx.pdf
1161,”simple, downloadable, virtual”,,Improvisational Skills Part III,1,0,visible,,,,,taxable,,1,,,0,0,,,,,1,On receipt of payment you will be able to log into your account and download a PDF file containing simple instructions to enable access.,,10,”Webinars > Lesson, Webinars”,,,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/product-ronnies-webinar.jpg,-1,-1,,,,,,,0,Level,Advanced,1,1,,,,,,,,,10000000000000,10000000000000,,,,,,,,,,Webinar-011-Improvisational-Skills-Part-III-Rhythm-Wednesday-6-17-15.pdf,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/Webinar-011-Improvisational-Skills-Part-III-Rhythm-Wxxxxxx.pdf
1162,”simple, downloadable, virtual”,,Improvisational Skills Part IV,1,0,visible,,,,,taxable,,1,,,0,0,,,,,1,On receipt of payment you will be able to log into your account and download a PDF file containing simple instructions to enable access.,,10,”Webinars > Lesson, Webinars”,,,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/product-ronnies-webinar.jpg,-1,-1,,,,,,,0,Level,Advanced,1,1,,,,,,,,,10000000000000,10000000000000,,,,,,,,,,Webinar-010-Improvisational-Skills-Part-IV-Layering-Monday-7-20-15.pdf,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/Webinar-010-Improvisational-Skills-Part-IV-Layering-xxxxxx.pdf
1163,”simple, downloadable, virtual”,,Improvisational Skills Part V,1,0,visible,,,,,taxable,,1,,,0,0,,,,,1,On receipt of payment you will be able to log into your account and download a PDF file containing simple instructions to enable access.,,10,”Webinars > Lesson, Webinars”,,,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/product-ronnies-webinar.jpg,-1,-1,,,,,,,0,Level,Advanced,1,1,,,,,,,,,10000000000000,10000000000000,,,,,,,,,,Webinar-009-Improvisational-Skills-Part-V-Slow-Blues-7-28-15.pdf,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/Webinar-009-Improvisational-Skills-Part-V-xxxxxx.pdfI followed your steps and created a new and unique product called Test Course 1 and exported all products. I edited the CSV file to remove all but the new product and created 3 more products in the spreadsheet (Test Course 2, 3 and 4). I then imported the CSV and 3 new products were visible …. but three new images appeared in the media library and each product points to a new image. My csv file is below:-
ID,Type,SKU,Name,Published,Is featured?,Visibility in catalog,Short description,Description,Date sale price starts,Date sale price ends,Tax status,Tax class,In stock?,Stock,Low stock amount,Backorders allowed?,Sold individually?,Weight (oz),Length (in),Width (in),Height (in),Allow customer reviews?,Purchase note,Sale price,Regular price,Categories,Tags,Shipping class,Images,Download limit,Download expiry days,Parent,Grouped products,Upsells,Cross-sells,External URL,Button text,Position,Attribute 1 name,Attribute 1 value(s),Attribute 1 visible,Attribute 1 global,Meta: _psad_onsale_order,Meta: _psad_featured_order,Meta: site-sidebar-layout,Meta: site-content-layout,Meta: theme-transparent-header-meta,Meta: _wp_old_date,Meta: _product_url,Meta: _button_text,Meta: _max_variation_sale_price,Meta: _min_variation_sale_price,Meta: _max_variation_regular_price,Meta: _min_variation_regular_price,Meta: _max_variation_price,Meta: _min_variation_price,Meta: pf_size_chart,Meta: _file_path,Attribute 2 name,Attribute 2 value(s),Attribute 2 visible,Attribute 2 global,Download 1 name,Download 1 URL,Download 2 name,Download 2 URL
2778,”simple, downloadable, virtual”,,TEST Course 1,1,0,visible,,This is a test product to test product image duplication,,,taxable,,1,,,0,0,,,,,1,,260,300,Course,,,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/category-course.jpg,-1,-1,,,,,,,0,Level,Beginner,1,1,,,default,default,default,,,,,,,,,,,,,,,,,,,
,”simple, downloadable, virtual”,,TEST Course 2,1,0,visible,,This is a test product to test product image duplication,,,taxable,,1,,,0,0,,,,,1,,260,300,Course,,,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/category-course.jpg,-1,-1,,,,,,,0,Level,Beginner,1,1,,,default,default,default,,,,,,,,,,,,,,,,,,,
,”simple, downloadable, virtual”,,TEST Course 3,1,0,visible,,This is a test product to test product image duplication,,,taxable,,1,,,0,0,,,,,1,,260,300,Course,,,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/category-course.jpg,-1,-1,,,,,,,0,Level,Beginner,1,1,,,default,default,default,,,,,,,,,,,,,,,,,,,
,”simple, downloadable, virtual”,,TEST Course 4,1,0,visible,,This is a test product to test product image duplication,,,taxable,,1,,,0,0,,,,,1,,260,300,Course,,,https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/category-course.jpg,-1,-1,,,,,,,0,Level,Beginner,1,1,,,default,default,default,,,,,,,,,,,,,,,,,,,So, what next?
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHanah,
Just to prove the point I just created a test page using each of the WC blocks in order…they all work as expected except for the Handpicked and Featured products blocks.
https://aditerum.co.uk/clients/rsh123/test-page/
I know I can work around this with shortcodes but when I hand this site over to the client (currently a Weebly user) he is going to want to use the simple route – Blocks.
Forum: Plugins
In reply to: [WooCommerce] Duplicated Product Images after native CSV importHanah,
Thanks again for responding (this and the other thread!)…
Yes, the image did exist in the media library before I imported. I have listed three lines of the CSV file below and you’ll see that the same image URL was specified…
1159 simple, downloadable, virtual Improvisational Skills Part I 1 0 visible taxable 1 0 0 1 On receipt of payment you will be able to log into your account and download a PDF file containing simple instructions to enable access. 10 Webinars > Lesson, Webinars https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/product-ronnies-webinar.jpg -1 -1 0 Level Advanced 1 1 10000000000000 10000000000000 Webinar-013-Improvisational-Skills-Part-I-Wednesday-5-20-15.pdf https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/Webinar-013-Improvisational-Skills-xxxxxxxxx.pdf
1160 simple, downloadable, virtual Improvisational Skills Part II 1 0 visible taxable 1 0 0 1 On receipt of payment you will be able to log into your account and download a PDF file containing simple instructions to enable access. 10 Webinars > Lesson, Webinars https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/product-ronnies-webinar.jpg -1 -1 0 Level Advanced 1 1 10000000000000 10000000000000 Webinar-012-Improvisational-Skills-Part-II-Friday-5-29-15.pdf https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/Webinar-012-Improvisational-Skills-yyyyyyyyyy.pdf
1161 simple, downloadable, virtual Improvisational Skills Part III 1 0 visible taxable 1 0 0 1 On receipt of payment you will be able to log into your account and download a PDF file containing simple instructions to enable access. 10 Webinars > Lesson, Webinars https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/product-ronnies-webinar.jpg -1 -1 0 Level Advanced 1 1 10000000000000 10000000000000 Webinar-011-Improvisational-Skills-Part-III-Rhythm-Wednesday-6-17-15.pdf https://aditerum.co.uk/clients/rsh123/wp-content/uploads/sites/5/2019/04/Webinar-011-Improvisational-Skills-zzzzzzzzz.pdfAnyway to remove or hide the URLs in the above lines after you are done?
- This reply was modified 7 years, 1 month ago by Adendum. Reason: Remove full pdf url's
Forum: Plugins
In reply to: [WooCommerce] Handpicked Products Block not seeing productsHannah,
Sorry, I didn’t make myself clear on this one then. I fully understand why a block that had specified a product that was deleted and recreated with a new ID would no longer display the product….but….
The problem I have is that when I use the Handpicked block now – a new instance – it reports no products. Same for the featured block. But if I use any of the other blocks, it picks up the products.
See here https://drive.google.com/file/d/1X_3y7gdofXOu2z5IEagkWhjLlEjTN7Ax/view
- This reply was modified 7 years, 1 month ago by Adendum.
